When creating a virtual warehouse, what setting should be used to avoid both over-provisioning resources and auto-scaling when there is increased concurrency?
https://docs.snowflake.com/en/user-guide/query-acceleration-service
ENABLE_QUERY_ACCELERATION is designed to improve performance for queries that experience high concurrency or large data scans without requiring additional manual scaling of resources. This feature dynamically allocates additional resources as needed for certain queries, avoiding both over-provisioning (which wastes resources) and scaling the number of clusters.
Snow parked optimized has minimum requirement as size M. This will avoid over-provisioning. This can be also, a good answer, especially if we look to A. The answer could be B.
With C you have the option to set it to 1 which is really the answer but its not an answer option given so C is the best option
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
bor4un
4 weeks, 1 day agoMatthieuDN
1 month agoMatthieuDN
3 weeks, 5 days ago37ceea2
1 month ago37ceea2
2 weeks, 3 days agoMultiCloudIronMan
1 month, 1 week ago