Answer-first summary for fast verification
Answer: Set tasks for suspension after 5 minutes.
The correct answer is B based on Snowflake's official documentation and community consensus. Snowflake recommends setting auto-suspend to a low value (e.g., 5 minutes) for virtual warehouses to minimize credit consumption since billing is per-second. This is explicitly stated in Snowflake's documentation on warehouse considerations. While some comments mention 10 minutes for BI warehouses or immediate suspension for tasks, the question specifically asks for the general guideline for virtual warehouses, making B the optimal choice. Options C and D (15 and 30 minutes) are too high and contradict cost-saving best practices, as they would lead to unnecessary credit usage during idle periods.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is the general Snowflake recommendation for configuring the auto-suspend time limit for a virtual warehouse?
A
Set tasks for immediate suspension.
B
Set tasks for suspension after 5 minutes.
C
Set query warehouses for suspension after 15 minutes.
D
Set query warehouses for suspension after 30 minutes.
No comments yet.