SnowPro Core Certification — Question 163

When should a multi-cluster warehouse be used in auto-scaling mode?

Answer options

• A. When it is unknown how much compute power is needed
• B. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
• C. If the runtime of the executed query is very slow
• D. When a large number of concurrent queries are run on the same warehouse

Correct answer: D

Explanation

The correct answer is D because a multi-cluster warehouse in auto-scaling mode can efficiently handle multiple concurrent queries by automatically adjusting resources. Options A, B, and C do not specifically address the need for scaling due to concurrent query loads, which is the primary benefit of using this feature.