SnowPro Core Certification — Question 668

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

Answer options

• 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

Correct answer: B, C

Explanation

Disabling auto-suspend is beneficial for steady workloads (B), as it ensures the warehouse remains active to handle ongoing tasks without interruption. Additionally, it is crucial when immediate availability is required without any lag time (C). The other options, while relevant to usage patterns, do not necessitate disabling auto-suspend.