nerdexam
SnowflakeSnowflake

DEA-C02 · Question #24

DEA-C02 Question #24: Real Exam Question with Answer & Explanation

Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #24. The question stem and answer options stay visible for context.

Data Movement

Question

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?

Options

  • ATRANSACTIONS_STM will keep working as expected.
  • BTRANSACTIONS_STM will be stale and will need to be re-created.
  • CTRANSACTIONS_STM will be automatically renamed TRANSACTIONS_RAW_STM.
  • DReading from the TRANSACTIONS_STM stream will succeed for some time after the expected

Unlock DEA-C02 to see the answer

You've previewed enough free DEA-C02 questions. Unlock DEA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Snowflake Streams#Stream Behavior#Table Renaming#Change Data Capture
Full DEA-C02 PracticeBrowse All DEA-C02 Questions