Certified Data Management Professional – Fundamentals (CDMP) — Question 144

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

Answer options

• 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

Correct answer: E

Explanation

The correct answer, E, emphasizes the importance of establishing approval processes early in the project lifecycle to prevent duplication issues. Options A and D, while related to approval and management, occur too late in the process or are not specifically focused on early design phases. Option B does not address the root cause of the problem, and option C suggests a different architectural approach rather than managing dimensions within the Kimball framework.