DA0-001 · Question #240
Given the following data set: Which of the following steps would be MOST appropriate to cleanse the data set?
The correct answer is A. Remove duplicate data. When cleansing a data set, removing duplicate data is a fundamental and often primary step to ensure accuracy and prevent skewed analysis. Duplicates can inflate counts or distort statistical measures, making their removal crucial for data integrity.
Question
Given the following data set:
Which of the following steps would be MOST appropriate to cleanse the data set?
Exhibit
Options
- ARemove duplicate data.
- BRemove outliers.
- CVerify the data.
- DAdd missing values.
How the community answered
(51 responses)- A86% (44)
- B2% (1)
- C4% (2)
- D8% (4)
Why each option
When cleansing a data set, removing duplicate data is a fundamental and often primary step to ensure accuracy and prevent skewed analysis. Duplicates can inflate counts or distort statistical measures, making their removal crucial for data integrity.
Removing duplicate data is a critical initial step in data cleansing as it ensures that each record is unique, preventing overcounting or misrepresentation in analyses. Duplicate entries can arise from various sources and must be addressed to maintain data quality and accuracy.
Removing outliers is a step in data preprocessing often done after initial cleansing, focusing on extreme values rather than fundamental record uniqueness.
Verifying the data is a broader process of checking accuracy against sources, not a specific cleansing action for an initial pass.
Adding missing values, also known as imputation, is a technique to handle incomplete data, but it typically follows the identification and removal of duplicate records.
Concept tested: Data cleansing - duplicate removal
Source: https://learn.microsoft.com/en-us/training/modules/clean-data-power-bi/3-explore-clean-data
Topics
Community Discussion
No community discussion yet for this question.
