Snowflake Quiz — Streams, Tasks & Data Pipelines

1. What is a Snowflake Stream used for?

2. Which type of stream captures only the new changes since the last read?

3. How do you create a stream on a table 'sales'?

4. What is a Snowflake Task used for?

5. How do you create a scheduled task that runs every hour?

6. How do you consume data from a stream to update a target table?

7. What is a Snowflake Pipe used for?

8. How do you create a Snowflake Pipe for a stage '@my_stage' and table 'sales'?

9. How can you monitor which tasks have run in Snowflake?

10. How do you chain multiple tasks in Snowflake based on success of a previous task?