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?

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 …



Leave a Reply 0

Your email address will not be published. Required fields are marked *