Data Modeling Certification (DMC) — Questions and Answers

Question 1: When a data quality issue is discovered in production data, which document should be updated to capture the root cause, business impact, and remediation steps?

Index usage report
Data quality issue log (Correct answer)
Entity-relationship diagram
Network topology diagram

Correct answer: Data quality issue log

A data quality issue log tracks discovered issues, their root causes, business impact assessments, and remediation actions, forming an audit trail for governance purposes.

Question 2: Which of the following tools are commonly used to integrate data modeling into data pipelines?

SQL Server Integration Services (SSIS) (Correct answer)
Talend (Correct answer)
Apache NiFi (Correct answer)
ER/Studio

Correct answer: SQL Server Integration Services (SSIS)

Apache NiFi, Talend, and SQL Server Integration Services (SSIS) are all powerful tools commonly used in data pipelines for Extract, Transform, Load (ETL) processes. They facilitate the movement and transformation of data between various sources and destinations, including databases designed with data modeling. These tools are essential for integrating and preparing data for various analytical and operational purposes.

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

A read-only backup of the production database
A list of all ETL jobs scheduled in the pipeline
An organized inventory of data assets with metadata, definitions, and ownership that enables data discovery and governance (Correct answer)
A list of approved SQL query templates

Correct 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.

Question 4: What does cardinality describe in a data model?

The primary key selection strategy
The data type of an attribute
The number of instances of one entity related to instances of another (Correct answer)
The indexing method used in storage

Correct answer: The number of instances of one entity related to instances of another

Cardinality defines how many instances of one entity can be associated with instances of another entity in a relationship.

Question 5: Which data quality dimension measures the degree to which data values fall within acceptable ranges and adhere to defined business rules?

Completeness
Timeliness
Consistency
Validity (Correct answer)

Correct answer: Validity

Validity measures whether data conforms to defined formats, ranges, and business rules, ensuring values are acceptable within the data model.

Question 6: What is the key difference between a strong entity and a weak entity?

A weak entity cannot be uniquely identified without referencing its parent entity (Correct answer)
Weak entities cannot have relationships
Strong entities have more attributes than weak entities
Strong entities use surrogate keys; weak entities use natural keys

Correct answer: A weak entity cannot be uniquely identified without referencing its parent entity

A weak entity depends on a parent (owner) entity for its identification and cannot be uniquely identified by its own attributes alone.

Question 7: When profiling a dataset to assess data quality, which activity involves analyzing the distribution of values in a column to detect anomalies?

Schema mapping
Index optimization
Column analysis (Correct answer)
Lineage tracing

Correct answer: Column analysis

Column analysis during data profiling examines the distribution, min/max, frequency, and null rates of values to surface quality anomalies.

Question 8: Which modeling artifact is used to document the meaning and origin of a single data element across an enterprise?

Physical table script
Entity-Relationship Diagram
Data element definition record (Correct answer)
Conceptual schema

Correct answer: Data element definition record

A data element definition record captures the business name, definition, data type, source, and steward of a single atomic piece of data.

Question 9: What is the purpose of a data dictionary in data modeling?

To translate SQL queries automatically
To map network traffic routes
To document the definitions, formats, and usage of data elements (Correct answer)
To store compressed database backups

Correct answer: To document the definitions, formats, and usage of data elements

A data dictionary provides authoritative documentation of data element definitions, formats, relationships, and business rules.

Question 10: What is the purpose of a data model review process in a governed organization?

To audit SQL query execution plans
To review ETL job scheduling
To approve changes to server hardware configurations
To ensure proposed data model changes conform to standards, don't break integrations, and are documented before implementation (Correct answer)

Correct answer: To ensure proposed data model changes conform to standards, don't break integrations, and are documented before implementation

A formal data model review process validates that changes meet naming standards, maintain data quality constraints, don't break downstream systems, and are properly documented in the data dictionary.

Question 11: In data governance, what is the role of a data governance council?

To operate the backup and recovery systems
To write SQL for data transformation projects
To conduct database performance tuning
To serve as a cross-functional decision-making body that sets data policies, resolves conflicts, and prioritizes data initiatives (Correct answer)

Correct answer: To serve as a cross-functional decision-making body that sets data policies, resolves conflicts, and prioritizes data initiatives

A data governance council brings together senior stakeholders from business and IT to establish data policies, resolve disputes about data ownership, and prioritize governance initiatives.

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

Operational data
Derived data
Transactional data
Master data (Correct answer)

Correct answer: Master data

Master data represents the core business entities — customers, products, employees, locations — that are shared and used consistently across multiple business processes and systems.

Question 13: What is data governance in the context of data modeling?

A software tool for automating database deployments
A backup and recovery strategy
A method for encrypting sensitive columns
The framework of policies, processes, roles, and standards that ensure data is managed consistently and responsibly (Correct answer)

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

Data governance establishes the policies, processes, accountability structures, and standards that define how data is created, stored, maintained, used, and retired across the organization.

Question 14: What does 'data lineage' document?

The origin of data and how it flows and transforms through systems over time (Correct answer)
The list of users who accessed specific data
The age of data records from creation to deletion
The genealogy of database schema versions

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

Data lineage tracks the complete journey of data from its source through every transformation and system it passes through to its final destination.

Question 15: What is table partitioning in physical data modeling?

Creating read-only replicas of a table
Splitting a table's columns into multiple tables
Dividing a large table's rows into segments based on a partition key to improve performance and manageability (Correct answer)
Encrypting specific columns for security

Correct answer: Dividing a large table's rows into segments based on a partition key to improve performance and manageability

Table partitioning divides a large table into smaller, manageable segments (partitions) based on a key such as date range or region, improving query performance and data maintenance.

Question 16: Which concept represents a property or characteristic of an entity in a data model?

Cardinality
Attribute (Correct answer)
Schema
Relationship

Correct answer: Attribute

An attribute is a property or characteristic that describes an entity, such as a customer's name or birth date.

Question 17: What is a join dependency, and which normal form addresses it?

A dependency where a table can only be reconstructed losslessly by joining three or more projections — addressed by 5NF (PJNF) (Correct answer)
A constraint that two foreign keys must reference the same parent — addressed by 3NF
A circular reference between two tables — addressed by 4NF
A dependency that requires a JOIN operation to retrieve a value — addressed by BCNF

Correct answer: A dependency where a table can only be reconstructed losslessly by joining three or more projections — addressed by 5NF (PJNF)

A join dependency exists when a table can only be decomposed into more than two tables and still be reconstructed losslessly, which Fifth Normal Form (5NF/PJNF) eliminates.

Question 18: What is vertical partitioning (also called column splitting) in physical data modeling?

Splitting a wide table into two narrower tables sharing the same primary key, separating frequently and rarely accessed columns (Correct answer)
Creating column-level access controls
Partitioning rows by date range across multiple tables
Dividing a table by business unit

Correct answer: Splitting a wide table into two narrower tables sharing the same primary key, separating frequently and rarely accessed columns

Vertical partitioning splits a table's columns into two or more tables with the same primary key, improving performance by keeping frequently accessed columns together.

Question 19: Which of the following are benefits of effective metadata management?

Enhanced data quality and governance (Correct answer)
Improved data discovery and accessibility (Correct answer)
Better compliance with regulations (Correct answer)
Faster query execution in relational databases

Correct answer: Enhanced data quality and governance

Effective metadata management offers several significant benefits, including improved data discovery and accessibility by making it easier to find and understand relevant data assets. It also enhances data quality and governance by providing context, lineage, and definitions, which are crucial for maintaining data accuracy and consistency. Furthermore, robust metadata management aids in better compliance with regulations by documenting data origins, transformations, and usage.

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

To set limits on query execution time
To control how many backups are stored
To prevent database indexes from growing too large
To define how long data must be kept and when it should be archived or deleted based on legal and business requirements (Correct answer)

Correct 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.

Question 21: What is a business glossary and why is it important in data modeling?

A SQL keyword reference manual
An authoritative list of business terms with agreed definitions used consistently across the organization (Correct answer)
A glossary of data modeling notation symbols
A list of approved database vendor products

Correct answer: An authoritative list of business terms with agreed definitions used consistently across the organization

A business glossary provides standard definitions for business terms, ensuring that data modelers, developers, and business users all mean the same thing when they use key terms.

Question 22: What does 'data sovereignty' mean and why does it affect physical data modeling decisions?

The principle that the data owner controls all access
The legal concept that data is subject to the laws of the country where it is stored, affecting where data can physically reside (Correct answer)
The rule that production data must not leave the data center
The right of developers to define their own schemas

Correct answer: The legal concept that data is subject to the laws of the country where it is stored, affecting where data can physically reside

Data sovereignty means data is governed by the laws of the country it is stored in, requiring physical models to implement region-specific data stores for compliance with local regulations.

Question 23: Which data quality concept refers to each entity instance being represented only once in a dataset, with no duplicate records?

Completeness
Uniqueness (Correct answer)
Consistency
Accuracy

Correct answer: Uniqueness

Uniqueness ensures that each real-world entity appears exactly once in the dataset, which is typically enforced through primary keys and deduplication processes.

Question 24: In data modeling, what is an entity?

A stored procedure
A person, place, object, event, or concept about which data is stored (Correct answer)
A foreign key constraint
A database index

Correct answer: A person, place, object, event, or concept about which data is stored

An entity is a real-world object or concept — such as a customer, product, or order — about which data is collected.

Question 25: What principle ensures that every fact in a data model is stored in exactly one place?

Single Source of Truth (SSOT) (Correct answer)
Referential integrity
Domain constraint
Entity completeness

Correct answer: Single Source of Truth (SSOT)

The Single Source of Truth principle ensures each fact is stored once and only once, eliminating redundancy and reducing inconsistency risk.

Question 26: What is a multi-valued attribute?

An attribute that can hold multiple independent values for a single entity instance (Correct answer)
An attribute that maps to multiple physical columns
An attribute with a composite data type
A foreign key that references two parent tables

Correct answer: An attribute that can hold multiple independent values for a single entity instance

A multi-valued attribute is one that can hold more than one value simultaneously for the same entity, such as a person having multiple phone numbers.

Question 27: What are the three levels of data abstraction in the ANSI/SPARC architecture?

Physical, Logical, Virtual
External, Conceptual, Internal (Correct answer)
Raw, Processed, Stored
Operational, Analytical, Strategic

Correct answer: External, Conceptual, Internal

The ANSI/SPARC architecture defines three levels: External (user views), Conceptual (logical whole), and Internal (physical storage).

Question 28: Which of the following are NoSQL database technologies?

Neo4j (Correct answer)
MongoDB (Correct answer)
Cassandra (Correct answer)
Oracle Database

Correct answer: Neo4j

Neo4j, MongoDB, and Cassandra are all examples of NoSQL database technologies, which offer alternatives to traditional relational databases. Neo4j is a graph database, MongoDB is a document database, and Cassandra is a wide-column store. These databases are designed to handle large volumes of unstructured or semi-structured data, providing flexibility, scalability, and high performance for specific use cases.

Question 29: What is schema-on-read, and how does it differ from schema-on-write?

Schema-on-read applies structure at query time; schema-on-write enforces structure when data is stored (Correct answer)
Schema-on-read enforces structure when data is written; schema-on-write enforces it at query time
Schema-on-read is only used in relational databases
Both are identical but used in different DBMS platforms

Correct answer: Schema-on-read applies structure at query time; schema-on-write enforces structure when data is stored

Schema-on-write (traditional RDBMS) enforces a defined schema when data is stored, while schema-on-read (data lakes) applies interpretation at query time, allowing raw data ingestion.

Question 30: Which of the following is a characteristic of a natural key?

It derives its value from business attributes that already exist (Correct answer)
It is always numeric
It never appears in reports
It is generated by the database system

Correct answer: It derives its value from business attributes that already exist

A natural key is derived from existing business data — such as a Social Security number or product barcode — that already has meaning in the real world.

Data Modeling Certification (DMC)

The DMC is an industry-recognized certification for data modelers offered by Technics Publications, testing proficiency across 10 areas of data modeling expertise including conceptual/logical/physical design, normalization, notations, naming standards, and best practices. The exam draws from over 350 questions with randomized selection to ensure each test is unique.

Questions

30 min

Time Limit

85%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds