SnowPro Core Certification — Question 916

While running a query on a virtual warehouse in auto-scale mode, additional clusters are started immediately if which setting is configured?

Answer options

• 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

Correct answer: C

Explanation

The correct answer is C because increasing the MIN_CLUSTER_COUNT allows for more clusters to be active when demand increases. Options A and B are related to MAX_CLUSTER_COUNT, which does not trigger additional clusters in auto-scale mode. Option D does not support scaling up, as decreasing MIN_CLUSTER_COUNT reduces the minimum number of clusters that can be active.