Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake ARA-C01 Exam - Topic 4 Question 61 Discussion

The following DDL command was used to create a task based on a stream:Assuming MY_WH is set to auto_suspend -- 60 and used exclusively for this task, which statement is true?
B) The warehouse MY_WH will only be active when there are results in the stream.
A) The warehouse MY_WH will be made active every five minutes to check the stream.
C) The warehouse MY_WH will never suspend.
D) The warehouse MY_WH will automatically resize to accommodate the size of the stream.

Snowflake ARA-C01 Exam - Topic 4 Question 61 Discussion

Actual exam question for Snowflake's ARA-C01 exam
Question #: 61
Topic #: 4
[All ARA-C01 Questions]

The following DDL command was used to create a task based on a stream:

Assuming MY_WH is set to auto_suspend -- 60 and used exclusively for this task, which statement is true?

Show Suggested Answer Hide Answer
Suggested Answer: B

The warehouse MY_WH will only be active when there are results in the stream. This is because the task is created based on a stream, which means that the task will only be executed when there are new data in the stream. Additionally, the warehouse is set to auto_suspend - 60, which means that the warehouse will automatically suspend after 60 seconds of inactivity. Therefore, the warehouse will only be active when there are results in the stream.Reference:

[CREATE TASK | Snowflake Documentation]

[Using Streams and Tasks | Snowflake Documentation]

[CREATE WAREHOUSE | Snowflake Documentation]


by Louann at Mar 08, 2026, 07:35 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Lucy
23 days ago
B) is definitely the right answer here.
upvoted 0 times
...
Bulah
28 days ago
Wait, MY_WH never suspends? That sounds odd.
upvoted 0 times
...
Annamae
1 month ago
I disagree, it only activates with results in the stream.
upvoted 0 times
...
Josphine
1 month ago
A) is correct, it checks every five minutes.
upvoted 0 times
...
Lacey
1 month ago
I doubt that the warehouse will never suspend; that seems too extreme given the auto-suspend setting.
upvoted 0 times
...
Rodolfo
2 months ago
I practiced a similar question, and I feel like option A might be correct since it mentions checking the stream regularly.
upvoted 0 times
...
Rodolfo
2 months ago
I remember something about auto-suspend settings, but I can't recall if that means it checks every five minutes or only when needed.
upvoted 0 times
...
Emerson
2 months ago
I think the warehouse will only be active when there are results in the stream, but I'm not entirely sure.
upvoted 0 times
...
Tracey
2 months ago
I feel like option A makes sense, but I also remember that auto-suspend means it could stay inactive until there's data.
upvoted 0 times
...
Wilson
2 months ago
I practiced a similar question where the warehouse was set to auto-resize, but I don't think that's the case here.
upvoted 0 times
...
Moira
2 months ago
I remember something about auto-suspend settings, but I can't recall if it means the warehouse will check the stream every five minutes or only when needed.
upvoted 0 times
...
Viki
3 months ago
I think the warehouse will only be active when there are results in the stream, but I'm not entirely sure.
upvoted 0 times
...

Save Cancel