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)- A10% (4)
- B5% (2)
- C83% (35)
- E2% (1)
Community Discussion
No community discussion yet for this question.