Which property needs to be added to the ALTER WAREHOUSE command to verify the additional compute resources for a virtual warehouse have been fully provisioned?
Which property needs to be added to the ALTER WAREHOUSE command to verify the additional compute resources for a virtual warehouse have been fully provisioned?
To verify that additional compute resources for a virtual warehouse have been fully provisioned, the property WAIT_FOR_COMPLETION needs to be added to the ALTER WAREHOUSE command. This parameter ensures that the command waits until the requested scaling operation is complete, providing confirmation that the resources are available.
https://docs.snowflake.com/en/user-guide/warehouses-tasks
Correct
D correct
https://docs.snowflake.com/en/user-guide/warehouses-tasks#:~:text=To%20verify%20the%20additional%20compute%20resources%20for%20your%20warehouse%20have%20been%20fully%20provisioned%2C%20add%20the%20WAIT_FOR_COMPLETION%20parameter%20to%20the%20ALTER%20WAREHOUSE%20command.