MENU
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?
Suggested Answer: B
Get Premium ARA-C01 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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]
33 comments · newest first
LE
Leota
5 days ago
I agree, B sounds right. It saves resources that way.
GA
Gayla
10 days ago
I think option B is correct. It makes sense for the warehouse to be active only when needed.
JO
Josphine
15 days ago
C is definitely wrong. It will suspend if idle.
DA
Daniel
20 days ago
A seems plausible too, but I lean towards B.
LE
Lenna
26 days ago
I agree, B sounds right. Only active with results.
JO
Josue
1 month ago
I think option B is correct. It makes sense for efficiency.
BE
Beth
1 month ago
C is definitely wrong. It has to suspend eventually if idle.
DI
Diane
1 month ago
A sounds plausible too, but I feel it’s not efficient.
TU
Tu
2 months ago
I agree, B seems logical. No point in wasting resources otherwise.
BU
Bulah
2 months ago
I think B is correct. It makes sense for the warehouse to activate only when needed.
EM
Emile
2 months ago
Just to clarify, MY_WH is only for this task, right?
CH
Chaya
2 months ago
D) sounds interesting, but I doubt it actually resizes.
NI
Nilsa
2 months ago
Wait, C) can't be right, it has auto_suspend!
HA
Haydee
2 months ago
I disagree, B) makes more sense to me.
SO
Sommer
3 months ago
A) is correct, it checks every five minutes.
JE
Jesus
3 months ago
I thought it would resize automatically, but I guess not!
NA
Narcisa
3 months ago
B) is definitely the right answer here.
CA
Carin
3 months ago
Wait, MY_WH never suspends? That seems off.
CO
Corazon
3 months ago
I disagree, it only activates with results in the stream.
DO
Dorothy
3 months ago
A) is correct, it checks every 5 minutes.
WY
Wynell
4 months ago
I thought it would resize automatically, but I guess not.
LU
Lucy
5 months ago
B) is definitely the right answer here.
BU
Bulah
5 months ago
Wait, MY_WH never suspends? That sounds odd.
AN
Annamae
5 months ago
I disagree, it only activates with results in the stream.
JO
Josphine
6 months ago
A) is correct, it checks every five minutes.
LA
Lacey
6 months ago
I doubt that the warehouse will never suspend; that seems too extreme given the auto-suspend setting.
RO
Rodolfo
6 months ago
I practiced a similar question, and I feel like option A might be correct since it mentions checking the stream regularly.
RO
Rodolfo
6 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.
EM
Emerson
6 months ago
I think the warehouse will only be active when there are results in the stream, but I'm not entirely sure.
TR
Tracey
6 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.
WI
Wilson
7 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.
MO
Moira
7 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.
VI
Viki
7 months ago
I think the warehouse will only be active when there are results in the stream, but I'm not entirely sure.