
Ultimate access to all questions.
Answer-first summary for fast verification
Answer: Stream
The correct answer is C (Stream) because Snowflake Streams are specifically designed to track data changes (inserts, updates, deletes) made to tables, providing change data capture (CDC) functionality. Streams create an offset that tracks the point in time when the stream was created or last consumed, allowing users to see what data has changed since that point. Option A (Tag) is incorrect as tags are used for data classification and governance, not change tracking. Option B (Task) is incorrect as tasks are used for scheduling SQL statements, not monitoring data changes. Option D (Stored procedure) is incorrect as stored procedures execute procedural logic but don't inherently track table data changes.
Author: LeetQuiz Editorial Team
No comments yet.