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

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
Rodolfo
3 days 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
9 days 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
14 days 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
19 days 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
24 days 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
29 days 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
1 month 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