SnowPro Advanced Architect Exam

Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam

Question 34

How does a standard virtual warehouse policy work in Snowflake?

It conserves credits by keeping running clusters fully loaded rather than starting additional clusters.

It starts only if the system estimates that there is a query load that will keep the cluster busy for at least 6 minutes.

It starts only f the system estimates that there is a query load that will keep the cluster busy for at least 2 minutes.

It prevents or minimizes queuing by starting additional clusters instead of conserving credits.

Correct Answer: D

A standard virtual warehouse policy in Snowflake works by preventing or minimizing queuing by starting additional clusters instead of conserving credits. This means that the system prioritizes performance and ensuring that queries do not wait in line, rather than saving on resources or credits.

Discussion

victorleonisOption: D

Standard (default) Prevents/minimizes queuing by favoring starting additional clusters over conserving credits.

HighBMIOption: D

https://docs.snowflake.com/en/user-guide/warehouses-multicluster#label-mcw-scaling-policies

hillcat111Option: D

Answer is D and is validated