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.)
To address performance issues and frequent time-outs reported by Store Managers when running key reports, it is best to configure a dedicated virtual warehouse specifically for the Store Manager team and configure the virtual warehouse to be multi-clustered. Configuring a dedicated virtual warehouse ensures that resources are allocated exclusively for the Store Manager team's report generation without interference from other processes. Additionally, making the virtual warehouse multi-clustered enhances performance by automatically scaling resources in response to the demand, reducing the likelihood of time-outs and improving report execution speed.
Agree with the answer