Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
What is the effect of specifying WAIT_FOR_COMPLETION = TRUE when executing an ALTER WAREHOUSE command to change the size of the warehouse?
WAIT_FOR_COMPLETION = TRUE
ALTER 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.
