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

A report displaying birth date contains possible, but incorrect values. What is a possible explanation?

Answer options

• A. Birth date is populated from a single source system, which contains missing values
• B. Birth date is populated from two source systems, both of which record the birth date in the birth date field
• C. Birth date is populated from a single source system, which does not contain birth date
• D. Birth date is populated from two source systems, one of which stores marriage date in the birth date field
• E. Birth date is populated from a single source system, where the date field is an offset value of 1601

Correct answer: D

Explanation

The correct answer is D because it indicates that one of the source systems mistakenly uses the marriage date in the birth date field, leading to incorrect values. Options A and C suggest issues with missing birth dates, while B indicates both systems are correctly populated, and E refers to an offset which doesn't relate to incorrect values in context.