A data set has the following values: Which of the following is the best reason for cleansing the data?

The correct answer is D. Missing data. The question describes a dataset where some values are absent, making missing data (D) the best reason for cleansing. Missing data can skew analysis and must be addressed - either by imputation, removal, or flagging. Invalid data (A) refers to values that don't conform to…

Data Governance, Quality, and Controls

Question

A data set has the following values:

Which of the following is the best reason for cleansing the data?

Exhibit

Options

AInvalid data
BRedundant data
CData outliers
DMissing data

How the community answered

(51 responses)

A
2% (1)
B
4% (2)
C
2% (1)
D
92% (47)

Explanation

The question describes a dataset where some values are absent, making missing data (D) the best reason for cleansing. Missing data can skew analysis and must be addressed - either by imputation, removal, or flagging. Invalid data (A) refers to values that don't conform to expected formats or ranges. Redundant data (B) refers to duplicates. Data outliers (C) are extreme values that may or may not need to be removed, but they are still present values - not missing ones.

Topics

#Data cleansing#Data quality#Missing data#Data preparation

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice