I85PREP
⌘ K
CDMP study materials
CDMP study resources

CDMP practice questions

One question at a time. Build your CDMP understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Data Management Fundamentals (DMF)

In the DAMA-DMBOK framework, which component of the data management environment defines the roles, decision rights, and accountability structure for data assets?

  1. Data governance Correct answer.
  2. Data architecture
  3. Data storage and operations
  4. Data integration and interoperability

Explanation

Data governance is the central discipline that establishes decision rights, accountability, policies, and standards for managing data as an asset. The other listed areas are execution disciplines that operate within the boundaries governance sets, not the accountability structure itself.

Question 2Data Management Fundamentals (DMF)

A retail company wants a single agreed definition of 'active customer' used consistently across marketing and finance reporting. Which data management discipline most directly owns this deliverable?

  1. Metadata management
  2. Reference and master data management Correct answer.
  3. Data quality management
  4. Document and content management

Explanation

Reference and master data management establishes controlled, shared definitions and values for core business entities so that systems and reports agree. A shared definition of a core entity such as customer is a master data concern, even though metadata and quality practices support it.

Question 3Data Management Fundamentals (DMF)

Which statement best describes the relationship between data and information within data management?

  1. Data consists of raw facts, while information is data processed and given context and meaning. Correct answer.
  2. Information exists only in structured databases, while data exists only in documents.
  3. Information is raw facts, while data is processed and contextualized.
  4. Data and information are interchangeable terms with no meaningful distinction.

Explanation

Data comprises raw, unprocessed facts and symbols, whereas information emerges when data is organized, contextualized, and interpreted so it becomes meaningful. This distinction underpins why data management invests in context such as metadata and definitions.

Question 4Data Management Fundamentals (DMF)

An organization is defining its data lifecycle. At which stage should retention requirements and archival or destruction rules be established?

  1. Only after data has been archived
  2. After the data has been deleted from production systems
  3. Only when a regulator requests records
  4. During the planning and design stage, before data is created or acquired Correct answer.

Explanation

Retention, archival, and destruction requirements should be designed into the lifecycle up front so that data is created and stored with the right controls from the start. Addressing them after the fact risks noncompliance and uncontrolled data accumulation.

Question 5Data Management Fundamentals (DMF)

Which pair correctly distinguishes structured data from unstructured data?

  1. Structured data is always stored on disk; unstructured data is always stored in memory.
  2. Structured data has a predefined schema such as relational tables; unstructured data lacks a predefined model, such as free text or images. Correct answer.
  3. Structured data is created by machines; unstructured data is created only by humans.
  4. Structured data is always more valuable; unstructured data is always low quality.

Explanation

Structured data conforms to a predefined schema, typically rows and columns in relational systems, while unstructured data such as text, images, and audio has no predefined data model. The distinction concerns organization and schema, not storage medium, origin, or inherent value.

Question 6Data Management Fundamentals (DMF)

A data steward needs to trace where a reported figure originated, how it was transformed, and which downstream reports consume it. Which metadata type primarily serves this need?

  1. Business metadata
  2. Technical metadata Correct answer.
  3. Operational metadata
  4. Reference metadata

Explanation

Technical metadata describes structures, transformations, and data flows such as source-to-target mappings and lineage, which is exactly what tracing origin and transformation requires. Business metadata provides definitions and usage context, while operational metadata covers runtime statistics.

Question 7Data Management Fundamentals (DMF)

Which activity is the primary purpose of a data quality dimension assessment such as completeness, accuracy, and timeliness?

  1. To replace master data management with automated cleansing
  2. To quantify how well data meets defined expectations so improvement can be prioritized Correct answer.
  3. To eliminate the need for data governance policies
  4. To guarantee that data will never contain errors

Explanation

Data quality dimensions provide measurable criteria that quantify conformance to expectations, enabling teams to prioritize remediation where gaps are largest. They support governance and improvement rather than replacing those disciplines or promising error-free data.

Question 8Data Management Fundamentals (DMF)

In a relational database, what does a foreign key enforce?

  1. That all attributes are stored in a single flat file
  2. That values in one table correspond to existing key values in a related table Correct answer.
  3. That every column in a table contains a unique value
  4. That a table cannot be updated once created

Explanation

A foreign key is an attribute whose values must match primary key values in a related table, enforcing referential integrity between the two. It constrains relationships, not uniqueness of every column or immutability of tables.

Question 9Data Management Fundamentals (DMF)

A team stores the same customer address in five separate applications and must update each one manually. Which data management problem does this most clearly illustrate?

  1. Insufficient data encryption
  2. Excessive normalization
  3. Overuse of metadata repositories
  4. Data redundancy and inconsistency risk Correct answer.

Explanation

Duplicating the same attribute across multiple systems creates redundancy and raises the risk of inconsistent values when updates are not synchronized. Master data management and integration practices address this by establishing an authoritative source.

Question 10Data Management Fundamentals (DMF)

Which statement accurately characterizes the role of data architecture within an organization?

  1. It defines the blueprint for data assets, their structure, and how they integrate with business processes and technology. Correct answer.
  2. It is a one-time project deliverable that never changes after approval.
  3. It is limited to selecting a single database vendor for the enterprise.
  4. It replaces data modeling by eliminating the need for entity definitions.

Explanation

Data architecture provides the overall blueprint describing data assets, their structure and relationships, and alignment with business processes and technology. It is broader than vendor selection, complements data modeling, and evolves with the organization.

Question 11Data Management Fundamentals (DMF)

A data management program wants to assign accountability so that each critical data element has a named owner responsible for its definition and quality. Which concept does this describe?

  1. Data virtualization
  2. Data federation
  3. Data replication
  4. Data stewardship and ownership Correct answer.

Explanation

Stewardship and ownership assign named accountability for data elements, including defining meaning and monitoring quality. Virtualization, federation, and replication are technical data access and movement techniques that do not assign accountability.

Question 12Data Management Fundamentals (DMF)

An analyst reports that a dashboard's revenue total differs from the finance ledger by a small margin each month. Which first step best reflects a disciplined data management response?

  1. Immediately rebuild the dashboard in a new tool
  2. Delete the dashboard to avoid confusion
  3. Trace lineage and definitions of the revenue metric to identify the source of divergence Correct answer.
  4. Assume the finance ledger is always correct without investigation

Explanation

Investigating lineage and metric definitions determines whether the divergence stems from different sources, transformations, timing, or filters. This evidence-based step addresses root cause before any remediation such as rebuilding or retiring the report.

Question 13Data Management Fundamentals (DMF)

Which description best captures the purpose of a data model at the conceptual level?

  1. It communicates the key business entities and their relationships independent of technology. Correct answer.
  2. It documents server configuration and backup schedules.
  3. It specifies physical storage parameters and index structures.
  4. It lists the exact SQL data types for every column.

Explanation

A conceptual data model presents the important business entities and relationships in technology-neutral terms, serving communication between business and technical stakeholders. Physical details such as storage, data types, and configuration belong to logical and physical models or operations.

Question 14Data Management Fundamentals (DMF)

A hospital must retain patient records for a legally mandated period and then destroy them in a controlled way. Which data management capability governs this requirement?

  1. Records retention and disposition policy within data governance Correct answer.
  2. Schema versioning in development
  3. Capacity planning for storage hardware
  4. Query performance tuning

Explanation

Retention and disposition policies, established under data governance, define how long records are kept and how they are lawfully destroyed. Performance tuning, schema versioning, and capacity planning are technical concerns that do not set legal retention rules.

Question 15Data Management Fundamentals (DMF)

Which of the following best describes the difference between a data warehouse and a data lake?

  1. A warehouse and a lake are identical concepts with different marketing names.
  2. A warehouse cannot be queried, while a lake always enforces strict relational constraints.
  3. A warehouse stores only unstructured data, while a lake stores only relational tables.
  4. A warehouse typically stores schema-on-write structured data for analytics, while a lake can store raw data of many forms using schema-on-read. Correct answer.

Explanation

A data warehouse generally applies schema on write and holds structured, curated data for analytical use, while a data lake stores raw data in varied formats and applies schema on read. This distinction concerns structure and processing approach rather than marketing terminology.

Question 16Data Management Fundamentals (DMF)

A global firm needs consistent codes for country, currency, and unit of measure shared across all applications. Which type of data is this?

  1. Reference data Correct answer.
  2. Unstructured content
  3. Streaming telemetry
  4. Transactional data

Explanation

Reference data consists of controlled, relatively static code sets and valid values, such as country codes, currencies, and units of measure, used to categorize other data. Transactional data records business events, while the other options describe different data forms.

Question 17Data Management Fundamentals (DMF)

Which practice most directly supports data interoperability between two systems that use different customer identifier formats?

  1. Disabling referential integrity in both systems
  2. Encouraging each system to invent new identifiers independently
  3. Defining a cross-reference or mapping between the identifier schemes Correct answer.
  4. Storing both systems' data in the same physical table without transformation

Explanation

Interoperability requires a mapping or cross-reference that translates between differing identifier schemes so records can be reconciled. Shared physical storage without transformation, disabled integrity, or proliferating identifiers all worsen inconsistency.

Question 18Data Management Fundamentals (DMF)

Which statement best explains why metadata is considered a critical data management asset rather than an optional by-product?

  1. It eliminates the need to store the underlying data itself.
  2. It provides the context, definitions, and lineage needed to trust, find, and govern data effectively. Correct answer.
  3. It guarantees that source systems will never change their schemas.
  4. It replaces the need for data quality measurement.

Explanation

Metadata supplies definitions, context, and lineage that let users find, understand, trust, and govern data, which is why it is managed as an asset. It does not substitute for the data, prevent schema changes, or replace quality measurement.

Question 19Data Management Fundamentals (DMF)

A team is choosing between a normalized operational schema and a denormalized analytical schema. Which rationale best fits the analytical choice?

  1. Normalization is only used for unstructured data.
  2. Denormalization can reduce join complexity and improve query performance for analytical workloads. Correct answer.
  3. Analytical schemas must never duplicate attributes.
  4. Denormalization always reduces storage cost to zero.

Explanation

Denormalized structures such as star schemas reduce the number of joins required, which can improve read performance for analytical queries. Operational systems favor normalization to control redundancy and integrity, while analytical systems often trade redundancy for speed.

Question 20Data Management Fundamentals (DMF)

Which of the following is the most accurate description of a data domain within an enterprise data governance program?

  1. A programming language used to query databases
  2. A physical server partition used only for backups
  3. A logical grouping of data related to a business subject area, governed by assigned owners and policies Correct answer.
  4. A temporary file used during extract-transform-load jobs

Explanation

A data domain groups data by business subject area, such as customer or product, and is governed by assigned owners, stewards, and policies. This organizational concept is distinct from physical infrastructure, languages, or transient processing artifacts.

Question 21Data Management Fundamentals (DMF)

An organization discovers that the same product appears under three different names across systems because no authority was designated. Which root cause does this most directly indicate?

  1. Overinvestment in data encryption
  2. Excessive use of data lineage tools
  3. Insufficient network bandwidth
  4. Absence of master data management for the product entity Correct answer.

Explanation

Multiple conflicting names for the same product indicate the lack of an authoritative master data source and governance for that entity. Master data management establishes a trusted, shared record to which other systems conform.

Question 22Data Management Fundamentals (DMF)

Which statement best describes the purpose of data profiling?

  1. To analyze data for patterns, anomalies, and quality issues such as nulls or outliers Correct answer.
  2. To schedule nightly backup jobs
  3. To design the user interface of a reporting dashboard
  4. To encrypt sensitive columns before storage

Explanation

Data profiling examines datasets statistically to reveal patterns, anomalies, and quality issues such as missing values, duplicates, and outliers. It informs quality assessment and modeling decisions rather than encryption, interface design, or backup scheduling.

Question 23Data Management Fundamentals (DMF)

A data management team is evaluating whether to virtualize access to several source systems instead of copying data into a central store. Which consideration is most relevant to this decision?

  1. Virtualization guarantees better data quality than physical consolidation.
  2. Virtualization removes all need for data governance.
  3. Virtualization can reduce duplication and latency but may depend on source availability and performance. Correct answer.
  4. Virtualization eliminates the need for metadata about sources.

Explanation

Data virtualization provides a logical access layer that can reduce duplication and staleness, but query performance and reliability depend on the availability and speed of underlying sources. It does not automatically improve quality, remove metadata needs, or replace governance.

Question 24Data Management Fundamentals (DMF)

Which activity best exemplifies the practice of data integration?

  1. Transforming and consolidating order data from three systems into a unified view Correct answer.
  2. Writing a policy on records destruction
  3. Defining a conceptual entity-relationship diagram
  4. Assigning a steward to a customer data domain

Explanation

Data integration involves combining and transforming data from multiple sources into a consistent, unified view for consumption. Stewardship, retention policy, and conceptual modeling are governance and design activities rather than integration execution.

Question 25Data Management Fundamentals (DMF)

A data architect argues that the organization needs both a logical and a physical data model. Which justification is most sound?

  1. The logical model is only for auditors, and the physical model is only for executives.
  2. The physical model is optional because databases generate themselves automatically.
  3. The logical model must include exact storage block sizes to be valid.
  4. The logical model captures business rules and relationships independent of technology, while the physical model specifies implementation details for a chosen platform. Correct answer.

Explanation

Logical models describe entities, attributes, and relationships with business rules but without platform specifics, while physical models translate that into tables, data types, indexes, and storage for a target platform. Both serve distinct and necessary purposes in design.

Question 26Data Modeling and Design

In a relational data model, which construct enforces that each row of a table can be uniquely identified and never duplicated?

  1. A check constraint
  2. A default constraint
  3. A foreign key constraint
  4. A primary key constraint Correct answer.

Explanation

A primary key uniquely identifies every row in a table and prohibits null or duplicate values in the key columns. Foreign keys instead reference keys in other tables, while check and default constraints restrict or supply column values rather than guaranteeing row uniqueness.

Question 27Data Modeling and Design

Which modeling notation represents a relationship as an associative entity (associative table) when a many-to-many relationship must be resolved for a relational database?

  1. Crow's foot
  2. Dimensional modeling
  3. Entity-relationship modeling Correct answer.
  4. Object role modeling

Explanation

In entity-relationship modeling, a many-to-many relationship is resolved by introducing an associative entity that holds the keys of both participating entities. This associative entity then becomes a junction table in the physical relational schema.

Question 28Data Modeling and Design

A data modeler normalizes an entity to third normal form. Which condition must the entity satisfy in addition to being in second normal form?

  1. Every non-key attribute must be free of transitive dependency on the primary key. Correct answer.
  2. Every non-key attribute must be functionally dependent on the whole primary key only.
  3. Every foreign key must reference an existing primary key value.
  4. Every attribute must be atomic and free of repeating groups.

Explanation

Third normal form eliminates transitive dependencies, meaning no non-key attribute depends on another non-key attribute. First normal form addresses atomicity and repeating groups, and second normal form removes partial dependencies on part of a composite key.

Question 29Data Modeling and Design

A retail model stores customer, order, and order line entities. Which cardinality correctly describes the relationship between an order and its order lines?

  1. Many-to-many
  2. One-to-many Correct answer.
  3. One-to-one
  4. Zero-to-one

Explanation

A single order can contain multiple order lines, but each order line belongs to exactly one order, producing a one-to-many relationship from order to order line. The many side is the child entity that carries the foreign key to the parent.

Question 30Data Modeling and Design

In dimensional modeling, which schema places a fact table at the center with fully normalized dimension tables joined through intermediate tables?

  1. Snowflake schema Correct answer.
  2. Third normal form schema
  3. Data vault
  4. Star schema

Explanation

A snowflake schema normalizes dimension tables into multiple related tables, reducing redundancy at the cost of more joins. A star schema keeps dimensions denormalized and directly joined to the fact table.

Question 31Data Modeling and Design

A data modeler must record the history of changes to a customer's address over time while preserving each prior version. Which technique best supports this requirement?

  1. Slowly changing dimension type 1
  2. Slowly changing dimension type 2 Correct answer.
  3. Degenerate dimension
  4. Junk dimension

Explanation

A slowly changing dimension type 2 adds a new row with effective dates and a current flag for each change, preserving full history. Type 1 overwrites the old value and therefore loses prior versions.

Question 32Data Modeling and Design

Which element of a data model captures a business rule stating that an account balance may never be negative?

  1. A relationship
  2. A constraint Correct answer.
  3. An attribute
  4. An entity

Explanation

A constraint expresses a rule that restricts the values or states data may take, such as a balance that cannot fall below zero. Entities, attributes, and relationships describe structure rather than value restrictions.

Question 33Data Modeling and Design

A modeler is designing a conceptual data model. Which characteristic is most appropriate at this level?

  1. It shows major entities and relationships without technical detail. Correct answer.
  2. It specifies data types and column lengths.
  3. It defines primary and foreign key columns.
  4. It includes indexes and storage parameters.

Explanation

A conceptual model captures the business view, showing major entities and relationships while abstracting away technical implementation. Physical details such as indexes, keys, and data types belong to logical and physical models.

Question 34Data Modeling and Design

A logical data model shows a many-to-many relationship between Student and Course. What is the standard way to transform this for a relational physical model?

  1. Remove the relationship to avoid redundancy.
  2. Add a foreign key from Student to Course only.
  3. Merge Student and Course into a single table.
  4. Create an associative entity Enrollment with foreign keys to both Student and Course. Correct answer.

Explanation

Relational databases cannot directly store a many-to-many relationship, so an associative entity (junction table) with foreign keys to both parents resolves it. This preserves the association while allowing multiple students per course and vice versa.

Question 35Data Modeling and Design

Which normal form specifically removes partial dependencies of non-key attributes on part of a composite primary key?

  1. Third normal form
  2. First normal form
  3. Second normal form Correct answer.
  4. Boyce-Codd normal form

Explanation

Second normal form requires that every non-key attribute depend on the entire primary key, eliminating partial dependency on part of a composite key. Third normal form and Boyce-Codd normal form address transitive and other functional dependencies.

Question 36Data Modeling and Design

A data modeler adds a surrogate key to a dimension table. What is the primary reason for using a surrogate key rather than the natural business key?

  1. It removes the need for a primary key.
  2. It provides a stable, compact identifier decoupled from business values. Correct answer.
  3. It guarantees the natural key is never changed.
  4. It enforces referential integrity automatically.

Explanation

A surrogate key is a system-generated identifier independent of business attributes, so changes to natural keys do not ripple through the warehouse. It is typically compact and stable, simplifying joins and history tracking in dimensions.

Question 37Data Modeling and Design

In a star schema, which table typically contains the numeric measures and foreign keys to dimension tables?

  1. Bridge table
  2. Dimension table
  3. Staging table
  4. Fact table Correct answer.

Explanation

The fact table stores measurable events and foreign keys that reference the surrounding dimension tables. Dimension tables hold descriptive attributes that give context to those measures.

Question 38Data Modeling and Design

A modeler wants to model a hierarchy in which each employee may report to at most one manager. Which relationship structure fits best?

  1. A one-to-one relationship between Employee and Manager entities
  2. A recursive one-to-many relationship within the Employee entity Correct answer.
  3. A many-to-many relationship between Employee and Department
  4. A recursive many-to-many relationship within the Employee entity

Explanation

A self-referencing one-to-many relationship on Employee models the reporting hierarchy: one manager has many direct reports, and each employee has at most one manager. This is also called a recursive or unary relationship.

Question 39Data Modeling and Design

Which data modeling approach organizes data into hubs, links, and satellites to support integration and auditability?

  1. Snowflake schema
  2. Data vault Correct answer.
  3. Star schema
  4. Object role modeling

Explanation

Data vault modeling separates business keys (hubs), relationships (links), and descriptive history (satellites) to support scalable integration and full auditability. Star and snowflake schemas are dimensional patterns for analytics rather than integration-oriented structures.

Question 40Data Modeling and Design

An attribute in a dimension table has low cardinality with many repeated values across rows. Which design action is most appropriate?

  1. Convert the attribute into a surrogate key.
  2. Move the attribute to a separate normalized table joined to the dimension.
  3. Group the attribute with related flags into a junk dimension. Correct answer.
  4. Remove the attribute from the model.

Explanation

Low-cardinality flags and indicators are often combined into a junk dimension to keep the main dimension narrow and avoid many tiny columns. Grouping related flags reduces clutter and improves query performance.

Question 41Data Modeling and Design

Which statement best describes the purpose of a data model review before physical implementation?

  1. It tunes database indexes for query performance.
  2. It generates the production deployment script.
  3. It validates that the model meets business requirements and modeling standards. Correct answer.
  4. It migrates data from legacy systems.

Explanation

A model review checks that the design satisfies business requirements, follows naming and modeling standards, and resolves structural issues before costly implementation. Index tuning, migration, and deployment occur later in the lifecycle.

Question 42Data Modeling and Design

A modeler wants to represent an optional relationship where a customer may have zero or more phone numbers. Which cardinality notation is correct?

  1. Zero-to-exactly-one
  2. One-to-exactly-one
  3. One-to-zero-or-many Correct answer.
  4. Many-to-many

Explanation

An optional one-to-many relationship is expressed as one-to-zero-or-many, meaning a customer exists with any number of phone numbers from zero upward. This captures both optionality and multiplicity correctly.

Question 43Data Modeling and Design

Which artifact documents the meaning of each attribute, its allowed values, and its source in a data model?

  1. A physical data model
  2. An entity-relationship diagram
  3. A data flow diagram
  4. A data dictionary Correct answer.

Explanation

A data dictionary provides metadata for each attribute, including definition, allowed values, data type, and source. Diagrams show structure visually but do not capture detailed attribute semantics.

Question 44Data Modeling and Design

A modeler is choosing between a star schema and a snowflake schema for a reporting mart. Which trade-off favors the star schema?

  1. Reduced storage through full dimension normalization
  2. Stronger enforcement of third normal form
  3. Elimination of the fact table
  4. Fewer joins and simpler queries for business users Correct answer.

Explanation

A star schema keeps dimensions denormalized, so queries require fewer joins and are simpler for business users and BI tools. A snowflake schema reduces redundancy but increases join complexity.

Question 45Data Modeling and Design

In an entity-relationship model, what does a weak entity require to be uniquely identified?

  1. An identifying relationship to an owner entity plus a partial key Correct answer.
  2. A surrogate key generated by the database
  3. A many-to-many relationship to a dimension
  4. A globally unique natural key

Explanation

A weak entity cannot be uniquely identified by its own attributes alone; it depends on an identifying relationship to an owner entity combined with a partial key. Its full identifier is the owner's key plus the partial key.

Question 46Data Modeling and Design

Which type of data model is most closely tied to a specific database management system and includes data types, indexes, and storage details?

  1. Logical data model
  2. Conceptual data model
  3. Physical data model Correct answer.
  4. Semantic data model

Explanation

A physical data model is tailored to a specific DBMS and includes data types, indexes, partitioning, and storage details. Conceptual and logical models remain platform-independent and progressively add detail.

Question 47Data Modeling and Design

A modeler discovers that a non-key attribute depends on another non-key attribute within the same entity. Which anomaly risk does this transitive dependency primarily create?

  1. Insert anomaly
  2. Referential anomaly
  3. Update anomaly Correct answer.
  4. Deletion anomaly

Explanation

A transitive dependency means the same fact is stored in multiple rows, so updating one non-key attribute may require updating many rows and risks inconsistency. This is the classic update anomaly that normalization to third normal form removes.

Question 48Data Modeling and Design

Which modeling technique uses facts and roles to express business rules in natural-language-like statements?

  1. Object role modeling Correct answer.
  2. Crow's foot notation
  3. Data vault modeling
  4. Dimensional modeling

Explanation

Object role modeling represents the domain as elementary facts that objects play roles in, expressed in natural-language-like statements. This supports precise constraint specification and traceability to business rules.

Question 49Data Modeling and Design

A fact table has a granularity defined at the individual sales transaction level. Which consequence follows from this choice?

  1. It prevents aggregation to daily totals.
  2. It eliminates the need for dimension keys.
  3. It enables flexible aggregation to any higher level. Correct answer.
  4. It requires a snowflaked dimension.

Explanation

Defining the fact table at the finest grain stores atomic data that can be aggregated to any higher level, such as daily or monthly totals. Coarser grain would permanently lose detail needed for flexible analysis.

Question 50Data Modeling and Design

Which practice best supports naming consistency across a large data model with many modelers?

  1. Allowing each modeler to choose names freely
  2. Adopting a documented naming convention and glossary Correct answer.
  3. Naming attributes after their source systems
  4. Using abbreviations without documentation

Explanation

A documented naming convention plus a business glossary ensures that entities and attributes are named consistently and understood by all stakeholders. Free-form naming leads to synonyms and ambiguity that complicate integration.