DA0-001 Question #140: Real Exam Question with Answer & Explanation

The correct answer is D: Data integrity. Creating a single, consistent column for customers' birth dates from potentially varied sources primarily addresses data integrity, ensuring the consistency and reliability of this important attribute.

Data Governance, Quality, and Controls

Question

A data analyst has a set with more than 40,000 rows in the sample schema below: The analyst would like to create one column that contains the customers' birth dates. Which of the following data quality dimensions would best explain the reason for compilation?

Options

AData accuracy
BData completeness
CData duplication
DData integrity

Explanation

Creating a single, consistent column for customers' birth dates from potentially varied sources primarily addresses data integrity, ensuring the consistency and reliability of this important attribute.

Common mistakes.

A. Data accuracy refers to the correctness of individual data values, not the structural compilation of a column.
B. Data completeness refers to whether all required data is present, rather than the organization or consolidation of existing data.
C. Data duplication refers to redundant records or entries, which is a different issue from combining data into a single column.

Concept tested. Data quality dimensions - Integrity

Reference. https://learn.microsoft.com/en-us/azure/architecture/guide/data-quality/data-quality-overview

Topics

#Data Quality#Data Integrity#Data Transformation#Data Dimensions

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice Browse All DA0-001 Questions