SnowPro Advanced: Architect · Free practice question 4 of 10
Warehouse concurrency
An analytics team reports that queries queue during business hours even though a single query completes quickly. The warehouse is a Small single-cluster. The goal is to eliminate queuing without changing per-query performance. Which configuration change directly addresses this?
- A.Increase the warehouse size to Medium or Large.
- B.Enable multi-cluster mode in Auto-scale with min=1, max=4.
- C.Add a clustering key to the largest fact table involved.
- D.Increase MAX_CONCURRENCY_LEVEL to allow more parallel queries per cluster.
Show answer and explanation
Correct answer: B. Enable multi-cluster mode in Auto-scale with min=1, max=4.
Why: Queuing during business hours is a concurrency problem, not a per-query performance problem. Multi-cluster Auto-scale spins up additional clusters of the same size when queue depth grows, and scales back down when it drains. Scaling the warehouse up helps individual queries, not concurrency. Clustering keys improve pruning, not queueing. Raising MAX_CONCURRENCY_LEVEL packs more queries onto one cluster and often makes contention worse.