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.
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
2 months, 3 weeks agoMatthieuDN
2 months, 3 weeks agoMatthieuDN
2 months, 3 weeks ago37ceea2
2 months, 4 weeks ago37ceea2
2 months, 1 week agoMultiCloudIronMan
3 months, 1 week ago