SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 1274


Which Snowflake multi-cluster virtual warehouse scaling policy or mode will MINIMIZE query queuing by prioritizing the startup of additional clusters?

Show Answer
Correct Answer:

Discussion

4 comments
Sign in to comment
37ceea2Option: B
Jan 21, 2025

The question must be refined. Or a scaling policy - and the answer is B, or the scaling mode and the answer is D.

37ceea2
Jan 31, 2025

Corection: if it is about MODE, it is AUTO-SCALE MODE C.

bor4unOption: B
Jan 24, 2025

https://docs.snowflake.com/en/user-guide/warehouses-multicluster#setting-the-scaling-policy-for-a-multi-cluster-warehouse

pieterjacobi1Option: B
Jan 27, 2025

Standard policy (B): Minimizes query queuing by prioritizing the startup of additional clusters as soon as they are needed.

BillhardyOption: B
Apr 20, 2025

To minimize query queuing in a multi‑cluster warehouse, you should use the Standard scaling policy. Under Standard (the default) policy, Snowflake prioritizes starting additional clusters as soon as it detects queued queries or anticipates insufficient capacity, ensuring queries run without delay.