A stream can be created on which Snowflake objects to record data manipulation language(DML) changes? (Select TWO).

The correct answer is B. Standard tables C. Standard tables. Snowflake streams are objects that enable users to track changes (inserts, updates, and deletes) to the data in tables, facilitating real-time data processing and integration workflows. Streams can be created on standard tables, capturing DML changes made to these tables so…

Data Transformations

Question

Options

ADatabase
BStandard tables
CStandard tables
DStandard views
ESchemas
FPipes

How the community answered

(20 responses)

B
95% (19)
E
5% (1)

Explanation

Snowflake streams are objects that enable users to track changes (inserts, updates, and deletes) to the data in tables, facilitating real-time data processing and integration workflows. Streams can be created on standard tables, capturing DML changes made to these tables so that downstream processes can consume the changes incrementally. This feature supports efficient data ETL, replication, and real-time analytics by providing a mechanism to process only the data that has changed. Note: The correct options should likely include a distinction between "Standard tables" and another object type such as "External tables" rather than repeating "Standard tables" twice.

Topics

#Streams#DML#Tables#Change Data Capture (CDC)

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice