Which of the following data cleansing issues will be fixed when a DISTINCT function is applied?

The correct answer is B. Duplicate data. A DISTINCT function is used to return unique values in a data set. It removes duplicates from the data set, so when a DISTINCT function is applied, the data cleansing issue of duplicate data will Missing data, redundant data, and invalid data are not issues that will be fixed…

Data Governance, Quality, and Controls

Question

Options

AMissing data
BDuplicate data
CRedundant data
DInvalid data

How the community answered

(31 responses)

B
90% (28)
C
6% (2)
D
3% (1)

Explanation

A DISTINCT function is used to return unique values in a data set. It removes duplicates from the data set, so when a DISTINCT function is applied, the data cleansing issue of duplicate data will Missing data, redundant data, and invalid data are not issues that will be fixed by applying a DISTINCT function. These issues can be addressed using other data cleansing techniques such as imputation for missing data, consolidation for redundant data, and validation for invalid data.

Topics

#Data cleansing#DISTINCT function#Duplicate data#Data quality

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice