nerdexam
CompTIA

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.

Data Analysis

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)
  • A
    3% (1)
  • B
    78% (25)
  • C
    13% (4)
  • E
    6% (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.

AData attribute limitations

Data attribute limitations refer to constraints on data types or sizes, which is not the primary reason for standardizing text entries.

BData accuracyCorrect

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.

CData completeness

Data completeness refers to having all required data present, which is not the issue being addressed by standardizing existing text entries.

DData manipulation

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.

EData blending

Data blending involves combining data from multiple sources, which is not what is happening when standardizing values within a single survey's responses.

FData consistencyCorrect

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

#Data quality#Data consistency#Data cleaning#Text standardization

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice