Answer-first summary for fast verification
Answer: When managing a steady workload, When the compute must be available with no delay or lag time
The question asks when to disable auto-suspend for a virtual warehouse, requiring two answers. Auto-suspend automatically stops a warehouse after a period of inactivity to save costs. Disabling it is appropriate when: B) Managing a steady workload - because constant activity means the warehouse wouldn't suspend anyway, and disabling auto-suspend avoids unnecessary suspend/resume cycles. C) When compute must be available with no delay or lag time - because disabling auto-suspend keeps the warehouse running, eliminating the warm-up time required when resuming from suspension. Option A is incorrect as different usage times throughout 24/7 would benefit from auto-suspend during idle periods. Option D describes a scenario for auto-resume, not disabling auto-suspend. Option E about shared warehouses doesn't directly relate to auto-suspend decisions. The community discussion shows 100% consensus on BC with upvoted confirmations.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Under what circumstances should a user disable the auto-suspend feature for a virtual warehouse? (Select two.)
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 the user does not want to have to manually turn on the warehouse each time it is needed
E
When the warehouse is shared across different teams