ADE Data Quality & Governance Flashcards

What does GDPR stand for, and which region's data privacy regulation does it represent?

Answer: General Data Protection Regulation — European Union

GDPR (General Data Protection Regulation) is the European Union's comprehensive data privacy law governing how organizations collect, store, and process personal data.

Which technique replaces sensitive data with a non-sensitive substitute while preserving data format and usability?

Answer: Masking

Data masking replaces sensitive values with realistic but fictional substitutes (e.g., replacing a real SSN with a fake one) for use in non-production environments.

What is a 'data contract' in modern data engineering?

Answer: A formal agreement between data producers and consumers defining data structure, quality, and SLAs

A data contract is a formal specification that defines the schema, quality expectations, and SLAs between a data producer and its consumers to prevent breaking changes.

Which data quality check would detect records where a customer's age field contains a negative value?

Answer: Validity/range check

A validity or range check verifies that data values fall within acceptable boundaries, catching logically impossible values like negative ages.

What is 'data deduplication' in data quality management?

Answer: Identifying and removing duplicate records to maintain data integrity

Data deduplication identifies and eliminates redundant records, ensuring each entity is represented only once to maintain accuracy and reduce storage waste.

In the context of data governance frameworks, what is a 'data dictionary'?

Answer: A centralized document defining data elements, their meanings, formats, and relationships

A data dictionary documents metadata about data elements including field names, data types, allowed values, and business definitions to ensure consistent understanding.