Microsoft
70-457 · Question #182
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…
The correct answer is C. Historical Attributes Inserts Output. See the full explanation below for the reasoning.
Question
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?
Options
- AUnchanged Output
- BInferred Member Updates Output
- CHistorical Attributes Inserts Output
- DFixed Attribute Output
- EChanging Attributes Updates Output
How the community answered
(23 responses)- A9% (2)
- C74% (17)
- D4% (1)
- E13% (3)
Community Discussion
No community discussion yet for this question.