Snowflake COF-C02 Exam - 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

Get Premium COF-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Matt

6 months ago

I'm not so sure about A, seems a bit counterintuitive.

upvoted 0 times

...

Alex

6 months ago

Wait, does that mean it can take longer to resize?

upvoted 0 times

...

Gilma

7 months ago

I thought it was B at first, but A is definitely right!

upvoted 0 times

...

Huey

7 months ago

Totally agree, it makes sense to finish current tasks first.

upvoted 0 times

...

Keshia

7 months ago

A is correct! The size change waits for running queries.

upvoted 0 times

...

Penney

7 months ago

I thought it was about the queries in the queue, so maybe option B? I need to double-check my notes on this.

upvoted 0 times

...

Loreen

7 months ago

I feel like it might be option D since it mentions the command not returning until the size change is done, but that seems a bit off.

upvoted 0 times

...

Layla

8 months ago

I remember a practice question about altering warehouse sizes, and I think it was related to option A, but I can't recall the details.

upvoted 0 times

...

Elly

8 months ago

I think WAIT_FOR_COMPLETION = TRUE means the warehouse size won't change until all running queries finish, but I'm not entirely sure.

upvoted 0 times

...

Merissa

8 months ago

Hmm, I'm a bit unsure about this one. The control environment is one of the COSO components, but I can't quite remember the specific responsibilities. I'll have to think this through carefully.

upvoted 0 times

...

Bette

8 months ago

I'm pretty sure the primary function of a certificate authority is to verify and validate certificates, so I'll go with option B.

upvoted 0 times

...

Steffanie

8 months ago

Hmm, this seems like a tricky one. I'll need to think carefully about the legal definitions of asset ownership.

upvoted 0 times

...