DMC Data Quality and Integrity 3

Question 1

Which data quality concept refers to each entity instance being represented only once in a dataset, with no duplicate records?

Accepted Answer

Uniqueness

Answer

Uniqueness ensures that each real-world entity appears exactly once in the dataset, which is typically enforced through primary keys and deduplication processes.

Question 2

In data modeling, which approach involves defining rules that data must satisfy and automatically rejecting records that violate those rules at the point of entry?

Accepted Answer

Proactive data quality enforcement

Answer

Proactive data quality enforcement uses constraints, validation rules, and business logic at the point of data entry or ingestion to prevent low-quality data from entering the system.

Question 3

Which of the following is a key responsibility of a data steward in maintaining data quality within a data model?

Accepted Answer

Defining, monitoring, and enforcing data quality rules for assigned data domains

Answer

Data stewards own the quality of specific data domains, setting quality rules, monitoring compliance, and coordinating remediation of data quality issues.

Question 4

A data model uses surrogate keys as primary keys. Which data integrity benefit does this provide over using natural keys?

Accepted Answer

Surrogate keys are immune to changes in business attributes, preserving referential integrity

Answer

Surrogate keys are system-generated and never change, so when natural key attributes (like SSN or email) are updated, referential integrity is preserved across all related tables.

Question 5

Which process involves systematically examining source data to understand its structure, content, and quality before designing a data model or ETL process?

Accepted Answer

Data profiling

Answer

Data profiling analyzes source data to discover patterns, anomalies, and quality issues, informing both data model design and the transformations needed in the integration layer.

DMC - Data Modeling Certification Practice Test

DMC - Data Modeling Certification Practice Test

DMC Data Quality and Integrity 3