How does a standard virtual warehouse policy work in Snowflake?

How does a standard virtual warehouse policy work in Snowflake?
A . It conserves credits by keeping running clusters fully loaded rather than starting additional clusters.
B . It starts only if the system estimates that there is a query load that will keep the cluster busy for at least 6 minutes.
C . It starts only f the system estimates that there is a query load that will keep the cluster busy for at least 2 minutes.
D . It prevents or minimizes queuing by starting additional clusters instead of conserving credits.

View Answer

Answer: D

Explanation:

A standard virtual warehouse policy is one of the two scaling policies available for multi-cluster warehouses in Snowflake. The other policy is economic. A standard policy aims to prevent or minimize queuing by starting additional clusters as soon as the current cluster is fully loaded, regardless of the number of queries in the queue. This policy can improve query performance and concurrency, but it may also consume more credits than an economic policy, which tries to conserve credits by keeping the running clusters fully loaded before starting additional clusters. The scaling policy can be set when creating or modifying a warehouse, and it can be changed at any time.

Reference: Snowflake Documentation: Multi-cluster Warehouses

Snowflake Documentation: Scaling Policy for Multi-cluster Warehouses