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? ```sql ALTER WAREHOUSE my_warehouse SET warehouse_size = 'X-LARGE' -- Add property here ```

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

Exam-Like

Snowflake SnowPro Core

Get started today

Comments