COF-C03: SnowPro Core Certification

By Snowflake · Question Mode

QuestionQ17

Performance Optimization, Querying & Transformation

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

Community Discussion

No comments yet. Be the first to start the discussion!