Answer: Scale-out with a multi-cluster warehouse.

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.

Author: LeetQuiz Editorial Team