DMC Data Quality and Integrity 2 — Questions and Answers
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?
- Accuracy
- Completeness
- Timeliness (Correct answer)
- Uniqueness
Correct answer: Timeliness
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?
- Referential integrity between tables
- Domain-level validity rules on column values (Correct answer)
- Primary key uniqueness
- Foreign key cascades
Correct answer: Domain-level validity rules on column values
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?
- Data has no duplicate records
- Data correctly represents the real-world entity or event it models (Correct answer)
- Data is available within the agreed service window
- Data conforms to the correct format
Correct answer: Data correctly represents the real-world entity or event it models
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?
- Schema mapping
- Column analysis (Correct answer)
- Lineage tracing
- Index optimization
Correct answer: Column analysis
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?
- Domain integrity
- Entity integrity
- Referential integrity (Correct answer)
- User-defined integrity
Correct answer: Referential integrity
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.
Question 6: Which data modeling artifact is most useful for documenting data quality rules alongside the attributes they govern?
- Entity-relationship diagram
- Data dictionary (Correct answer)
- Star schema diagram
- Index definition script
Correct answer: Data dictionary
A data dictionary captures attribute definitions, data types, allowable values, and associated data quality rules, making it the authoritative reference for quality governance.
Question 7: What is the term for the process of converting data from one format or structure to another while maintaining its integrity during data integration?
- Data replication
- Data transformation (Correct answer)
- Data partitioning
- Data archiving
Correct answer: Data transformation
Data transformation converts data from source formats to target formats during ETL or integration, and maintaining integrity requires applying data quality rules throughout this process.
DMC Data Quality and Integrity 2
Which data quality dimension is concerned with whether data is available and up-to-date enough to meet the needs of the business process?