DAC DAC Data Governance & Quality 2 — Questions and Answers
Question 1: In data governance, what does 'data lineage' refer to?
- The age of a dataset
- The number of rows in a table
- The tracking of data's origin, movement, and transformations over time (Correct answer)
- The encryption standard applied to data
Correct answer: The tracking of data's origin, movement, and transformations over time
Data lineage documents the lifecycle of data — where it originates, how it moves, and how it is transformed — enabling auditability and troubleshooting.
Question 2: Which regulation primarily governs data privacy and protection for individuals in the United States healthcare sector?
- GDPR
- CCPA
- HIPAA (Correct answer)
- SOX
Correct answer: HIPAA
HIPAA (Health Insurance Portability and Accountability Act) sets national standards for protecting sensitive patient health information in the US.
Question 3: What is the purpose of a data quality scorecard?
- To rate individual employees' SQL skills
- To measure and track data quality metrics over time against defined thresholds (Correct answer)
- To assign storage tiers to datasets
- To document ETL pipeline failures
Correct answer: To measure and track data quality metrics over time against defined thresholds
A data quality scorecard provides a structured view of key quality metrics (accuracy, completeness, consistency) measured against targets over time.
Question 4: Which of the following best describes 'data consistency'?
- Data is stored in a single location
- Data values are the same across all systems and formats where they appear (Correct answer)
- Data is backed up regularly
- Data is accessible to all employees
Correct answer: Data values are the same across all systems and formats where they appear
Data consistency means that the same data element holds the same value wherever it appears across different systems or datasets.
Question 5: What is the role of a Chief Data Officer (CDO) in an organization?
- Managing network infrastructure
- Leading data governance, strategy, and ensuring data is a valued business asset (Correct answer)
- Writing production code for data pipelines
- Conducting statistical research
Correct answer: Leading data governance, strategy, and ensuring data is a valued business asset
The CDO is responsible for enterprise-wide data strategy, governance frameworks, and maximizing the value of data as an organizational asset.
Question 6: In data governance, what is a 'data dictionary'?
- A lookup table for foreign key values
- A document defining the meaning, format, and rules for each data element in a system (Correct answer)
- A compression algorithm for large text fields
- A type of database index
Correct answer: A document defining the meaning, format, and rules for each data element in a system
A data dictionary is a centralized repository that defines all data elements including their names, definitions, data types, and business rules.
DAC DAC Data Governance & Quality 2
In data governance, what does 'data lineage' refer to?