CompTIA Data+ (DA0-001) — Question 33

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

Answer options

• A. Missing data
• B. Duplicate data
• C. Redundant data
• D. Invalid data

Correct answer: B

Explanation

The DISTINCT function is designed to eliminate duplicate entries from a dataset, making option B the correct answer. Options A, C, and D are not addressed by the DISTINCT function, as it does not resolve issues related to missing, redundant, or invalid data.