Microsoft Exam Questions

You need to add a task or component to the package that allows you to implement the SCD logic

You are creating a SQL Server Integration Services (SSIS) package that implements a Type 3 Slowly Changing
Dimension (SCD). You need to add a task or component to the package that allows you to implement the SCD
logic. What should you use?

A.
a Script component

B.
an SCD component

C.
an Aggregate component

D.
a Merge component