ADE Data Quality & Governance Flashcards

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

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

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

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

Answer: HIPAA

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

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

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

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.

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

Answer: Data mesh

Data mesh is a decentralized governance paradigm where individual business domains own, manage, and publish their data as products with federated governance standards.

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

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

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.

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

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

A golden record is the consolidated, trusted master record for an entity, created by resolving conflicts and merging data from multiple source systems via master data management.