Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

The correct answer is B. Streams. In Snowflake, Streams are the objects that track Data Manipulation Language (DML) changes made to tables, such as inserts, updates, and deletes. Streams record these changes along with metadata about each change, enabling actions to be taken using the changed data. This process…

Data Transformations

Question

Options

APipes
BStreams
CTasks
DProcedures

How the community answered

(30 responses)

A
3% (1)
B
93% (28)
C
3% (1)

Explanation

In Snowflake, Streams are the objects that track Data Manipulation Language (DML) changes made to tables, such as inserts, updates, and deletes. Streams record these changes along with metadata about each change, enabling actions to be taken using the changed data. This process is known as change data capture (CDC).

Topics

#Snowflake Streams#Change Data Capture (CDC)#DML Tracking#Data Transformation

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice