Answer: Enable auto-suspend to a low value to minimize credit consumption during inactivity.

Snowflake's best practice for the auto-suspend parameter is to enable it and set it to a low value (typically 5-10 minutes or less) to minimize credit consumption during periods of warehouse inactivity. This approach balances resource availability with cost efficiency by automatically suspending warehouses when they're not in use, preventing unnecessary credit charges. Option C directly aligns with this recommendation. Option A is incorrect because setting auto-suspend to the maximum duration would waste credits during extended idle periods. Option B is suboptimal as a high auto-suspend value still results in unnecessary credit consumption. Option D is the worst practice as disabling auto-suspend keeps warehouses running continuously, leading to maximum credit consumption regardless of actual usage needs.

Author: LeetQuiz Editorial Team