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?

AThe warehouse MY_WH will be made active every five minutes to check the stream.

BThe warehouse MY_WH will only be active when there are results in the stream.

CThe warehouse MY_WH will never suspend.

DThe warehouse MY_WH will automatically resize to accommodate the size of the stream.

Show Suggested 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:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!