SnowPro Core Certification — Question 1026

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

Answer options

• A. Use the ALTER WAREHOUSE command on an active Standard virtual warehouse.
• B. Use the ALTER WAREHOUSE command on an active Snowpark-optimized warehouse.
• C. Use the ALTER WAREHOUSE command on a suspended Standard virtual warehouse.
• D. Use the ALTER WAREHOUSE command on a suspended Snowpark-optimized warehouse.

Correct answer: C

Explanation

The correct answer is C because the ALTER WAREHOUSE command can only convert a suspended Standard virtual warehouse to a Snowpark-optimized virtual warehouse. Options A and B are incorrect as they involve active warehouses, and option D is incorrect because you cannot change a suspended Snowpark-optimized warehouse into a Standard one.