DEA-C02 · Question #54
A company is using Snowpipe to bring in millions of rows every day of Change Data Capture (CDC) into a Snowflake staging table on a real-time basis. The CDC needs to get processed and combined with ot
Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #54. The question stem and answer options stay visible for context.
Question
A company is using Snowpipe to bring in millions of rows every day of Change Data Capture (CDC) into a Snowflake staging table on a real-time basis. The CDC needs to get processed and combined with other data in Snowflake and land in a final table as part of the full data pipeline. How can a Data Engineer MOST efficiently process the incoming CDC on an ongoing basis?
Options
- ACreate a stream on the staging table and schedule a task that transforms data from the stream,
- BTransform the data during the data load with Snowpipe by modifying the related COPY INTO
- CSchedule a task that dynamically retrieves the last time the task was run from
- DUse a CREATE OR REPLACE TABLE AS statement that references the staging table and
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.