A Snowflake administrator notices that a virtual warehouse named 'REPORTING WH' is frequently idle during off-peak hours. They want to optimize costs by ensuring the warehouse suspends automatically w

Question

Options

• ASet 'AUTO SUSPEND to a low value (e.g., 60 seconds) and set 'AUTO RESUME to FALSE.
• BSet 'AUTO_SUSPEND' to a low value (e.g., 60 seconds) and ensure AUTO_RESUME is TRUE.
• CSet 'AUTO SUSPEND to a high value (e.g., 3600 seconds) and set `AUTO RESUME to TRUE.
• DSet 'AUTO SUSPEND to NULL and set 'AUTO RESUME to FALSE.
• ESet 'AUTO SUSPEND to a low value (e.g., 60 seconds), ensure `AUTO RESUME is TRUE, and

• A
  14% (5)
• B
  51% (18)
• C
  9% (3)
• D
  26% (9)

Explanation

B is correct because setting AUTO_SUSPEND to a low value (like 60 seconds) ensures the warehouse suspends quickly after going idle, directly reducing wasted credits during off-peak hours. AUTO_RESUME = TRUE ensures the warehouse restarts automatically the moment a query is submitted, keeping latency manageable without manual intervention. E extends B by adding an additional optimization (the option is cut off, but typically involves enabling query result caching or a scheduled pre-warm task) to further reduce first-query latency after a cold start.

Why the distractors fail:

• A - AUTO_RESUME = FALSE forces users or applications to manually resume the warehouse before queries run, introducing significant latency and operational overhead.
• C - A 3600-second (1-hour) AUTO_SUSPEND keeps the warehouse running for up to an hour of idle time, negating most of the cost savings the administrator is trying to achieve.
• D - AUTO_SUSPEND = NULL disables automatic suspension entirely (warehouse runs forever), which is the opposite of cost optimization, and AUTO_RESUME = FALSE compounds the problem by requiring manual restarts.

Memory tip: Think of the two settings as a pair - AUTO_SUSPEND controls how fast you save money (lower = faster savings), and AUTO_RESUME controls who turns the lights back on (TRUE = automatic, FALSE = you). For cost + convenience, you always want low suspend + TRUE resume.

No community discussion yet for this question.