Answer: Stream

The correct answer is C (Stream) because Snowflake Streams are specifically designed to track all data manipulation language (DML) changes (inserts, updates, deletes) made to tables, enabling change data capture (CDC) processes. Streams provide an immutable change history that can be consumed by downstream processes like tasks or external systems. Option A (Materialized View) is incorrect as it stores precomputed query results rather than tracking changes. Option B (Pipe) is incorrect as it's used for loading data from external stages, not tracking table changes. Option D (Task) is incorrect as it's used for scheduling SQL statements, not capturing table changes. The community discussion shows 100% consensus on answer C with multiple upvoted comments confirming this is the correct Snowflake feature for CDC.

Author: LeetQuiz Editorial Team