Microsoft
70-463 · Question #110
70-463 Question #110: Real Exam Question with Answer & Explanation
The correct answer is B: It allows a package to create logical copies of data.. Multicast transformation in SSIS sends the same input data to one or more outputs simultaneously, allowing logical copies of the data to flow to different destinations.
Question
You are hosting a training exercise for Microsoft SQL Server 2012 administrators. You are currently discussing Multicast transformation. Which of the following is TRUE with regards to Multicast transformation? (Choose two.)
Options
- AIt prevents a package from creating logical copies of data.
- BIt allows a package to create logical copies of data.
- CIt distributes its input to one or more outputs.
- DIt distributes its input to a single output.
Explanation
Multicast transformation in SSIS sends the same input data to one or more outputs simultaneously, allowing logical copies of the data to flow to different destinations.
Common mistakes.
- A. This is the opposite of Multicast's purpose - it is specifically designed to enable logical data copying to multiple outputs, not prevent it.
- D. Multicast is not limited to a single output; sending to only one output would negate its purpose and describes a standard pass-through, not Multicast.
Concept tested. SSIS Multicast transformation multi-output data distribution
Community Discussion
No community discussion yet for this question.