CDMP DMF Practice Test 75
Question 740
Select TWO appropriate statements, one intervention and one verification, for this data management case: Business units need local writes but also expect synchronized approved enterprise attributes.
- Verification: The consolidated view is refreshed and lineage shows each source-system contribution.
- Verification: Update conflicts are resolved under stated rules and master attributes converge.
- Action: Design coexistence MDM with controlled bidirectional synchronization and conflict handling.
- Shortcut: Allow every system to overwrite the master without conflict rules.
- Action: Model party identity separately from business roles and maintain role-specific attributes.
Explanation
Correct Answers
B:Verification: Update conflicts are resolved under stated rules and master attributes converge. The observed result demonstrates whether the correction operates as intended. Coexistence combines shared mastering with retained local application data maintenance.
C:Action: Design coexistence MDM with controlled bidirectional synchronization and conflict handling. The proposed intervention targets the reported issue. Coexistence combines shared mastering with retained local application data maintenance.
Incorrect Answers
A:Verification: The consolidated view is refreshed and lineage shows each source-system contribution. This evidence is for a separate context (A company wants a central analytical customer view while operational systems continue owning updates.), not this case. The valid outcome is: Update conflicts are resolved under stated rules and master attributes converge.
D:Shortcut: Allow every system to overwrite the master without conflict rules. This shortcut is not a sound remediation. Coexistence combines shared mastering with retained local application data maintenance. The appropriate action is: Design coexistence MDM with controlled bidirectional synchronization and conflict handling.
E:This intervention is for a different scenario (One organization can be both a supplier and customer, but systems duplicate its legal entity per role.), not the one stated. Appropriate action here: Design coexistence MDM with controlled bidirectional synchronization and conflict handling.
Question 741
A governance review considers the following: Marketing requests full birth dates for a campaign that only needs age bands. Which proposal would create an avoidable risk?
- Validate critical changes against representative positive and negative examples.
- Verify a new interface using a controlled sample and reconciliation.
- Send complete identification records because they might be useful later.
- Retain a rollback or recovery plan before making destructive data changes.
Explanation
Correct Answer
C:Send complete identification records because they might be useful later. Data minimization limits processing to what the justified purpose requires. A sound response instead: Share only derived age ranges under approved purpose and retention controls.
Incorrect Answers
A:Validate critical changes against representative positive and negative examples. Controlled tests provide more reliable proof than untested assumptions. The case-specific response is: Share only derived age ranges under approved purpose and retention controls.
B:Verify a new interface using a controlled sample and reconciliation. Testing reveals mismatches before broad deployment. The case-specific response is: Share only derived age ranges under approved purpose and retention controls.
D:Retain a rollback or recovery plan before making destructive data changes. Recoverability reduces the consequences of incorrect remediation. The case-specific response is: Share only derived age ranges under approved purpose and retention controls.
Question 742
A data steward challenges an assumption in this case: A CRM has duplicate contact records with different punctuation in their names. Which verification should be performed first?
- Test form constraints, exception permissions and downstream defect rates.
- Review normalized identity pairs and manually labeled match cases.
- Reconcile source coverage to measured records and inspect metric definitions.
- Review quality agreements, monitoring windows, breaches and corrective actions.
Explanation
Correct Answer
B:Review normalized identity pairs and manually labeled match cases. This test checks the relevant business and technical failure rather than assuming its cause. Uniqueness depends on the real-world entity being represented, not only string equality. Expected control result: Confirmed duplicate rates fall without inappropriate merges of distinct customers.
Incorrect Answers
A:Test form constraints, exception permissions and downstream defect rates. This check would investigate another issue (Bad dates are entered during onboarding and corrected only after monthly reporting failures.), not the immediate case. The direct diagnostic is: Review normalized identity pairs and manually labeled match cases.
C:Reconcile source coverage to measured records and inspect metric definitions. This check would investigate another issue (A scorecard reports 99 percent valid rows but excludes an entire failed daily feed.), not the immediate case. The direct diagnostic is: Review normalized identity pairs and manually labeled match cases.
D:Review quality agreements, monitoring windows, breaches and corrective actions. This check would investigate another issue (A shared customer dataset has no agreed defect response or availability expectations.), not the immediate case. The direct diagnostic is: Review normalized identity pairs and manually labeled match cases.
Question 743
A governance review considers the following: A financial analyst needs totals by region and quarter without modifying source orders. Which proposal would create an avoidable risk?
- Protect relevant audit records while investigating data problems.
- Respect active legal holds before scheduling record disposition.
- Document which dataset version was used in a material decision.
- Modify operational orders to make an analytical pivot table easier.
Explanation
Correct Answer
D:Modify operational orders to make an analytical pivot table easier. OLAP supports multidimensional analysis separate from OLTP transaction processing. A sound response instead: Use analytical aggregations and dimensional hierarchies rather than transactional updates.
Incorrect Answers
A:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Use analytical aggregations and dimensional hierarchies rather than transactional updates.
B:Respect active legal holds before scheduling record disposition. Preservation duties may override scheduled destruction. The case-specific response is: Use analytical aggregations and dimensional hierarchies rather than transactional updates.
C:Document which dataset version was used in a material decision. Version records support reproducible decisions. The case-specific response is: Use analytical aggregations and dimensional hierarchies rather than transactional updates.
Question 744
Before changing procedures, the team investigates: Metadata lives in individual spreadsheets that differ on owners and field meanings. Which review or test MOST directly locates the relevant failure?
- Sample owner contacts, definitions, update dates and verified accuracy.
- Compare timestamp serialization, timezone offsets and parsing tests.
- Test semantic queries, metric totals and join validity against sample facts.
- Compare repository versions, ownership changes and reconciliation logs.
Explanation
Correct Answer
D:Compare repository versions, ownership changes and reconciliation logs. This test checks the relevant business and technical failure rather than assuming its cause. A metadata repository supports shared, managed descriptions across assets. Expected control result: A single discovery workflow retrieves consistent definitions and authoritative owners.
Incorrect Answers
A:Sample owner contacts, definitions, update dates and verified accuracy. This check would investigate another issue (A catalog lists every dataset but half of its owners and descriptions are outdated.), not the immediate case. The direct diagnostic is: Compare repository versions, ownership changes and reconciliation logs.
B:Compare timestamp serialization, timezone offsets and parsing tests. This check would investigate another issue (Three systems record table creation dates in incompatible time zones and formats.), not the immediate case. The direct diagnostic is: Compare repository versions, ownership changes and reconciliation logs.
C:Test semantic queries, metric totals and join validity against sample facts. This check would investigate another issue (Reports join unrelated entities because business dimensions lack a mapped semantic model.), not the immediate case. The direct diagnostic is: Compare repository versions, ownership changes and reconciliation logs.
Question 745
Which statement best describes the governing idea behind the response to this case: A new organizational hierarchy update accidentally makes Division A the parent of itself through B.
- Preventing duplicate creation is usually cheaper than repeated downstream reconciliation.
- Golden-record construction applies business rules to conflicting source attributes.
- Master relationship governance must enforce structural integrity constraints.
- Consolidation offers a harmonized downstream master view without mandatory operational writeback.
Explanation
Correct Answer
C:Master relationship governance must enforce structural integrity constraints. This concept explains the reason for the proposed control. Appropriate intervention: Validate hierarchy acyclicity, permitted parents and effective dates before publishing.
Incorrect Answers
A:Preventing duplicate creation is usually cheaper than repeated downstream reconciliation. This is a defensible principle in another context (New customer onboarding creates a second record when spacing differs in a business name.), not the most relevant rationale here. For the stated issue: Master relationship governance must enforce structural integrity constraints.
B: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: Master relationship governance must enforce structural integrity constraints.
D:Consolidation offers a harmonized downstream master view without mandatory operational writeback. This is a defensible principle in another context (A company wants a central analytical customer view while operational systems continue owning updates.), not the most relevant rationale here. For the stated issue: Master relationship governance must enforce structural integrity constraints.
Question 746
For this situation, which combined intervention and validation MOST directly addresses the issue? A database approaches disk exhaustion during a seasonal reporting surge.
- Action: Monitor growth, plan capacity headroom and tune storage before outage. Verification: Forecasted and observed capacity stay within safe thresholds under peak workloads.
- Action: Add performance monitoring for query latency, locks, throughput and resource saturation. Verification: Alerts identify bottlenecks and response resolves tested workload degradation.
- Action: Design and test failover, client reconnection and replica consistency under representative faults. Verification: A simulated primary outage transfers service within the target and avoids unacceptable data loss.
- Action: Implement scheduled retention with legal holds, access controls and verifiable deletion. Verification: Expired eligible logs are deleted while hold-protected records remain preserved.
Explanation
Correct Answer
A:Action: Monitor growth, plan capacity headroom and tune storage before outage. Verification: Forecasted and observed capacity stay within safe thresholds under peak workloads. Both the intervention and measurable outcome are directly relevant. Storage operations need proactive capacity management, not crisis-only expansion.
Incorrect Answers
B:This plan addresses a different situation (A database service is slow but monitoring records only whether its process is up.), not the targeted problem.
C:This plan addresses a different situation (A replica exists for critical reads but failover has never been validated.), not the targeted problem. Here, action and evidence must match: Action: Monitor growth, plan capacity headroom and tune storage before outage.
D:This plan addresses a different situation (Operational logs contain sensitive identifiers beyond the allowed retention period.), not the targeted problem.
Question 747
A proposed shortcut is offered for this situation: A transformation program has diagrams but no one decides whether new platforms meet enterprise principles. Which choice is the CLEAREST mistake?
- Define the intended data population before interpreting quality percentages.
- Apply access controls proportional to the sensitivity of business information.
- Let suppliers approve their own architecture deviations without business scrutiny.
- Protect relevant audit records while investigating data problems.
Explanation
Correct Answer
C:Let suppliers approve their own architecture deviations without business scrutiny. Architecture decisions need accountability and review, not just documentation. A sound response instead: Establish an architecture review board with documented authority and exception controls.
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: Establish an architecture review board with documented authority and exception controls.
B:Apply access controls proportional to the sensitivity of business information. Confidentiality obligations still apply during quality improvements. The case-specific response is: Establish an architecture review board with documented authority and exception controls.
D:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Establish an architecture review board with documented authority and exception controls.
Question 748
Before changing procedures, the team investigates: Three regions encode country using names, ISO codes and private numeric lists. Which review or test MOST directly locates the relevant failure?
- Test write APIs, downstream propagation, identity uniqueness and failover.
- Compare regional code maps, valid-value tests and effective date handling.
- Inspect ingestion cadence, lineage and source ownership before selecting the style.
- Simulate conflicting source updates and inspect synchronization audit records.
Explanation
Correct Answer
B:Compare regional code maps, valid-value tests and effective date handling. This test checks the relevant business and technical failure rather than assuming its cause. Reference data supplies standardized allowable values rather than individual business entities. Expected control result: Country values map consistently and invalid codes fail controlled validation.
Incorrect Answers
A:Test write APIs, downstream propagation, identity uniqueness and failover. This check would investigate another issue (A new platform requires all customer master updates to occur through one governed service.), not the immediate case. The direct diagnostic is: Compare regional code maps, valid-value tests and effective date handling.
C:Inspect ingestion cadence, lineage and source ownership before selecting the style. This check would investigate another issue (A company wants a central analytical customer view while operational systems continue owning updates.), not the immediate case. The direct diagnostic is: Compare regional code maps, valid-value tests and effective date handling.
D:Simulate conflicting source updates and inspect synchronization audit records. This check would investigate another issue (Business units need local writes but also expect synchronized approved enterprise attributes.), not the immediate case. The direct diagnostic is: Compare regional code maps, valid-value tests and effective date handling.
Question 749
Which statement best describes the governing idea behind the response to this case: Several applications retain their own customer stores but need a shared identity index.
- Preventing duplicate creation is usually cheaper than repeated downstream reconciliation.
- Master-data stewardship needs business authority for accepted entity definitions.
- Golden-record construction applies business rules to conflicting source attributes.
- Registry MDM can manage identity linkage without necessarily storing all mastered attributes.
Explanation
Correct Answer
D:Registry MDM can manage identity linkage without necessarily storing all mastered attributes. This concept explains the reason for the proposed control. Appropriate intervention: Adopt a registry-style MDM where appropriate, linking identifiers without assuming data centralization.
Incorrect Answers
A:This is a defensible principle in another context (New customer onboarding creates a second record when spacing differs in a business name.), not the most relevant rationale here. For the stated issue: Registry MDM can manage identity linkage without necessarily storing all mastered attributes.
B:Master-data stewardship needs business authority for accepted entity definitions. This is a defensible principle in another context (Marketing and finance disagree on who approves supplier legal entity identifiers.), not the most relevant rationale here. For the stated issue: Registry MDM can manage identity linkage without necessarily storing all mastered attributes.
C: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.
Question 750
A reviewer asks for proof of improvement: Executives need consistent historical revenue despite frequent transactional schema changes. Which result MOST convincingly demonstrates that the control works?
- Historical reports reconcile and are insulated from irrelevant transactional changes.
- The invoice appears in the appropriate business period with reconciliation and audit history.
- Cross-mart comparisons reconcile categories for equivalent reporting periods.
- Run duration falls while incremental totals match the authoritative source.
Explanation
Correct Answer
A:It tests the action: Build governed analytical integration and conformed business measures for reporting.
Incorrect Answers
B:The invoice appears in the appropriate business period with reconciliation and audit history. This would verify a different control (A vendor invoice from last month arrives after the monthly warehouse close.), not the one in the question. The required evidence is: Historical reports reconcile and are insulated from irrelevant transactional changes.
C:Cross-mart comparisons reconcile categories for equivalent reporting periods. This would verify a different control (Finance and sales marts use different definitions of product category for the same item.), not the one in the question. The required evidence is: Historical reports reconcile and are insulated from irrelevant transactional changes.
D:Run duration falls while incremental totals match the authoritative source. This would verify a different control (A nightly warehouse load rereads the entire history and repeatedly misses its completion window.), not the one in the question. The required evidence is: Historical reports reconcile and are insulated from irrelevant transactional changes.