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 Data Conversion component

B.
an Execute SQL task that executes a MERGE statement on the database

C.
a Merge component

D.
an Expression task

Explanation:
Note: Type of Slowly Changing Dimensions
Slowly Changing Dimensions are categorized into three types named: Type 1, Type 2, and
Type3. The Type 1 SCD does not maintain the history of changing attributes, it overwrites
values of the attributes. Type 2 maintains historical values for changing attributes. Type 3
that we do not use much maintains separate columns for changed attributes. SSIS SCD
wizard supports both Type 1 and Type 2.
Using MERGE instead of SCD wizard
Replacement of SCD wizard with MERGE is not a straightforward technique. If the SCD has
both Type 1 and Type 2 types attributes, they need to be handled separately.