CDMP DMF Practice Test 71
Question 700
A data management auditor evaluates this situation: A team plans to remove a source column that feeds several dashboards and fraud rules. Which observable finding supports successful remediation?
- Affected consumers are notified and changed logic passes compatibility tests.
- Consumers see retirement dates, replacements and appropriate access warnings.
- Risk report runs identify applicable mapping versions and affected records.
- Ingestion validation matches recorded technical structures and flags incompatible changes.
Explanation
Correct Answer
A:It tests the action: Use dependency lineage to assess downstream impact and coordinate migration.
Incorrect Answers
B:Consumers see retirement dates, replacements and appropriate access warnings. This would verify a different control (A retired system's catalog entries remain marked active, misleading new project teams.), not the one in the question. The required evidence is: Affected consumers are notified and changed logic passes compatibility tests.
C:Risk report runs identify applicable mapping versions and affected records. This would verify a different control (A risk report uses an old industry code mapping but its catalog does not record which version.), not the one in the question. The required evidence is: Affected consumers are notified and changed logic passes compatibility tests.
D:Ingestion validation matches recorded technical structures and flags incompatible changes. This would verify a different control (A data engineering team cannot determine the format and schema of a nightly inbound file.), not the one in the question. The required evidence is: Affected consumers are notified and changed logic passes compatibility tests.
Question 701
Select TWO appropriate statements, one intervention and one verification, for this data management case: Test developers need representative orders but a test export includes real customer identity numbers.
- Action: Grant narrow read access to approved views instead of broad administrative rights.
- Action: Apply governed masking or synthetic data that preserves testing requirements without exposing identities.
- Shortcut: Copy production personally identifiable information unchanged to every sandbox.
- Verification: Test datasets retain required distributions while direct identifiers cannot be recovered.
- Verification: An authorized manager sees own-region rows and cannot access other regions.
Explanation
Correct Answers
B:Action: Apply governed masking or synthetic data that preserves testing requirements without exposing identities. The proposed intervention targets the reported issue. Non-production use should minimize exposure of real sensitive data.
D:Verification: Test datasets retain required distributions while direct identifiers cannot be recovered. The observed result demonstrates whether the correction operates as intended. Non-production use should minimize exposure of real sensitive data.
Incorrect Answers
A:This intervention is for a different scenario (A BI analyst receives administrator access to production customer tables for simple reporting.), not the one stated.
C:Shortcut: Copy production personally identifiable information unchanged to every sandbox. This shortcut is not a sound remediation. Non-production use should minimize exposure of real sensitive data. The appropriate action is: Apply governed masking or synthetic data that preserves testing requirements without exposing identities.
E:Verification: An authorized manager sees own-region rows and cannot access other regions. This evidence is for a separate context (Regional sales managers can query all customer records despite regional authorization rules.), not this case. The valid outcome is: Test datasets retain required distributions while direct identifiers cannot be recovered.
Question 702
A governance review considers the following: An upstream API changes a numeric customer status code into a text value and breaks consumers. Which proposal would create an avoidable risk?
- Retain a rollback or recovery plan before making destructive data changes.
- Release a breaking payload change without informing consuming teams.
- Respect active legal holds before scheduling record disposition.
- Inspect lineage and source context before changing a derived report.
Explanation
Correct Answer
B:A sound response instead: Establish a versioned API contract and compatibility tests before deploying breaking changes.
Incorrect Answers
A:Retain a rollback or recovery plan before making destructive data changes. Recoverability reduces the consequences of incorrect remediation. The case-specific response is: Establish a versioned API contract and compatibility tests before deploying breaking changes.
C:Respect active legal holds before scheduling record disposition. Preservation duties may override scheduled destruction. The case-specific response is: Establish a versioned API contract and compatibility tests before deploying breaking changes.
D:Inspect lineage and source context before changing a derived report. Provenance analysis distinguishes source errors from transformations. The case-specific response is: Establish a versioned API contract and compatibility tests before deploying breaking changes.
Question 703
For this situation, which combined intervention and validation MOST directly addresses the issue? A daily tax report and a live fraud decision service share one nightly transfer mechanism.
- Action: Add completeness reconciliation, lateness handling and replay controls to the ETL pipeline. Verification: Source-to-target counts and financial totals reconcile after late batches are processed.
- Action: Use change data capture with durable offsets, ordering assumptions and replay handling. Verification: Changed rows propagate with acceptable lag and no missing or duplicate business effects.
- Action: Apply data minimization, encryption, scoped access and deletion controls across the transfer path. Verification: Staging access is restricted, audit logged and temporary files expire as approved.
- Action: Choose integration methods based on latency, consistency, volume and operational risk. Verification: The fraud service receives timely events while tax reporting reconciles its complete batch.
Explanation
Correct Answer
D:Action: Choose integration methods based on latency, consistency, volume and operational risk. Verification: The fraud service receives timely events while tax reporting reconciles its complete batch. Both the intervention and measurable outcome are directly relevant. Batch, messaging and service APIs meet different business service levels.
Incorrect Answers
A:This plan addresses a different situation (Finance reports omit transactions because an extraction job silently skips late-arriving records.), not the targeted problem. Here, action and evidence must match: Action: Choose integration methods based on latency, consistency, volume and operational risk.
B:This plan addresses a different situation (A customer platform needs low-latency updates without repeatedly scanning entire operational tables.), not the targeted problem. Here, action and evidence must match: Action: Choose integration methods based on latency, consistency, volume and operational risk.
C:This plan addresses a different situation (A file-transfer integration includes confidential customer attributes in an unsecured staging bucket.), not the targeted problem. Here, action and evidence must match: Action: Choose integration methods based on latency, consistency, volume and operational risk.
Question 704
A reviewer asks for proof of improvement: A firm builds individualized prices from personal browsing histories without meaningful customer explanation. Which result MOST convincingly demonstrates that the control works?
- Stored backups are unreadable without authorized key access and restores succeed.
- The dataset is correctly labeled and unauthorized roles cannot read restricted attributes.
- People receive intelligible information and the team records a lawful, ethical justification.
- A test export captures actor, dataset, time and authorized action in immutable evidence.
Explanation
Correct Answer
C:It tests the action: Assess meaningful disclosure, user expectations and controls for intrusive profiling.
Incorrect Answers
A:Stored backups are unreadable without authorized key access and restores succeed. This would verify a different control (A backup contains confidential employee salaries and is stored without encryption controls.), not the one in the question. The required evidence is: People receive intelligible information and the team records a lawful, ethical justification.
B: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: People receive intelligible information and the team records a lawful, ethical justification.
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: People receive intelligible information and the team records a lawful, ethical justification.
Question 705
Which statement best describes the governing idea behind the response to this case: A governance team treats every data field as equally critical, overwhelming its controls program.
- Governance operating models balance local agility with cross-enterprise consistency.
- A governance program needs achievable adoption and sustainable operating capacity.
- Critical data designation should target elements whose failure materially affects outcomes.
- Governed exceptions prevent informal departures from becoming permanent invisible risk.
Explanation
Correct Answer
C:Critical data designation should target elements whose failure materially affects outcomes. This concept explains the reason for the proposed control. Appropriate intervention: Identify critical data elements according to material reporting, operational and risk impact.
Incorrect Answers
A:Governance operating models balance local agility with cross-enterprise consistency. This is a defensible principle in another context (A federated enterprise wants local stewards but must preserve consistent enterprise rules.), not the most relevant rationale here. For the stated issue: Critical data designation should target elements whose failure materially affects outcomes.
B:This is a defensible principle in another context (A new governance office attempts simultaneous enterprise rollout with no prioritization or adoption plan.), not the most relevant rationale here.
D: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: Critical data designation should target elements whose failure materially affects outcomes.
Question 706
In reviewing this data risk, select the LEAST defensible practice: A customer platform needs low-latency updates without repeatedly scanning entire operational tables.
- Define the intended data population before interpreting quality percentages.
- Check that the proposed procedure has an identified operator and approval path.
- Preserve source evidence and document why any exception was approved.
- Ignore log retention and restart consumers from arbitrary offsets without reconciliation.
Explanation
Correct Answer
D:Ignore log retention and restart consumers from arbitrary offsets without reconciliation. CDC depends on correct change ordering and consumption state across failures. A sound response instead: Use change data capture with durable offsets, ordering assumptions and replay handling.
Incorrect Answers
A:Define the intended data population before interpreting quality percentages. An undisclosed denominator can make strong scores misleading. The case-specific response is: Use change data capture with durable offsets, ordering assumptions and replay handling.
B:Check that the proposed procedure has an identified operator and approval path. Operational responsibility prevents undocumented workarounds. The case-specific response is: Use change data capture with durable offsets, ordering assumptions and replay handling.
C:Preserve source evidence and document why any exception was approved. Traceability enables independent review of exceptions. The case-specific response is: Use change data capture with durable offsets, ordering assumptions and replay handling.
Question 707
A data management auditor evaluates this situation: A vendor invoice from last month arrives after the monthly warehouse close. Which observable finding supports successful remediation?
- Both dashboards compute equivalent values for the same period and exclusions.
- Self-service reports use approved measures and respect data restrictions.
- Historical reports reconcile and are insulated from irrelevant transactional changes.
- The invoice appears in the appropriate business period with reconciliation and audit history.
Explanation
Correct Answer
D:It tests the action: Apply late-arrival processing with date-correct attribution and controlled restatement if needed.
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: The invoice appears in the appropriate business period with reconciliation and audit history.
B: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: The invoice appears in the appropriate business period with reconciliation and audit history.
C:Historical reports reconcile and are insulated from irrelevant transactional changes. This would verify a different control (Executives need consistent historical revenue despite frequent transactional schema changes.), not the one in the question. The required evidence is: The invoice appears in the appropriate business period with reconciliation and audit history.
Question 708
In reviewing this data risk, select the LEAST defensible practice: Several applications retain their own customer stores but need a shared identity index.
- Monitor control outcomes after deployment rather than relying only on design intent.
- Claim a registry solution automatically cleans every source record.
- Document which dataset version was used in a material decision.
- Separate short-term issue containment from durable root-cause correction.
Explanation
Correct Answer
B:Claim a registry solution automatically cleans every source record. Registry MDM can manage identity linkage without necessarily storing all mastered attributes. A sound response instead: Adopt a registry-style MDM where appropriate, linking identifiers without assuming data centralization.
Incorrect Answers
A:Monitor control outcomes after deployment rather than relying only on design intent. Operations need evidence that a planned control actually works. The case-specific response is: Adopt a registry-style MDM where appropriate, linking identifiers without assuming data centralization.
C:Document which dataset version was used in a material decision. Version records support reproducible decisions. The case-specific response is: Adopt a registry-style MDM where appropriate, linking identifiers without assuming data centralization.
D:Separate short-term issue containment from durable root-cause correction. An immediate workaround rarely proves the defect cannot recur. The case-specific response is: Adopt a registry-style MDM where appropriate, linking identifiers without assuming data centralization.
Question 709
Consider this data-management scenario: A company wants a central analytical customer view while operational systems continue owning updates. Which underlying principle MOST directly explains the preferred response?
- Golden-record construction applies business rules to conflicting source attributes.
- Centralized mastering makes the hub the system of entry for core entity changes.
- Consolidation offers a harmonized downstream master view without mandatory operational writeback.
- Master data management provides consistent core business entity views across systems.
Explanation
Correct Answer
C:Consolidation offers a harmonized downstream master view without mandatory operational writeback. This concept explains the reason for the proposed control. Appropriate intervention: Choose a consolidation MDM approach with governed ingestion and survivorship.
Incorrect Answers
A:Golden-record construction applies business rules to conflicting source attributes. This is a defensible principle in another context (Two customer sources disagree about legal name after one verifies recent government ID.), not the most relevant rationale here. For the stated issue: Consolidation offers a harmonized downstream master view without mandatory operational writeback.
B:This is a defensible principle in another context (A new platform requires all customer master updates to occur through one governed service.), not the most relevant rationale here. For the stated issue: Consolidation offers a harmonized downstream master view without mandatory operational writeback.
D:This is a defensible principle in another context (Retail and service systems each assign different IDs to the same real-world customer.), not the most relevant rationale here. For the stated issue: Consolidation offers a harmonized downstream master view without mandatory operational writeback.
Question 710
A data analyst must confirm the cause of this issue: Finance and sales marts use different definitions of product category for the same item. Which check provides the strongest diagnostic evidence?
- Compare dimension key mapping and category labels across marts.
- Inspect dimension record count and description after controlled correction.
- Recompute representative totals using source currency, rates and period.
- Trace sample source facts through grain rules to report totals.
Explanation
Correct Answer
A:Compare dimension key mapping and category labels across marts. This test checks the relevant business and technical failure rather than assuming its cause. Conformed dimensions enable consistent analyses across multiple facts and marts. Expected control result: Cross-mart comparisons reconcile categories for equivalent reporting periods.
Incorrect Answers
B: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: Compare dimension key mapping and category labels across marts.
C:Recompute representative totals using source currency, rates and period. This check would investigate another issue (A dashboard shows revenue increasing sharply because source currency values are mixed without conversion.), not the immediate case. The direct diagnostic is: Compare dimension key mapping and category labels across marts.
D:Trace sample source facts through grain rules to report totals. This check would investigate another issue (A sales fact table mixes shipment-level and order-line-level amounts, doubling totals.), not the immediate case. The direct diagnostic is: Compare dimension key mapping and category labels across marts.