nerdexam
Microsoft

70-457 · Question #187

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 are…

The correct answer is E. Changing Attributes Updates Output. See the full explanation below for the reasoning.

Question

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 are used to update the record in the lookup table. Which of the following is the output option?

Options

  • AUnchanged Output
  • BInferred Member Updates Output
  • CHistorical Attributes Inserts Output
  • DFixed Attribute Output
  • EChanging Attributes Updates Output

How the community answered

(34 responses)
  • A
    3% (1)
  • B
    3% (1)
  • C
    12% (4)
  • D
    6% (2)
  • E
    76% (26)

Community Discussion

No community discussion yet for this question.

Full 70-457 Practice