COF-C02 · Question #199
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?
The correct answer is D. It does not return from the command until the warehouse has finished changing its size. The WAIT_FOR_COMPLETION = TRUE parameter in an ALTER WAREHOUSE command ensures that the command does not return until the warehouse has completed resizing. This means that the command will wait until all the necessary compute resources have been provisioned and the warehouse…
Question
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?
Options
- AThe warehouse size does not change until all queries currently running in the warehouse have
- BThe warehouse size does not change until all queries currently in the warehouse queue have
- CThe warehouse size does not change until the warehouse is suspended and restarted.
- DIt does not return from the command until the warehouse has finished changing its size.
How the community answered
(23 responses)- B4% (1)
- D96% (22)
Explanation
The WAIT_FOR_COMPLETION = TRUE parameter in an ALTER WAREHOUSE command ensures that the command does not return until the warehouse has completed resizing. This means that the command will wait until all the necessary compute resources have been provisioned and the warehouse size has been changed.
Topics
Community Discussion
No community discussion yet for this question.