SnowPro Advanced: Architect — Question 7

What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)

Answer options

• A. The MERGE command
• B. The UPSERT command
• C. The CHANGES clause
• D. A STREAM object
• E. Thee CHANGE_DATA_CAPTURE command

Correct answer: C, D

Explanation

The CHANGES clause and a STREAM object are specifically designed to leverage change tracking metadata in Snowflake. The MERGE command and UPSERT command do not directly use this metadata, while CHANGE_DATA_CAPTURE is not a built-in feature of Snowflake.