
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.
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.
No comments yet.