
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