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

The correct answer is C. Use the ALTER warehouse command on a suspended Standard virtual warehouse. To convert a Standard virtual warehouse to a Snowpark-optimized warehouse, the warehouse must first be in a SUSPENDED state. Snowflake does not allow changes to the warehouse type while it is running (ACTIVE state) because doing so would disrupt in-flight queries and affect the…

Performance Management

Question

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.

How the community answered

(31 responses)

A
16% (5)
B
6% (2)
C
74% (23)
D
3% (1)

Explanation

To convert a Standard virtual warehouse to a Snowpark-optimized warehouse, the warehouse must first be in a SUSPENDED state. Snowflake does not allow changes to the warehouse type while it is running (ACTIVE state) because doing so would disrupt in-flight queries and affect the underlying compute resources. The correct approach is to suspend the warehouse first, then issue the ALTER WAREHOUSE ... SET WAREHOUSE_TYPE = SNOWPARK-OPTIMIZED command. Snowpark-optimized warehouses provide significantly more memory per node, making them suitable for large-scale machine learning and data transformation workloads.

Topics

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

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice