Answer-first summary for fast verification
Answer: New queries will be queued and executed when capacity is available.
When a virtual warehouse reaches maximum resource capacity (meaning MIN_CLUSTER_COUNT = MAX_CLUSTER_COUNT in a multi-cluster warehouse configuration), Snowflake employs a queuing mechanism rather than terminating queries or suspending the warehouse. Option D correctly describes this behavior - new queries are queued and executed when capacity becomes available. This aligns with Snowflake's documented behavior and the strong community consensus (80% selected D, with multiple upvoted comments confirming this). Option B is incorrect because the warehouse cannot scale out further when resources are already maximized. Option C is wrong because the warehouse remains active, not suspended. Option A is incorrect because queries are queued, not terminated.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
If a virtual warehouse is at maximum resource capacity while processing a query workload, what is the outcome for newly submitted queries?
A
All queries will terminate when the resources are maximized.
B
The warehouse will scale out automatically
C
The warehouse will move to a suspended state.
D
New queries will be queued and executed when capacity is available.
No comments yet.