You have a Snowflake virtual warehouse named 'ANALYTICS WH' that is used for complex data transformations. You need to ensure that the warehouse automatically suspends itself when it's idle to minimize costs, but also want to ensure it can quickly resume when a query is submitted.
You also want to scale up the warehouse size during peak business hours to handle increased query load. Which of the following actions should you take?
Correct Answer: D
Option D is the most appropriate solution. Setting to a reasonable value (300 seconds = 5 minutes) ensures cost optimization by automatically suspending the warehouse when idle.
Setting 'AUTO_RESUME = TRUE ensures the warehouse resumes automatically when a query is submitted. Using a scheduled task with SALTER WAREHOUSE' provides programmatic control to resize the warehouse during peak hours. A is mostly correct but uses resource monitor to handle increasing and decreasing the warehouse size, using Scheduled Tasks to do this is more appropriate. B has `AUTO RESUME = FALSE', which is undesirable. C is incorrect since resource monitors cannot increase/decrease warehouse size. E while related to cost management, resource monitors themselves don't handle warehouse resizing dynamically based on workload. Using a task for this with 'ALTER WAREHOUSE provides explicit control.