Q1. Which of the following components joins the rows of two sorted inputs based on a defined join column and adds the column from each source?

INNER JoinMERGE joinUNION ALLConcatenationDefined Join

Q2. Which component combines the rows of two similar sorted inputs, one on top of the other, based on defined sort key?

LookupMergeMerge JoinMulticast

Q3. Which transformation associates records based on defined groupings and generate calculations such as: SUM, MAX, MIN, and COUNT

Sort TransformationPivot TransformationUnpivot TransformationAggregate Transformation

Q4. Which transformation would be the most useful for rejoining previously split paths- for example, paths that were split upstream by a Conditional split?

Script ComponentUnsortUnionUnion AllLookup

Q5. Which component tool groups task into control flow that are subset of the package control flow, and allows you to apply transactions or assign logging to the container

Sequence ContainerFor Loop ContainerFor Each Loop ContainerFirst Container