When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).

Question

Options

• AWhen users will be using compute at different times throughout a 24/7 period
• BWhen managing a steady workload
• CWhen the compute must be available with no delay or lag time
• DWhen the user does not want to have to manually turn on the warehouse each time it is needed
• EWhen the warehouse is shared across different teams

• A
  5% (2)
• B
  90% (36)
• D
  3% (1)
• E
  3% (1)

Explanation

Auto-suspend should be disabled when keeping the warehouse continuously active is more beneficial than saving credits. (B) A steady, consistent workload means the warehouse will be in constant use anyway - suspending and resuming adds overhead and wastes credits on the resume process rather than saving them. (C) When queries must execute with zero latency, auto-resume introduces a delay (typically 5–20 seconds) while the warehouse spins back up - disabling auto-suspend keeps the warehouse always-warm. Options A, D, and E are incorrect: sporadic usage across a 24/7 period, avoiding manual restarts (auto-resume handles this), and multi-team sharing are all situations where auto-suspend saves money and auto-resume transparently handles wake-up, so disabling auto-suspend is unnecessary.

No community discussion yet for this question.