Microsoft
70-463 · Question #13
70-463 Question #13: Real Exam Question with Answer & Explanation
The correct answer is D: union All. To combine rows from two separate data sources into a single destination in SSIS, you need a transformation that merges multiple inputs into one output stream. Both Union All and Merge accomplish this goal.
Question
You are creating a SQL Server Integration Services (SSIS) package to retrieve product data from two different sources. One source is hosted in a SQL Azure database. Each source contains products for different distributors. Products for each distributor source must be combined for insertion into a single product table destination. You need to select the appropriate data flow transformation to meet this requirement. Which transformation types should you use? (Each correct answer presents a complete solution. Choose all that apply.)
Options
- AMulticast
- BMerge Join
- CTerm Extraction
- Dunion All
- EMerge
Explanation
To combine rows from two separate data sources into a single destination in SSIS, you need a transformation that merges multiple inputs into one output stream. Both Union All and Merge accomplish this goal.
Common mistakes.
- A. Multicast sends one input to multiple output paths, which is the opposite of what is needed - it splits data, it does not combine it.
- B. Merge Join performs a SQL-style join (inner, left outer, or full outer) on two sorted inputs to produce a combined column set per row, not a row union - it does not append rows from two sources into one stream.
- C. Term Extraction identifies noun phrases from text columns and is a text-mining transformation unrelated to combining rows from multiple data sources.
Concept tested. SSIS data flow transformations for combining multiple inputs
Community Discussion
No community discussion yet for this question.