CDMP DMF Practice Test 74
Question 730
An accountable team must correct this problem and prove results. Select TWO sound statements: Loan applications often omit annual income even though policy requires it for underwriting.
- Action: Publish reusable data-quality rules with owners, thresholds and exceptions.
- Shortcut: Call the application complete when an optional comments box has any text.
- Verification: The proportion of applications with credible required income rises under a defined rule.
- Action: Measure required-field completeness and introduce appropriate collection checkpoints.
- Verification: Every accepted line references a valid invoice or has an owned exception.
Explanation
Correct Answers
C:Verification: The proportion of applications with credible required income rises under a defined rule. The observed result demonstrates whether the correction operates as intended. Completeness measures presence of required information for a defined purpose.
D:Action: Measure required-field completeness and introduce appropriate collection checkpoints. The proposed intervention targets the reported issue. Completeness measures presence of required information for a defined purpose.
Incorrect Answers
A:Action: Publish reusable data-quality rules with owners, thresholds and exceptions. This intervention is for a different scenario (Different pipelines enforce different allowable values for the same governed country field.), not the one stated. Appropriate action here: Measure required-field completeness and introduce appropriate collection checkpoints.
B:Shortcut: Call the application complete when an optional comments box has any text. This shortcut is not a sound remediation. Completeness measures presence of required information for a defined purpose. The appropriate action is: Measure required-field completeness and introduce appropriate collection checkpoints.
E:This evidence is for a separate context (An invoice line appears without an invoice header after a partial load.), not this case.
Question 731
The data management team encounters this situation: A sales fact table mixes shipment-level and order-line-level amounts, doubling totals. Which intervention BEST addresses the actual problem?
- Publish a conformed product dimension with agreed business categories and history rules.
- Provide certified datasets, semantic layer guidance and role-based BI access.
- Use Type 2 dimension rows with effective dates, surrogate keys and validity checks.
- State the fact grain explicitly and separate incompatible measures or aggregate correctly.
Explanation
Correct Answer
D:State the fact grain explicitly and separate incompatible measures or aggregate correctly. A consistent fact grain is required for correct dimensional aggregation. Evidence to obtain: Revenue reconciles at order, line and shipment levels without duplicated values.
Incorrect Answers
A:Publish a conformed product dimension with agreed business categories and history rules. This response fits a separate situation (Finance and sales marts use different definitions of product category for the same item.), but does not resolve the stated case. The targeted response is: State the fact grain explicitly and separate incompatible measures or aggregate correctly.
B:Provide certified datasets, semantic layer guidance and role-based BI access. This response fits a separate situation (Citizen analysts build dashboards using tables with unknown sensitivity and ambiguous joins.), but does not resolve the stated case. The targeted response is: State the fact grain explicitly and separate incompatible measures or aggregate correctly.
C:Use Type 2 dimension rows with effective dates, surrogate keys and validity checks. This response fits a separate situation (A salesperson moves territories and historical sales must remain attributed to prior territory.), but does not resolve the stated case. The targeted response is: State the fact grain explicitly and separate incompatible measures or aggregate correctly.
Question 732
A proposed shortcut is offered for this situation: A consultant rates governance mature from interview opinions without supporting operational evidence. Which choice is the CLEAREST mistake?
- Apply access controls proportional to the sensitivity of business information.
- Assign top maturity ratings simply because a policy PDF exists.
- Retain a rollback or recovery plan before making destructive data changes.
- Protect relevant audit records while investigating data problems.
Explanation
Correct Answer
B:Assign top maturity ratings simply because a policy PDF exists. Maturity is an evidence-based view of institutionalized practices, not aspirational claims. A sound response instead: Assess maturity against defined capabilities with artifacts, repeatable evidence and gaps.
Incorrect Answers
A:Apply access controls proportional to the sensitivity of business information. Confidentiality obligations still apply during quality improvements. The case-specific response is: Assess maturity against defined capabilities with artifacts, repeatable evidence and gaps.
C:Retain a rollback or recovery plan before making destructive data changes. Recoverability reduces the consequences of incorrect remediation. The case-specific response is: Assess maturity against defined capabilities with artifacts, repeatable evidence and gaps.
D:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Assess maturity against defined capabilities with artifacts, repeatable evidence and gaps.
Question 733
The data management team encounters this situation: A product data owner expects the data steward to set commercial policy unilaterally. Which intervention BEST addresses the actual problem?
- Separate accountable owner decisions from stewardship coordination and operational execution.
- Provide role-based training and supervised examples matched to assigned stewardship duties.
- Assign policy decision rights to a business data owner with steward-led coordination.
- Identify critical data elements according to material reporting, operational and risk impact.
Explanation
Correct Answer
A:Separate accountable owner decisions from stewardship coordination and operational execution. Owners are accountable for business decisions while stewards coordinate data management practice. Evidence to obtain: Role descriptions and approvals reflect owner authority and steward implementation.
Incorrect Answers
B:Provide role-based training and supervised examples matched to assigned stewardship duties. This response fits a separate situation (New business stewards do not understand how to document definitions or resolve data defects.), but does not resolve the stated case. The targeted response is: Separate accountable owner decisions from stewardship coordination and operational execution.
C:Assign policy decision rights to a business data owner with steward-led coordination. This response fits a separate situation (Two departments disagree about the authoritative definition of an active customer and neither can decide.), but does not resolve the stated case. The targeted response is: Separate accountable owner decisions from stewardship coordination and operational execution.
D:Identify critical data elements according to material reporting, operational and risk impact. This response fits a separate situation (A governance team treats every data field as equally critical, overwhelming its controls program.), but does not resolve the stated case. The targeted response is: Separate accountable owner decisions from stewardship coordination and operational execution.
Question 734
A data steward examines this condition: The customer's tier is gold in billing but silver in the loyalty platform on the same date. What concept best justifies the corrective approach?
- Consistency is agreement across representations under comparable meaning and time.
- Data-quality issue processes should prioritize consequential defects and accountable response.
- A quality score can be misleading when its monitored population is incomplete.
- Quality commitments should reflect consuming business needs and operational accountability.
Explanation
Correct Answer
A:Consistency is agreement across representations under comparable meaning and time. This concept explains the reason for the proposed control. Appropriate intervention: Reconcile tier definitions and synchronization logic using a defined authoritative source.
Incorrect Answers
B:Data-quality issue processes should prioritize consequential defects and accountable response. This is a defensible principle in another context (High-impact reconciliation defects are buried among hundreds of cosmetic warnings.), not the most relevant rationale here. For the stated issue: Consistency is agreement across representations under comparable meaning and time.
C:This is a defensible principle in another context (A scorecard reports 99 percent valid rows but excludes an entire failed daily feed.), not the most relevant rationale here. For the stated issue: Consistency is agreement across representations under comparable meaning and time.
D:Quality commitments should reflect consuming business needs and operational accountability. This is a defensible principle in another context (A shared customer dataset has no agreed defect response or availability expectations.), not the most relevant rationale here. For the stated issue: Consistency is agreement across representations under comparable meaning and time.
Question 735
A reviewer asks for proof of improvement: A chief data officer proposes a program measured only by number of dashboards published. Which result MOST convincingly demonstrates that the control works?
- All regions use a versioned approved term or documented qualified exception.
- Teams implement specified checks and exception workflows tied to an approved policy.
- Quarterly measures show adoption, fewer material defects and demonstrable business value.
- Council minutes record decisions, dissent, accountable actions and resolution dates.
Explanation
Correct Answer
C:It tests the action: Define outcome measures for data reliability, regulatory risk reduction and decision usefulness.
Incorrect Answers
A:All regions use a versioned approved term or documented qualified exception. This would verify a different control (Different regions change the meaning of a sales metric without notifying downstream consumers.), not the one in the question. The required evidence is: Quarterly measures show adoption, fewer material defects and demonstrable business value.
B:Teams implement specified checks and exception workflows tied to an approved policy. This would verify a different control (A company has a general policy promising accurate data but no operational validation thresholds.), not the one in the question. The required evidence is: Quarterly measures show adoption, fewer material defects and demonstrable business value.
D:Council minutes record decisions, dissent, accountable actions and resolution dates. This would verify a different control (Customer and finance functions cannot agree on shared priority data rules.), not the one in the question. The required evidence is: Quarterly measures show adoption, fewer material defects and demonstrable business value.
Question 736
An accountable team must correct this problem and prove results. Select TWO sound statements: A bank intends to retire a reporting platform but has no inventory of upstream sources or dependencies.
- Shortcut: Decommission the reporting store before identifying its critical consumers.
- Action: Publish target enterprise data architecture with shared identity principles and integration boundaries.
- Action: Model the current and target data states and a sequenced transition roadmap.
- Verification: An approved logical model distinguishes party, agreement and financial account semantics.
- Verification: Architecture artifacts identify dependencies, gap owners and a credible migration path.
Explanation
Correct Answers
C:Action: Model the current and target data states and a sequenced transition roadmap. The proposed intervention targets the reported issue. Architecture migration should expose the gap between existing capabilities and desired future state.
E:Verification: Architecture artifacts identify dependencies, gap owners and a credible migration path. The observed result demonstrates whether the correction operates as intended. Architecture migration should expose the gap between existing capabilities and desired future state.
Incorrect Answers
A:Shortcut: Decommission the reporting store before identifying its critical consumers. This shortcut is not a sound remediation. Architecture migration should expose the gap between existing capabilities and desired future state. The appropriate action is: Model the current and target data states and a sequenced transition roadmap.
B:Action: Publish target enterprise data architecture with shared identity principles and integration boundaries. This intervention is for a different scenario (Customer identifiers differ across sales, billing and support, preventing consistent reporting.), not the one stated. Appropriate action here: Model the current and target data states and a sequenced transition roadmap.
D:Verification: An approved logical model distinguishes party, agreement and financial account semantics. This evidence is for a separate context (Two departments use the term account for unrelated concepts and merge records incorrectly.), not this case. The valid outcome is: Architecture artifacts identify dependencies, gap owners and a credible migration path.
Question 737
Consider this organizational data problem: An analytics team reuses location records collected for delivery tracking to infer employees' medical visits. What action is most defensible?
- Enforce row-level security using authoritative user-to-region mapping.
- Assess meaningful disclosure, user expectations and controls for intrusive profiling.
- Classify sensitive fields and apply controls aligned to business and regulatory risk.
- Evaluate the new use against purpose, notice, proportionality and potential harm before access.
Explanation
Correct Answer
D:Evaluate the new use against purpose, notice, proportionality and potential harm before access. Ethical data handling asks whether a use is fair and justified even when technically possible. Evidence to obtain: The use is rejected or redesigned with appropriate authorization, minimization and safeguards.
Incorrect Answers
A: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: Evaluate the new use against purpose, notice, proportionality and potential harm before access.
B:This response fits a separate situation (A firm builds individualized prices from personal browsing histories without meaningful customer explanation.), but does not resolve the stated case.
C:Classify sensitive fields and apply controls aligned to business and regulatory risk. This response fits a separate situation (A developer stores payment account numbers in a general-purpose dataset tagged public.), but does not resolve the stated case. The targeted response is: Evaluate the new use against purpose, notice, proportionality and potential harm before access.
Question 738
In reviewing this data risk, select the LEAST defensible practice: A catalog tool identifies data owners but cannot force them to decide disputed definitions.
- Buy more software licenses instead of resolving decision rights.
- Define the intended data population before interpreting quality percentages.
- Document which dataset version was used in a material decision.
- Retain a rollback or recovery plan before making destructive data changes.
Explanation
Correct Answer
A:Buy more software licenses instead of resolving decision rights. This is the unsafe shortcut because it ignores the control logic. Technology enables governance but cannot replace business authority and decisions. A sound response instead: Integrate governance decisions and stewardship workflows with technology support.
Incorrect Answers
B:Define the intended data population before interpreting quality percentages. An undisclosed denominator can make strong scores misleading. The case-specific response is: Integrate governance decisions and stewardship workflows with technology support.
C:Document which dataset version was used in a material decision. Version records support reproducible decisions. The case-specific response is: Integrate governance decisions and stewardship workflows with technology support.
D:Retain a rollback or recovery plan before making destructive data changes. Recoverability reduces the consequences of incorrect remediation. The case-specific response is: Integrate governance decisions and stewardship workflows with technology support.
Question 739
A proposed shortcut is offered for this situation: A records team says old files were deleted but cannot show what was destroyed or who authorized it. Which choice is the CLEAREST mistake?
- Retain a rollback or recovery plan before making destructive data changes.
- Protect relevant audit records while investigating data problems.
- Erase records with a bulk script and discard the deletion logs.
- Document which dataset version was used in a material decision.
Explanation
Correct Answer
C:Erase records with a bulk script and discard the deletion logs. Defensible disposal requires provable compliance with retention and preservation rules. A sound response instead: Implement disposition approval, hold checking and tamper-resistant destruction logs.
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: Implement disposition approval, hold checking and tamper-resistant destruction logs.
B:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Implement disposition approval, hold checking and tamper-resistant destruction logs.
D:Document which dataset version was used in a material decision. Version records support reproducible decisions. The case-specific response is: Implement disposition approval, hold checking and tamper-resistant destruction logs.
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.