SnowPro Advanced: Data Engineer — Question 7

A stream called TRANSACTIONS_STM is created on top of a TRANSACTIONS table in a continuous pipeline running in Snowflake. After a couple of months, the TRANSACTIONS table is renamed TRANSACTIONS_RAW to comply with new naming standards.
What will happen to the TRANSACTIONS_STM object?

Answer options

• A. TRANSACTIONS_STM will keep working as expected.
• B. TRANSACTIONS_STM will be stale and will need to be re-created.
• C. TRANSACTIONS_STM will be automatically renamed TRANSACTIONS_RAW_STM.
• D. Reading from the TRANSACTIONS_STM stream will succeed for some time after the expected STALE_TIME.

Correct answer: A

Explanation

The correct answer is A because Snowflake streams are designed to continue functioning despite changes to the underlying table names. Options B and C are incorrect as there is no need to recreate the stream or automatically rename it. Option D is also incorrect because the stream will continue to operate normally, not just for a limited time.