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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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


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

Limited Time Offer

25%

Off

Get Premium COF-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Erinn
8 months 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
Amie
7 months ago
Got it, thanks for the clarification!
upvoted 0 times
...
Reuben
7 months ago
C) Use the ALTER warehouse command on a suspended Standard virtual warehouse.
upvoted 0 times
...
Cheryll
7 months ago
A) Use the ALTER WAREHOUSE command on an active Standard virtual warehouse
upvoted 0 times
...
...
Johna
8 months 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
8 months 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
Evan
7 months ago
A) Once it's suspended, we can then easily change it to a Snowpark-optimized virtual warehouse.
upvoted 0 times
...
Eden
7 months ago
C) Using the ALTER warehouse command on a suspended Standard virtual warehouse seems like the way to go.
upvoted 0 times
...
Val
7 months ago
A) I agree, it's better to be safe and suspend the warehouse first before making any changes.
upvoted 0 times
...
...
Ceola
8 months ago
Hmm, that makes sense too. I guess we'll have to wait and see what the actual answer is.
upvoted 0 times
...
Gregoria
8 months 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
9 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
Andrew
7 months ago
You're welcome!
upvoted 0 times
...
Winifred
8 months ago
Got it, thanks for the tip!
upvoted 0 times
...
Agustin
8 months ago
C) Use the ALTER warehouse command on a suspended Standard virtual warehouse.
upvoted 0 times
...
Silva
8 months ago
A) Use the ALTER WAREHOUSE command on an active Standard virtual warehouse
upvoted 0 times
...
...
Ceola
9 months ago
I think the answer is A) Use the ALTER WAREHOUSE command on an active Standard virtual warehouse.
upvoted 0 times
...

Save Cancel