What general guideline does Snowflake recommend when setting the auto-suspension time limit?
What general guideline does Snowflake recommend when setting the auto-suspension time limit?
Snowflake recommends setting auto-suspension to a low value, such as 5 minutes or less, because Snowflake utilizes per-second billing. This helps in minimizing costs by preventing warehouses from running and consuming credits when they are not in use.
B is correct. https://docs.snowflake.com/en/user-guide/warehouses-considerations#automating-warehouse-suspension
It shoulb be 5 min B
B correct
If you enable auto-suspend, we recommend setting it to a low value (e.g. 5 or 10 minutes or less) because Snowflake utilizes per-second billing. This will help keep your warehouses from running (and consuming credits) when not in use. https://docs.snowflake.com/en/user-guide/warehouses-considerations#automating-warehouse-suspension
Nowhere in the question is saying that the auto-suspension is for the warehouse, thats the confusion. Based on the alternatives the question is asking for auto suspension of TASK and QUERY. And as per this official blog the answer is A, Best Practice #3: Set Timeouts Appropriately for Workloads All virtual warehouses should have an appropriate timeout for their particular workload: For task, data loading, and ETL/ELT warehouses, set the timeout for suspension immediately upon completion. For BI and SELECT query warehouses, set the suspension timeout to 10 minutes in most situations to keep data caches warm for frequent access by end users. For DevOps, DataOps, and data science warehouses, set the suspension timeout to 5 minutes because having a warm cache is not as important for ad hoc and highly unique queries.
There is no way to set suspension for the Task in minutes, only parameter SUSPEND_TASK_AFTER_NUM_FAILURES
Warehouse suspension guideline is 10 min. C and D are not correct. I never saw a guide line for 5 min for task. I didn't see any guideline for tasks, but I do not see any reason why to keep it active, without any reason. Hence, not B. Answer is A.