Which Snowflake database object can be used to track data changes made to table data?

The correct answer is C. Stream. A Stream is a Snowflake object that records DML changes (INSERTs, UPDATEs, DELETEs) made to a table, providing Change Data Capture (CDC) functionality. Streams store metadata about what changed, allowing downstream processes to consume only the delta. Tags are used for data…

Snowflake Cloud Data Platform Features and Architecture

Question

Options

ATag
BTask
CStream
DStored procedure

How the community answered

(43 responses)

A
2% (1)
C
95% (41)
D
2% (1)

Explanation

A Stream is a Snowflake object that records DML changes (INSERTs, UPDATEs, DELETEs) made to a table, providing Change Data Capture (CDC) functionality. Streams store metadata about what changed, allowing downstream processes to consume only the delta. Tags are used for data classification and governance. Tasks schedule SQL or procedure execution. Stored procedures execute logic but do not passively track data changes.

Topics

#Stream#Change Data Capture#Data Tracking#Database Objects

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice