SnowPro Core Certification — Question 618

What Snowflake object records Data Manipulation Language (DML) changes so that actions can be taken using the changed data?

Answer options

• A. Pipe
• B. Stream
• C. Task
• D. View

Correct answer: B

Explanation

The correct answer is B, Stream, as it captures DML changes in Snowflake, allowing users to track and act upon the altered data. Option A, Pipe, is used for data loading but does not log changes. Option C, Task, is for scheduling recurring SQL statements and does not directly manage DML changes. Option D, View, is a virtual table that presents data but does not record DML activities.