SnowPro Advanced: Architect — Question 102

A retail company has 2000+ stores spread across the country. Store Managers report that they are having trouble running key reports related to inventory management, sales targets, payroll, and staffing during business hours. The Managers report that performance is poor and time-outs occur frequently.

Currently all reports share the same Snowflake virtual warehouse.

How should this situation be addressed? (Choose two.)

Answer options

• A. Use a Business Intelligence tool for in-memory computation to improve performance.
• B. Configure a dedicated virtual warehouse for the Store Manager team.
• C. Configure the virtual warehouse to be multi-clustered.
• D. Configure the virtual warehouse to size 4-XL.
• E. Advise the Store Manager team to defer report execution to off-business hours.

Correct answer: B, C

Explanation

Configuring a dedicated virtual warehouse for the Store Manager team (B) will allow them to run their reports without being affected by the workload of other users, thus improving performance. Additionally, making the virtual warehouse multi-clustered (C) can help handle concurrent report executions more effectively, reducing time-outs. The other options either do not address the core issue of performance during business hours or suggest less effective measures.