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

Question

A Snowflake virtual warehouse named 'TRANSFORM WH' is configured with the following parameters: 'WAREHOUSE SIZE = XSMALL', 'AUTO SUSPEND = , and 'AUTO RESUME = TRUE. During peak hours, this warehouse processes a large volume of data transformations. However, users report frequent delays as the warehouse repeatedly suspends and resumes. Which of the following changes would BEST address these performance delays while optimizing cost?

Options

• AIncrease the 'AUTO_SUSPEND parameter to a larger value (e.g., 3600 seconds) to prevent
• BIncrease the to MEDIUM. A larger warehouse has more compute power and will finish tasks faster.
• CEnable Multi-Cluster Warehouse with 'MIN CLUSTER COUNT = 1' and `MAX CLUSTER COUNT
• DSet 'AUTO SUSPEND = NULLS. This will prevent the warehouse from ever suspending, ensuring
• EDecrease the 'AUTO_SUSPEND' parameter to a smaller value (e.g., 60 seconds) to force more

Explanation

Increasing (A) merely delays the problem; it doesn't solve the underlying issue of insufficient compute during peak times. Increasing WAREHOUSE SIZE' (B) is a viable option, but Multi- Cluster warehouses (C) provide a more dynamic scaling solution. Setting 'AUTO_SUSPEND = NULL' (D) is wasteful and incurs unnecessary costs, as the warehouse will always be running, even when idle. Decreasing AUTO SUSPEND (E) exacerbates the problem. Multi-Cluster warehouses with a reasonable range allow Snowflake to automatically scale resources based on demand, providing better performance during peak hours and cost optimization during idle

No community discussion yet for this question.