COF-C02 Question #640: Real Exam Question with Answer & Explanation

The correct answer is C: Use the ALTER warehouse command on a suspended Standard virtual warehouse.. To change a Standard virtual warehouse to a Snowpark-optimized virtual warehouse, the warehouse must be in a suspended state. This ensures that no operations are disrupted during the modification process. Suspend the Warehouse: Ensure that the warehouse is suspended. ALTER WAREHO

Performance Management

Question

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

Options

AUse the ALTER WAREHOUSE command on an active Standard virtual warehouse
BUse the alter warehouse command on an active Snowpark-optimized warehouse.
CUse the ALTER warehouse command on a suspended Standard virtual warehouse.
DUse the ALTER WAREHOUSE command on a suspended Snowpark-optimized warehouse.

Explanation

To change a Standard virtual warehouse to a Snowpark-optimized virtual warehouse, the warehouse must be in a suspended state. This ensures that no operations are disrupted during the modification process. Suspend the Warehouse: Ensure that the warehouse is suspended. ALTER WAREHOUSE my_warehouse SUSPEND; Alter the Warehouse: Modify the warehouse to be Snowpark-optimized. ALTER WAREHOUSE my_warehouse SET WAREHOUSE_TYPE = 'SNOWPARK-OPTIMIZED'; Resume the Warehouse: Resume the warehouse to make it operational. ALTER WAREHOUSE my_warehouse RESUME;

Topics

#Virtual Warehouses#Snowpark-optimized Warehouses#ALTER WAREHOUSE#Warehouse Configuration

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice Browse All COF-C02 Questions