SOL-C01 Question #147: Real Exam Question with Answer & Explanation

Question

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 when not in use, but they also need to minimize the latency for the first query after a period of inactivity. Which combination of actions would achieve this goal?

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

Explanation

Setting `AUTO SUSPEND to a low value (60 seconds) ensures the warehouse suspends quickly when idle (cost optimization). 'AUTO_RESUME = FALSE (A) would require manual warehouse resumption, increasing latency. Setting 'AUTO_RESUME' to TRUE (B, C, E) allows automatic resumption upon a new query. 'AUTO SUSPEND to a high value(C) defeats the purpose of cost optimization. Setting 'AUTO_SUSPEND' to NULL(D) prevents suspension, negating cost savings. Reducing latency requires both automatic resumption (AUTO RESIJME = TRUE) AND minimizing the initial query scan time through proper clustering (E), in combination with AUTO RESUME and a low AUTO_SUSPEND time. Result Cache only helps on repeat queries with the same parameters.

No community discussion yet for this question.