Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 897 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 897
Topic #: 1
[All SnowPro Core Questions]

What general guideline does Snowflake recommend when setting the auto-suspension time limit?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
BobFar
Highly Voted 1 year ago
B is correct. https://docs.snowflake.com/en/user-guide/warehouses-considerations#automating-warehouse-suspension
upvoted 7 times
...
gaco
Most Recent 3 weeks, 2 days ago
Selected Answer: 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.
upvoted 1 times
...
gizzamo
10 months, 3 weeks ago
Selected Answer: B
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
upvoted 2 times
...
Heetec
1 year ago
Selected Answer: B
B correct
upvoted 2 times
...
Pradeep_7869
1 year ago
It shoulb be 5 min B
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel
Loading ...