Answer-first summary for fast verification
Answer: The additional compute resources are provisioned when the warehouse is resumed.
When a suspended virtual warehouse is resized in Snowflake, the resize operation is recorded but the actual provisioning of additional compute resources does not occur immediately. The warehouse remains suspended, and the new compute resources are only provisioned when the warehouse is explicitly resumed. This behavior is documented in Snowflake's official documentation and confirmed by the community discussion where option D received 100% consensus with supporting documentation references. Option A is incorrect because no error occurs - resizing suspended warehouses is a valid operation. Option B is incorrect because no warning is generated. Option C is incorrect because the warehouse remains suspended and compute resources are not provisioned immediately.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What is the outcome of resizing a suspended virtual warehouse in Snowflake?
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.