Data Processing Data Quality and Validation 3

Question 1

What is a master data management (MDM) system used for?

Accepted Answer

Providing a single consistent source of truth for critical business data entities

Answer

Storing encrypted master passwords

Answer

Backing up all databases nightly

Answer

Managing network routing tables

Question 2

Which metric expresses the percentage of records that pass all defined data quality rules?

Accepted Answer

Data quality score

Answer

Data latency rate

Answer

Throughput rate

Answer

Compression ratio

Question 3

What is a data steward responsible for?

Accepted Answer

Overseeing data quality, governance, and policies for a specific data domain

Answer

Writing backend application code

Answer

Managing server hardware infrastructure

Answer

Designing network firewall rules

Question 4

What is format validation in data quality?

Accepted Answer

Verifying that data matches a required pattern or structure, such as phone number format

Answer

Checking that values fall within numeric ranges

Answer

Ensuring foreign keys reference valid rows

Answer

Compressing data into a standard file format

Question 5

What is data lineage used for in data quality management?

Accepted Answer

Tracking the origin and transformations of data across its lifecycle

Answer

Encrypting data at the source

Answer

Scheduling backup jobs

Answer

Partitioning large tables

Question 6

Which validation technique compares record counts between source and target after an ETL load?

Accepted Answer

Reconciliation check

Answer

Schema validation

Answer

Range validation

Answer

Format check