ADE ADE Data Quality & Governance 1 — Questions and Answers
Question 1: What is a data catalog in a data engineering context?
- A list of approved data vendors
- A metadata repository that helps users discover, understand, and govern data assets (Correct answer)
- A backup registry of all database schemas
- A tool for generating synthetic test data
Correct answer: A metadata repository that helps users discover, understand, and govern data assets
A data catalog is a metadata management tool that inventories data assets, describes their lineage, and helps teams discover and govern data.
Question 2: Which data quality dimension measures whether data accurately represents the real-world entity it models?
- Completeness
- Timeliness
- Accuracy (Correct answer)
- Consistency
Correct answer: Accuracy
Data accuracy measures whether values correctly reflect the real-world facts they represent, such as a customer's correct address or birth date.
Question 3: What is data lineage in a data engineering context?
- The historical ownership records of a dataset
- The tracking of data's origin, movement, and transformations throughout its lifecycle (Correct answer)
- The genealogy of database schema versions
- A compliance log of who accessed data and when
Correct answer: The tracking of data's origin, movement, and transformations throughout its lifecycle
Data lineage tracks where data comes from, how it moves through pipelines, and what transformations it undergoes, enabling impact analysis and debugging.
Question 4: Which of the following best defines 'data completeness' as a data quality dimension?
- All data records are free of duplicates
- All required data fields are populated with valid values (Correct answer)
- Data values are consistent across all systems
- Data is delivered within the required time window
Correct answer: All required data fields are populated with valid values
Data completeness measures whether all required data fields are present and populated, flagging null or missing values as quality issues.
Question 5: In data governance, what is a 'data steward'?
- A software tool that automatically enforces data policies
- A person responsible for managing data quality and ensuring compliance for a specific data domain (Correct answer)
- An executive who owns all enterprise data assets
- A database administrator who manages physical storage
Correct answer: A person responsible for managing data quality and ensuring compliance for a specific data domain
A data steward is an assigned person who oversees data quality, defines business rules, and ensures data policies are followed within a domain.
Question 6: What is 'PII' in the context of data governance and compliance?
- Pipeline Integration Index
- Personally Identifiable Information (Correct answer)
- Primary Index Identifier
- Protected Infrastructure Information
Correct answer: Personally Identifiable Information
PII (Personally Identifiable Information) refers to data that can identify a specific individual, such as SSN, email, or address, and requires special handling under regulations like GDPR and CCPA.
ADE ADE Data Quality & Governance 1
What is a data catalog in a data engineering context?