CDMP Exam Prep Free practice test →

Free CDMP Practice Questions

10 free, exam-style Certified Data Management Professional (CDMP) practice questions with answers and explanations. No signup required. Work through them below, then take the full free CDMP practice test to study every exam domain.

The CDMP exam has 100 questions and runs 1 hour 30 minutes.

These 10 free CDMP questions are organized by exam domain, so you can see how each part of the Certified Data Management Professional blueprint is tested. Reveal the answer and explanation under each question.

Domain 1: Data Governance 11% of exam

Question 1

The difference between a data owner and a data custodian is BEST described as:

  1. Data owners manage technology; data custodians manage business rules
  2. Data owners are accountable for data; data custodians manage data infrastructure
  3. Data custodians have more authority than data owners
  4. There is no difference; the roles are interchangeable
Show answer & explanation

Correct answer: B - Data owners are accountable for data; data custodians manage data infrastructure

Domain 2: Data Architecture 6% of exam

Question 2

A customer record has an email address in the correct format (name@domain.com) but it belongs to a different person. Which data quality dimension is violated?

  1. Validity
  2. Accuracy
  3. Completeness
  4. Timeliness
Show answer & explanation

Correct answer: B - Accuracy

Domain 3: Data Modeling and Design 11% of exam

Question 3

A table has a composite primary key of (StudentID, CourseID) and an attribute 'StudentName' that depends only on StudentID. This violates:

  1. First Normal Form
  2. Second Normal Form
  3. Third Normal Form
  4. No normal form is violated
Show answer & explanation

Correct answer: B - Second Normal Form

Domain 4: Data Storage and Operations 6% of exam

Question 4

Which combination BEST represents the three metadata types for a 'Customer_Revenue' column?

  1. Business: 'Customer identification number'; Technical: VARCHAR(50), not null constraint; Operational: updated daily at 3:00 AM, 45,000 records
  2. Business: 'Total annual revenue from a customer'; Technical: DECIMAL(12,2), indexed; Operational: last loaded 2025-03-14, 50,000 rows
  3. Business: 'Revenue tracking for customer accounts'; Technical: INTEGER primary key, unique index; Operational: synchronized hourly, 52,000 entries
  4. Business: 'Customer payment history summary'; Technical: FLOAT(15,4), foreign key reference; Operational: refreshed nightly, 48,000 rows
Show answer & explanation

Correct answer: B - Business: 'Total annual revenue from a customer'; Technical: DECIMAL(12,2), indexed; Operational: last loaded 2025-03-14, 50,000 rows

Domain 5: Data Security 6% of exam

Question 5

A probabilistic match engine returns a confidence score of 85% for two customer records. The auto-match threshold is 90% and the auto-reject threshold is 40%. What should happen?

  1. The records are automatically merged
  2. The records are automatically rejected as non-matches
  3. The records are sent to a data steward for manual review
  4. The matching engine restarts
Show answer & explanation

Correct answer: C - The records are sent to a data steward for manual review

Domain 6: Data Integration and Interoperability 6% of exam

Question 6

A customer changes their last name after marriage. The DW must retain the complete history of all name changes. Which SCD type should be used?

  1. Type 0
  2. Type 1
  3. Type 2
  4. Type 3
Show answer & explanation

Correct answer: C - Type 2

Domain 7: Document and Content Management 4% of exam

Question 7

The Zachman Framework is BEST described as:

  1. A step-by-step methodology for building data architectures
  2. A classification taxonomy for organizing enterprise architecture artifacts
  3. A database design tool for data modeling
  4. A project management framework for IT governance
Show answer & explanation

Correct answer: B - A classification taxonomy for organizing enterprise architecture artifacts

Domain 8: Reference and Master Data 5% of exam

Question 8

The PRIMARY benefit of a canonical data model is:

  1. It eliminates all data transformation requirements
  2. It reduces point-to-point mappings by using a common format
  3. It increases system integration complexity
  4. It requires separate models for each system
Show answer & explanation

Correct answer: B - It reduces point-to-point mappings by using a common format

Domain 9: Data Warehousing and Business Intelligence 6% of exam

Question 9

The PRIMARY difference between encryption and tokenization is:

  1. They are identical technologies
  2. Encryption uses algorithms; tokenization uses lookup tables
  3. Tokenization provides stronger data protection
  4. Encryption transforms data irreversibly
Show answer & explanation

Correct answer: B - Encryption uses algorithms; tokenization uses lookup tables

Domain 10: Metadata Management 11% of exam

Question 10

Since network partitions are inevitable in distributed systems, the CAP theorem effectively forces a choice between:

  1. Availability and Partition tolerance (AP or PA systems)
  2. Consistency and Availability (CP or AP systems)
  3. Performance and Partition tolerance (PP or PA systems)
  4. Scalability and Availability (SA or AP systems)
Show answer & explanation

Correct answer: B - Consistency and Availability (CP or AP systems)

The rest of the CDMP blueprint

The CDMP exam also covers these domains. Drill them in the full free practice test:

Ready for the real thing?

Practice hundreds more CDMP questions with instant scoring, weak-area drills, and full exam simulations.

Start the free practice test See pricing