exam questions

Exam DMF All Questions

View all questions & answers for the DMF exam

Exam DMF topic 1 question 62 discussion

Actual exam question from CDMP's DMF
Question #: 62
Topic #: 1
[All DMF Questions]

The uncontrolled duplication of dimensions in a Kimball data warehouse is best controlled by:

  • A. Establishing approval processes after user testing and before implementation
  • B. Replacing the data modelling team
  • C. Adapting the data architecture techniques supporting an Inmon style
  • D. Increased reference data management in source systems
  • E. Establishing approval processes during requirements and design
Show Suggested Answer Hide Answer
Suggested Answer: E 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
aqilraza
3 months ago
Selected Answer: E
Explanation In a Kimball dimensional warehouse, dimensions (e.g., Customer, Product, Date) should be conformed so they can be reused across fact tables and subject areas. The risk is that, without governance, duplicate or inconsistent dimensions get created (e.g., multiple "Customer" dimensions with different keys/definitions). The best control mechanism is to have approval and governance processes in place early — during the requirements and design phase — to enforce reuse of conformed dimensions. Waiting until after testing/implementation (Option A) is too late, because duplication would already be baked into the design. In Kimball’s approach, dimension conformity = enforced through early governance in requirements & design.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...