A stream contains table data.

• A. True
• B. False
• C. It depends on the stream
• D. It contains a small amount of data but not the table

Answer: (B)

Streams in Snowflake are used for change data capture, not to store a full copy of the table. They contain only the changes that have happened since the last time the stream was consumed—each change event represents an insert, update, or delete and includes the affected row data plus metadata about the action. Because it’s a delta, not the entire table, the statement that a stream contains table data is not accurate. The amount of data in a stream varies with how much change has occurred; it’s not meant to hold the complete table.