Answer-first summary for fast verification
Answer: Change the multi-cluster settings to add additional clusters.
The question describes a scenario where a virtual warehouse experiences poor performance due to queuing from multiple concurrent processes, which resolves over time. This pattern suggests fluctuating concurrency demands. Option C (changing multi-cluster settings to add additional clusters) is optimal because multi-cluster warehouses are specifically designed to handle concurrency issues by automatically scaling clusters up or down based on query load, preventing queuing when concurrent processes spike. The community discussion unanimously supports C (100% consensus), citing Snowflake documentation that multi-cluster warehouses improve concurrency for fluctuating workloads. Other options are less suitable: A (increasing warehouse size) addresses compute power but not concurrency scaling; B (adding a cluster key) optimizes table performance for large scans but does not resolve warehouse-level queuing; D (enabling search optimization) accelerates point lookups but is irrelevant to concurrency queuing.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A virtual warehouse initially experienced poor performance due to queries from multiple concurrent processes queuing. The problem resolved itself over time.
What action can be taken to prevent this from happening again?
A
Increase the size of the virtual warehouse.
B
Add a cluster key to the most used JOIN key.
C
Change the multi-cluster settings to add additional clusters.
D
Enable the search optimization service for the underlying tables.
No comments yet.