SnowPro Core Recertification — Question 11

What happens when a suspended virtual warehouse is resized in Snowflake?

Answer options

• A. It will return an error.
• B. It will return a warning.
• C. The suspended warehouse is resumed and new compute resources are provisioned immediately.
• D. The additional compute resources are provisioned when the warehouse is resumed.

Correct answer: D

Explanation

The correct answer is D because when a suspended virtual warehouse is resized, the additional compute resources are only allocated once the warehouse is resumed. Options A and B are incorrect as resizing a suspended warehouse does not generate an error or a warning. Option C incorrectly states that resources are provisioned immediately, which is not the case.