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.

Question 1

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

Question 2

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

Question 3

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

Question 4

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

Question 5

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

Question 6

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

Question 7

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

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

Question 9

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)

Question 10

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

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