Free CompTIA DA0-002 Actual Exam Questions - Question 13 Discussion
[Data Governance]
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?
A imo, since birth month and DOB repeat the same info on different levels.
I’m thinking it’s more about redundancy since DOB and birth month are basically the same info repeated in different detail; duplication would need actual repeated records, which we don’t know for sure. A
It’s D too, because if employee IDs aren’t unique or appear more than once, that’s duplication right there. Redundancy is about overlapping info like DOB and birth month, but duplication deals with repeated records or data entries which could cause bigger issues when analyzing. Makes sense to watch out for both, but duplication feels more critical here since repeated IDs mess up data integrity.
D vs A, duplication is about repeated entries, redundancy fits better here.
Maybe A—birth month is part of DOB, so info overlaps, not exact copies.
It’s A since birth month is included in date of birth, causing overlapping info.
A The birth month is just part of the date of birth, so it’s more about overlapping info than exact copies. That’s why redundancy feels like the right issue here.
A/D? Dates of birth and birth months definitely overlap, but I think redundancy (A) fits better than duplication (D) because the data isn’t repeated exactly—birth month is just a part of the full date. Duplication usually means the exact same info shows up multiple times, not partial info like this. So it feels more like redundant data that could cause confusion or inconsistencies if not handled properly.
D. Duplication usually means the same data appears multiple times unnecessarily, which fits with having both dates of birth and birth months separately. That seems like duplicated info rather than just redundant.
Option A seems off because equivalence isn’t usually about data mismatches like these. The main confusion is probably between redundancy and duplication, but redundancy fits better here.