SnowPro Core Certification — Question 1203

What does Snowflake recommend when configuring the auto-suspend parameter for a virtual warehouse?

Answer options

• A. Set auto-suspend to the maximum possible duration for optimal resource utilization.
• B. Enable auto-suspend to a high value to maximize warehouse availability.
• C. Enable auto-suspend to a low value to minimize credit consumption during inactivity.
• D. Disable auto-suspend to ensure continuous availability of the warehouse.

Correct answer: C

Explanation

The correct answer, C, is appropriate because enabling auto-suspend to a low value helps in reducing credit consumption when the warehouse is not in use. Options A and B contradict this by suggesting longer suspension times, which would not minimize credit usage. Option D is incorrect as disabling auto-suspend leads to unnecessary costs due to continuous warehouse operation.