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

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.