DEA-C02 · Question #109
DEA-C02 Question #109: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #109. The question stem and answer options stay visible for context.
Question
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?
Options
- AThe DESCRIBE STREAM for the stream will show the value of the STALE column as TRUE.
- BThe renaming will cause no disruption to the existing data pipeline.
- CThe DESCRIBE STREAM for the stream will show the value of the STALE column as FALSE.
- DThe TASK_HISTORY for the subsequent run will show an error after the renaming operation.
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.