SOL-C01 · Question #191
You have a Snowflake virtual warehouse named 'COMPUTE that is experiencing performance issues during peak hours. The workload consists of a mix of complex analytical queries and high- volume data load
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #191. The question stem and answer options stay visible for context.
Question
You have a Snowflake virtual warehouse named 'COMPUTE that is experiencing performance issues during peak hours. The workload consists of a mix of complex analytical queries and high- volume data loading operations. To optimize performance, you want to implement resource monitoring and auto- scaling. Which of the following strategies would be MOST effective?
Options
- AIncrease the size of 'COMPUTE_WH' to a larger T-shirt size (e.g., from Medium to Large).
- BCreate a resource monitor that triggers notifications when the warehouse's credit consumption
- CEnable auto-suspend on "COMPUTE_WH' to minimize costs during idle periods.
- DCreate separate virtual warehouses for analytical queries and data loading, configure auto-scaling
- EImplement workload management rules to prioritize analytical queries over data loading
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.