SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ66

VerifiedPerformance, Cost, and Resource Optimization

The following DDL statement created a task based on a stream:

Question Image

Assuming MY_WH is configured with auto_suspend = 60 and is used solely for this task, which statement is true?

Explanation

A scheduled task evaluates SYSTEM$STREAM_HAS_DATA('MYSTREAM') before executing. If the stream has no change data, the run is skipped without starting the user-managed warehouse; the WHEN validation is processed by Snowflake’s cloud services layer. Therefore, MY_WH is active only when the stream condition permits the task to execute. Snowflake CREATE TASK documentation

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!