ARA-C01 · Question #115
A stream stores data with the same columns as the source data but with additional columns. What are those additional columns?
The correct answer is A. METADATA$ACTION B. METADATA$ISUPDATE C. METADATA$ROW_ID. Snowflake streams capture DML changes (inserts, updates, deletes) and append three metadata columns to every row. METADATA$ACTION (A) records the DML operation type - either 'INSERT' or 'DELETE' (updates are represented as a DELETE of the old row paired with an INSERT of the…
Question
A stream stores data with the same columns as the source data but with additional columns. What are those additional columns?
Options
- AMETADATA$ACTION
- BMETADATA$ISUPDATE
- CMETADATA$ROW_ID
- DMETADATA$DELETE
How the community answered
(57 responses)- A93% (53)
- D7% (4)
Explanation
Snowflake streams capture DML changes (inserts, updates, deletes) and append three metadata columns to every row. METADATA$ACTION (A) records the DML operation type - either 'INSERT' or 'DELETE' (updates are represented as a DELETE of the old row paired with an INSERT of the new row). METADATA$ISUPDATE (B) is a boolean flag that is TRUE when the INSERT or DELETE row is part of an UPDATE operation, allowing consumers to distinguish updates from standalone inserts/deletes. METADATA$ROW_ID (C) is a unique, immutable identifier for each row in the source table, enabling row-level tracking across changes. Answer D (METADATA$DELETE) does not exist as a stream column - delete operations are represented through METADATA$ACTION = 'DELETE', not a separate column.
Topics
Community Discussion
No community discussion yet for this question.