nerdexam
Microsoft

70-463 · Question #110

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 transf

The correct answer is B. It allows a package to create logical copies of data. C. It distributes its input to one or more outputs.. 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.

Extract and transform data

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.

How the community answered

(31 responses)
  • A
    3% (1)
  • B
    87% (27)
  • D
    10% (3)

Why each option

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.

AIt prevents a package from creating logical copies of data.

This is the opposite of Multicast's purpose - it is specifically designed to enable logical data copying to multiple outputs, not prevent it.

BIt allows a package to create logical copies of data.Correct

Multicast transformation allows a package to create logical copies of data by sending the same input dataset to every configured output without physically duplicating the data source.

CIt distributes its input to one or more outputs.Correct

Multicast transformation distributes its single input to one or more outputs, meaning each connected output receives an identical copy of every input row.

DIt distributes its input to a single output.

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

Source: https://learn.microsoft.com/en-us/sql/integration-services/data-flow/transformations/multicast-transformation

Topics

#Multicast transformation#logical data copies#multiple outputs#data flow

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-463 Practice