Pre-Summer Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: validbest

Discussions
  1. Home
  2. Discussions
  3. Snowflake
  4. SnowPro Core Certification
  5. COF-C02 Discussions
  6. COF-C02 Exam Topic 10 Question 82 Discussion
 Snowflake Discussions
Exam COF-C02 All Questions
Exam COF-C02 All Questions

View all questions & answers for the COF-C02 exam

Go to Exam

Snowflake SnowPro Core Certification COF-C02 Question # 82 Topic 10 Discussion

COF-C02 Exam Topic 10 Question 82 Discussion:
Question #: 82
Topic #: 10

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

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

B.

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

C.

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

D.

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

Get Premium COF-C02 Questions
Actual exam question for Snowflake COF-C02 exam by Rael44985 at Apr 28, 2026, 3:55:13 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit