COF-C02 · Question #646
Which Snowflake object can be used to record DML changes made to a table?
The correct answer is C. Stream. A Snowflake Stream is a Change Data Capture (CDC) object that tracks and records all DML changes (INSERT, UPDATE, DELETE) made to a source table between two points in time. Streams are commonly used in ELT pipelines to process only new or changed data incrementally. Snowpipe is…
Question
Which Snowflake object can be used to record DML changes made to a table?
Options
- ASnowpipe
- BStage
- CStream
- DTask
How the community answered
(20 responses)- A5% (1)
- C85% (17)
- D10% (2)
Explanation
A Snowflake Stream is a Change Data Capture (CDC) object that tracks and records all DML changes (INSERT, UPDATE, DELETE) made to a source table between two points in time. Streams are commonly used in ELT pipelines to process only new or changed data incrementally. Snowpipe is used for automated continuous data ingestion from staged files into tables. A Stage is a temporary file storage location (not a change-tracking object). A Task is used to schedule the execution of SQL statements or stored procedures on a recurring basis.
Topics
Community Discussion
No community discussion yet for this question.