nerdexam
Microsoft

70-458 · Question #133

You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy. The package reads data from a source system that uses the SQL Server change data…

The correct answer is D. CDC Splitter. See the full explanation below for the reasoning.

Question

You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy. The package reads data from a source system that uses the SQL Server change data capture (CDC) feature. You have added a CDC Source component to the data flow to read changed data from the source system. You need to add a data flow transformation to redirect rows for separate processing of insert, update, and delete operations. Which data flow transformation should you use?

Options

  • AMerge Join
  • BDQS Cleansing
  • CPivot
  • DCDC Splitter

How the community answered

(51 responses)
  • A
    8% (4)
  • B
    12% (6)
  • C
    2% (1)
  • D
    78% (40)

Community Discussion

No community discussion yet for this question.

Full 70-458 Practice