DA0-002 · Question #55
A data analyst receives a new data source that contains employee IDs, job titles, dates of birth, addresses, years of service, and employees' birth months. Which of the following inconsistencies…
The correct answer is A. Redundancy. The data analyst should identify redundancy as an inconsistency because both 'dates of birth' and 'employees' birth months' contain overlapping information for the same entity.
Question
A data analyst receives a new data source that contains employee IDs, job titles, dates of birth, addresses, years of service, and employees' birth months. Which of the following inconsistencies should the analyst identify?
Options
- ARedundancy
- BEquivalence
- CParallel
- DDuplication
How the community answered
(45 responses)- A71% (32)
- B16% (7)
- C9% (4)
- D4% (2)
Why each option
The data analyst should identify redundancy as an inconsistency because both 'dates of birth' and 'employees' birth months' contain overlapping information for the same entity.
Redundancy refers to the presence of duplicate data or repeating information within a dataset, which is evident here as 'dates of birth' inherently includes 'employees' birth months.' Storing the birth month separately when the full date is already available creates redundant information.
Equivalence in data refers to two different pieces of data having the same meaning or representing the same underlying concept, which is not the primary inconsistency here.
Parallel data typically refers to data structures that align or correspond in some way, which is not an inconsistency type.
Duplication refers to identical records or entries, whereas redundancy often means storing the same information in different forms or attributes within a single record.
Concept tested: Data quality - Redundancy
Topics
Community Discussion
No community discussion yet for this question.