Which statement is false about the following Snowflake task?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

Which statement is false about the following Snowflake task?

Explanation:
When a Snowflake task uses a WHEN clause that references a stream, Snowflake checks that condition at the scheduled time to decide whether to run. If there’s no new data in the stream, the WHEN expression evaluates to false, and the task is skipped for that run. It does not go into a suspended state simply because the stream is empty; suspension is a separate state that requires manual action or a failure, not a lack of data. So the statement that the task will be suspended if the stream doesn’t have data is not correct. The other points are correct: the WHEN expression is evaluated to decide execution, and the task will run when the stream has data and the WHEN condition is true.

When a Snowflake task uses a WHEN clause that references a stream, Snowflake checks that condition at the scheduled time to decide whether to run. If there’s no new data in the stream, the WHEN expression evaluates to false, and the task is skipped for that run. It does not go into a suspended state simply because the stream is empty; suspension is a separate state that requires manual action or a failure, not a lack of data. So the statement that the task will be suspended if the stream doesn’t have data is not correct.

The other points are correct: the WHEN expression is evaluated to decide execution, and the task will run when the stream has data and the WHEN condition is true.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy