DA0-001 · Question #342
During data cleansing, an analyst conducts measures of central tendency on a data set. Which of the following data is the analyst attempting to identify?
The correct answer is C. Outlying. When an analyst conducts measures of central tendency during data cleansing, they are primarily attempting to identify outlying data points. Outliers can significantly skew central tendency measures like the mean, and identifying them is crucial for maintaining data quality.
Question
During data cleansing, an analyst conducts measures of central tendency on a data set. Which of the following data is the analyst attempting to identify?
Options
- ADuplicate
- BMissing
- COutlying
- DInvalid
How the community answered
(53 responses)- A8% (4)
- B2% (1)
- C89% (47)
- D2% (1)
Why each option
When an analyst conducts measures of central tendency during data cleansing, they are primarily attempting to identify outlying data points. Outliers can significantly skew central tendency measures like the mean, and identifying them is crucial for maintaining data quality.
Duplicate data is typically identified using unique identifiers or direct comparison, not primarily through measures of central tendency.
Missing data is usually identified by checking for null values or gaps, not by calculating central tendency measures.
Measures of central tendency (mean, median, mode) can be significantly affected by outliers, which are data points that deviate significantly from other observations. By analyzing these measures, an analyst can detect unusual or extreme values that might indicate data errors or anomalies requiring cleansing.
Invalid data refers to data that does not conform to defined rules or formats, which is checked by validation rules rather than central tendency measures.
Concept tested: Data cleansing, central tendency, outlier detection
Source: https://learn.microsoft.com/en-us/azure/machine-learning/concept-data-quality-issues
Topics
Community Discussion
No community discussion yet for this question.