A database contains tables named Sales and SalesArchive. SalesArchive contains historical sales
dat
a. You configure Change Tracking on the Sales table. The minimum valid version of the Sales table is
10.
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?
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 …