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 80

Question 790

A data analyst must confirm the cause of this issue: A developer stores payment account numbers in a general-purpose dataset tagged public. Which check provides the strongest diagnostic evidence?

  1. Test different identities through both dashboards and direct data access paths.
  2. Test role grants with allowed reporting and prohibited update queries.
  3. Inspect classification lineage, access grants and unauthorized read attempts.
  4. Inspect storage encryption status, key access logs and a restoration test.

Explanation

Correct Answer

C:

Inspect classification lineage, access grants and unauthorized read attempts. This test checks the relevant business and technical failure rather than assuming its cause. Security controls should reflect classification and sensitivity, not storage location alone. Expected control result: The dataset is correctly labeled and unauthorized roles cannot read restricted attributes.

Incorrect Answers

A:

Test different identities through both dashboards and direct data access paths. This check would investigate another issue (Regional sales managers can query all customer records despite regional authorization rules.), not the immediate case. The direct diagnostic is: Inspect classification lineage, access grants and unauthorized read attempts.

B:

Test role grants with allowed reporting and prohibited update queries. This check would investigate another issue (A BI analyst receives administrator access to production customer tables for simple reporting.), not the immediate case. The direct diagnostic is: Inspect classification lineage, access grants and unauthorized read attempts.

D:

Inspect storage encryption status, key access logs and a restoration test. This check would investigate another issue (A backup contains confidential employee salaries and is stored without encryption controls.), not the immediate case. The direct diagnostic is: Inspect classification lineage, access grants and unauthorized read attempts.

Question 791

A data steward examines this condition: A financial analyst needs totals by region and quarter without modifying source orders. What concept best justifies the corrective approach?

  1. Type 1 slowly changing dimensions replace values when historical changes are unnecessary.
  2. OLAP supports multidimensional analysis separate from OLTP transaction processing.
  3. Conformed dimensions enable consistent analyses across multiple facts and marts.
  4. Incremental loads reduce cost but depend on correct change tracking and recovery.

Explanation

Correct Answer

B:

OLAP supports multidimensional analysis separate from OLTP transaction processing. This concept explains the reason for the proposed control. Appropriate intervention: Use analytical aggregations and dimensional hierarchies rather than transactional updates.

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: OLAP supports multidimensional analysis separate from OLTP transaction processing.

C:

Conformed dimensions enable consistent analyses across multiple facts and marts. This is a defensible principle in another context (Finance and sales marts use different definitions of product category for the same item.), not the most relevant rationale here. For the stated issue: OLAP supports multidimensional analysis separate from OLTP transaction processing.

D:

This is a defensible principle in another context (A nightly warehouse load rereads the entire history and repeatedly misses its completion window.), not the most relevant rationale here. For the stated issue: OLAP supports multidimensional analysis separate from OLTP transaction processing.

Question 792

A reviewer asks for proof of improvement: A backup contains confidential employee salaries and is stored without encryption controls. Which result MOST convincingly demonstrates that the control works?

  1. Test datasets retain required distributions while direct identifiers cannot be recovered.
  2. Stored backups are unreadable without authorized key access and restores succeed.
  3. Investigation records affected datasets, containment, timeline and obligations.
  4. Traffic capture reveals no plaintext sensitive fields and valid endpoint trust is enforced.

Explanation

Correct Answer

B:

It tests the action: Encrypt backup data using approved keys with controlled key access and recovery procedures.

Incorrect Answers

A:

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: Stored backups are unreadable without authorized key access and restores succeed.

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: Stored backups are unreadable without authorized key access and restores succeed.

D:

Traffic capture reveals no plaintext sensitive fields and valid endpoint trust is enforced. This would verify a different control (A service transfers customer attributes over unencrypted HTTP between data centers.), not the one in the question. The required evidence is: Stored backups are unreadable without authorized key access and restores succeed.

Question 793

A business owner identifies this issue: A service transfers customer attributes over unencrypted HTTP between data centers. What is the MOST appropriate data management response?

  1. Require authenticated encrypted transport using supported TLS configuration.
  2. Grant narrow read access to approved views instead of broad administrative rights.
  3. Enforce row-level security using authoritative user-to-region mapping.
  4. Share only derived age ranges under approved purpose and retention controls.

Explanation

Correct Answer

A:

Require authenticated encrypted transport using supported TLS configuration. Secure data movement must protect confidentiality and integrity in transit. Evidence to obtain: Traffic capture reveals no plaintext sensitive fields and valid endpoint trust is enforced.

Incorrect Answers

B:

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: Require authenticated encrypted transport using supported TLS configuration.

C:

Enforce row-level security using authoritative user-to-region mapping. This response fits a separate situation (Regional sales managers can query all customer records despite regional authorization rules.), but does not resolve the stated case. The targeted response is: Require authenticated encrypted transport using supported TLS configuration.

D:

Share only derived age ranges under approved purpose and retention controls. This response fits a separate situation (Marketing requests full birth dates for a campaign that only needs age bands.), but does not resolve the stated case. The targeted response is: Require authenticated encrypted transport using supported TLS configuration.

Question 794

After addressing this problem, what evidence would justify closure? Finance reports omit transactions because an extraction job silently skips late-arriving records.

  1. The fraud service receives timely events while tax reporting reconciles its complete batch.
  2. Translated identifiers reconcile across both systems and erroneous mappings are detected.
  3. Source-to-target counts and financial totals reconcile after late batches are processed.
  4. Staging access is restricted, audit logged and temporary files expire as approved.

Explanation

Correct Answer

C:

It tests the action: Add completeness reconciliation, lateness handling and replay controls to the ETL pipeline.

Incorrect Answers

A:

The fraud service receives timely events while tax reporting reconciles its complete batch. This would verify a different control (A daily tax report and a live fraud decision service share one nightly transfer mechanism.), not the one in the question. The required evidence is: Source-to-target counts and financial totals reconcile after late batches are processed.

B:

Translated identifiers reconcile across both systems and erroneous mappings are detected. This would verify a different control (One interface calls a field supplier_id while another calls it vendor_code with different identifier rules.), not the one in the question. The required evidence is: Source-to-target counts and financial totals reconcile after late batches are processed.

D:

Staging access is restricted, audit logged and temporary files expire as approved. This would verify a different control (A file-transfer integration includes confidential customer attributes in an unsecured staging bucket.), not the one in the question. The required evidence is: Source-to-target counts and financial totals reconcile after late batches are processed.

Question 795

A governance review considers the following: A database approaches disk exhaustion during a seasonal reporting surge. Which proposal would create an avoidable risk?

  1. Document which dataset version was used in a material decision.
  2. Apply access controls proportional to the sensitivity of business information.
  3. Wait until filesystems are completely full to request more storage.
  4. Retain a rollback or recovery plan before making destructive data changes.

Explanation

Correct Answer

C:

Wait until filesystems are completely full to request more storage. Storage operations need proactive capacity management, not crisis-only expansion. A sound response instead: Monitor growth, plan capacity headroom and tune storage before outage.

Incorrect Answers

A:

Document which dataset version was used in a material decision. Version records support reproducible decisions. The case-specific response is: Monitor growth, plan capacity headroom and tune storage before outage.

B:

Apply access controls proportional to the sensitivity of business information. Confidentiality obligations still apply during quality improvements. The case-specific response is: Monitor growth, plan capacity headroom and tune storage before outage.

D:

Retain a rollback or recovery plan before making destructive data changes. Recoverability reduces the consequences of incorrect remediation. The case-specific response is: Monitor growth, plan capacity headroom and tune storage before outage.

Question 796

Select TWO appropriate statements, one intervention and one verification, for this data management case: A dataset is copied into three systems and each team claims another group owns quality.

  1. Verification: The ownership matrix identifies decision rights and contractual handoffs for each critical field.
  2. Action: Establish audience-specific data literacy guidance and approved metric interpretation.
  3. Shortcut: Make every team responsible for everything with no designated accountable owner.
  4. Action: Define authoritative source and attribute-level ownership for producers and consumers.
  5. Verification: A reproducible score references controls, owners and improvement actions.

Explanation

Correct Answers

A:

Verification: The ownership matrix identifies decision rights and contractual handoffs for each critical field. The observed result demonstrates whether the correction operates as intended. Data accountability must remain clear when information crosses system boundaries.

D:

Action: Define authoritative source and attribute-level ownership for producers and consumers. The proposed intervention targets the reported issue. Data accountability must remain clear when information crosses system boundaries.

Incorrect Answers

B:

Action: Establish audience-specific data literacy guidance and approved metric interpretation. This intervention is for a different scenario (Executives regularly misinterpret dashboards because they confuse current records with historical cohorts.), not the one stated. Appropriate action here: Define authoritative source and attribute-level ownership for producers and consumers.

C:

Shortcut: Make every team responsible for everything with no designated accountable owner. This shortcut is not a sound remediation. Data accountability must remain clear when information crosses system boundaries. The appropriate action is: Define authoritative source and attribute-level ownership for producers and consumers.

E:

Verification: A reproducible score references controls, owners and improvement actions. This evidence is for a separate context (A consultant rates governance mature from interview opinions without supporting operational evidence.), not this case. The valid outcome is: The ownership matrix identifies decision rights and contractual handoffs for each critical field.

Question 797

A data steward examines this condition: Executives regularly misinterpret dashboards because they confuse current records with historical cohorts. What concept best justifies the corrective approach?

  1. Data governance establishes authority and accountability for data decisions.
  2. Governance includes enabling informed use of data, not merely producing datasets.
  3. Enterprise governance needs a forum for conflicting priorities with explicit authority.
  4. Technology enables governance but cannot replace business authority and decisions.

Explanation

Correct Answer

B:

This concept explains the reason for the proposed control. Appropriate intervention: Establish audience-specific data literacy guidance and approved metric interpretation.

Incorrect Answers

A:

This is a defensible principle in another context (Two departments disagree about the authoritative definition of an active customer and neither can decide.), not the most relevant rationale here. Data governance establishes authority and accountability for data decisions.

C:

This is a defensible principle in another context (Customer and finance functions cannot agree on shared priority data rules.), not the most relevant rationale here. Enterprise governance needs a forum for conflicting priorities with explicit authority.

D:

This is a defensible principle in another context (A catalog tool identifies data owners but cannot force them to decide disputed definitions.), not the most relevant rationale here. Technology enables governance but cannot replace business authority and decisions.

Question 798

Consider this data-management scenario: Staff collaborate on a policy but several copied files are called final and no approved version is clear. Which underlying principle MOST directly explains the preferred response?

  1. Content version management prevents superseded drafts from being mistaken for authoritative records.
  2. Records need authentic contextual evidence, not just retrievable bytes.
  3. Extracted content is derived data whose accuracy and provenance require verification.
  4. Controlled classification improves discovery and consistent handling of unstructured assets.

Explanation

Correct Answer

A:

Content version management prevents superseded drafts from being mistaken for authoritative records. This concept explains the reason for the proposed control. Appropriate intervention: Use controlled document versioning with approval, access and supersession metadata.

Incorrect Answers

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 version management prevents superseded drafts from being mistaken for authoritative records.

C:

This is a defensible principle in another context (A team runs OCR on handwritten forms and loads extracted values directly into an account ledger.), not the most relevant rationale here. For the stated issue: Content version management prevents superseded drafts from being mistaken for authoritative records.

D:

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 version management prevents superseded drafts from being mistaken for authoritative records.

Question 799

Before changing procedures, the team investigates: A sales fact table mixes shipment-level and order-line-level amounts, doubling totals. Which review or test MOST directly locates the relevant failure?

  1. Inspect invoice event date, load watermark and restated monthly totals.
  2. Replay a prior reporting run using captured source and code versions.
  3. Review historical fact loads, source reconciliation and business metric conformance.
  4. Trace sample source facts through grain rules to report totals.

Explanation

Correct Answer

D:

Trace sample source facts through grain rules to report totals. This test checks the relevant business and technical failure rather than assuming its cause. A consistent fact grain is required for correct dimensional aggregation. Expected control result: Revenue reconciles at order, line and shipment levels without duplicated values.

Incorrect Answers

A:

Inspect invoice event date, load watermark and restated monthly totals. This check would investigate another issue (A vendor invoice from last month arrives after the monthly warehouse close.), not the immediate case. The direct diagnostic is: Trace sample source facts through grain rules to report totals.

B:

Replay a prior reporting run using captured source and code versions. This check would investigate another issue (A published regulatory dashboard cannot explain why last month's total changed after a source correction.), not the immediate case. The direct diagnostic is: Trace sample source facts through grain rules to report totals.

C:

Review historical fact loads, source reconciliation and business metric conformance. This check would investigate another issue (Executives need consistent historical revenue despite frequent transactional schema changes.), not the immediate case. The direct diagnostic is: Trace sample source facts through grain rules to report totals.

Question 800

For the following case select THREE defensible statements covering correction, reason and proof: A composite-key enrollment table repeats course title determined by course_id alone.

  1. Verification: Renaming a department updates one authoritative record without conflicting employee copies.
  2. Shortcut: Keep title copied per enrollment and accept contradictory updates.
  3. Principle: Second normal form removes partial dependencies on composite candidate keys.
  4. Action: Model an associative enrollment entity with both relationships and enrollment attributes.
  5. Action: Separate attributes dependent on only part of a composite key into their proper relation.
  6. Verification: Course title updates occur once and enrollment rows retain correct course links.

Explanation

Correct Answers

C:

Principle: Second normal form removes partial dependencies on composite candidate keys. This is the governing concept explaining the selected correction and expected outcome.

E:

Action: Separate attributes dependent on only part of a composite key into their proper relation. The proposed intervention targets the reported issue. Second normal form removes partial dependencies on composite candidate keys.

F:

Verification: Course title updates occur once and enrollment rows retain correct course links. The observed result demonstrates whether the correction operates as intended. Second normal form removes partial dependencies on composite candidate keys.

Incorrect Answers

A:

Verification: Renaming a department updates one authoritative record without conflicting employee copies. This evidence is for a separate context (An employee table stores department name determined by department_id, causing inconsistent renames.), not this case. The valid outcome is: Course title updates occur once and enrollment rows retain correct course links.

B:

Shortcut: Keep title copied per enrollment and accept contradictory updates. This shortcut is not a sound remediation. Second normal form removes partial dependencies on composite candidate keys. The appropriate action is: Separate attributes dependent on only part of a composite key into their proper relation.

D:

This intervention is for a different scenario (A student can enroll in many courses and a course can enroll many students.), not the one stated.

Data Management Fundamentals (DMF) Practice Tests