Data Governance and Standards Flashcards

What is the purpose of a data quality dimension in governance?

Answer: To define measurable characteristics — such as completeness, accuracy, and timeliness — used to assess data quality

Data quality dimensions — including completeness, accuracy, consistency, timeliness, validity, and uniqueness — provide measurable criteria for evaluating how fit data is for its intended use.

What is data profiling in the context of data governance and modeling?

Answer: Analyzing existing data to understand its structure, content, quality, and patterns

Data profiling examines source data to discover its structure, value ranges, null rates, uniqueness, and patterns — essential input for building accurate data models and governance policies.

What is the difference between data classification and data categorization in governance?

Answer: Classification assigns sensitivity/security labels (PII, confidential); categorization groups data by business subject area (Finance, HR)

Data classification assigns security/sensitivity labels (public, internal, confidential, restricted) while data categorization organizes data by business domain or subject area.

What does GDPR require of data models that store personal data of EU residents?

Answer: Models must accommodate data subject rights including access, correction, and erasure of personal data

GDPR requires that data systems support the right to access, rectify, port, and erase personal data — data models must be designed to accommodate these rights technically.

What is a data catalog and how does it relate to data governance?

Answer: An organized inventory of data assets with metadata, definitions, and ownership that enables data discovery and governance

A data catalog provides a searchable inventory of data assets enriched with business definitions, ownership, lineage, quality metrics, and usage statistics to enable governance and self-service analytics.

What is the purpose of a data retention policy in a data model?

Answer: To define how long data must be kept and when it should be archived or deleted based on legal and business requirements

A data retention policy specifies the required storage duration for data categories, driving physical design decisions about archiving, partitioning, and purging strategies.