Snowflake
COF-R02 · Question #305
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. See the full explanation below for the reasoning.
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
(34 responses)- A3% (1)
- B6% (2)
- C9% (3)
- D82% (28)
Community Discussion
No community discussion yet for this question.