DA0-001 · Question #234
A data analyst is reviewing the results of a survey. Respondents used the terms "avg," "average," and "avg." throughout the survey in a response for the word "average." Because of this, the analyst…
The correct answer is B. Data accuracy F. Data consistency. The analyst standardized survey responses to "average" to improve data consistency by unifying varied inputs and enhance data accuracy by ensuring correct representation of the intended meaning.
Question
A data analyst is reviewing the results of a survey. Respondents used the terms "avg," "average," and "avg." throughout the survey in a response for the word "average." Because of this, the analyst changed all related answers to say "average." Which of the following are reasons why the analyst MOST likely made these changes? (Choose two.)
Options
- AData attribute limitations
- BData accuracy
- CData completeness
- DData manipulation
- EData blending
- FData consistency
How the community answered
(32 responses)- A3% (1)
- B78% (25)
- C13% (4)
- E6% (2)
Why each option
The analyst standardized survey responses to "average" to improve data consistency by unifying varied inputs and enhance data accuracy by ensuring correct representation of the intended meaning.
Data attribute limitations refer to constraints on data types or sizes, which is not the primary reason for standardizing text entries.
Data accuracy is improved by standardizing "avg" and "avg." to "average," ensuring that the data correctly and precisely reflects the intended meaning and avoids misinterpretation.
Data completeness refers to having all required data present, which is not the issue being addressed by standardizing existing text entries.
Data manipulation is a general term for altering data, but it doesn't specify the reason for the change, which is what the question asks for.
Data blending involves combining data from multiple sources, which is not what is happening when standardizing values within a single survey's responses.
Data consistency is achieved by unifying different representations of the same concept ("avg," "average," "avg.") into a single standard form, making the data uniform and comparable.
Concept tested: Data quality - consistency and accuracy
Source: https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-quality-characteristics
Topics
Community Discussion
No community discussion yet for this question.