SnowPro Core Certification — Question 61

When should you 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 you do not want to have to manually turn on the Warehouse each time a user needs it

Correct answer: B, C

Explanation

The correct answers are B and C because disabling auto-suspend is beneficial for managing a steady workload (B) and ensuring that compute resources are readily available without any waiting time (C). Options A and D do not justify a need to disable auto-suspend, as they do not specifically relate to the need for uninterrupted availability or consistent workload management.