Answer-first summary for fast verification
Answer: When managing a steady workload, When the compute must be available with no delay or lag time
According to Snowflake documentation and the community consensus with 100% agreement, auto-suspend should be disabled when: (B) managing a steady workload, as frequent suspension and resumption would be inefficient for continuous usage; and (C) when compute must be available with no delay or lag time, as auto-suspend introduces a brief provisioning delay when resuming. Option A is incorrect because varying usage patterns benefit from auto-suspend to save costs during idle periods. Option D describes a scenario where auto-resume (not disabling auto-suspend) would be appropriate, as auto-suspend can still be enabled while allowing automatic resumption.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Under which two circumstances should you consider disabling the auto-suspend feature for a virtual warehouse?
A
When users will be using compute at different times throughout a 24/7 period
B
When managing a steady workload
C
When the compute must be available with no delay or lag time
D
When you do not want to have to manually turn on the Warehouse each time a user needs it
No comments yet.