Under the economy scaling policy, when will a multi-cluster Snowflake warehouse shut down?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

Under the economy scaling policy, when will a multi-cluster Snowflake warehouse shut down?

Explanation:
Economy scaling is about saving costs by removing unused compute without hurting performance. In a multi-cluster warehouse, the system watches whether the workload on the least-loaded cluster can be absorbed by the other clusters without needing to spin up a new one. It checks this at one-minute intervals. If those checks stay true for five to six consecutive minutes, the system is confident enough to shut down that least-loaded cluster. This cadence provides a balance: it avoids turning off a cluster due to a brief lull, while still letting you reduce capacity when demand is consistently steady. Shorter streaks like one or two checks risk premature shutdown, while longer streaks like seven or eight checks would delay potential cost savings. Keep in mind the policy only applies when there are multiple clusters to reassign the load to.

Economy scaling is about saving costs by removing unused compute without hurting performance. In a multi-cluster warehouse, the system watches whether the workload on the least-loaded cluster can be absorbed by the other clusters without needing to spin up a new one. It checks this at one-minute intervals. If those checks stay true for five to six consecutive minutes, the system is confident enough to shut down that least-loaded cluster. This cadence provides a balance: it avoids turning off a cluster due to a brief lull, while still letting you reduce capacity when demand is consistently steady. Shorter streaks like one or two checks risk premature shutdown, while longer streaks like seven or eight checks would delay potential cost savings. Keep in mind the policy only applies when there are multiple clusters to reassign the load to.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy