This question is part of the Data Concepts and Environments domain, focusing on identifying data quality issues. The table shows Type and TypeID columns, where TypeID seems to repeat information from Type with an additional identifier.
Redundancy (Option A): The TypeID column (e.g., "Full Time 1") redundantly includes the Type value ("Full Time") with an extra identifier, which is unnecessary and could be simplified by using a numeric ID instead.
Outlier (Option B): Outliers are data points that deviate significantly, which isn’t applicable here.
Missing data (Option C): There are no missing values in the table.
Duplication (Option D): Duplication refers to identical rows, but the rows here are unique; the issue is with the column content.
The DA0-002 Data Concepts and Environments domain includes understanding "data schemas and dimensions," and redundancy is a common data quality issue in schema design.
[Reference: CompTIA Data+ DA0-002 Draft Exam Objectives, Domain 1.0 Data Concepts and Environments., ==============]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit