Which statement about initial stream creation and change tracking is true?

• A. Creating the initial stream automatically enables change tracking on the table.
• B. Change tracking is independent of streams.
• C. Initial stream has no effect.
• D. Only after some time change tracking is enabled.

Answer: (A)

Change data capture in Snowflake is implemented via streams attached to a table. The moment you create the initial stream on a table, change tracking for that table is turned on and begins recording the DML changes that happen after that moment. The stream acts as a log of those changes, allowing you to read inserts, updates, and deletes incrementally. It does not backfill prior data because there is no stream to capture it; only changes since the stream's creation are visible. So the statement is true: creating the initial stream automatically enables change tracking on the table.