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.
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)
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...
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
JRayan
Highly Voted 1 year, 7 months agoNachoPrendes
Most Recent 4 months, 1 week agocui_li
6 months agoVipin_Singham
8 months, 1 week ago