SnowPro Core Certification — Question 391

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

Answer options

• A. Pipes
• B. Streams
• C. Tasks
• D. Procedures

Correct answer: B

Explanation

The correct answer is B, as Streams in Snowflake are designed specifically to capture DML changes including inserts, updates, and deletes on tables. Pipes are used for data ingestion, Tasks are for scheduling SQL statements, and Procedures are for encapsulating SQL logic, none of which are meant for tracking DML changes.