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.
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.
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
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
BobFar
Highly Voted 1 year, 5 months ago37ceea2
Most Recent 1 month, 4 weeks agobor4un
2 months, 3 weeks agogaco
5 months, 3 weeks agogizzamo
1 year, 3 months agoHeetec
1 year, 5 months agoPradeep_7869
1 year, 5 months ago