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

Completeness

Answer

Consistency

Answer

Accuracy

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

Reactive data cleansing

Answer

Retrospective data profiling

Answer

Batch data correction

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

Writing SQL queries for reporting

Answer

Optimizing database indexes for performance

Answer

Designing the network infrastructure for data storage

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 store more business meaning

Answer

Surrogate keys reduce storage requirements significantly

Answer

Surrogate keys automatically enforce domain constraints

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 normalization

Answer

Data archiving

Answer

Data masking

Question 6

When a data quality issue is discovered in production data, which document should be updated to capture the root cause, business impact, and remediation steps?

Accepted Answer

Data quality issue log

Answer

Entity-relationship diagram

Answer

Network topology diagram

Answer

Index usage report

Question 7

Which concept in data modeling defines the set of allowable values, formats, and constraints for a particular attribute, directly supporting data validity?

Accepted Answer

Domain

Answer

Cardinality

Answer

Relationship

Answer

Identifier