SnowPro Advanced: Data Engineer — Question 63

A Data Engineer is building a data pipeline to ingest incremental data from a data source using streams and tasks in Snowflake. A stream is created on a CUSTOMER_RAW table to track the new records and merge them into a CUSTOMER master table by way of a task that runs every hour.

What will occur if the CUSTOMER_RAW table gets renamed to CUSTOMER_BASE after the task runs for three days?

Answer options

• A. The DESCRIBE STREAM for the stream will show the value of the STALE column as TRUE.
• B. The renaming will cause no disruption to the existing data pipeline.
• C. The DESCRIBE STREAM for the stream will show the value of the STALE column as FALSE.
• D. The TASK_HISTORY for the subsequent run will show an error after the renaming operation.

Correct answer: B

Explanation

Renaming the CUSTOMER_RAW table to CUSTOMER_BASE does not affect the stream, as the stream tracks changes based on the original table's definition. Therefore, the data pipeline continues to function normally, making option B the correct answer. The other options incorrectly assume that the renaming would lead to errors or changes in stream status.