SOL-C01 · Question #145
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
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #145. The question stem and answer options stay visible for context.
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
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.