Answer-first summary for fast verification
Answer: The provisioning of additional compute resources will be in effect when the warehouse is next resumed.
According to Snowflake documentation and the community discussion consensus (with 100% agreement and upvoted comments), resizing a suspended virtual warehouse does not immediately provision new compute resources. Instead, Snowflake stores the new size configuration and will provision the additional compute resources only when the warehouse is next resumed. This behavior prevents unnecessary resource consumption and credit charges while the warehouse is suspended. Option A is incorrect because provisioning doesn't begin immediately. Option B is wrong because query acceleration service resources are separate from warehouse compute resources. Option D is incorrect because the warehouse doesn't resume immediately and doesn't share compute load with other warehouses.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What happens when a Snowflake user resizes a virtual warehouse that is in a suspended state?
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.
No comments yet.