Answer: INSERT

A stream object's offset advances when it is used in DML (Data Manipulation Language) operations such as INSERT, UPDATE, or DELETE, as these operations consume the change data captured by the stream. The community discussion and Snowflake documentation confirm that INSERT is a DML statement that advances the stream offset. While other DML statements (UPDATE, DELETE) also advance the offset, only INSERT is listed among the choices. SELECT does not advance the offset because it is a DQL (Data Query Language) statement and does not modify data. CREATE is a DDL (Data Definition Language) statement and does not consume change data. COPY INTO [location] is a data loading command but is not explicitly mentioned in the context of advancing stream offsets in the provided discussion or documentation references.

Author: LeetQuiz Editorial Team