ADE ADE Data Quality & Governance 3

Question 1

What is the purpose of data profiling in a data quality workflow?

Accepted Answer

To analyze datasets and assess their structure, content, and quality metrics

Answer

To encrypt sensitive data before storage

Answer

To create user profiles based on behavioral data

Answer

To compress large datasets for efficient storage

Question 2

Which framework is commonly used in the US healthcare industry to govern patient data privacy and requires HIPAA compliance?

Accepted Answer

HIPAA

Answer

PCI-DSS

Answer

SOC 2

Answer

FedRAMP

Question 3

What does 'data consistency' mean across distributed data systems?

Accepted Answer

The same data entity has the same values across all systems and replicas

Answer

All records are free of null values

Answer

Data is delivered at a consistent rate over time

Answer

All database tables follow the same naming convention

Question 4

Which approach to data governance assigns ownership of data assets to specific business domains rather than a central IT team?

Accepted Answer

Data mesh

Answer

Data warehouse governance

Answer

Centralized data lake governance

Answer

Master data management

Question 5

What is 'referential integrity' in relational databases, and why is it important for data quality?

Accepted Answer

Ensuring foreign key values always reference valid primary key values in related tables

Answer

Ensuring all column names reference the official data dictionary

Answer

Keeping database references synchronized with documentation

Answer

Validating that all data references comply with GDPR

Question 6

In data quality management, what is a 'golden record'?

Accepted Answer

The single, authoritative, and most accurate version of a data entity created by merging multiple source records

Answer

A record stored in premium high-speed storage

Answer

A database record that has never been modified since creation

Answer

The first record inserted into a master data table