Answer-first summary for fast verification
Answer: A resize can be completed at any time.
The correct answer is D because Snowflake documentation and community consensus confirm that virtual warehouses can be resized at any time, regardless of their current state (running, suspended, or processing queries). This flexibility is a key feature of Snowflake's architecture. Option A is incorrect because resizing doesn't necessarily affect all query types simultaneously. Option B is wrong because warehouses don't need to be in auto-resume status for resizing. Option C is incorrect because resizing can occur while the warehouse is running, not just when suspended.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When can a virtual warehouse be resized?
A
A resize will affect running, queued, and new queries.
B
A resize can only be completed when the warehouse is in an auto-resume status.
C
A resize must be completed when the warehouse is suspended.
D
A resize can be completed at any time.
No comments yet.