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

The correct answer is B. Redundant data. The dataset contains both "Birthday" and "Date of birth" columns, which store the same information in different formats. This redundancy is the main reason the data needs cleansing.

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

(25 responses)

B
88% (22)
C
8% (2)
D
4% (1)

Explanation

The dataset contains both "Birthday" and "Date of birth" columns, which store the same information in different formats. This redundancy is the main reason the data needs cleansing.

Topics

#data cleansing#data quality#redundant data

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice