SnowPro Core Certification — Question 617

If queries start to queue in a multi-cluster virtual warehouse an additional compute cluster starts immediately under what setting?

Answer options

• A. Auto-scale mode
• B. Maximized mode
• C. Economy scaling policy
• D. Standard scaling policy

Correct answer: D

Explanation

The correct answer is D, Standard scaling policy, as it is specifically designed to add additional compute clusters immediately when there is a queue of queries. Options A, B, and C do not trigger an immediate response to queuing; for instance, Auto-scale mode adjusts based on demand but does not guarantee instant cluster addition.