SnowPro Advanced: Data Engineer — Question 39

What is a characteristic of the operations of streams in Snowflake?

Answer options

• A. Whenever a stream is queried, the offset is automatically advanced.
• B. When a stream is used to update a target table, the offset is advanced to the current time.
• C. Querying a stream returns all change records and table rows from the current offset to the current time.
• D. Each committed and uncommitted transaction on the source table automatically puts a change record in the stream.

Correct answer: B

Explanation

The correct answer is B because when updating a target table using a stream, the offset is indeed advanced to the current timestamp. Option A is incorrect as it suggests automatic advancement upon querying, which is not accurate. Option C misrepresents the behavior since it does not specify that the offset is not moved when just querying. Option D is misleading as it implies all transactions create change records, but only committed transactions do.