
Explanation:
The correct answer is B (Scale-out with a multi-cluster warehouse) because when a large number of concurrent queries are queued, it indicates that the current warehouse capacity is insufficient to handle the workload. Scaling out with a multi-cluster warehouse allows Snowflake to automatically add additional clusters to process concurrent queries in parallel, effectively addressing the queuing issue. Option A (Scale-up by resizing the warehouse) would increase the size of individual clusters but may not efficiently handle high concurrency. Options C (Disable auto-suspend) and D (Enable auto-resume) relate to warehouse state management but do not directly address the core problem of insufficient compute resources for concurrent query processing.
Ultimate access to all questions.
No comments yet.
What action should be taken when a high number of concurrent queries are queued on a virtual warehouse?
A
Scale-up by resizing the warehouse.
B
Scale-out with a multi-cluster warehouse.
C
Disable auto-suspend on the warehouse.
D
Enable auto-resume on the warehouse.