Answer-first summary for fast verification
Answer: WAIT_FOR_COMPLETION
The WAIT_FOR_COMPLETION parameter must be added to the ALTER WAREHOUSE command to ensure that the additional compute resources for a virtual warehouse are fully provisioned before proceeding. This parameter waits for the warehouse to complete the resize operation, confirming that all resources are ready. The community discussion unanimously supports option D, with multiple users confirming it as correct and providing documentation links that explicitly state this requirement. Other options are incorrect: QUERY_ACCELERATION_MAX_SCALE_FACTOR controls query acceleration scaling, RESOURCE_MONITOR manages resource usage limits, and SCALING_POLICY defines auto-scaling behavior, none of which verify resource provisioning.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In Snowflake, which parameter should be included in the ALTER WAREHOUSE command to ensure that a resized virtual warehouse has fully provisioned its additional compute resources before continuing?
ALTER WAREHOUSE my_warehouse
SET
warehouse_size = 'X-LARGE'
-- Add property here
ALTER WAREHOUSE my_warehouse
SET
warehouse_size = 'X-LARGE'
-- Add property here
A
QUERY_ACCELERATION_MAX_SCALE_FACTOR
B
RESOURCE_MONITOR
C
SCALING_POLICY
D
WAIT_FOR_COMPLETION
