Snowflake Exam COF-C02 Topic 6 Question 42 Discussion

Actual exam question for Snowflake's COF-C02 exam

Question #: 42
Topic #: 6

[All COF-C02 Questions]

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

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.

Show Suggested Answer

Suggested Answer: C

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;

References:

Snowflake Documentation: Creating Snowpark-Optimized Warehouses

Snowflake Documentation: ALTER WAREHOUSE

by Silvana at Sep 14, 2024, 03:54 AM

Limited Time Offer

25%

1 months ago

C) is the way to go. You need to suspend the Standard virtual warehouse before you can change it to Snowpark-optimized.

upvoted 0 times

Winifred

12 days ago

Got it, thanks for the tip!

upvoted 0 times

...

Agustin

21 days ago

C) Use the ALTER warehouse command on a suspended Standard virtual warehouse.

upvoted 0 times

...

Silva

22 days ago

A) Use the ALTER WAREHOUSE command on an active Standard virtual warehouse

upvoted 0 times

...

Ceola

1 months ago

I think the answer is A) Use the ALTER WAREHOUSE command on an active Standard virtual warehouse.

upvoted 0 times

...