A stream can be queried multiple times to update multiple objects in the same transaction and it will return the same data.

• A. TRUE
• B. FALSE
• C. IN SOME CASES
• D. NOT POSSIBLE

Answer: (A)

Streams provide a change-tracking view that reflects edits since the last consumption, and within a single transaction Snowflake presents a single, consistent snapshot to all statements. Because of this transactional consistency, the data you read from a stream in multiple queries within the same transaction won’t change between reads. You can use the same stream data to drive updates to multiple objects in that transaction, and you’ll see the identical set of changes each time. Once the transaction commits, the stream’s offset advances for that consumer, and future reads will reflect newer changes. This stability within a transaction is why the statement is true.