nerdexam
CompTIA

DA0-001 · Question #232

An analyst is summarizing the results from a recently completed survey. The results have been validated, but the analyst notices a few rows of data are missing at the bottom. For which of the…

The correct answer is A. Data completeness. Missing rows in a dataset directly and most significantly impact data completeness, as it means not all necessary information is present.

Data Governance, Quality, and Controls

Question

An analyst is summarizing the results from a recently completed survey. The results have been validated, but the analyst notices a few rows of data are missing at the bottom. For which of the following data qualities does this present the GREATEST issue?

Options

  • AData completeness
  • BData integrity
  • CData consistency
  • DData accuracy

How the community answered

(44 responses)
  • A
    95% (42)
  • B
    2% (1)
  • D
    2% (1)

Why each option

Missing rows in a dataset directly and most significantly impact data completeness, as it means not all necessary information is present.

AData completenessCorrect

Data completeness refers to whether all required data is present in the dataset; missing rows directly indicate that the dataset is incomplete, which is the greatest issue here.

BData integrity

Data integrity refers to the overall accuracy, consistency, and reliability of data, and while missing data can affect it, completeness is the more specific and direct concern.

CData consistency

Data consistency refers to whether data values are uniform and do not contradict each other across different datasets or over time, which is not directly described by missing rows.

DData accuracy

Data accuracy refers to whether the data values are correct and reflect the real-world facts, which is distinct from data simply being absent.

Concept tested: Data quality - completeness

Source: https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-quality-characteristics

Topics

#Data quality#Data completeness#Data issues

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice