Answer-first summary for fast verification
Answer: When a large number of concurrent queries are run on the same warehouse
The correct answer is D because auto-scaling in multi-cluster warehouses is specifically designed to handle fluctuating concurrent query loads by dynamically starting and stopping clusters as needed. This is directly supported by Snowflake documentation and the community discussion, where the highest upvoted comments (8 upvotes) reference the official documentation stating that auto-scaling manages load by scaling clusters based on concurrent user sessions/queries. Option A is less suitable because while auto-scaling addresses unknown compute needs, it's more about handling concurrency fluctuations rather than just unknown compute power requirements. Options B and C describe query-specific characteristics that don't necessarily require auto-scaling configuration.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Under what circumstances should a multi-cluster warehouse be configured to use auto-scaling?
A
When it is unknown how much compute power is needed
B
If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
C
If the runtime of the executed query is very slow
D
When a large number of concurrent queries are run on the same warehouse
No comments yet.