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

What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)
A . The MERGE command
B . The UPSERT command
C . The CHANGES clause
D . A STREAM object
E . The CHANGE_DATA_CAPTURE command

View Answer

Answer: A, D

Explanation:

In Snowflake, the change tracking metadata for a table is utilized by the MERGE command and the STREAM object. The MERGE command uses change tracking to determine how to apply updates and inserts efficiently based on differences between source and target tables. STREAM objects, on the other hand, specifically capture and store change data, enabling incremental processing based on changes made to a table since the last stream offset was committed.

Reference: Snowflake Documentation on MERGE and STREAM Objects.