CompTIACompTIA
DA0-002 · Question #72
DA0-002 Question #72: Real Exam Question with Answer & Explanation
The correct answer is A: Duplication. Before calculating an average, it is crucial to address data quality issues such as duplicate records to ensure accuracy.
Data Acquisition and Preparation
Question
A data analyst calculated the average score per student without making any changes to the following table: Which of the following exploration techniques should the analyst have considered before calculating the average?
Options
- ADuplication
- BRedundancy
- CBinning
- DGrouping
Explanation
Before calculating an average, it is crucial to address data quality issues such as duplicate records to ensure accuracy.
Common mistakes.
- B. Redundancy is a broader concept that may include duplication but is not the most precise data exploration technique to address before averaging.
- C. Binning is a data transformation technique used to group data into intervals, not a pre-calculation cleaning step for averages.
- D. Grouping is an aggregation technique to summarize data by categories, not a technique to address data quality issues before calculating an overall average.
Concept tested. Data quality and preprocessing-duplication
Reference. https://learn.microsoft.com/en-us/power-query/remove-duplicates
Topics
#Data Quality#Duplicate Data#Data Preprocessing#Exploratory Data Analysis
Community Discussion
No community discussion yet for this question.