PrepAway - Latest Free Exam Questions & Answers

Which method should you use?

A database contains tables named Sales and SalesArchive. SalesArchive contains historical sales data. You configure Change Tracking on the Sales table. The minimum valid version of the Sales table is

You need to write a query to export only sales data that changed since version 10, including the primary key of deleted rows. Which method should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
FROM Sales RIGHT JOIN CHANGETABLE (CHANGES Sales, 10) AS C …

B.
FROM Sales INNER JOIN CHANGETABLE (CHANGES Sales, 10) AS C …

C.
FROM Sales INNER JOIN CHANGETABLE (CHANGES SalesArchive, 10) AS C …

D.
FROM Sales RIGHT JOIN CHANGETABLE (CHANGES SalesArchive, 10) AS C …


Leave a Reply