DAC DAC Data Governance & Quality 1 — Questions and Answers
Question 1: Which of the following best defines data governance in the context of data analytics?
- A set of rules for formatting reports
- A framework of policies and processes ensuring data is accurate, available, and secure (Correct answer)
- A tool used for data visualization
- A method for compressing large datasets
Correct answer: A framework of policies and processes ensuring data is accurate, available, and secure
Data governance is a framework of policies, processes, and roles that ensures data is managed as a valuable organizational asset.
Question 2: What is a data steward's primary responsibility?
- Writing SQL queries for reporting
- Managing server hardware
- Overseeing data quality and enforcing data policies within a domain (Correct answer)
- Building machine learning models
Correct answer: Overseeing data quality and enforcing data policies within a domain
A data steward is responsible for maintaining data quality, enforcing governance policies, and acting as a subject-matter expert for a specific data domain.
Question 3: Which data quality dimension measures whether data correctly represents real-world values?
- Completeness
- Timeliness
- Accuracy (Correct answer)
- Uniqueness
Correct answer: Accuracy
Accuracy refers to how well data values reflect the true real-world state of the entity being described.
Question 4: What is a Master Data Management (MDM) system used for?
- Storing raw unstructured data
- Creating a single, authoritative reference for critical business data entities (Correct answer)
- Generating data visualizations
- Encrypting database backups
Correct answer: Creating a single, authoritative reference for critical business data entities
MDM creates a single trusted view of key business entities (like customers, products, or employees) by consolidating data from multiple sources.
Question 5: Which of the following is an example of a data quality issue related to completeness?
- A customer's age is recorded as 250
- A product price field contains letters
- A customer record has no email address (Correct answer)
- Two records share the same customer ID
Correct answer: A customer record has no email address
Completeness refers to whether all required data attributes are present; a missing email address is a completeness issue.
Question 6: What does a data catalog primarily provide in a data governance program?
- Automated data cleaning routines
- A searchable inventory of data assets with metadata and lineage information (Correct answer)
- A real-time data streaming pipeline
- A set of ETL transformation scripts
Correct answer: A searchable inventory of data assets with metadata and lineage information
A data catalog is a metadata management tool that helps users find, understand, and trust data assets across the organization.
