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
Tu
1 day ago
I agree, B seems logical. No point in wasting resources otherwise.
upvoted 0 times
...
Bulah
6 days ago
I think B is correct. It makes sense for the warehouse to activate only when needed.
upvoted 0 times
...
Emile
11 days ago
Just to clarify, MY_WH is only for this task, right?
upvoted 0 times
...
Chaya
17 days ago
D) sounds interesting, but I doubt it actually resizes.
upvoted 0 times
...
Nilsa
22 days ago
Wait, C) can't be right, it has auto_suspend!
upvoted 0 times
...
Haydee
27 days ago
I disagree, B) makes more sense to me.
upvoted 0 times
...
Sommer
1 month ago
A) is correct, it checks every five minutes.
upvoted 0 times
...
Jesus
1 month ago
I thought it would resize automatically, but I guess not!
upvoted 0 times
...
Narcisa
1 month ago
B) is definitely the right answer here.
upvoted 0 times
...
Carin
2 months ago
Wait, MY_WH never suspends? That seems off.
upvoted 0 times
...
Corazon
2 months ago
I disagree, it only activates with results in the stream.
upvoted 0 times
...
Dorothy
2 months ago
A) is correct, it checks every 5 minutes.
upvoted 0 times
...
Wynell
2 months ago
I thought it would resize automatically, but I guess not.
upvoted 0 times
...
Lucy
4 months ago
B) is definitely the right answer here.
upvoted 0 times
...
Bulah
4 months ago
Wait, MY_WH never suspends? That sounds odd.
upvoted 0 times
...
Annamae
4 months ago
I disagree, it only activates with results in the stream.
upvoted 0 times
...
Josphine
4 months ago
A) is correct, it checks every five minutes.
upvoted 0 times
...
Lacey
4 months ago
I doubt that the warehouse will never suspend; that seems too extreme given the auto-suspend setting.
upvoted 0 times
...
Rodolfo
4 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
5 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
5 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
5 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
5 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
5 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
6 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