Black Friday Reward - Upto 75% off - Ends in 0d 00h 00m 00s - Coupon code: CFsave75

Snowflake SnowPro Core Certification Exam SnowPro-Core Question # 108 Topic 11 Discussion

Note! The SnowPro-Core Exam is no longer available.

Snowflake SnowPro Core Certification Exam SnowPro-Core Question # 108 Topic 11 Discussion

SnowPro-Core Exam Topic 11 Question 108 Discussion:
Question #: 108
Topic #: 11

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 SnowPro-Core Questions

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.