Snowflake Exam COF-C02 Topic 7 Question 14 Discussion

Actual exam question for Snowflake's COF-C02 exam

Question #: 14
Topic #: 7

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

AThe warehouse size does not change until all queries currently running in the warehouse have completed.

BThe warehouse size does not change until all queries currently in the warehouse queue have completed.

CThe warehouse size does not change until the warehouse is suspended and restarted.

DIt does not return from the command until the warehouse has finished changing its size.

Show Suggested Answer

Suggested Answer: D

by Laurel at May 26, 2023, 05:17 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!