nerdexam
Microsoft

70-458 · Question #150

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. Depending on the value in a source…

The correct answer is C. Conditional Split. 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. Depending on the value in a source column, the package redirects rows to one of five different data flow paths. You need to add a data flow transformation to support the package redirection. Which data flow transformation should you use?

Options

  • ALookup
  • BMulticast
  • CConditional Split
  • DPivot

How the community answered

(34 responses)
  • A
    12% (4)
  • B
    9% (3)
  • C
    76% (26)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 70-458 Practice