
Explanation:
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.
No comments yet.
How can a Snowflake user minimize query queuing on a multi-cluster virtual warehouse?
A
Increase the warehouse size.
B
Use an economy scaling policy.
C
Increase the maximum number of clusters.
D
Convert the warehouse to a Snowpark-optimized warehouse.