Which query should you use as the data source?

Posted by: Pdfprep Category: 70-463 Tags: , ,

You are developing a SQL Server Integration Services (SSIS) package that imports data from a relational database to a data warehouse.

You are importing data from a relational table named Projects. The table has change data capture enabled on all columns.

You need to process only the most recent values from rows that have been inserted or updated since the previous execution of the package.

Which query should you use as the data source?

A . Option A
B . Option B
C . Option C
D . Option D

Answer: D

Explanation:

Reference: http:// msdn.microsoft .com/en-us/library /bb522511.aspx

Reference: http://msdn.microsoft.com/en-us/library/bb510627.aspx

Reference: http://msdn.microsoft.com/en-us/library/cc645937.aspx

Leave a Reply

Your email address will not be published.