CDMP DMF Practice Test 7
Question 60
Before changing procedures, the team investigates: A consultant rates governance mature from interview opinions without supporting operational evidence. Which review or test MOST directly locates the relevant failure?
- Compare claimed maturity with audit samples, repeatability and control operation.
- Test user understanding of cohort, metric definition and reporting timeframe.
- Review council charter, quorum, action log and overdue escalations.
- Trace metric definition versions, impacted reports and approval history.
Explanation
Correct Answer
A:Compare claimed maturity with audit samples, repeatability and control operation. This test checks the relevant business and technical failure rather than assuming its cause. Maturity is an evidence-based view of institutionalized practices, not aspirational claims. Expected control result: A reproducible score references controls, owners and improvement actions.
Incorrect Answers
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: Compare claimed maturity with audit samples, repeatability and control operation.
C:Review council charter, quorum, action log and overdue escalations. This check would investigate another issue (Customer and finance functions cannot agree on shared priority data rules.), not the immediate case. The direct diagnostic is: Compare claimed maturity with audit samples, repeatability and control operation.
D:Trace metric definition versions, impacted reports and approval history. This check would investigate another issue (Different regions change the meaning of a sales metric without notifying downstream consumers.), not the immediate case. The direct diagnostic is: Compare claimed maturity with audit samples, repeatability and control operation.
Question 61
Select TWO appropriate statements, one intervention and one verification, for this data management case: Sales cannot roll up revenue because the customer parent-child corporate hierarchy differs across reports.
- Action: Distribute reference versions through a governed publish/subscribe or release process.
- Verification: Rollups follow an approved hierarchy for each reporting period and reconcile to detail.
- Shortcut: Overwrite historical parent relationships without retaining effective dates.
- Verification: Each approved update follows the master service and downstream consumers receive consistent versions.
- Action: Govern effective-dated entity relationships and hierarchy ownership.
Explanation
Correct Answers
B:Verification: Rollups follow an approved hierarchy for each reporting period and reconcile to detail. The observed result demonstrates whether the correction operates as intended. Master data includes controlled relationships and hierarchies, not only flat attributes.
E:Action: Govern effective-dated entity relationships and hierarchy ownership. The proposed intervention targets the reported issue. Master data includes controlled relationships and hierarchies, not only flat attributes.
Incorrect Answers
A:Action: Distribute reference versions through a governed publish/subscribe or release process. This intervention is for a different scenario (A mobile app uses a currency-code list six months older than the payments platform.), not the one stated. Appropriate action here: Govern effective-dated entity relationships and hierarchy ownership.
C:Shortcut: Overwrite historical parent relationships without retaining effective dates. This shortcut is not a sound remediation. Master data includes controlled relationships and hierarchies, not only flat attributes. The appropriate action is: Govern effective-dated entity relationships and hierarchy ownership.
D:This evidence is for a separate context (A new platform requires all customer master updates to occur through one governed service.), not this case.
Question 62
An accountable data owner wants both a response and a measurable check: A repository mixes invoices, procedures and complaints under inconsistent free-text tags. Which action-and-evidence pair is BEST?
- Action: Define a managed content taxonomy and classify documents using validated metadata. Verification: Search and lifecycle workflows retrieve the expected classes with measurable precision.
- Action: Improve indexing, controlled metadata, search relevance and authoritative-source labeling. Verification: Search tests surface the current approved procedure rather than obsolete drafts.
- Action: Capture records with reliable context, immutable audit metadata and preservation controls. Verification: The record shows origin, integrity, retention rule and auditable access history.
- Action: Validate extraction confidence and route uncertain fields to authorized human review. Verification: Reconciled records document original images, reviewed exceptions and corrected values.
Explanation
Correct Answer
A:Action: Define a managed content taxonomy and classify documents using validated metadata. Verification: Search and lifecycle workflows retrieve the expected classes with measurable precision. Both the intervention and measurable outcome are directly relevant. Controlled classification improves discovery and consistent handling of unstructured assets.
Incorrect Answers
B:This plan addresses a different situation (Employees cannot find approved procedures because files lack titles, tags and indexed text.), not the targeted problem. Here, action and evidence must match: Action: Define a managed content taxonomy and classify documents using validated metadata.
C:This plan addresses a different situation (An archived approval email is needed as evidence in a dispute but its author and date are missing.), not the targeted problem.
D:This plan addresses a different situation (A team runs OCR on handwritten forms and loads extracted values directly into an account ledger.), not the targeted problem. Here, action and evidence must match: Action: Define a managed content taxonomy and classify documents using validated metadata.
Question 63
A reviewer asks for proof of improvement: A product data owner expects the data steward to set commercial policy unilaterally. Which result MOST convincingly demonstrates that the control works?
- A justified CDE register prioritizes measurable quality, ownership and controls.
- All regions use a versioned approved term or documented qualified exception.
- Role descriptions and approvals reflect owner authority and steward implementation.
- Aged high-impact defects are escalated and recurrence decreases after verified remediation.
Explanation
Correct Answer
C:It tests the action: Separate accountable owner decisions from stewardship coordination and operational execution.
Incorrect Answers
A:A justified CDE register prioritizes measurable quality, ownership and controls. This would verify a different control (A governance team treats every data field as equally critical, overwhelming its controls program.), not the one in the question. The required evidence is: Role descriptions and approvals reflect owner authority and steward implementation.
B: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: Role descriptions and approvals reflect owner authority and steward implementation.
D:Aged high-impact defects are escalated and recurrence decreases after verified remediation. This would verify a different control (Data-quality defects recur because workers close tickets without addressing causes.), not the one in the question. The required evidence is: Role descriptions and approvals reflect owner authority and steward implementation.
Question 64
A governance review considers the following: A governance team treats every data field as equally critical, overwhelming its controls program. Which proposal would create an avoidable risk?
- Flag every column critical to avoid prioritization decisions.
- Check that the proposed procedure has an identified operator and approval path.
- Monitor control outcomes after deployment rather than relying only on design intent.
- Check relevant business definitions before joining independently sourced data.
Explanation
Correct Answer
A:Flag every column critical to avoid prioritization decisions. Critical data designation should target elements whose failure materially affects outcomes. A sound response instead: Identify critical data elements according to material reporting, operational and risk impact.
Incorrect Answers
B:Check that the proposed procedure has an identified operator and approval path. Operational responsibility prevents undocumented workarounds. The case-specific response is: Identify critical data elements according to material reporting, operational and risk impact.
C: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: Identify critical data elements according to material reporting, operational and risk impact.
D:Check relevant business definitions before joining independently sourced data. Semantic agreements prevent incorrect cross-system correlations. The case-specific response is: Identify critical data elements according to material reporting, operational and risk impact.
Question 65
A data analyst must confirm the cause of this issue: Bad dates are entered during onboarding and corrected only after monthly reporting failures. Which check provides the strongest diagnostic evidence?
- Check foreign-key violations and source-target parent/child record counts.
- Compare rule IDs, accepted domains and exception handling across pipelines.
- Sample records for presence, recency and accurate destination independently.
- Test form constraints, exception permissions and downstream defect rates.
Explanation
Correct Answer
D:Test form constraints, exception permissions and downstream defect rates. This test checks the relevant business and technical failure rather than assuming its cause. Preventive quality controls act earlier than downstream detective cleanup. Expected control result: Invalid dates are blocked at entry and legitimate exceptions are traceable.
Incorrect Answers
A:Check foreign-key violations and source-target parent/child record counts. This check would investigate another issue (An invoice line appears without an invoice header after a partial load.), not the immediate case. The direct diagnostic is: Test form constraints, exception permissions and downstream defect rates.
B:Compare rule IDs, accepted domains and exception handling across pipelines. This check would investigate another issue (Different pipelines enforce different allowable values for the same governed country field.), not the immediate case. The direct diagnostic is: Test form constraints, exception permissions and downstream defect rates.
C:Sample records for presence, recency and accurate destination independently. This check would investigate another issue (A postal address field is 100 percent complete but several entries are no longer current.), not the immediate case. The direct diagnostic is: Test form constraints, exception permissions and downstream defect rates.
Question 66
Which statement best describes the governing idea behind the response to this case: A vendor invoice from last month arrives after the monthly warehouse close.
- Type 1 slowly changing dimensions replace values when historical changes are unnecessary.
- Warehouse pipelines must distinguish event/business time from loading time.
- Trusted BI requires reproducible metrics and transparent revision histories.
- Preaggregation trades computation cost for maintenance and freshness requirements.
Explanation
Correct Answer
B:Warehouse pipelines must distinguish event/business time from loading time. This concept explains the reason for the proposed control. Appropriate intervention: Apply late-arrival processing with date-correct attribution and controlled restatement if needed.
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: Warehouse pipelines must distinguish event/business time from loading time.
C:Trusted BI requires reproducible metrics and transparent revision histories. This is a defensible principle in another context (A published regulatory dashboard cannot explain why last month's total changed after a source correction.), not the most relevant rationale here. For the stated issue: Warehouse pipelines must distinguish event/business time from loading time.
D:Preaggregation trades computation cost for maintenance and freshness requirements. This is a defensible principle in another context (A star-schema dashboard query repeatedly scans granular facts for the same monthly totals.), not the most relevant rationale here. For the stated issue: Warehouse pipelines must distinguish event/business time from loading time.
Question 67
A data steward challenges an assumption in this case: A data team wants to set quality targets before knowing null, duplicate and value distributions. Which verification should be performed first?
- Inspect profiling SQL, population definitions and sampling coverage.
- Join same-customer records at a common as-of time and compare tier values.
- Run reference-set validation and count invalid statuses by producer.
- Review quality agreements, monitoring windows, breaches and corrective actions.
Explanation
Correct Answer
A:Inspect profiling SQL, population definitions and sampling coverage. This test checks the relevant business and technical failure rather than assuming its cause. Data profiling provides empirical evidence before quality thresholds are selected. Expected control result: The baseline includes measured distributions, anomalies and reliability of sampling.
Incorrect Answers
B:Join same-customer records at a common as-of time and compare tier values. This check would investigate another issue (The customer's tier is gold in billing but silver in the loyalty platform on the same date.), not the immediate case. The direct diagnostic is: Inspect profiling SQL, population definitions and sampling coverage.
C:Run reference-set validation and count invalid statuses by producer. This check would investigate another issue (A product status field contains values archived and disabled although only active and retired are approved.), not the immediate case. The direct diagnostic is: Inspect profiling SQL, population definitions and sampling coverage.
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: Inspect profiling SQL, population definitions and sampling coverage.
Question 68
Select TWO appropriate statements, one intervention and one verification, for this data management case: A report scans millions of rows although its date filter is selective and frequent.
- Action: Evaluate query plans and appropriate indexes while considering write and storage overhead.
- Shortcut: Add an index to every column without examining workload patterns.
- Verification: Representative query time improves without unacceptable ingestion regression.
- Verification: A simulated primary outage transfers service within the target and avoids unacceptable data loss.
- Action: Define one-hour RPO and fifteen-minute RTO, then choose replication and recovery controls accordingly.
Explanation
Correct Answers
A:Action: Evaluate query plans and appropriate indexes while considering write and storage overhead. The proposed intervention targets the reported issue. Indexes speed selective access but impose maintenance and write costs.
C:Verification: Representative query time improves without unacceptable ingestion regression. The observed result demonstrates whether the correction operates as intended. Indexes speed selective access but impose maintenance and write costs.
Incorrect Answers
B:Shortcut: Add an index to every column without examining workload patterns. This shortcut is not a sound remediation. Indexes speed selective access but impose maintenance and write costs. The appropriate action is: Evaluate query plans and appropriate indexes while considering write and storage overhead.
D:Verification: A simulated primary outage transfers service within the target and avoids unacceptable data loss. This evidence is for a separate context (A replica exists for critical reads but failover has never been validated.), not this case. The valid outcome is: Representative query time improves without unacceptable ingestion regression.
E:This intervention is for a different scenario (A service can tolerate one hour of data loss but must return within fifteen minutes of outage.), not the one stated.
Question 69
A data steward examines this condition: A company keeps only the latest backup copy, leaving no way to recover before ransomware encryption. What concept best justifies the corrective approach?
- Storage operations need proactive capacity management, not crisis-only expansion.
- Recovery needs retained trustworthy recovery points as well as available replicas.
- Replication improves availability only when failover and consistency assumptions are tested.
- Database availability alone does not establish acceptable operational performance.
Explanation
Correct Answer
B:Recovery needs retained trustworthy recovery points as well as available replicas. This concept explains the reason for the proposed control. Appropriate intervention: Apply versioned, protected backups with retention, isolation and tested restore points.
Incorrect Answers
A:Storage operations need proactive capacity management, not crisis-only expansion. This is a defensible principle in another context (A database approaches disk exhaustion during a seasonal reporting surge.), not the most relevant rationale here. For the stated issue: Recovery needs retained trustworthy recovery points as well as available replicas.
C:This is a defensible principle in another context (A replica exists for critical reads but failover has never been validated.), not the most relevant rationale here. For the stated issue: Recovery needs retained trustworthy recovery points as well as available replicas.
D:This is a defensible principle in another context (A database service is slow but monitoring records only whether its process is up.), not the most relevant rationale here. For the stated issue: Recovery needs retained trustworthy recovery points as well as available replicas.
Question 70
An accountable team must correct this problem and prove results. Select TWO sound statements: A product taxonomy changes in January but last year's reports must preserve prior category assignments.
- Shortcut: Replace historical code descriptions in place and recalculate old reports silently.
- Action: Design coexistence MDM with controlled bidirectional synchronization and conflict handling.
- Verification: The organization links to multiple roles without conflating role-specific permissions.
- Verification: Historical reports use previous mappings while current queries use approved new categories.
- Action: Manage reference data as effective-dated versions with historical mapping support.
Explanation
Correct Answers
D:Verification: Historical reports use previous mappings while current queries use approved new categories. The observed result demonstrates whether the correction operates as intended. Reference-data changes can alter meaning across time and require controlled versions.
E:Action: Manage reference data as effective-dated versions with historical mapping support. The proposed intervention targets the reported issue. Reference-data changes can alter meaning across time and require controlled versions.
Incorrect Answers
A:Shortcut: Replace historical code descriptions in place and recalculate old reports silently. This shortcut is not a sound remediation. Reference-data changes can alter meaning across time and require controlled versions. The appropriate action is: Manage reference data as effective-dated versions with historical mapping support.
B:Action: Design coexistence MDM with controlled bidirectional synchronization and conflict handling. This intervention is for a different scenario (Business units need local writes but also expect synchronized approved enterprise attributes.), not the one stated. Appropriate action here: Manage reference data as effective-dated versions with historical mapping support.
C:This evidence is for a separate context (One organization can be both a supplier and customer, but systems duplicate its legal entity per role.), not this case. The valid outcome is: Historical reports use previous mappings while current queries use approved new categories.