Which statement is true below?

You have create a task as below

CREATE TASK mytask1

WAREHOUSE = mywh

SCHEDULE = ‘5 minute’

WHEN

SYSTEM$STREAM_HAS_DATA(‘MYSTREAM’)

AS

INSERT INTO mytable1(id,name) SELECT id, name FROM mystream WHERE METADATA$ACTION = ‘INSERT’;

Which statement is true below?
A . If SYSTEM$STREAM_HAS_DATA returns false, the task will be skipped
B. If SYSTEM$STREAM_HAS_DATA returns false, the task will still run
C. If SYSTEM$STREAM_HAS_DATA returns false, the task will go to suspended mode

View Answer

Answer: A

Explanation:

SYSTEM$STREAM_HAS_DATA

Indicates whether a specified stream contains change tracking data. Used to skip the current task run if the stream contains no change data.

If the result is FALSE, then the task does not run. https://docs.snowflake.com/en/sql-reference/sql/create-task.html#create-task