SnowPro Core Certification — Question 850

When should a multi-cluster virtual warehouse be used in Snowflake?

Answer options

• A. When queuing is delaying query execution on the warehouse
• B. When there is significant disk spilling shown on the Query Profile
• C. When dynamic vertical scaling is being used in the warehouse
• D. When there are no concurrent queries running on the warehouse

Correct answer: A

Explanation

A multi-cluster virtual warehouse should be employed when queuing is hindering the execution of queries, as it allows for better handling of concurrent requests. The other options do not specifically address issues related to query execution delays; significant disk spilling can indicate performance issues but does not directly relate to the need for multi-cluster usage, and dynamic vertical scaling and no concurrent queries do not necessitate a multi-cluster setup.