COF-C03: SnowPro Core Certification

Question

A Medium virtual warehouse handles scheduled reports for a team. More than 30 reports execute concurrently during business hours, and the team needs high availability, consistent performance, and minimal startup time.

What action should be taken to help prevent queuing when these reports run?

Explanation

A multi-cluster warehouse in Auto-scale mode adds clusters as concurrent demand requires. The Standard scaling policy prioritizes responsiveness and throughput by favoring the startup of additional clusters, thereby minimizing query queuing. The Economy policy prioritizes credit conservation and can leave queries queued.

Learn more

COF-C03: SnowPro Core Certification

AstroTutor

Notes

Readiness

QuestionQ17

Community Discussion