DA0-001 · Question #231
Given the following table: Which of the following explains why this data set needs to be cleansed?
The correct answer is A. Redundant data. Data cleansing is necessary when a dataset contains information that is unnecessarily repeated, leading to inefficiencies and potential inconsistencies.
Question
Given the following table:
Which of the following explains why this data set needs to be cleansed?
Exhibit
Options
- ARedundant data
- BInvalid data
- CDuplicate data
- DMissing data
How the community answered
(43 responses)- A86% (37)
- B5% (2)
- C7% (3)
- D2% (1)
Why each option
Data cleansing is necessary when a dataset contains information that is unnecessarily repeated, leading to inefficiencies and potential inconsistencies.
Redundant data means the same information is stored multiple times, which can lead to increased storage, update anomalies, and inconsistencies, making data cleansing essential to remove these repetitions.
Invalid data refers to data that does not conform to expected formats, types, or value ranges, which is a different issue from mere redundancy.
Duplicate data specifically refers to entire records or rows being identical, while redundant data can refer to specific fields or pieces of information repeated across different records.
Missing data refers to absent values in fields where data should exist, which is another distinct data quality issue separate from redundancy.
Concept tested: Reasons for data cleansing - redundancy
Source: https://learn.microsoft.com/en-us/sql/data-quality-services/data-cleansing?view=sql-server-ver16
Topics
Community Discussion
No community discussion yet for this question.