What are the possible values within a METADATASACTION column in a Snowflake stream? (Select TWO).

The correct answer is A. INSERT C. DELETE. The METADATA$ACTION column in a Snowflake stream contains only two possible values: INSERT and DELETE. These reflect the type of DML change captured for each row. Importantly, UPDATE operations are not represented directly - instead, an UPDATE is decomposed into two stream…

Data Transformations

Question

Options

AINSERT
BUPDATE
CDELETE
DTRUNCATE
EUPSERT

How the community answered

(31 responses)

A
90% (28)
B
6% (2)
D
3% (1)

Explanation

The METADATA$ACTION column in a Snowflake stream contains only two possible values: INSERT and DELETE. These reflect the type of DML change captured for each row. Importantly, UPDATE operations are not represented directly - instead, an UPDATE is decomposed into two stream entries: a DELETE row (the old version of the record) and an INSERT row (the new version). TRUNCATE and UPSERT are not valid METADATA$ACTION values. A companion column, METADATA$ISUPDATE, flags whether INSERT/DELETE pairs originated from an UPDATE operation.

Topics

#Snowflake Streams#METADATA$ACTION#Data Change Tracking#DML Operations

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice