Snowflake SnowPro Core Recertification Exam COF-R02 Question # 71 Topic 8 Discussion

Snowflake SnowPro Core Recertification Exam COF-R02 Question # 71 Topic 8 Discussion

COF-R02 Exam Topic 8 Question 71 Discussion:
Question #: 71
Topic #: 8

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-R02 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.