Exam SnowPro Advanced Data Engineer topic 1 question 80 discussion

Actual exam question from Snowflake's SnowPro Advanced Data Engineer

Question #: 80
Topic #: 1

[All SnowPro Advanced Data Engineer Questions]

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?

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.

Show Suggested Answer

Suggested Answer: A 🗳️

by KeylorCR at Aug. 3, 2025, 4:36 p.m.

Comments

Submit Cancel

KeylorCR

1 week, 6 days ago

Selected Answer: B

Correction to my other comment, I meant to click B

upvoted 1 times

...

KeylorCR

1 week, 6 days ago

Selected Answer: C

https://docs.snowflake.com/en/user-guide/streams-intro "Renaming a source object does not break a stream or cause it to go stale. In addition, if a source object is dropped and a new object is created with the same name, any streams linked to the original object are not linked to the new object."

upvoted 1 times

...