Given the following data table: Which of the following are appropriate reasons to undertake data cleansing? (Select two).

The correct answer is D. Invalid data E. Redundant data. The Date and HireDate for CandidateID 03 is listed as 13-05-99. If the format is MM-DD-YY, then 13-05-99 is invalid since there is no 13th month. The Date and HireDate fields have identical values. If both are meant to capture the same information, one is likely redundant.

Data Governance, Quality, and Controls

Question

Given the following data table:

Which of the following are appropriate reasons to undertake data cleansing? (Select two).

Exhibit

Options

ANon-parametric data
BMissing data
CDuplicate data
DInvalid data
ERedundant data
FNormalized data

How the community answered

(30 responses)

A
3% (1)
C
7% (2)
D
90% (27)

Explanation

The Date and HireDate for CandidateID 03 is listed as 13-05-99. If the format is MM-DD-YY, then 13-05-99 is invalid since there is no 13th month. The Date and HireDate fields have identical values. If both are meant to capture the same information, one is likely redundant.

Topics

#Data Cleansing#Data Quality#Invalid Data#Redundant Data

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice