While running a query on a virtual warehouse in auto-scale mode, additional clusters are started immediately if which setting is configured?
While running a query on a virtual warehouse in auto-scale mode, additional clusters are started immediately if which setting is configured?
Additional clusters are started immediately if the MIN_CLUSTER_COUNT is increased and the new_min_clusters value is greater than the number of currently running clusters. This ensures that the system meets the minimum cluster count requirement immediately, thus triggering the start of additional clusters.
Auto-scale: ↑ max If new_max_clusters > running_clusters, no changes until additional clusters are needed. ↓ max If new_max_clusters < running_clusters, excess clusters shut down when they finish executing statements and the scaling policy conditions are met. ↑ min If new_min_clusters > running_clusters, additional clusters immediately started to meet the minimum. ↓ min If new_min_clusters < running_clusters, excess clusters shut down when they finish executing statements and the scaling policy conditions are met.
Answer A,D