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%

Off

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

Contribute your Thoughts:

Submit Cancel

Erinn

2 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

29 days ago

Got it, thanks for the clarification!

upvoted 0 times

...

Reuben

1 months ago

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

upvoted 0 times

...

Cheryll

1 months ago

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

upvoted 0 times

...

Johna

2 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

2 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

28 days ago

A) Once it's suspended, we can then easily change it to a Snowpark-optimized virtual warehouse.

upvoted 0 times

...

Eden

1 months ago

C) Using the ALTER warehouse command on a suspended Standard virtual warehouse seems like the way to go.

upvoted 0 times

...

Val

1 months ago

A) I agree, it's better to be safe and suspend the warehouse first before making any changes.

upvoted 0 times

...

Ceola

2 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

3 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

3 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

1 months ago

You're welcome!

upvoted 0 times

...

Winifred

2 months ago

Got it, thanks for the tip!

upvoted 0 times

...

Agustin

2 months ago

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

upvoted 0 times

...

Silva

2 months ago

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

upvoted 0 times

...

Ceola

3 months ago

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

upvoted 0 times

...