DMC Data Quality and Integrity 2

Question 1

Which data quality dimension is concerned with whether data is available and up-to-date enough to meet the needs of the business process?

Accepted Answer

Timeliness

Answer

Timeliness measures whether data is current and available when needed, ensuring that decisions are based on up-to-date information.

Question 2

In a relational data model, a CHECK constraint is used to enforce which of the following?

Accepted Answer

Domain-level validity rules on column values

Answer

A CHECK constraint enforces domain-level validity by restricting what values can be inserted into a column based on a logical expression.

Question 3

Which of the following best describes data accuracy as a data quality dimension?

Accepted Answer

Data correctly represents the real-world entity or event it models

Answer

Accuracy measures whether data values truthfully reflect the real-world objects or events they represent, which is distinct from format conformity or completeness.

Question 4

When profiling a dataset to assess data quality, which activity involves analyzing the distribution of values in a column to detect anomalies?

Accepted Answer

Column analysis

Answer

Column analysis during data profiling examines the distribution, min/max, frequency, and null rates of values to surface quality anomalies.

Question 5

A data model requires that every order must be associated with exactly one customer. Which type of integrity rule enforces this requirement?

Accepted Answer

Referential integrity

Answer

Referential integrity ensures that every foreign key value in the orders table matches an existing primary key in the customers table, enforcing the mandatory relationship.

DMC - Data Modeling Certification Practice Test

DMC - Data Modeling Certification Practice Test

DMC Data Quality and Integrity 2