SnowPro Core Certification — Question 590
If there is queueing in the virtual warehouse load monitoring chart, what should a Snowflake user do?
Answer options
- A. Decrease the warehouse size.
- B. Decrease the MIN_CLUSTER_COUNT parameter.
- C. Change the multi-cluster settings to add additional clusters.
- D. Start a separate warehouse and move queued queries there.
Correct answer: C
Explanation
The correct answer is C, as adding more clusters can help accommodate the load and reduce queueing. Options A and B would decrease capacity and could exacerbate the issue, while option D does not resolve the root cause of the queueing and may lead to inefficient resource usage.