nerdexam
CompTIA

DA0-002 · Question #120

A developer builds an online survey that requires all questions to have an answer. Which of the following inconsistencies does this setting prevent?

The correct answer is A. Missing values. Requiring all questions to be answered in an online survey prevents the inconsistency of missing values in the collected dataset.

Data Acquisition and Preparation

Question

A developer builds an online survey that requires all questions to have an answer. Which of the following inconsistencies does this setting prevent?

Options

  • AMissing values
  • BDuplication
  • CData corruption
  • DCompleteness

How the community answered

(31 responses)
  • A
    94% (29)
  • B
    3% (1)
  • C
    3% (1)

Why each option

Requiring all questions to be answered in an online survey prevents the inconsistency of missing values in the collected dataset.

AMissing valuesCorrect

When all questions are required to have an answer, the survey system enforces that no data points are left blank for those specific fields, directly preventing the occurrence of missing values in the collected dataset. This ensures that every entry for those questions has a recorded response.

BDuplication

This setting prevents missing values, not duplication; duplication typically refers to entire identical records or specific data entries appearing multiple times when they shouldn't.

CData corruption

Data corruption refers to errors in data storage or transmission that alter the data, which is not directly prevented by requiring an answer.

DCompleteness

While requiring answers contributes to data completeness, 'completeness' itself is a data quality dimension, not an inconsistency.

Concept tested: Data validation - preventing missing values

Source: null

Topics

#Data validation#Missing values#Data quality#Data integrity

Community Discussion

No community discussion yet for this question.

Full DA0-002 Practice