Answer-first summary for fast verification
Answer: MIN_CLUSTER_COUNT is increased and new_min_clusters is greater than running_clusters
The question asks when additional clusters are started immediately in auto-scale mode. According to Snowflake documentation and the community discussion (with the highest upvoted comment from Gudref), when MIN_CLUSTER_COUNT is increased and the new minimum (new_min_clusters) is greater than the number of currently running clusters, additional clusters are started immediately to meet the new minimum requirement. This contrasts with MAX_CLUSTER_COUNT changes, where scaling up only occurs when needed based on workload, not immediately. Option C correctly describes this scenario, while A is incorrect because increasing MAX_CLUSTER_COUNT doesn't trigger immediate scaling—it only allows scaling up to the new maximum when needed. Options B and D describe scenarios where clusters are shut down, not started.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In auto-scale mode, when is an additional cluster started for a virtual warehouse?
A
MAX_CLUSTER_COUNT is increased and new_max_clusters is greater than running_clusters
B
MAX_CLUSTER_COUNT is decreased and new_max_clusters is less than running_clusters
C
MIN_CLUSTER_COUNT is increased and new_min_clusters is greater than running_clusters
D
MIN_CLUSTER_COUNT is decreased and new_min_clusters is less than running_clusters
No comments yet.