DMC Data Quality and Integrity

Question 1

Which data quality dimension measures the degree to which data values fall within acceptable ranges and adhere to defined business rules?

Accepted Answer

Validity

Answer

Validity measures whether data conforms to defined formats, ranges, and business rules, ensuring values are acceptable within the data model.

Question 2

A data model enforces referential integrity by ensuring that every foreign key value in a child table corresponds to an existing primary key in the parent table. What happens when this rule is violated?

Accepted Answer

An orphan record is created

Answer

A referential integrity violation results in an orphan record — a child record that references a non-existent parent, breaking relationships in the data model.

Question 3

In the context of data quality, which term describes data that exists in multiple places but has conflicting values?

Accepted Answer

Inconsistent data

Answer

Inconsistent data refers to the same data element having different values across systems or tables, which violates the consistency dimension of data quality.

Question 4

Which constraint type in a relational data model ensures that a column or set of columns cannot contain NULL values?

Accepted Answer

NOT NULL constraint

Answer

A NOT NULL constraint enforces the completeness dimension of data quality by requiring that a column always has a value.

Question 5

A data steward discovers that customer records have phone numbers stored as both '555-1234' and '5551234'. Which data quality dimension is primarily affected?

Accepted Answer

Conformity

Answer

Conformity measures whether data follows specified formats and standards; inconsistent phone number formats indicate a conformity failure.

DMC - Data Modeling Certification Practice Test

DMC - Data Modeling Certification Practice Test

DMC Data Quality and Integrity