
Answer-first summary for fast verification
Answer: Streams
The correct answer is B (Streams) because Snowflake Streams are specifically designed to track DML changes (INSERT, UPDATE, DELETE) made to tables by providing change data capture (CDC) functionality. Streams create a point-in-time cursor that records all data manipulation changes, allowing users to consume these changes incrementally. The community discussion shows 100% consensus on Streams, with multiple comments confirming that Streams monitor DML changes and references to official Snowflake documentation. Pipes (A) are for loading data from external stages, Tasks (C) are for scheduling SQL statements, and Procedures (D) are for executing procedural code - none of these track DML changes like Streams do.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.