DA0-002 · Question #8
A data analyst pulls a table similar to the following one: Which of the following best explains the data issue with TypeID?
The correct answer is A. Redundancy. Assuming the TypeID column shows multiple entries for the same conceptual type or inconsistent mapping, the best description of the data issue is redundancy. Redundancy occurs when the same information is stored multiple times or can be derived from other data within a schema.
Question
A data analyst pulls a table similar to the following one:
Which of the following best explains the data issue with TypeID?
Options
- ARedundancy
- BOutlier
- CMissing data
- DDuplication
How the community answered
(43 responses)- A72% (31)
- B16% (7)
- C2% (1)
- D9% (4)
Why each option
Assuming the TypeID column shows multiple entries for the same conceptual type or inconsistent mapping, the best description of the data issue is redundancy. Redundancy occurs when the same information is stored multiple times or can be derived from other data within a schema.
Redundancy in data refers to the presence of duplicate data in multiple places or when information can be inferred from other stored data, which often indicates a database design flaw. If TypeID should uniquely identify a Type, but shows multiple entries for the same Type or inconsistent TypeID-to-Type mappings, this indicates redundant information.
An outlier is a data point significantly different from other observations, which is not the primary issue described by an inconsistent or repeated TypeID mapping.
Missing data implies an absence of values, not an issue of repeated or inconsistently mapped existing values in TypeID.
While duplication can be a form of redundancy, 'redundancy' is a broader term encompassing semantic repetition or information that is unnecessarily stored, often due to a poor data model, which better describes inconsistent TypeID mappings.
Concept tested: Data redundancy, data integrity
Source: https://en.wikipedia.org/wiki/Data_redundancy
Topics
Community Discussion
No community discussion yet for this question.