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 tablehas
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.
SELECT * FROM cdc.fn_cdc_get_all_changes_Projects (@from_lsn, @to_lsn, N’ all
update old’)
B.
SELECT * FROM cdc.fn_cdc_get_all_changes_Projects (@from_lsn, @to_lsn, N’ all’)
C.
SELECT * FROM cdc.fn_cdc_get_net_changes_Projects (@from_lsn, @to_lsn)
D.
SELECT * FROM cdc.Projects_CT WHERE @from_lsn >= _$start_lsn AND @to_lsn <
_$start_lsn
Explanation:
According to these references, this answer looks correct.
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