Answer-first summary for fast verification
Answer: It does not return from the command until the warehouse has finished changing its size.
The WAIT_FOR_COMPLETION parameter controls whether the ALTER WAREHOUSE command returns immediately or waits for the resize operation to fully complete. When set to TRUE, the command blocks and does not return until the warehouse has finished changing its size and all compute resources have been fully provisioned. This is particularly useful when resizing to a larger warehouse, as it ensures the command only returns when the warehouse is ready to execute queries using all the new resources. The community discussion confirms this understanding with unanimous support for option D (100% consensus) and references to Snowflake documentation that clearly state this behavior. Options A, B, and C are incorrect because they describe different warehouse behaviors unrelated to the WAIT_FOR_COMPLETION parameter - warehouse size changes can occur while queries are running or queued, and suspension/restart is not required for size changes.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What is the effect of specifying WAIT_FOR_COMPLETION = TRUE when executing an ALTER WAREHOUSE command to change the size of the warehouse?
A
The warehouse size does not change until all queries currently running in the warehouse have completed.
B
The warehouse size does not change until all queries currently in the warehouse queue have completed.
C
The warehouse size does not change until the warehouse is suspended and restarted.
D
It does not return from the command until the warehouse has finished changing its size.