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?
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 …