nerdexam
IBM

C2090-303 · Question #15

In the Slowly Changing Dimension stage, a dimension columns Purpose code property can trigger which two actions. (Choose two.)

The correct answer is B. Detect dimension changes. C. Update the dimension table. See the full explanation below for the reasoning.

Question

In the Slowly Changing Dimension stage, a dimension columns Purpose code property can trigger which two actions. (Choose two.)

Options

  • AUpdate fact table keys.
  • BDetect dimension changes.
  • CUpdate the dimension table.
  • DInsert rows into the fact table.
  • EDelete duplicate dimension table rows.

How the community answered

(28 responses)
  • A
    4% (1)
  • B
    75% (21)
  • D
    7% (2)
  • E
    14% (4)

Community Discussion

No community discussion yet for this question.

Full C2090-303 Practice