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

Which of the following data cleansing issues will be fixed when a DISTINCT function is applied?
A . Missing data
B . Duplicate data
C . Redundant data
D . Invalid data

View Answer

Answer: B

Explanation:

This is because duplicate data refers to data that is repeated or copied in a data set, which can affect the quality and validity of the analysis. A DISTINCT function is a type of function that removes duplicate values from a column or a table, leaving only unique values.

For example, a DISTINCT function in SQL that can achieve this is:

The other data cleansing issues will not be fixed by applying a DISTINCT function.

Here is why:

Missing data refers to data that is absent or incomplete in a data set, which can affect the accuracy

and reliability of the analysis. A DISTINCT function does not help with missing data, because it does not fill in or impute the missing values.

Redundant data refers to data that is unnecessary or irrelevant for the analysis, which can affect the efficiency and performance of the analysis. A DISTINCT function does not help with redundant data, because it does not remove or filter out the redundant values.

Invalid data refers to data that is incorrect or inaccurate in a data set, which can affect the validity and reliability of the analysis. A DISTINCT function does not help with invalid data, because it does not validate or correct the invalid values.