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.)
Snowflake's built-in features that utilize change tracking metadata for a table include the CHANGES clause and a STREAM object. The CHANGES clause allows for querying change tracking metadata directly, while STREAM objects are specifically designed to track changes in tables for use in data pipelines and other operations.
The built-in Snowflake features that make use of the change tracking metadata for a table are the CHANGES clause and a STREAM object. Therefore, options (C) and (D) are the correct answers.
Was this question on the exam ?
C and D: Currently, the following must be true before change tracking metadata is recorded: Tables. Either enable change tracking on the table (using ALTER TABLE … CHANGE_TRACKING = TRUE), or create a stream on the table (using CREATE STREAM) https://docs.snowflake.com/en/user-guide/streams-intro
https://docs.snowflake.com/en/user-guide/streams-intro#:~:text=As%20an%20alternative%20to%20streams%2C%20Snowflake%20supports%20querying%20change%20tracking%20metadata%20for%20tables%20or%20views%20using%20the%20CHANGES%20clause%20for%20SELECT%20statements
Is it A and D. Merge command is used to upsert and delete based on Metadata informations from stream objects.So I think,it's A and D...