
Answer-first summary for fast verification
Answer: Stream
The correct answer is B (Stream) because Snowflake Streams are specifically designed to track Data Manipulation Language (DML) changes (INSERT, UPDATE, DELETE) on tables and views. Streams capture change data that can be consumed to perform actions based on the modified data, such as processing in data pipelines or triggering downstream processes. Option A (Pipe) is incorrect as it's used for loading data from external stages, not tracking DML changes. Option C (Task) is incorrect as it's used for scheduling SQL statements, not tracking data changes. Option D (View) is incorrect as it's a virtual table representing a stored query, not a mechanism for tracking DML changes. The community discussion shows 100% consensus on answer B with upvoted comments confirming 'Stream' is the correct choice.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.