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

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

Assuming MY_WH is set to auto_suspend C 60 and used exclusively for this task, which statement is true?
A . The warehouse MY_WH will be made active every five minutes to check the stream.
B . The warehouse MY_WH will only be active when there are results in 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.

View Answer

Answer: B

Explanation:

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]