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

Completeness

Answer

Consistency

Answer

Timeliness

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

The record is automatically corrected

Answer

The parent record is duplicated

Answer

The foreign key is set to the maximum value

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

Duplicate data

Answer

Stale data

Answer

Sparse data

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

Check constraint

Answer

Unique constraint

Answer

Default constraint

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

Accuracy

Answer

Consistency

Answer

Uniqueness

Question 6

What is the primary purpose of a data quality scorecard in enterprise data modeling?

Accepted Answer

To measure and communicate data quality metrics against defined thresholds

Answer

To rank database administrators by performance

Answer

To document the physical storage layout

Answer

To map ETL pipeline throughput

Question 7

Which technique is commonly used in data modeling to detect and merge duplicate entity records that represent the same real-world object?

Accepted Answer

Master data management (MDM)

Answer

Data partitioning

Answer

Horizontal scaling

Answer

Schema migration