SnowPro Core Certification — Question 946

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

When a suspended warehouse is resized, the additional compute resources are provisioned only once the warehouse is resumed, making option D the correct answer. Options A and B are incorrect as resizing does not generate an error or a warning. Option C is also incorrect because the new compute resources are not provisioned immediately; they are provisioned on resumption.