Snowflake Exam ARA-C01 Topic 5 Question 10 Discussion

Actual exam question for Snowflake's ARA-C01 exam

Question #: 10
Topic #: 5

A data platform team creates two multi-cluster virtual warehouses with the AUTO_SUSPEND value set to NULL on one. and '0' on the other. What would be the execution behavior of these virtual warehouses?

ASetting a '0' or NULL value means the warehouses will never suspend.

BSetting a '0' or NULL value means the warehouses will suspend immediately.

CSetting a '0' or NULL value means the warehouses will suspend after the default of 600 seconds.

DSetting a '0' value means the warehouses will suspend immediately, and NULL means the warehouses will never suspend.

Show Suggested Answer

Suggested Answer: B, C

by Salena at Jul 05, 2023, 04:37 PM

Limited Time Offer

25%

Off

Get Premium ARA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Thaddeus

4 days ago

I think C is the right answer. The default suspension time is 600 seconds, so that's what would happen if you set AUTO_SUSPEND to '0' or NULL.

upvoted 0 times

...

Barrett

4 days ago

But what about the default of 600 seconds? Could that be a factor?

upvoted 0 times

...

Nohemi

5 days ago

I disagree, I believe setting a '0' or NULL value means the warehouses will suspend immediately.

upvoted 0 times

...

Barrett

6 days ago

I think setting a '0' or NULL value means the warehouses will never suspend.

upvoted 0 times

...

Jaclyn

7 days ago

So, the execution behavior would be different for each virtual warehouse based on the AUTO_SUSPEND value.

upvoted 0 times

...

Pa

8 days ago

I believe setting '0' means the warehouses will suspend immediately.

upvoted 0 times

...

Elouise

18 days ago

Option D seems to be the correct answer. Setting AUTO_SUSPEND to '0' means the warehouses will suspend immediately, while NULL means they will never suspend.

upvoted 0 times

...

Jaclyn

25 days ago

I think setting NULL means the warehouses will never suspend.

upvoted 0 times

...