SnowPro Core Certification — Question 1111

What are the possible values within a METADATA$ACTION column in a Snowflake stream? (Choose two.)

Answer options

• A. INSERT
• B. UPDATE
• C. DELETE
• D. TRUNCATE
• E. UPSERT

Correct answer: A, C

Explanation

The correct answers are A and C because the METADATA$ACTION column specifically records actions related to data changes in Snowflake streams, which include INSERT and DELETE operations. UPDATE and TRUNCATE are not tracked in this context, and UPSERT is not a distinct action but rather a combination of INSERT and UPDATE.