Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 1051

How can a Snowsight user change a Standard virtual warehouse to a Snowpark-optimized virtual warehouse?

Use the ALTER WAREHOUSE command on an active Standard virtual warehouse.

Use the ALTER WAREHOUSE command on an active Snowpark-optimized warehouse.

Use the ALTER WAREHOUSE command on a suspended Standard virtual warehouse.

Use the ALTER WAREHOUSE command on a suspended Snowpark-optimized warehouse.

Correct Answer: C

To change a Standard virtual warehouse to a Snowpark-optimized virtual warehouse, the ALTER WAREHOUSE command must be used on a suspended Standard virtual warehouse. This is because altering the type of warehouse is only supported when the warehouse is in the suspended state, ensuring that no active sessions or queries are disrupted during the transition.

Discussion

vs1717Option: C

C https://docs.snowflake.com/en/user-guide/warehouses-snowpark-optimized

nexerSnowOption: C

Changing the warehouse type using the ALTER WAREHOUSE command is only supported for a warehouse in the SUSPENDED state.