SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ36

Performance, Cost, and Resource Optimization

A retail company operates more than 2,000 stores across the country. Store Managers say they have difficulty running key reports for inventory management, sales targets, payroll, and staffing during business hours. They report poor performance and frequent time-outs.

All reports currently use the same Snowflake virtual warehouse.

How should this situation be resolved?

Choose two
Explanation

A dedicated virtual warehouse isolates the Store Manager reporting workload from other workloads, preventing them from competing for the same compute resources. A multi-cluster warehouse adds compute clusters to address high user and query concurrency, reducing queuing and associated time-outs. Snowflake advises using additional warehouses or multi-cluster warehouses for concurrency issues rather than relying on warehouse resizing.

Learn more

Community Discussion

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