
Answer-first summary for fast verification
Answer: Change the warehouse to a multi-cluster warehouse., Increase the warehouse size.
Queueing occurs when more queries are submitted than the warehouse can process concurrently. Option B (changing to a multi-cluster warehouse) is correct because it allows multiple clusters to handle queries simultaneously, increasing overall concurrency and reducing queue wait times. Option C (increasing warehouse size) is also correct as larger warehouses have more compute resources and higher concurrency limits, enabling them to process more queries at once. Option A (increasing AUTO_SUSPEND) only affects when the warehouse automatically suspends after inactivity and doesn't impact queueing. Option D (lowering MAX_CONCURRENCY_LEVEL) would actually increase queueing by reducing the number of concurrent queries the warehouse can handle. The community discussion with 100% consensus on B supports this analysis, though C is also valid based on Snowflake documentation about warehouse performance optimization.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.