Microsoft
70-463 · Question #106
70-463 Question #106: Real Exam Question with Answer & Explanation
The correct answer is C: Historical Attributes Inserts Output. The Historical Attributes Inserts Output in the SCD Transformation triggers Derived Column transformations that generate columns for the expired row indicator and the current row indicator, supporting Type 2 SCD processing.
Question
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?
Options
- AUnchanged Output
- BInferred Member Updates Output
- CHistorical Attributes Inserts Output
- DFixed Attribute Output
- EChanging Attributes Updates Output
Explanation
The Historical Attributes Inserts Output in the SCD Transformation triggers Derived Column transformations that generate columns for the expired row indicator and the current row indicator, supporting Type 2 SCD processing.
Common mistakes.
- A. Unchanged Output routes rows where no column values have changed and does not create expired or current row indicator columns.
- B. Inferred Member Updates Output handles rows for inferred members that need updating, not the creation of expired and current row indicator columns.
- D. Fixed Attribute Output routes rows where a fixed attribute has illegally changed and triggers an error or redirect, not the generation of expired or current row indicators.
- E. Changing Attributes Updates Output routes rows where a changing attribute has changed and updates those values in place, without creating expired or current row indicator columns.
Concept tested. SCD Transformation Historical Attributes Inserts Output behavior
Community Discussion
No community discussion yet for this question.