Answer-first summary for fast verification
Answer: The queries will be placed in a queue.
The correct answer is C because when a single-cluster virtual warehouse has no available resources, new queries cannot be executed immediately and are placed in a queue to wait for resources to become free. This behavior is consistent with Snowflake's resource management, where queries wait in queue when the warehouse is at capacity. Option A is incorrect because queries are not automatically reassigned to another warehouse. Option B is incorrect because queries are not skipped; they are queued for execution. Option D is incorrect because a single-cluster warehouse cannot automatically resize (scaling requires multi-cluster warehouses), and resizing wouldn't address immediate resource unavailability.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A single-cluster virtual warehouse has no available resources.
What will happen to new queries that are executed against this warehouse?
A
The queries will be assigned to another virtual warehouse.
B
The queries will be skipped.
C
The queries will be placed in a queue.
D
The warehouse will automatically resize and execute the queries.
No comments yet.