Data Engineering Fundamentals - Data Validation and Profiling

Question 1

_________________ Ensures all required data is present and no essential parts are running.

a) Completeness
b) Consistency
c) Accuracy
d) Integrity

Answer 1

Completeness

Checks: missing values, nulls counts, percentage of populated fields.

Question 2

__________ Ensures data values are consistent across datasets and do not contradict each other.

a) Completeness
b) Consistency
c) Accuracy
d) Integrity

Answer 2

a) Consistency

Cross Field validation, comparing data from different sources or periods.

Question 3

Ensures data is correct, reliable and represents what is supposed to.

a) Completeness
b) Consistency
c) Accuracy
d) Integrity

Answer 3

Accuracy

Comparing with trusted sources, validation against known standards or rules.

Question 4

______________ Ensures data maintains its correctness and consistency over its lifecycle and across systems.

a) Completeness
b) Consistency
c) Accuracy
d) Integrity

Answer 4

Integrity