
Answer-first summary for fast verification
Answer: Increase the maximum number of clusters.
The question asks how to reduce queuing on a multi-cluster virtual warehouse. According to Snowflake documentation and the community discussion (with 100% consensus on option C), increasing the maximum number of clusters allows the warehouse to scale out more aggressively when query load increases, which directly reduces queuing by providing more compute resources to handle concurrent queries. Option A (increasing warehouse size) improves individual query performance but doesn't directly address queuing for concurrent queries. Option B (economy scaling policy) actually increases queuing by waiting longer before scaling. Option D (Snowpark-optimized warehouse) is designed for memory-intensive workloads, not specifically for reducing queuing in general multi-cluster scenarios.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.