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.
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)- A95% (42)
- B2% (1)
- D2% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.