DEA-C02: SnowPro Advanced — Data Engineer

By Snowflake · Question Mode

QuestionQ23

VerifiedOfficial exam objectives/topics

A stream named TRANSACTIONS_STM is created on a TRANSACTIONS table in a continuous Snowflake pipeline. After a couple of months, the TRANSACTIONS table is renamed to TRANSACTIONS_RAW to meet new naming standards.

What happens to the TRANSACTIONS_STM object?

Explanation

Renaming a Snowflake stream’s source object does not break the stream or cause it to become stale. The stream remains linked to the renamed table and continues operating; only the source table’s name changes. Staleness depends on the stream offset falling outside the source table’s retention period, and the stream name is not automatically changed. Snowflake: Introduction to streams

Learn more

Community Discussion

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