How does a standard virtual warehouse policy work in Snowflake?

Question

Options

• AIt conserves credits by keeping running clusters fully loaded rather than starting additional clusters.
• BIt starts only if the system estimates that there is a query load that will keep the cluster busy for at
• CIt starts only f the system estimates that there is a query load that will keep the cluster busy for at
• DIt prevents or minimizes queuing by starting additional clusters instead of conserving credits.

• A
  3% (1)
• B
  3% (1)
• C
  5% (2)
• D
  89% (33)

Explanation

In a multi-cluster virtual warehouse, the Standard scaling policy prioritizes preventing or minimizing query queuing. When queries begin to queue, Snowflake immediately starts additional clusters to handle the load, trading credit efficiency for query responsiveness. Option A describes the Economy scaling policy, which keeps existing clusters fully loaded before adding new ones. Options B and C also describe the Economy policy, which only starts additional clusters when the system estimates the query load will keep the new cluster busy - avoiding the startup cost for short bursts. The Standard policy is the opposite: it starts clusters proactively at the first sign of queuing.

No community discussion yet for this question.