Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 1 of 60
Free Preview · 60 of 198 · questions 1–60 of 198 are free. Sign up free to sync your progress across devices.
Select 2 answers.
This question asks for 2 answers, but our data marks only 1. Compare with the community discussion below for the full answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
CD
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...