Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 770

What is the effect of configuring a virtual warehouse auto-suspend value to ‘0’?

    Correct Answer: A

    Configuring a virtual warehouse auto-suspend value to '0' means that the warehouse will never suspend. When the auto-suspend value is set to 0, the warehouse remains active indefinitely, ensuring that it is always ready for use without undergoing suspension.

Discussion
romega2Option: A

correct

HeetecOption: A

A correct - Valid values Any integer 0 or greater, or NULL: Setting a value less than 60 is allowed, but might not result in the desired/expected behavior because the background process that suspends a warehouse runs approximately every 60 seconds and, therefore, is not intended for enabling exact control over warehouse suspension. Setting a 0 or NULL value means the warehouse never suspends.