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 11

Question 100

Consider this data-management scenario: Test developers need representative orders but a test export includes real customer identity numbers. Which underlying principle MOST directly explains the preferred response?

  1. Secure data movement must protect confidentiality and integrity in transit.
  2. Non-production use should minimize exposure of real sensitive data.
  3. Security controls should reflect classification and sensitivity, not storage location alone.
  4. Encryption at rest reduces exposure of stored sensitive information but requires key governance.

Explanation

Correct Answer

B:

Non-production use should minimize exposure of real sensitive data. This concept explains the reason for the proposed control. Appropriate intervention: Apply governed masking or synthetic data that preserves testing requirements without exposing identities.

Incorrect Answers

A:

Secure data movement must protect confidentiality and integrity in transit. This is a defensible principle in another context (A service transfers customer attributes over unencrypted HTTP between data centers.), not the most relevant rationale here. For the stated issue: Non-production use should minimize exposure of real sensitive data.

C:

Security controls should reflect classification and sensitivity, not storage location alone. This is a defensible principle in another context (A developer stores payment account numbers in a general-purpose dataset tagged public.), not the most relevant rationale here. For the stated issue: Non-production use should minimize exposure of real sensitive data.

D:

This is a defensible principle in another context (A backup contains confidential employee salaries and is stored without encryption controls.), not the most relevant rationale here. For the stated issue: Non-production use should minimize exposure of real sensitive data.

Question 101

A reviewer asks for proof of improvement: A sales fact table mixes shipment-level and order-line-level amounts, doubling totals. Which result MOST convincingly demonstrates that the control works?

  1. Both dashboards compute equivalent values for the same period and exclusions.
  2. Sales on each date join the applicable territory history without overlap.
  3. Self-service reports use approved measures and respect data restrictions.
  4. Revenue reconciles at order, line and shipment levels without duplicated values.

Explanation

Correct Answer

D:

It tests the action: State the fact grain explicitly and separate incompatible measures or aggregate correctly.

Incorrect Answers

A:

Both dashboards compute equivalent values for the same period and exclusions. This would verify a different control (Two executive dashboards both show profit margin but use different numerator adjustments.), not the one in the question. The required evidence is: Revenue reconciles at order, line and shipment levels without duplicated values.

B:

Sales on each date join the applicable territory history without overlap. This would verify a different control (A salesperson moves territories and historical sales must remain attributed to prior territory.), not the one in the question. The required evidence is: Revenue reconciles at order, line and shipment levels without duplicated values.

C:

Self-service reports use approved measures and respect data restrictions. This would verify a different control (Citizen analysts build dashboards using tables with unknown sensitivity and ambiguous joins.), not the one in the question. The required evidence is: Revenue reconciles at order, line and shipment levels without duplicated values.

Question 102

A data steward examines this condition: A consultant rates governance mature from interview opinions without supporting operational evidence. What concept best justifies the corrective approach?

  1. Stewardship capability requires practice and accountability, not titles alone.
  2. Governed exceptions prevent informal departures from becoming permanent invisible risk.
  3. Governance issue management must address root causes and accountability.
  4. Maturity is an evidence-based view of institutionalized practices, not aspirational claims.

Explanation

Correct Answer

D:

Maturity is an evidence-based view of institutionalized practices, not aspirational claims. This concept explains the reason for the proposed control. Appropriate intervention: Assess maturity against defined capabilities with artifacts, repeatable evidence and gaps.

Incorrect Answers

A:

This is a defensible principle in another context (New business stewards do not understand how to document definitions or resolve data defects.), not the most relevant rationale here. For the stated issue: Maturity is an evidence-based view of institutionalized practices, not aspirational claims.

B:

Governed exceptions prevent informal departures from becoming permanent invisible risk. This is a defensible principle in another context (A business requests a temporary deviation from a sensitive data retention standard.), not the most relevant rationale here. For the stated issue: Maturity is an evidence-based view of institutionalized practices, not aspirational claims.

C:

Governance issue management must address root causes and accountability. This is a defensible principle in another context (Data-quality defects recur because workers close tickets without addressing causes.), not the most relevant rationale here. For the stated issue: Maturity is an evidence-based view of institutionalized practices, not aspirational claims.

Question 103

Select TWO appropriate statements, one intervention and one verification, for this data management case: A service transfers customer attributes over unencrypted HTTP between data centers.

  1. Action: Apply governed masking or synthetic data that preserves testing requirements without exposing identities.
  2. Action: Require authenticated encrypted transport using supported TLS configuration.
  3. Verification: Traffic capture reveals no plaintext sensitive fields and valid endpoint trust is enforced.
  4. Shortcut: Accept plaintext transfer because both data centers are owned by the same firm.
  5. Verification: The analyst can perform the report but cannot alter or see unrelated sensitive records.

Explanation

Correct Answers

B:

Action: Require authenticated encrypted transport using supported TLS configuration. The proposed intervention targets the reported issue. Secure data movement must protect confidentiality and integrity in transit.

C:

Verification: Traffic capture reveals no plaintext sensitive fields and valid endpoint trust is enforced. The observed result demonstrates whether the correction operates as intended. Secure data movement must protect confidentiality and integrity in transit.

Incorrect Answers

A:

Action: Apply governed masking or synthetic data that preserves testing requirements without exposing identities. This intervention is for a different scenario (Test developers need representative orders but a test export includes real customer identity numbers.), not the one stated. Appropriate action here: Require authenticated encrypted transport using supported TLS configuration.

D:

Shortcut: Accept plaintext transfer because both data centers are owned by the same firm. This shortcut is not a sound remediation. Secure data movement must protect confidentiality and integrity in transit. The appropriate action is: Require authenticated encrypted transport using supported TLS configuration.

E:

The valid outcome is: Traffic capture reveals no plaintext sensitive fields and valid endpoint trust is enforced.

Question 104

A data steward challenges an assumption in this case: A warehouse fact table mixes one-row-per-order and one-row-per-order-line measures. Which verification should be performed first?

  1. Test change propagation, stale-data exposure and measured query performance.
  2. Inspect missing-value rules and test calculations with unknown and genuine zero.
  3. Review grain statement, keys and reconciliation with source order totals.
  4. Check functional dependencies and update anomalies across enrollment data.

Explanation

Correct Answer

C:

Review grain statement, keys and reconciliation with source order totals. This test checks the relevant business and technical failure rather than assuming its cause. Dimensional modeling requires an unambiguous grain for additive measures. Expected control result: Totals reconcile without double-counting headers across line-level analysis.

Incorrect Answers

A:

Test change propagation, stale-data exposure and measured query performance. This check would investigate another issue (A read-heavy dashboard suffers repeated expensive joins but operational source integrity is sound.), not the immediate case. The direct diagnostic is: Review grain statement, keys and reconciliation with source order totals.

B:

Inspect missing-value rules and test calculations with unknown and genuine zero. This check would investigate another issue (A registration field is blank, but downstream calculations treat unknown age as zero.), not the immediate case. The direct diagnostic is: Review grain statement, keys and reconciliation with source order totals.

D:

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: Review grain statement, keys and reconciliation with source order totals.

Question 105

A data steward examines this condition: A warehouse fact table mixes one-row-per-order and one-row-per-order-line measures. What concept best justifies the corrective approach?

  1. Dimensional modeling requires an unambiguous grain for additive measures.
  2. Temporal modeling preserves time-dependent truth needed for historical analysis.
  3. Logical modeling formalizes business data structure separate from storage technology.
  4. Foreign keys protect relationships between dependent and referenced entities.

Explanation

Correct Answer

A:

Dimensional modeling requires an unambiguous grain for additive measures. This concept explains the reason for the proposed control. Appropriate intervention: Declare a single fact grain and separate or aggregate measures consistently.

Incorrect Answers

B:

This is a defensible principle in another context (A customer changes region but analysts need sales under the region valid at each transaction date.), not the most relevant rationale here. For the stated issue: Dimensional modeling requires an unambiguous grain for additive measures.

C:

Logical modeling formalizes business data structure separate from storage technology. This is a defensible principle in another context (An enterprise needs rules for customer-to-contract cardinality without choosing a database product.), not the most relevant rationale here. For the stated issue: Dimensional modeling requires an unambiguous grain for additive measures.

D:

Foreign keys protect relationships between dependent and referenced entities. This is a defensible principle in another context (An order line references a product identifier that does not exist in the product table.), not the most relevant rationale here. For the stated issue: Dimensional modeling requires an unambiguous grain for additive measures.

Question 106

Before changing procedures, the team investigates: A mobile app uses a currency-code list six months older than the payments platform. Which review or test MOST directly locates the relevant failure?

  1. Audit consumer version inventories and replay changed code mappings.
  2. Validate parent-child paths, cycle detection and period-specific aggregate totals.
  3. Compare regional code maps, valid-value tests and effective date handling.
  4. Compare reports across the change boundary with reference effective dates.

Explanation

Correct Answer

A:

Audit consumer version inventories and replay changed code mappings. This test checks the relevant business and technical failure rather than assuming its cause. Reference data consistency requires controlled publication and consumer adoption. Expected control result: Consumers use supported versions and invalid currency codes trigger clear exceptions.

Incorrect Answers

B:

Validate parent-child paths, cycle detection and period-specific aggregate totals. This check would investigate another issue (Sales cannot roll up revenue because the customer parent-child corporate hierarchy differs across reports.), not the immediate case. The direct diagnostic is: Audit consumer version inventories and replay changed code mappings.

C:

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: Audit consumer version inventories and replay changed code mappings.

D:

Compare reports across the change boundary with reference effective dates. This check would investigate another issue (A product taxonomy changes in January but last year's reports must preserve prior category assignments.), not the immediate case. The direct diagnostic is: Audit consumer version inventories and replay changed code mappings.

Question 107

A governance committee needs a defensible plan and proof: A developer stores payment account numbers in a general-purpose dataset tagged public. Which paired proposal is appropriate?

  1. Action: Enable protected access and export audit logs with appropriate retention and review. Verification: A test export captures actor, dataset, time and authorized action in immutable evidence.
  2. Action: Encrypt backup data using approved keys with controlled key access and recovery procedures. Verification: Stored backups are unreadable without authorized key access and restores succeed.
  3. Action: Classify sensitive fields and apply controls aligned to business and regulatory risk. Verification: The dataset is correctly labeled and unauthorized roles cannot read restricted attributes.
  4. Action: Enforce row-level security using authoritative user-to-region mapping. Verification: An authorized manager sees own-region rows and cannot access other regions.

Explanation

Correct Answer

C:

Action: Classify sensitive fields and apply controls aligned to business and regulatory risk. Verification: The dataset is correctly labeled and unauthorized roles cannot read restricted attributes. Both the intervention and measurable outcome are directly relevant. Security controls should reflect classification and sensitivity, not storage location alone.

Incorrect Answers

A:

This plan addresses a different situation (Privileged database exports are possible but no one records who initiated them.), not the targeted problem. Here, action and evidence must match: Action: Classify sensitive fields and apply controls aligned to business and regulatory risk.

B:

This plan addresses a different situation (A backup contains confidential employee salaries and is stored without encryption controls.), not the targeted problem. Here, action and evidence must match: Action: Classify sensitive fields and apply controls aligned to business and regulatory risk.

D:

This plan addresses a different situation (Regional sales managers can query all customer records despite regional authorization rules.), not the targeted problem. Here, action and evidence must match: Action: Classify sensitive fields and apply controls aligned to business and regulatory risk.

Question 108

An accountable team must correct this problem and prove results. Select TWO sound statements: A multinational has legal requirements to keep certain data local while enabling group analytics.

  1. Verification: The selected pattern has recorded tradeoffs and meets representative end-to-end workload tests.
  2. Action: Use a federated architecture with governed metadata and lawful cross-border access patterns.
  3. Action: Model the current and target data states and a sequenced transition roadmap.
  4. Verification: Queries respect localization constraints and approved shared views expose necessary aggregates.
  5. Shortcut: Replicate all raw personal data centrally without examining location restrictions.

Explanation

Correct Answers

B:

Action: Use a federated architecture with governed metadata and lawful cross-border access patterns. The proposed intervention targets the reported issue. Architecture must balance enterprise interoperability with local legal and operational constraints.

D:

Verification: Queries respect localization constraints and approved shared views expose necessary aggregates. The observed result demonstrates whether the correction operates as intended. Architecture must balance enterprise interoperability with local legal and operational constraints.

Incorrect Answers

A:

The valid outcome is: Queries respect localization constraints and approved shared views expose necessary aggregates.

C:

This intervention is for a different scenario (A bank intends to retire a reporting platform but has no inventory of upstream sources or dependencies.), not the one stated. Appropriate action here: Use a federated architecture with governed metadata and lawful cross-border access patterns.

E:

Shortcut: Replicate all raw personal data centrally without examining location restrictions. This shortcut is not a sound remediation. Architecture must balance enterprise interoperability with local legal and operational constraints. The appropriate action is: Use a federated architecture with governed metadata and lawful cross-border access patterns.

Question 109

Consider this organizational data problem: A team runs OCR on handwritten forms and loads extracted values directly into an account ledger. What action is most defensible?

  1. Suspend disposition for in-scope content until an authorized hold release is recorded.
  2. Implement disposition approval, hold checking and tamper-resistant destruction logs.
  3. Validate extraction confidence and route uncertain fields to authorized human review.
  4. Apply need-to-know roles, link governance and monitored content permissions.

Explanation

Correct Answer

C:

Validate extraction confidence and route uncertain fields to authorized human review. Extracted content is derived data whose accuracy and provenance require verification. Evidence to obtain: Reconciled records document original images, reviewed exceptions and corrected values.

Incorrect Answers

A:

This response fits a separate situation (An automated seven-year purge is about to remove correspondence covered by an active litigation hold.), but does not resolve the stated case. Suspend disposition for in-scope content until an authorized hold release is recorded.

B:

This response fits a separate situation (A records team says old files were deleted but cannot show what was destroyed or who authorized it.), but does not resolve the stated case. Implement disposition approval, hold checking and tamper-resistant destruction logs.

D:

Apply need-to-know roles, link governance and monitored content permissions. This response fits a separate situation (A public sharing link exposes sensitive human resources documents to contractors.), but does not resolve the stated case. The targeted response is: Validate extraction confidence and route uncertain fields to authorized human review.

Question 110

After addressing this problem, what evidence would justify closure? Marketing requests full birth dates for a campaign that only needs age bands.

  1. The campaign operates while recipients cannot retrieve unnecessary full dates.
  2. The analyst can perform the report but cannot alter or see unrelated sensitive records.
  3. Investigation records affected datasets, containment, timeline and obligations.
  4. A test export captures actor, dataset, time and authorized action in immutable evidence.

Explanation

Correct Answer

A:

It tests the action: Share only derived age ranges under approved purpose and retention controls.

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: The campaign operates while recipients cannot retrieve unnecessary full dates.

C:

Investigation records affected datasets, containment, timeline and obligations. This would verify a different control (An unauthorized service account downloads a large restricted dataset overnight.), not the one in the question. The required evidence is: The campaign operates while recipients cannot retrieve unnecessary full dates.

D:

A test export captures actor, dataset, time and authorized action in immutable evidence. This would verify a different control (Privileged database exports are possible but no one records who initiated them.), not the one in the question. The required evidence is: The campaign operates while recipients cannot retrieve unnecessary full dates.

Data Management Fundamentals (DMF) Practice Tests