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

Which of the following is the best example of the data quality dimension of 'consistency'?

Answer options

• A. All the records in the CRM have been accounted for in the data warehouse
• B. The source data for the end of month report arrived 1 week late
• C. The phone numbers in the customer file do not adhere to the standard format
• D. The revenue data in the dataset is always $100 out
• E. The customer file has 50% duplicated entries

Correct answer: A

Explanation

The correct answer, A, demonstrates consistency as it indicates that all records are accurately reflected between the CRM and the data warehouse. The other options either indicate issues with timeliness (B), format adherence (C), accuracy (D), or duplication (E), which do not pertain directly to the concept of consistency.