Answer-first summary for fast verification
Answer: When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
The question specifies a STANDARD multi-cluster warehouse auto-scaling policy. According to Snowflake documentation and the community discussion, the standard policy is more aggressive about conserving credits by shutting down clusters sooner. For standard policy, clusters shut down after 2-3 consecutive checks (at 1-minute intervals) when the system determines that the load on the least-loaded cluster could be redistributed to other clusters. Option D correctly describes this behavior. Option C describes the economy policy (5-6 checks), which prioritizes minimizing cluster restarts over credit conservation. Options A and B are incorrect because they reference the 'most-loaded' cluster, which doesn't align with the shutdown logic - shutdown decisions are based on the least-loaded cluster being underutilized.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Under a standard multi-cluster warehouse auto-scaling policy, which condition will cause a cluster to shut down?
A
When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
B
When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
C
When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
D
When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
No comments yet.