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

Save Cancel