Snowflake SnowPro Certification Practice Test

Disable ads (and more) with a membership for a one time $4.99 payment

Prepare for the Snowflake SnowPro Certification exam with flashcards and multiple choice questions. Understand each question with detailed hints and explanations. Ace your test!

Practice this question and more.

What is the shortest duration before a Warehouse can be set to auto-suspend?

1 minute
3 minutes
5 minutes
10 minutes

The correct answer is: 5 minutes

The shortest duration before a Warehouse can be set to auto-suspend in Snowflake is 5 minutes. This feature is designed to help manage compute resources efficiently and reduce costs associated with unused warehouses. By setting the auto-suspend time to 5 minutes, users ensure that they are not incurring charges for a warehouse that is idle while still allowing some buffer time for potential new queries or workloads. A duration of 1 minute is not applicable as it is too short to effectively manage the auto-suspend feature without frequent suspensions and resumptions, which could lead to inefficiencies and slow query performance. Similarly, options of 3 and 10 minutes exceed the minimum required threshold for auto-suspend, making 5 minutes the optimal and shortest allowable period.