Answer-first summary for fast verification
Answer: When the system has enough load for 6 minutes
The correct answer is B because Snowflake documentation explicitly states that in an auto-scaling multi-cluster warehouse with SCALING_POLICY = ECONOMY, an additional cluster is started only when the system estimates there's enough query load to keep the cluster busy for at least 6 minutes. This policy prioritizes cost efficiency by avoiding unnecessary cluster startups for short-lived workloads. The community discussion shows 100% consensus on answer B, with multiple users citing the official Snowflake documentation that confirms the 6-minute threshold. Options A (2 minutes), C (8 minutes), and D (10 minutes) are incorrect as they don't match the documented ECONOMY scaling policy requirement.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In an auto-scaling multi-cluster virtual warehouse configured with SCALING_POLICY = ECONOMY, when is an additional cluster started?
A
When the system has enough load for 2 minutes
B
When the system has enough load for 6 minutes
C
When the system has enough load for 8 minutes
D
When the system has enough load for 10 minutes
No comments yet.