DMC Data Quality and Integrity 2

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?

Accepted Answer

Timeliness

Answer

Accuracy

Answer

Completeness

Answer

Uniqueness

Question 2

In a relational data model, a CHECK constraint is used to enforce which of the following?

Accepted Answer

Domain-level validity rules on column values

Answer

Referential integrity between tables

Answer

Primary key uniqueness

Answer

Foreign key cascades

Question 3

Which of the following best describes data accuracy as a data quality dimension?

Accepted Answer

Data correctly represents the real-world entity or event it models

Answer

Data has no duplicate records

Answer

Data is available within the agreed service window

Answer

Data conforms to the correct format

Question 4

When profiling a dataset to assess data quality, which activity involves analyzing the distribution of values in a column to detect anomalies?

Accepted Answer

Column analysis

Answer

Schema mapping

Answer

Lineage tracing

Answer

Index optimization

Question 5

A data model requires that every order must be associated with exactly one customer. Which type of integrity rule enforces this requirement?

Accepted Answer

Referential integrity

Answer

Domain integrity

Answer

Entity integrity

Answer

User-defined integrity

Question 6

Which data modeling artifact is most useful for documenting data quality rules alongside the attributes they govern?

Accepted Answer

Data dictionary

Answer

Entity-relationship diagram

Answer

Star schema diagram

Answer

Index definition script

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?

Accepted Answer

Data transformation

Answer

Data replication

Answer

Data partitioning

Answer

Data archiving