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.
The Answer Is:
D
This question includes an explanation.
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.
Snowflake Documentation: Multi-cluster Warehouses
Snowflake Documentation: Scaling Policy for Multi-cluster Warehouses
ARA-C01 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"