ADE ADE Data Quality & Governance 2 — Questions and Answers
Question 1: What does GDPR stand for, and which region's data privacy regulation does it represent?
- General Data Processing Rules — United States
- Global Data Protection Regulation — Worldwide
- General Data Protection Regulation — European Union (Correct answer)
- Governed Data Privacy Regulation — United Kingdom
Correct 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.
Question 2: Which technique replaces sensitive data with a non-sensitive substitute while preserving data format and usability?
- Encryption
- Tokenization
- Masking (Correct answer)
- Hashing
Correct 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.
Question 3: What is a 'data contract' in modern data engineering?
- A legal agreement between data vendors and buyers
- A formal agreement between data producers and consumers defining data structure, quality, and SLAs (Correct answer)
- A database schema version control file
- A billing document for cloud data storage usage
Correct 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.
Question 4: Which data quality check would detect records where a customer's age field contains a negative value?
- Completeness check
- Uniqueness check
- Validity/range check (Correct answer)
- Consistency check
Correct answer: Validity/range check
A validity or range check verifies that data values fall within acceptable boundaries, catching logically impossible values like negative ages.
Question 5: What is 'data deduplication' in data quality management?
- Compressing data to reduce storage costs
- Identifying and removing duplicate records to maintain data integrity (Correct answer)
- Backing up data to a secondary location
- Splitting large datasets into smaller partitions
Correct 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.
Question 6: In the context of data governance frameworks, what is a 'data dictionary'?
- A glossary of technical jargon used by the data engineering team
- A centralized document defining data elements, their meanings, formats, and relationships (Correct answer)
- A translation tool for multilingual datasets
- An index of all stored procedure names in a database
Correct 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.
ADE ADE Data Quality & Governance 2
What does GDPR stand for, and which region's data privacy regulation does it represent?