CDMP DMF Practice Test 24
Question 230
A business owner identifies this issue: Two departments disagree about the authoritative definition of an active customer and neither can decide. What is the MOST appropriate data management response?
- Assign policy decision rights to a business data owner with steward-led coordination.
- Control glossary definitions and semantic changes with approval and impact analysis.
- Report meaningful risk, issue aging, quality compliance and business-value outcomes.
- Provide role-based training and supervised examples matched to assigned stewardship duties.
Explanation
Correct Answer
A:Assign policy decision rights to a business data owner with steward-led coordination. Data governance establishes authority and accountability for data decisions. Evidence to obtain: An approved definition, accountable owner and escalation path resolve cross-team disagreements.
Incorrect Answers
B:This response fits a separate situation (Different regions change the meaning of a sales metric without notifying downstream consumers.), but does not resolve the stated case.
C:Report meaningful risk, issue aging, quality compliance and business-value outcomes. This response fits a separate situation (Leadership receives the total number of stewardship meetings as the sole effectiveness KPI.), but does not resolve the stated case. The targeted response is: Assign policy decision rights to a business data owner with steward-led coordination.
D: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. Provide role-based training and supervised examples matched to assigned stewardship duties.
Question 231
An accountable team must correct this problem and prove results. Select TWO sound statements: Customer and finance functions cannot agree on shared priority data rules.
- Verification: Milestones show ownership uptake and validated quality/control improvements.
- Verification: Council minutes record decisions, dissent, accountable actions and resolution dates.
- Action: Translate principles into measurable standards, owner responsibilities and repeatable procedures.
- Action: Convene an authorized cross-functional council to make and escalate policy decisions.
- Shortcut: Allow the loudest department to override approved enterprise rules informally.
Explanation
Correct Answers
B:Verification: Council minutes record decisions, dissent, accountable actions and resolution dates. The observed result demonstrates whether the correction operates as intended. Enterprise governance needs a forum for conflicting priorities with explicit authority.
D:Action: Convene an authorized cross-functional council to make and escalate policy decisions. The proposed intervention targets the reported issue. Enterprise governance needs a forum for conflicting priorities with explicit authority.
Incorrect Answers
A:Verification: Milestones show ownership uptake and validated quality/control improvements. This evidence is for a separate context (A new governance office attempts simultaneous enterprise rollout with no prioritization or adoption plan.), not this case. The valid outcome is: Council minutes record decisions, dissent, accountable actions and resolution dates.
C:Action: Translate principles into measurable standards, owner responsibilities and repeatable procedures. This intervention is for a different scenario (A company has a general policy promising accurate data but no operational validation thresholds.), not the one stated. Appropriate action here: Convene an authorized cross-functional council to make and escalate policy decisions.
E:Shortcut: Allow the loudest department to override approved enterprise rules informally. This shortcut is not a sound remediation. Enterprise governance needs a forum for conflicting priorities with explicit authority. The appropriate action is: Convene an authorized cross-functional council to make and escalate policy decisions.
Question 232
A governance review considers the following: Business units create separate departmental marts from inconsistent extracts of customer master data. Which proposal would create an avoidable risk?
- Verify a new interface using a controlled sample and reconciliation.
- Keep approved reference mappings versioned and traceable.
- Preserve source evidence and document why any exception was approved.
- Build each mart from unrelated spreadsheets with no lineage.
Explanation
Correct Answer
D:Build each mart from unrelated spreadsheets with no lineage. Data marts should not undermine enterprise definitions or trusted master sources. A sound response instead: Govern mart sourcing and shared dimensions while allowing fit-for-purpose views.
Incorrect Answers
A:Verify a new interface using a controlled sample and reconciliation. Testing reveals mismatches before broad deployment. The case-specific response is: Govern mart sourcing and shared dimensions while allowing fit-for-purpose views.
B:Keep approved reference mappings versioned and traceable. Value meaning can change across time and applications. The case-specific response is: Govern mart sourcing and shared dimensions while allowing fit-for-purpose views.
C:Preserve source evidence and document why any exception was approved. Traceability enables independent review of exceptions. The case-specific response is: Govern mart sourcing and shared dimensions while allowing fit-for-purpose views.
Question 233
A data steward examines this condition: An archived approval email is needed as evidence in a dispute but its author and date are missing. What concept best justifies the corrective approach?
- Enterprise content discoverability depends on metadata and indexing quality.
- Records need authentic contextual evidence, not just retrievable bytes.
- Extracted content is derived data whose accuracy and provenance require verification.
- Defensible disposal requires provable compliance with retention and preservation rules.
Explanation
Correct Answer
B:Records need authentic contextual evidence, not just retrievable bytes. This concept explains the reason for the proposed control. Appropriate intervention: Capture records with reliable context, immutable audit metadata and preservation controls.
Incorrect Answers
A:Enterprise content discoverability depends on metadata and indexing quality. This is a defensible principle in another context (Employees cannot find approved procedures because files lack titles, tags and indexed text.), not the most relevant rationale here. For the stated issue: Records need authentic contextual evidence, not just retrievable bytes.
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: Records need authentic contextual evidence, not just retrievable bytes.
D:This is a defensible principle in another context (A records team says old files were deleted but cannot show what was destroyed or who authorized it.), not the most relevant rationale here. For the stated issue: Records need authentic contextual evidence, not just retrievable bytes.
Question 234
For this situation, which combined intervention and validation MOST directly addresses the issue? A customer platform needs low-latency updates without repeatedly scanning entire operational tables.
- Action: Govern landing, transformation logic, lineage and compute costs in a controlled ELT workflow. Verification: Raw inputs and reproducible transformation outputs are traceable and validated.
- 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: Evaluate governed federation or virtualization with source access, query pushdown and performance limits. Verification: Queries return authorized current results within documented latency and availability bounds.
- 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.
Explanation
Correct Answer
D: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. Both the intervention and measurable outcome are directly relevant. CDC depends on correct change ordering and consumption state across failures.
Incorrect Answers
A:This plan addresses a different situation (An analytics platform loads source extracts into a warehouse then performs transformations there.), not the targeted problem. Here, action and evidence must match: Action: Use change data capture with durable offsets, ordering assumptions and replay handling.
B: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: Use change data capture with durable offsets, ordering assumptions and replay handling.
C:This plan addresses a different situation (An organization wants live access to distributed records without copying every source table.), not the targeted problem.
Question 235
After addressing this problem, what evidence would justify closure? Several applications retain their own customer stores but need a shared identity index.
- Known duplicate test cases are flagged while legitimate similar companies remain distinct.
- Verified false merges decrease without unacceptable missed true matches.
- The consolidated view is refreshed and lineage shows each source-system contribution.
- A lookup resolves cross-system references while authoritative attributes remain in sources.
Explanation
Correct Answer
D:It tests the action: Adopt a registry-style MDM where appropriate, linking identifiers without assuming data centralization.
Incorrect Answers
A:Known duplicate test cases are flagged while legitimate similar companies remain distinct. This would verify a different control (New customer onboarding creates a second record when spacing differs in a business name.), not the one in the question. The required evidence is: A lookup resolves cross-system references while authoritative attributes remain in sources.
B:Verified false merges decrease without unacceptable missed true matches. This would verify a different control (A matching algorithm merges a parent and child solely because they share surname and address.), not the one in the question. The required evidence is: A lookup resolves cross-system references while authoritative attributes remain in sources.
C:The consolidated view is refreshed and lineage shows each source-system contribution. This would verify a different control (A company wants a central analytical customer view while operational systems continue owning updates.), not the one in the question. The required evidence is: A lookup resolves cross-system references while authoritative attributes remain in sources.
Question 236
A data management auditor evaluates this situation: A risk report uses an old industry code mapping but its catalog does not record which version. Which observable finding supports successful remediation?
- New schema fields appear promptly with change events and review status.
- Risk report runs identify applicable mapping versions and affected records.
- Consumers see retirement dates, replacements and appropriate access warnings.
- Owners detect late or failed loads using observable pipeline execution history.
Explanation
Correct Answer
B:It tests the action: Capture metadata linking transformed fields to versioned reference-data mappings.
Incorrect Answers
A:New schema fields appear promptly with change events and review status. This would verify a different control (A source database gains fields but the catalog schema remains unchanged for months.), not the one in the question. The required evidence is: Risk report runs identify applicable mapping versions and affected records.
C: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: Risk report runs identify applicable mapping versions and affected records.
D:Owners detect late or failed loads using observable pipeline execution history. This would verify a different control (A pipeline silently stopped after a weekend but no one tracks run status or freshness.), not the one in the question. The required evidence is: Risk report runs identify applicable mapping versions and affected records.
Question 237
A data steward challenges an assumption in this case: A product data owner expects the data steward to set commercial policy unilaterally. Which verification should be performed first?
- Evaluate trained steward issue submissions against a documented handling standard.
- Test user understanding of cohort, metric definition and reporting timeframe.
- Inspect RACI assignments, policy approvals and steward issue logs.
- Sample defects for root-cause evidence, risk acceptance and post-fix monitoring.
Explanation
Correct Answer
C:Inspect RACI assignments, policy approvals and steward issue logs. This test checks the relevant business and technical failure rather than assuming its cause. Owners are accountable for business decisions while stewards coordinate data management practice. Expected control result: Role descriptions and approvals reflect owner authority and steward implementation.
Incorrect Answers
A:Evaluate trained steward issue submissions against a documented handling standard. This check would investigate another issue (New business stewards do not understand how to document definitions or resolve data defects.), not the immediate case. The direct diagnostic is: Inspect RACI assignments, policy approvals and steward issue logs.
B:Test user understanding of cohort, metric definition and reporting timeframe. This check would investigate another issue (Executives regularly misinterpret dashboards because they confuse current records with historical cohorts.), not the immediate case. The direct diagnostic is: Inspect RACI assignments, policy approvals and steward issue logs.
D:Sample defects for root-cause evidence, risk acceptance and post-fix monitoring. This check would investigate another issue (Data-quality defects recur because workers close tickets without addressing causes.), not the immediate case. The direct diagnostic is: Inspect RACI assignments, policy approvals and steward issue logs.
Question 238
A data steward challenges an assumption in this case: Two departments disagree about the authoritative definition of an active customer and neither can decide. Which verification should be performed first?
- Compare claimed maturity with audit samples, repeatability and control operation.
- Inspect roadmap dependencies, funding, adoption measures and change readiness.
- Check that catalog ownership links to actual issue decisions and approved definitions.
- Review governance charter, ownership map and approved definition changes.
Explanation
Correct Answer
D:Review governance charter, ownership map and approved definition changes. This test checks the relevant business and technical failure rather than assuming its cause. Data governance establishes authority and accountability for data decisions. Expected control result: An approved definition, accountable owner and escalation path resolve cross-team disagreements.
Incorrect Answers
A:Compare claimed maturity with audit samples, repeatability and control operation. This check would investigate another issue (A consultant rates governance mature from interview opinions without supporting operational evidence.), not the immediate case. The direct diagnostic is: Review governance charter, ownership map and approved definition changes.
B:Inspect roadmap dependencies, funding, adoption measures and change readiness. This check would investigate another issue (A new governance office attempts simultaneous enterprise rollout with no prioritization or adoption plan.), not the immediate case. The direct diagnostic is: Review governance charter, ownership map and approved definition changes.
C:Check that catalog ownership links to actual issue decisions and approved definitions. This check would investigate another issue (A catalog tool identifies data owners but cannot force them to decide disputed definitions.), not the immediate case. The direct diagnostic is: Review governance charter, ownership map and approved definition changes.
Question 239
A governance committee needs a defensible plan and proof: A postal address field is 100 percent complete but several entries are no longer current. Which paired proposal is appropriate?
- Action: Verify the address against a trusted recent source and update the authoritative record. Verification: A sampled comparison confirms the stored address reflects current real-world facts.
- Action: Apply referential integrity or explicit orphan reconciliation across source and target. Verification: Every accepted line references a valid invoice or has an owned exception.
- Action: Assess completeness and timeliness separately, then choose remediation based on use. Verification: The scorecard shows distinct dimension measures and decision-relevant targets.
- Action: Evaluate quality against the specific consumer's required provenance and interpretability. Verification: Regulatory users can reproduce lineage and assess permitted use of each observation.
Explanation
Correct Answer
C:Action: Assess completeness and timeliness separately, then choose remediation based on use. Verification: The scorecard shows distinct dimension measures and decision-relevant targets. Both the intervention and measurable outcome are directly relevant. High performance on one data-quality dimension does not establish overall fitness.
Incorrect Answers
A:This plan addresses a different situation (A customer's billing address is validly formatted but refers to a previous residence.), not the targeted problem. Here, action and evidence must match: Action: Assess completeness and timeliness separately, then choose remediation based on use.
B:This plan addresses a different situation (An invoice line appears without an invoice header after a partial load.), not the targeted problem. Here, action and evidence must match: Action: Assess completeness and timeliness separately, then choose remediation based on use.
D:This plan addresses a different situation (A scientific dataset has fine precision but lacks metadata required for the regulator's audit.), not the targeted problem. Here, action and evidence must match: Action: Assess completeness and timeliness separately, then choose remediation based on use.
Question 240
After addressing this problem, what evidence would justify closure? A developer stores payment account numbers in a general-purpose dataset tagged public.
- The dataset is correctly labeled and unauthorized roles cannot read restricted attributes.
- An authorized manager sees own-region rows and cannot access other regions.
- Traffic capture reveals no plaintext sensitive fields and valid endpoint trust is enforced.
- Test datasets retain required distributions while direct identifiers cannot be recovered.
Explanation
Correct Answer
A:It tests the action: Classify sensitive fields and apply controls aligned to business and regulatory risk.
Incorrect Answers
B:An authorized manager sees own-region rows and cannot access other regions. This would verify a different control (Regional sales managers can query all customer records despite regional authorization rules.), not the one in the question. The required evidence is: The dataset is correctly labeled and unauthorized roles cannot read restricted attributes.
C: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: The dataset is correctly labeled and unauthorized roles cannot read restricted attributes.
D: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: The dataset is correctly labeled and unauthorized roles cannot read restricted attributes.