nerdexam
Microsoft

70-458 · Question #129

You are developing a SQL Server Integration Services (SSIS) package. The package uses a data flow task to source data from a SQL Server database for loading into a dimension table in a data…

The correct answer is C. Lookup D. Multicast. See the full explanation below for the reasoning.

Question

You are developing a SQL Server Integration Services (SSIS) package. The package uses a data flow task to source data from a SQL Server database for loading into a dimension table in a data warehouse. You need to create a separate data flow path for data that has been modified since it was last processed. Which data flow components should you use to identify modified data? (Each correct answer presents a complete solution. Choose all that apply.)

Options

  • AData Conversion
  • BAggregate
  • CLookup
  • DMulticast
  • ESlowly Changing Dimension

How the community answered

(42 responses)
  • A
    10% (4)
  • B
    5% (2)
  • C
    83% (35)
  • E
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 70-458 Practice