SnowPro Advanced: Architect — Question 34

How does a standard virtual warehouse policy work in Snowflake?

Answer options

• 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.

Correct answer: D

Explanation

The correct answer is D because a standard virtual warehouse policy aims to enhance performance by spinning up additional clusters to reduce wait times. Options A, B, and C focus on credit conservation or time thresholds, which do not align with the primary objective of minimizing queuing.