DMC Data Governance and Standards

Question 1

What is data governance in the context of data modeling?

Accepted Answer

The framework of policies, processes, roles, and standards that ensure data is managed consistently and responsibly

Answer

A software tool for automating database deployments

Answer

A method for encrypting sensitive columns

Answer

A backup and recovery strategy

Question 2

What is a data steward's primary responsibility?

Accepted Answer

Accountable for the quality, definition, and appropriate use of specific data elements within a business domain

Answer

Writing SQL queries for data extraction

Answer

Administering database server hardware

Answer

Developing ETL pipelines

Question 3

What is the purpose of a data naming convention standard?

Accepted Answer

To ensure consistent, meaningful, and unambiguous naming of data elements across the organization

Answer

To speed up query execution

Answer

To restrict who can create new tables

Answer

To compress data by using shorter names

Question 4

What does 'data lineage' document?

Accepted Answer

The origin of data and how it flows and transforms through systems over time

Answer

The age of data records from creation to deletion

Answer

The genealogy of database schema versions

Answer

The list of users who accessed specific data

Question 5

Which DMC concept refers to a consistent definition of a business entity agreed upon across the enterprise?

Accepted Answer

Master data

Answer

Operational data

Answer

Transactional data

Answer

Derived data

Question 6

What is a data owner in a governance framework?

Accepted Answer

A senior business executive accountable for the strategic use and protection of a data domain

Answer

The DBA who created the table

Answer

The developer who wrote the ETL script

Answer

The analyst who most frequently queries the data