SnowPro Core Certification — Question 406

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

Answer options

• 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.

Correct answer: D

Explanation

The correct answer, D, indicates that the command will wait until the warehouse has completed the size change before returning control. Options A and B incorrectly focus on the status of queries, while option C misunderstands the suspension process, which is not a requirement for changing the warehouse size.