You work as a senior database administrator at ABC.com. The ABC.com network consists of a single domain
named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are discussing the
use of Slowly Changing Dimension Transformation Outputs. One of the output options causes Derived Column
transformations to create columns for the expired row and the current row indicators.
Which option is the output that causes this?
A.
Unchanged Output
B.
Inferred Member Updates Output
C.
Historical Attributes Inserts Output
D.
Fixed Attribute Output
E.
Changing Attributes Updates Output