SnowPro Core Certification — Question 813

What will happen if a Snowflake user increases the size of a suspended virtual warehouse?

Answer options

• A. The provisioning of new compute resources for the warehouse will begin immediately.
• B. The warehouse will remain suspended but new resources will be added to the query acceleration service.
• C. The provisioning of additional compute resources will be in effect when the warehouse is next resumed.
• D. The warehouse will resume immediately and start to share the compute load with other running virtual warehouses.

Correct answer: C

Explanation

The correct answer is C because increasing the size of a suspended virtual warehouse means that the additional resources will only be provisioned once the warehouse is resumed. Options A, B, and D are incorrect as they imply immediate provisioning or actions that do not occur while the warehouse is still suspended.