cert
cert-1
cert-2

Pass CDMP DMF Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers to Pass the Actual Exam!
30 Days Free Updates, Instant Download!

cert-5
cert-6
DMF Exam - Verified By Experts
DMF Premium File

DMF Premium File

$69.99
$76.99
  • Premium File 295 Questions & Answers. Last Update: Nov 12, 2026

Whats Included:

  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates
 
$76.99
$69.99
accept 22 downloads in the last 7 days
block-screenshots
CDMP DMF Practice Test 14

Question 130

Consider this data-management scenario: A salesperson moves territories and historical sales must remain attributed to prior territory. Which underlying principle MOST directly explains the preferred response?

  1. Type 1 slowly changing dimensions replace values when historical changes are unnecessary.
  2. Type 2 dimensions preserve attribute history by versioning rows.
  3. Star schemas place numeric events in facts and descriptive context in dimensions.
  4. A warehouse supports integrated historical analysis distinct from operational transactions.

Explanation

Correct Answer

B:

Type 2 dimensions preserve attribute history by versioning rows. This concept explains the reason for the proposed control. Appropriate intervention: Use Type 2 dimension rows with effective dates, surrogate keys and validity checks.

Incorrect Answers

A:

This is a defensible principle in another context (A product description contains a typo and historic analytics do not need the old spelling.), not the most relevant rationale here. For the stated issue: Type 2 dimensions preserve attribute history by versioning rows.

C:

Star schemas place numeric events in facts and descriptive context in dimensions. This is a defensible principle in another context (Business users need to analyze order revenue by date, product and geography.), not the most relevant rationale here. For the stated issue: Type 2 dimensions preserve attribute history by versioning rows.

D:

A warehouse supports integrated historical analysis distinct from operational transactions. This is a defensible principle in another context (Executives need consistent historical revenue despite frequent transactional schema changes.), not the most relevant rationale here. For the stated issue: Type 2 dimensions preserve attribute history by versioning rows.

Question 131

After addressing this problem, what evidence would justify closure? A team runs OCR on handwritten forms and loads extracted values directly into an account ledger.

  1. Unauthorized test users cannot open sensitive documents and approved users retain access.
  2. Reconciled records document original images, reviewed exceptions and corrected values.
  3. Held content survives purge jobs and hold decisions have a traceable case reference.
  4. Search tests surface the current approved procedure rather than obsolete drafts.

Explanation

Correct Answer

B:

It tests the action: Validate extraction confidence and route uncertain fields to authorized human review.

Incorrect Answers

A:

Unauthorized test users cannot open sensitive documents and approved users retain access. This would verify a different control (A public sharing link exposes sensitive human resources documents to contractors.), not the one in the question. The required evidence is: Reconciled records document original images, reviewed exceptions and corrected values.

C:

Held content survives purge jobs and hold decisions have a traceable case reference. This would verify a different control (An automated seven-year purge is about to remove correspondence covered by an active litigation hold.), not the one in the question. The required evidence is: Reconciled records document original images, reviewed exceptions and corrected values.

D:

Search tests surface the current approved procedure rather than obsolete drafts. This would verify a different control (Employees cannot find approved procedures because files lack titles, tags and indexed text.), not the one in the question. The required evidence is: Reconciled records document original images, reviewed exceptions and corrected values.

Question 132

A data management auditor evaluates this situation: Test developers need representative orders but a test export includes real customer identity numbers. Which observable finding supports successful remediation?

  1. Test datasets retain required distributions while direct identifiers cannot be recovered.
  2. The analyst can perform the report but cannot alter or see unrelated sensitive records.
  3. The campaign operates while recipients cannot retrieve unnecessary full dates.
  4. The dataset is correctly labeled and unauthorized roles cannot read restricted attributes.

Explanation

Correct Answer

A:

It tests the action: Apply governed masking or synthetic data that preserves testing requirements without exposing identities.

Incorrect Answers

B:

The analyst can perform the report but cannot alter or see unrelated sensitive records. This would verify a different control (A BI analyst receives administrator access to production customer tables for simple reporting.), not the one in the question. The required evidence is: Test datasets retain required distributions while direct identifiers cannot be recovered.

C:

The campaign operates while recipients cannot retrieve unnecessary full dates. This would verify a different control (Marketing requests full birth dates for a campaign that only needs age bands.), not the one in the question. The required evidence is: Test datasets retain required distributions while direct identifiers cannot be recovered.

D:

The dataset is correctly labeled and unauthorized roles cannot read restricted attributes. This would verify a different control (A developer stores payment account numbers in a general-purpose dataset tagged public.), not the one in the question. The required evidence is: Test datasets retain required distributions while direct identifiers cannot be recovered.

Question 133

A governance review considers the following: A new platform requires all customer master updates to occur through one governed service. Which proposal would create an avoidable risk?

  1. Permit untracked direct writes to satellite copies of authoritative master attributes.
  2. Protect relevant audit records while investigating data problems.
  3. Escalate material unresolved issues to an accountable business decision owner.
  4. Check relevant business definitions before joining independently sourced data.

Explanation

Correct Answer

A:

Permit untracked direct writes to satellite copies of authoritative master attributes. Centralized mastering makes the hub the system of entry for core entity changes. A sound response instead: Consider centralized transaction-style MDM with authoritative write APIs and availability controls.

Incorrect Answers

B:

Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Consider centralized transaction-style MDM with authoritative write APIs and availability controls.

C:

Escalate material unresolved issues to an accountable business decision owner. Accountability prevents silent acceptance of consequential risk. The case-specific response is: Consider centralized transaction-style MDM with authoritative write APIs and availability controls.

D:

Check relevant business definitions before joining independently sourced data. Semantic agreements prevent incorrect cross-system correlations. The case-specific response is: Consider centralized transaction-style MDM with authoritative write APIs and availability controls.

Question 134

Consider this organizational data problem: A student can enroll in many courses and a course can enroll many students. What action is most defensible?

  1. Apply naming, glossary mapping and controlled definitions to important model elements.
  2. Model an associative enrollment entity with both relationships and enrollment attributes.
  3. Separate attributes dependent on only part of a composite key into their proper relation.
  4. Declare a single fact grain and separate or aggregate measures consistently.

Explanation

Correct Answer

B:

Model an associative enrollment entity with both relationships and enrollment attributes. Many-to-many relationships are implemented using associative structures in relational designs. Evidence to obtain: Enrolments are uniquely recorded without duplicate student or course entities.

Incorrect Answers

A:

Apply naming, glossary mapping and controlled definitions to important model elements. This response fits a separate situation (Teams use inconsistent definitions for status and state across logical models.), but does not resolve the stated case. The targeted response is: Model an associative enrollment entity with both relationships and enrollment attributes.

C:

Separate attributes dependent on only part of a composite key into their proper relation.

D:

Declare a single fact grain and separate or aggregate measures consistently. This response fits a separate situation (A warehouse fact table mixes one-row-per-order and one-row-per-order-line measures.), but does not resolve the stated case. The targeted response is: Model an associative enrollment entity with both relationships and enrollment attributes.

Question 135

The data program reviews the following failure: An analytics platform loads source extracts into a warehouse then performs transformations there. Which change should be prioritized?

  1. Use idempotent processing and durable identifiers with explicit delivery semantics.
  2. Apply data minimization, encryption, scoped access and deletion controls across the transfer path.
  3. Govern landing, transformation logic, lineage and compute costs in a controlled ELT workflow.
  4. Choose integration methods based on latency, consistency, volume and operational risk.

Explanation

Correct Answer

C:

Govern landing, transformation logic, lineage and compute costs in a controlled ELT workflow. ELT moves transformation into the target platform but does not remove data quality obligations. Evidence to obtain: Raw inputs and reproducible transformation outputs are traceable and validated.

Incorrect Answers

A:

Use idempotent processing and durable identifiers with explicit delivery semantics. This response fits a separate situation (An event consumer processes a payment notification twice after retry and creates duplicate ledger postings.), but does not resolve the stated case. The targeted response is: Govern landing, transformation logic, lineage and compute costs in a controlled ELT workflow.

B:

Apply data minimization, encryption, scoped access and deletion controls across the transfer path. This response fits a separate situation (A file-transfer integration includes confidential customer attributes in an unsecured staging bucket.), but does not resolve the stated case. The targeted response is: Govern landing, transformation logic, lineage and compute costs in a controlled ELT workflow.

D:

This response fits a separate situation (A daily tax report and a live fraud decision service share one nightly transfer mechanism.), but does not resolve the stated case. Choose integration methods based on latency, consistency, volume and operational risk.

Question 136

After addressing this problem, what evidence would justify closure? New business stewards do not understand how to document definitions or resolve data defects.

  1. Completed exercises demonstrate consistent definition updates and issue routing.
  2. Aged high-impact defects are escalated and recurrence decreases after verified remediation.
  3. All regions use a versioned approved term or documented qualified exception.
  4. A justified CDE register prioritizes measurable quality, ownership and controls.

Explanation

Correct Answer

A:

It tests the action: Provide role-based training and supervised examples matched to assigned stewardship duties.

Incorrect Answers

B:

Aged high-impact defects are escalated and recurrence decreases after verified remediation. This would verify a different control (Data-quality defects recur because workers close tickets without addressing causes.), not the one in the question. The required evidence is: Completed exercises demonstrate consistent definition updates and issue routing.

C:

All regions use a versioned approved term or documented qualified exception. This would verify a different control (Different regions change the meaning of a sales metric without notifying downstream consumers.), not the one in the question. The required evidence is: Completed exercises demonstrate consistent definition updates and issue routing.

D:

A justified CDE register prioritizes measurable quality, ownership and controls. This would verify a different control (A governance team treats every data field as equally critical, overwhelming its controls program.), not the one in the question. The required evidence is: Completed exercises demonstrate consistent definition updates and issue routing.

Question 137

For this situation, which combined intervention and validation MOST directly addresses the issue? A customer table identifies rows by mutable email address, causing broken relationships after updates.

  1. Action: Create a conceptual model of core business entities and relationships without implementation details. Verification: Stakeholders approve shared concepts and relationship definitions.
  2. Action: Introduce a stable key and manage mutable natural identifiers as governed attributes. Verification: Email changes leave entity identity and referencing foreign keys intact.
  3. Action: Use a common party supertype with justified person and organization subtypes. Verification: Shared identity fields are unified and subtype-specific validation is enforced.
  4. Action: Consider controlled denormalization with refresh ownership and reconciliation. Verification: Dashboard latency improves and redundant values stay consistent under updates.

Explanation

Correct Answer

B:

Action: Introduce a stable key and manage mutable natural identifiers as governed attributes. Verification: Email changes leave entity identity and referencing foreign keys intact. Both the intervention and measurable outcome are directly relevant. A stable primary key should preserve record identity across ordinary attribute changes.

Incorrect Answers

A:

This plan addresses a different situation (Business stakeholders cannot agree which things should be treated as customers, accounts or products.), not the targeted problem. Here, action and evidence must match: Action: Introduce a stable key and manage mutable natural identifiers as governed attributes.

C:

This plan addresses a different situation (A party table mixes person birthdate with organization registration number, leaving ambiguous rules.), not the targeted problem. Here, action and evidence must match: Action: Introduce a stable key and manage mutable natural identifiers as governed attributes.

D:

This plan addresses a different situation (A read-heavy dashboard suffers repeated expensive joins but operational source integrity is sound.), not the targeted problem.

Question 138

A data analyst must confirm the cause of this issue: A party table mixes person birthdate with organization registration number, leaving ambiguous rules. Which check provides the strongest diagnostic evidence?

  1. Check functional dependencies and update anomalies across enrollment data.
  2. Inspect effective windows, surrogate dimension keys and time-bound fact joins.
  3. Review DDL, foreign keys, indexes and query plans against the logical model.
  4. Inspect subtype constraints, shared keys and invalid category combinations.

Explanation

Correct Answer

D:

Inspect subtype constraints, shared keys and invalid category combinations. This test checks the relevant business and technical failure rather than assuming its cause. Subtype modeling represents common identity while preserving different business attributes. Expected control result: Shared identity fields are unified and subtype-specific validation is enforced.

Incorrect Answers

A:

Check functional dependencies and update anomalies across enrollment data. This check would investigate another issue (A composite-key enrollment table repeats course title determined by course_id alone.), not the immediate case. The direct diagnostic is: Inspect subtype constraints, shared keys and invalid category combinations.

B:

Inspect effective windows, surrogate dimension keys and time-bound fact joins. This check would investigate another issue (A customer changes region but analysts need sales under the region valid at each transaction date.), not the immediate case. The direct diagnostic is: Inspect subtype constraints, shared keys and invalid category combinations.

C:

Review DDL, foreign keys, indexes and query plans against the logical model. This check would investigate another issue (A logical model is approved but a PostgreSQL implementation needs columns and access paths.), not the immediate case. The direct diagnostic is: Inspect subtype constraints, shared keys and invalid category combinations.

Question 139

A data steward challenges an assumption in this case: Three systems record table creation dates in incompatible time zones and formats. Which verification should be performed first?

  1. Test user retrieval tasks, certification tags and obsolete dataset ranking.
  2. Trace a report row to mapping versions, key lookups and source codes.
  3. Compare timestamp serialization, timezone offsets and parsing tests.
  4. Trace one critical metric through source attributes and transformation code.

Explanation

Correct Answer

C:

Compare timestamp serialization, timezone offsets and parsing tests. This test checks the relevant business and technical failure rather than assuming its cause. Interoperable metadata requires shared representations and semantics. Expected control result: Catalog times convert consistently with time zone and source provenance retained.

Incorrect Answers

A:

Test user retrieval tasks, certification tags and obsolete dataset ranking. This check would investigate another issue (Users search for a customer dataset but see dozens of unlabeled backups ahead of certified sources.), not the immediate case. The direct diagnostic is: Compare timestamp serialization, timezone offsets and parsing tests.

B:

Trace a report row to mapping versions, key lookups and source codes. This check would investigate another issue (A risk report uses an old industry code mapping but its catalog does not record which version.), not the immediate case. The direct diagnostic is: Compare timestamp serialization, timezone offsets and parsing tests.

D:

Trace one critical metric through source attributes and transformation code. This check would investigate another issue (A compliance report is wrong but no one knows which source change introduced the value.), not the immediate case. The direct diagnostic is: Compare timestamp serialization, timezone offsets and parsing tests.

Question 140

The data program reviews the following failure: A firm builds individualized prices from personal browsing histories without meaningful customer explanation. Which change should be prioritized?

  1. Encrypt backup data using approved keys with controlled key access and recovery procedures.
  2. Assess meaningful disclosure, user expectations and controls for intrusive profiling.
  3. Grant narrow read access to approved views instead of broad administrative rights.
  4. Test subgroup outcomes, data representativeness and remediations with accountable review.

Explanation

Correct Answer

B:

Assess meaningful disclosure, user expectations and controls for intrusive profiling. Responsible data use respects agency and transparency in addition to legal minimums. Evidence to obtain: People receive intelligible information and the team records a lawful, ethical justification.

Incorrect Answers

A:

This response fits a separate situation (A backup contains confidential employee salaries and is stored without encryption controls.), but does not resolve the stated case. Encrypt backup data using approved keys with controlled key access and recovery procedures.

C:

Grant narrow read access to approved views instead of broad administrative rights. This response fits a separate situation (A BI analyst receives administrator access to production customer tables for simple reporting.), but does not resolve the stated case. The targeted response is: Assess meaningful disclosure, user expectations and controls for intrusive profiling.

D:

Test subgroup outcomes, data representativeness and remediations with accountable review. This response fits a separate situation (A credit model has similar overall accuracy but rejects an underserved population disproportionately.), but does not resolve the stated case. The targeted response is: Assess meaningful disclosure, user expectations and controls for intrusive profiling.

Data Management Fundamentals (DMF) Practice Tests