If a multi-cluster warehouse is using an economy scaling policy, how long will queries wait in the queue before another cluster is started?

The correct answer is B. 2 minutes. With the Economy scaling policy, Snowflake waits approximately 2 minutes before starting an additional cluster to handle queued queries. This is in contrast to the Standard scaling policy, which starts a new cluster almost immediately when queries queue up. The Economy policy…

Performance Management

Question

Options

A1 minute
B2 minutes
C6 minutes
D8 minutes

How the community answered

(42 responses)

A
2% (1)
B
86% (36)
C
10% (4)
D
2% (1)

Explanation

With the Economy scaling policy, Snowflake waits approximately 2 minutes before starting an additional cluster to handle queued queries. This is in contrast to the Standard scaling policy, which starts a new cluster almost immediately when queries queue up. The Economy policy is designed to conserve credits by tolerating short queue wait times, making it suitable for workloads where cost efficiency is prioritized over minimal latency. The 2-minute threshold is a key exam fact that differentiates Economy from Standard scaling behavior.

Topics

#Multi-cluster warehouses#Economy scaling policy#Warehouse scaling#Query queuing

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice