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

Data profiling examines datasets to understand their structure, completeness, uniqueness, and distributions, identifying quality issues before processing.

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

HIPAA (Health Insurance Portability and Accountability Act) is the US federal law governing the privacy and security of protected health information (PHI).

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

Data consistency ensures that the same attribute of the same entity holds the same value across all systems, databases, and replicas at any given time.

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 mesh is a decentralized governance paradigm where individual business domains own, manage, and publish their data as products with federated governance standards.

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

Referential integrity enforces that every foreign key value must match an existing primary key in the referenced table, preventing orphaned records and maintaining relational consistency.

ADE - Associate Data Engineer Certification Practice Test

ADE - Associate Data Engineer Certification Practice Test

ADE ADE Data Quality & Governance 3