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 87

Question 860

A data analyst must confirm the cause of this issue: A published regulatory dashboard cannot explain why last month's total changed after a source correction. Which check provides the strongest diagnostic evidence?

  1. Check nonoverlapping effective windows and historical fact joins.
  2. Replay a prior reporting run using captured source and code versions.
  3. Simulate retry after partial failure and compare source/target completeness.
  4. Inspect dimension record count and description after controlled correction.

Explanation

Correct Answer

B:

Replay a prior reporting run using captured source and code versions. This test checks the relevant business and technical failure rather than assuming its cause. Trusted BI requires reproducible metrics and transparent revision histories. Expected control result: Auditors reproduce the original total and explain the changed figure from documented inputs.

Incorrect Answers

A:

Check nonoverlapping effective windows and historical fact joins. This check would investigate another issue (A salesperson moves territories and historical sales must remain attributed to prior territory.), not the immediate case. The direct diagnostic is: Replay a prior reporting run using captured source and code versions.

C:

Simulate retry after partial failure and compare source/target completeness. This check would investigate another issue (A nightly warehouse load rereads the entire history and repeatedly misses its completion window.), not the immediate case. The direct diagnostic is: Replay a prior reporting run using captured source and code versions.

D:

Inspect dimension record count and description after controlled correction. This check would investigate another issue (A product description contains a typo and historic analytics do not need the old spelling.), not the immediate case. The direct diagnostic is: Replay a prior reporting run using captured source and code versions.

Question 861

A governance review considers the following: An order line references a product identifier that does not exist in the product table. Which proposal would create an avoidable risk?

  1. Remove all foreign-key checks to allow broken transactions through.
  2. Protect relevant audit records while investigating data problems.
  3. Escalate material unresolved issues to an accountable business decision owner.
  4. Define the intended data population before interpreting quality percentages.

Explanation

Correct Answer

A:

Remove all foreign-key checks to allow broken transactions through. Foreign keys protect relationships between dependent and referenced entities. A sound response instead: Enforce appropriate referential integrity and define valid deletion behavior.

Incorrect Answers

B:

Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Enforce appropriate referential integrity and define valid deletion behavior.

C:

Escalate material unresolved issues to an accountable business decision owner. Accountability prevents silent acceptance of consequential risk. The case-specific response is: Enforce appropriate referential integrity and define valid deletion behavior.

D:

Define the intended data population before interpreting quality percentages. An undisclosed denominator can make strong scores misleading. The case-specific response is: Enforce appropriate referential integrity and define valid deletion behavior.

Question 862

In reviewing this data risk, select the LEAST defensible practice: Different regions change the meaning of a sales metric without notifying downstream consumers.

  1. Edit the glossary silently and leave historical dashboards unchanged.
  2. Respect active legal holds before scheduling record disposition.
  3. Validate critical changes against representative positive and negative examples.
  4. Check relevant business definitions before joining independently sourced data.

Explanation

Correct Answer

A:

Edit the glossary silently and leave historical dashboards unchanged. Governance of shared language prevents silent semantic drift. A sound response instead: Control glossary definitions and semantic changes with approval and impact analysis.

Incorrect Answers

B:

Respect active legal holds before scheduling record disposition. Preservation duties may override scheduled destruction. The case-specific response is: Control glossary definitions and semantic changes with approval and impact analysis.

C:

Validate critical changes against representative positive and negative examples. Controlled tests provide more reliable proof than untested assumptions. The case-specific response is: Control glossary definitions and semantic changes with approval and impact analysis.

D:

Check relevant business definitions before joining independently sourced data. Semantic agreements prevent incorrect cross-system correlations. The case-specific response is: Control glossary definitions and semantic changes with approval and impact analysis.

Question 863

A reviewer asks for proof of improvement: A file-transfer integration includes confidential customer attributes in an unsecured staging bucket. Which result MOST convincingly demonstrates that the control works?

  1. Staging access is restricted, audit logged and temporary files expire as approved.
  2. Raw inputs and reproducible transformation outputs are traceable and validated.
  3. Source-to-target counts and financial totals reconcile after late batches are processed.
  4. Consumer integration tests pass or the incompatible change is deliberately migrated.

Explanation

Correct Answer

A:

It tests the action: Apply data minimization, encryption, scoped access and deletion controls across the transfer path.

Incorrect Answers

B:

Raw inputs and reproducible transformation outputs are traceable and validated. This would verify a different control (An analytics platform loads source extracts into a warehouse then performs transformations there.), not the one in the question. The required evidence is: Staging access is restricted, audit logged and temporary files expire as approved.

C:

Source-to-target counts and financial totals reconcile after late batches are processed. This would verify a different control (Finance reports omit transactions because an extraction job silently skips late-arriving records.), not the one in the question. The required evidence is: Staging access is restricted, audit logged and temporary files expire as approved.

D:

Consumer integration tests pass or the incompatible change is deliberately migrated. This would verify a different control (An upstream API changes a numeric customer status code into a text value and breaks consumers.), not the one in the question. The required evidence is: Staging access is restricted, audit logged and temporary files expire as approved.

Question 864

A data steward examines this condition: A public sharing link exposes sensitive human resources documents to contractors. What concept best justifies the corrective approach?

  1. Controlled classification improves discovery and consistent handling of unstructured assets.
  2. Records need authentic contextual evidence, not just retrievable bytes.
  3. Content version management prevents superseded drafts from being mistaken for authoritative records.
  4. Content repositories require classification-based access and sharing restrictions.

Explanation

Correct Answer

D:

Content repositories require classification-based access and sharing restrictions. This concept explains the reason for the proposed control. Appropriate intervention: Apply need-to-know roles, link governance and monitored content permissions.

Incorrect Answers

A:

Controlled classification improves discovery and consistent handling of unstructured assets. This is a defensible principle in another context (A repository mixes invoices, procedures and complaints under inconsistent free-text tags.), not the most relevant rationale here. For the stated issue: Content repositories require classification-based access and sharing restrictions.

B:

This is a defensible principle in another context (An archived approval email is needed as evidence in a dispute but its author and date are missing.), not the most relevant rationale here. For the stated issue: Content repositories require classification-based access and sharing restrictions.

C:

This is a defensible principle in another context (Staff collaborate on a policy but several copied files are called final and no approved version is clear.), not the most relevant rationale here. For the stated issue: Content repositories require classification-based access and sharing restrictions.

Question 865

A governance review considers the following: An organization wants live access to distributed records without copying every source table. Which proposal would create an avoidable risk?

  1. Treat a virtual view as guaranteed fast and available when its sources are down.
  2. Inspect lineage and source context before changing a derived report.
  3. Preserve source evidence and document why any exception was approved.
  4. Document which dataset version was used in a material decision.

Explanation

Correct Answer

A:

Treat a virtual view as guaranteed fast and available when its sources are down. Virtualization reduces duplication but retains source dependence and governance costs. A sound response instead: Evaluate governed federation or virtualization with source access, query pushdown and performance limits.

Incorrect Answers

B:

Inspect lineage and source context before changing a derived report. Provenance analysis distinguishes source errors from transformations. The case-specific response is: Evaluate governed federation or virtualization with source access, query pushdown and performance limits.

C:

Preserve source evidence and document why any exception was approved. Traceability enables independent review of exceptions. The case-specific response is: Evaluate governed federation or virtualization with source access, query pushdown and performance limits.

D:

Document which dataset version was used in a material decision. Version records support reproducible decisions. The case-specific response is: Evaluate governed federation or virtualization with source access, query pushdown and performance limits.

Question 866

Before changing procedures, the team investigates: New customer onboarding creates a second record when spacing differs in a business name. Which review or test MOST directly locates the relevant failure?

  1. Test normalized names, identifiers, negative matches and manual overrides.
  2. Review attribute-level survivorship decisions and evidence for a sample of conflicts.
  3. Test match/link coverage and trace mastered fields to their actual systems of record.
  4. Compare regional code maps, valid-value tests and effective date handling.

Explanation

Correct Answer

A:

Test normalized names, identifiers, negative matches and manual overrides. This test checks the relevant business and technical failure rather than assuming its cause. Preventing duplicate creation is usually cheaper than repeated downstream reconciliation. Expected control result: Known duplicate test cases are flagged while legitimate similar companies remain distinct.

Incorrect Answers

B:

Review attribute-level survivorship decisions and evidence for a sample of conflicts. This check would investigate another issue (Two customer sources disagree about legal name after one verifies recent government ID.), not the immediate case. The direct diagnostic is: Test normalized names, identifiers, negative matches and manual overrides.

C:

Test match/link coverage and trace mastered fields to their actual systems of record. This check would investigate another issue (Several applications retain their own customer stores but need a shared identity index.), not the immediate case. The direct diagnostic is: Test normalized names, identifiers, negative matches and manual overrides.

D:

Compare regional code maps, valid-value tests and effective date handling. This check would investigate another issue (Three regions encode country using names, ISO codes and private numeric lists.), not the immediate case. The direct diagnostic is: Test normalized names, identifiers, negative matches and manual overrides.

Question 867

A governance review considers the following: A developer stores payment account numbers in a general-purpose dataset tagged public. Which proposal would create an avoidable risk?

  1. Inspect lineage and source context before changing a derived report.
  2. Assume an internal database is automatically safe for all employees.
  3. Separate short-term issue containment from durable root-cause correction.
  4. Preserve source evidence and document why any exception was approved.

Explanation

Correct Answer

B:

Assume an internal database is automatically safe for all employees. Security controls should reflect classification and sensitivity, not storage location alone. A sound response instead: Classify sensitive fields and apply controls aligned to business and regulatory risk.

Incorrect Answers

A:

Inspect lineage and source context before changing a derived report. Provenance analysis distinguishes source errors from transformations. The case-specific response is: Classify sensitive fields and apply controls aligned to business and regulatory risk.

C:

Separate short-term issue containment from durable root-cause correction. An immediate workaround rarely proves the defect cannot recur. The case-specific response is: Classify sensitive fields and apply controls aligned to business and regulatory risk.

D:

Preserve source evidence and document why any exception was approved. Traceability enables independent review of exceptions. The case-specific response is: Classify sensitive fields and apply controls aligned to business and regulatory risk.

Question 868

For this situation, which combined intervention and validation MOST directly addresses the issue? An archived approval email is needed as evidence in a dispute but its author and date are missing.

  1. Action: Classify documents and apply approved creation, review, retention, archive and disposal procedures. Verification: Records have retention schedules and disposal evidence while active holds are respected.
  2. Action: Improve indexing, controlled metadata, search relevance and authoritative-source labeling. Verification: Search tests surface the current approved procedure rather than obsolete drafts.
  3. Action: Use controlled document versioning with approval, access and supersession metadata. Verification: Users find the currently approved policy and earlier revisions remain traceable.
  4. Action: Capture records with reliable context, immutable audit metadata and preservation controls. Verification: The record shows origin, integrity, retention rule and auditable access history.

Explanation

Correct Answer

D:

Action: Capture records with reliable context, immutable audit metadata and preservation controls. Verification: The record shows origin, integrity, retention rule and auditable access history. Both the intervention and measurable outcome are directly relevant. Records need authentic contextual evidence, not just retrievable bytes.

Incorrect Answers

A:

This plan addresses a different situation (Contract PDFs are retained indefinitely after business use with no destruction rules.), not the targeted problem.

B:

This plan addresses a different situation (Employees cannot find approved procedures because files lack titles, tags and indexed text.), not the targeted problem. Here, action and evidence must match: Action: Capture records with reliable context, immutable audit metadata and preservation controls.

C:

This plan addresses a different situation (Staff collaborate on a policy but several copied files are called final and no approved version is clear.), not the targeted problem. Here, action and evidence must match: Action: Capture records with reliable context, immutable audit metadata and preservation controls.

Question 869

A reviewer asks for proof of improvement: Regional sales managers can query all customer records despite regional authorization rules. Which result MOST convincingly demonstrates that the control works?

  1. The campaign operates while recipients cannot retrieve unnecessary full dates.
  2. An authorized manager sees own-region rows and cannot access other regions.
  3. Test datasets retain required distributions while direct identifiers cannot be recovered.
  4. The analyst can perform the report but cannot alter or see unrelated sensitive records.

Explanation

Correct Answer

B:

It tests the action: Enforce row-level security using authoritative user-to-region mapping.

Incorrect Answers

A:

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: An authorized manager sees own-region rows and cannot access other regions.

C:

Test datasets retain required distributions while direct identifiers cannot be recovered. This would verify a different control (Test developers need representative orders but a test export includes real customer identity numbers.), not the one in the question. The required evidence is: An authorized manager sees own-region rows and cannot access other regions.

D:

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: An authorized manager sees own-region rows and cannot access other regions.

Question 870

A business owner identifies this issue: Users search for a customer dataset but see dozens of unlabeled backups ahead of certified sources. What is the MOST appropriate data management response?

  1. Use a governed repository or catalog with stewardship workflows and controlled synchronization.
  2. Introduce active, deprecated and archived lifecycle states with accountable approval.
  3. Improve catalog classification, search relevance and certified-asset indicators.
  4. Collect operational metadata such as run timestamps, row counts and failure states.

Explanation

Correct Answer

C:

Evidence to obtain: Representative searches surface approved datasets and disclose archival alternatives.

Incorrect Answers

A:

Use a governed repository or catalog with stewardship workflows and controlled synchronization. This response fits a separate situation (Metadata lives in individual spreadsheets that differ on owners and field meanings.), but does not resolve the stated case. The targeted response is: Improve catalog classification, search relevance and certified-asset indicators.

B:

Introduce active, deprecated and archived lifecycle states with accountable approval. This response fits a separate situation (A retired system's catalog entries remain marked active, misleading new project teams.), but does not resolve the stated case. The targeted response is: Improve catalog classification, search relevance and certified-asset indicators.

D:

Collect operational metadata such as run timestamps, row counts and failure states. This response fits a separate situation (A pipeline silently stopped after a weekend but no one tracks run status or freshness.), but does not resolve the stated case. The targeted response is: Improve catalog classification, search relevance and certified-asset indicators.

Data Management Fundamentals (DMF) Practice Tests