COF-C02 · Question #516
Which Snowflake feature records changes mace to a table so actions can be taken using that change data capture?
The correct answer is C. Stream. A Snowflake Stream is a change data capture (CDC) mechanism that records a log of DML operations (INSERT, UPDATE, DELETE) made to a source table. The stream stores the delta - what changed since it was last consumed - and exposes it as rows that downstream processes (often…
Question
Which Snowflake feature records changes mace to a table so actions can be taken using that change data capture?
Options
- AMaterialized View
- BPipe
- CStream
- DTask
How the community answered
(66 responses)- A3% (2)
- B2% (1)
- C94% (62)
- D2% (1)
Explanation
A Snowflake Stream is a change data capture (CDC) mechanism that records a log of DML operations (INSERT, UPDATE, DELETE) made to a source table. The stream stores the delta - what changed since it was last consumed - and exposes it as rows that downstream processes (often Tasks) can read and act on. Materialized Views are pre-computed query result sets that refresh automatically but do not track changes for CDC. Pipes (Snowpipe) are for continuous data ingestion from external stages. Tasks are scheduled SQL executors - they are commonly paired WITH streams to process change data, but they do not themselves record the changes.
Topics
Community Discussion
No community discussion yet for this question.