Answer-first summary for fast verification
Answer: When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
Based on the community discussion and Snowflake documentation, option B is correct because when reducing warehouse size, Snowflake safely removes compute resources only after they are no longer executing any current statements, ensuring no disruption to active queries. Option A is incorrect because increasing warehouse size adds resources without affecting running queries. Option C is incorrect because warehouses are not suspended during resizing - they remain operational. Option D is incorrect because users do not receive error messages during resizing; the process is transparent to users with minimal disruption.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What occurs when a virtual warehouse in Snowflake is resized?
A
When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected.
B
When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
C
The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
D
Users who are trying to use the warehouse will receive an error message until the resizing is complete.
No comments yet.