Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

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?

Show Suggested Answer Hide 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


Contribute your Thoughts:

Erinn
4 days ago
D) is just plain wrong. You can't alter a Snowpark-optimized warehouse to a Standard one, that's like mixing oil and water.
upvoted 0 times
...
Johna
11 days ago
Haha, I bet the exam writers are really trying to trick us with these options. Gotta be careful not to alter the wrong warehouse!
upvoted 0 times
...
Shanice
12 days ago
A) seems like the easiest option, but I'm not sure if it will work on an active warehouse. Better to be safe and suspend it first.
upvoted 0 times
...
Ceola
19 days ago
Hmm, that makes sense too. I guess we'll have to wait and see what the actual answer is.
upvoted 0 times
...
Gregoria
23 days ago
I disagree, I believe the correct answer is C) Use the ALTER warehouse command on a suspended Standard virtual warehouse.
upvoted 0 times
...
Erick
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
...

Save Cancel