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 ofSlowly 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
Explanation: