CDMP DMF Practice Test 61
Question 600
For the following case select THREE defensible statements covering correction, reason and proof: A published regulatory dashboard cannot explain why last month's total changed after a source correction.
- Shortcut: Overwrite historical aggregates without recording revisions or reasons.
- Verification: Auditors reproduce the original total and explain the changed figure from documented inputs.
- Verification: Current and historical queries show the corrected description without extra history rows.
- Action: Preserve run versions, source snapshots and transformation lineage with approved restatement rules.
- Action: Build governed analytical integration and conformed business measures for reporting.
- Principle: Trusted BI requires reproducible metrics and transparent revision histories.
Explanation
Correct Answers
B:Verification: Auditors reproduce the original total and explain the changed figure from documented inputs. The observed result demonstrates whether the correction operates as intended. Trusted BI requires reproducible metrics and transparent revision histories.
D:Action: Preserve run versions, source snapshots and transformation lineage with approved restatement rules. The proposed intervention targets the reported issue. Trusted BI requires reproducible metrics and transparent revision histories.
F:Principle: Trusted BI requires reproducible metrics and transparent revision histories. This is the governing concept explaining the selected correction and expected outcome.
Incorrect Answers
A:Shortcut: Overwrite historical aggregates without recording revisions or reasons. This shortcut is not a sound remediation. Trusted BI requires reproducible metrics and transparent revision histories. The appropriate action is: Preserve run versions, source snapshots and transformation lineage with approved restatement rules.
C:This evidence is for a separate context (A product description contains a typo and historic analytics do not need the old spelling.), not this case. The valid outcome is: Auditors reproduce the original total and explain the changed figure from documented inputs.
E:Action: Build governed analytical integration and conformed business measures for reporting. This intervention is for a different scenario (Executives need consistent historical revenue despite frequent transactional schema changes.), not the one stated. Appropriate action here: Preserve run versions, source snapshots and transformation lineage with approved restatement rules.
Question 601
The data program reviews the following failure: New customer onboarding creates a second record when spacing differs in a business name. Which change should be prioritized?
- Normalize relevant fields and check probable duplicates before creating master identities.
- Define survivorship rules that favor verified recent evidence with traceable provenance.
- Distribute reference versions through a governed publish/subscribe or release process.
- Govern a shared country reference set with mappings, definitions and permitted changes.
Explanation
Correct Answer
A:Normalize relevant fields and check probable duplicates before creating master identities. Preventing duplicate creation is usually cheaper than repeated downstream reconciliation. Evidence to obtain: Known duplicate test cases are flagged while legitimate similar companies remain distinct.
Incorrect Answers
B:This response fits a separate situation (Two customer sources disagree about legal name after one verifies recent government ID.), but does not resolve the stated case.
C:Distribute reference versions through a governed publish/subscribe or release process. This response fits a separate situation (A mobile app uses a currency-code list six months older than the payments platform.), but does not resolve the stated case. The targeted response is: Normalize relevant fields and check probable duplicates before creating master identities.
D:This response fits a separate situation (Three regions encode country using names, ISO codes and private numeric lists.), but does not resolve the stated case.
Question 602
A data steward challenges an assumption in this case: Reports join unrelated entities because business dimensions lack a mapped semantic model. Which verification should be performed first?
- Test catalog search and preview using low-privilege identities.
- Audit current systems against catalog lifecycle labels and successor links.
- Inspect column-level lineage graph and controlled schema change tests.
- Test semantic queries, metric totals and join validity against sample facts.
Explanation
Correct Answer
D:Test semantic queries, metric totals and join validity against sample facts. This test checks the relevant business and technical failure rather than assuming its cause. Semantic metadata bridges technical schemas and business interpretation. Expected control result: Users get consistent results and invalid joins are rejected or flagged.
Incorrect Answers
A:Test catalog search and preview using low-privilege identities. This check would investigate another issue (A public catalog description reveals restricted patient identities in sample values.), not the immediate case. The direct diagnostic is: Test semantic queries, metric totals and join validity against sample facts.
B:Audit current systems against catalog lifecycle labels and successor links. This check would investigate another issue (A retired system's catalog entries remain marked active, misleading new project teams.), not the immediate case. The direct diagnostic is: Test semantic queries, metric totals and join validity against sample facts.
C:Inspect column-level lineage graph and controlled schema change tests. This check would investigate another issue (A team plans to remove a source column that feeds several dashboards and fraud rules.), not the immediate case. The direct diagnostic is: Test semantic queries, metric totals and join validity against sample facts.
Question 603
A data analyst must confirm the cause of this issue: A postal address field is 100 percent complete but several entries are no longer current. Which check provides the strongest diagnostic evidence?
- Run reference-set validation and count invalid statuses by producer.
- Sample records for presence, recency and accurate destination independently.
- Review normalized identity pairs and manually labeled match cases.
- Trace missing IDs to upstream forms, interfaces and repeated source events.
Explanation
Correct Answer
B:Sample records for presence, recency and accurate destination independently. This test checks the relevant business and technical failure rather than assuming its cause. High performance on one data-quality dimension does not establish overall fitness. Expected control result: The scorecard shows distinct dimension measures and decision-relevant targets.
Incorrect Answers
A: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: Sample records for presence, recency and accurate destination independently.
C:Review normalized identity pairs and manually labeled match cases. This check would investigate another issue (A CRM has duplicate contact records with different punctuation in their names.), not the immediate case. The direct diagnostic is: Sample records for presence, recency and accurate destination independently.
D:Trace missing IDs to upstream forms, interfaces and repeated source events. This check would investigate another issue (An analyst manually fixes the same missing supplier IDs every week.), not the immediate case. The direct diagnostic is: Sample records for presence, recency and accurate destination independently.
Question 604
A governance review considers the following: An automated seven-year purge is about to remove correspondence covered by an active litigation hold. Which proposal would create an avoidable risk?
- Escalate material unresolved issues to an accountable business decision owner.
- Verify a new interface using a controlled sample and reconciliation.
- Check that the proposed procedure has an identified operator and approval path.
- Run the normal purge because the nominal retention date has passed.
Explanation
Correct Answer
D:Run the normal purge because the nominal retention date has passed. Legal holds can override routine retention disposition for specified records. A sound response instead: Suspend disposition for in-scope content until an authorized hold release is recorded.
Incorrect Answers
A:Escalate material unresolved issues to an accountable business decision owner. Accountability prevents silent acceptance of consequential risk. The case-specific response is: Suspend disposition for in-scope content until an authorized hold release is recorded.
B:Verify a new interface using a controlled sample and reconciliation. Testing reveals mismatches before broad deployment. The case-specific response is: Suspend disposition for in-scope content until an authorized hold release is recorded.
C:Check that the proposed procedure has an identified operator and approval path. Operational responsibility prevents undocumented workarounds. The case-specific response is: Suspend disposition for in-scope content until an authorized hold release is recorded.
Question 605
A data analyst must confirm the cause of this issue: Privileged database exports are possible but no one records who initiated them. Which check provides the strongest diagnostic evidence?
- Compare requested fields with campaign needs and recipient entitlements.
- Inspect storage encryption status, key access logs and a restoration test.
- Perform a permitted test export and trace it through retained security logs.
- Test different identities through both dashboards and direct data access paths.
Explanation
Correct Answer
C:Perform a permitted test export and trace it through retained security logs. This test checks the relevant business and technical failure rather than assuming its cause. Auditability complements prevention by making sensitive operations attributable. Expected control result: A test export captures actor, dataset, time and authorized action in immutable evidence.
Incorrect Answers
A:Compare requested fields with campaign needs and recipient entitlements. This check would investigate another issue (Marketing requests full birth dates for a campaign that only needs age bands.), not the immediate case. The direct diagnostic is: Perform a permitted test export and trace it through retained security logs.
B:Inspect storage encryption status, key access logs and a restoration test. This check would investigate another issue (A backup contains confidential employee salaries and is stored without encryption controls.), not the immediate case. The direct diagnostic is: Perform a permitted test export and trace it through retained security logs.
D:Test different identities through both dashboards and direct data access paths. This check would investigate another issue (Regional sales managers can query all customer records despite regional authorization rules.), not the immediate case. The direct diagnostic is: Perform a permitted test export and trace it through retained security logs.
Question 606
A data analyst must confirm the cause of this issue: An analytics team reuses location records collected for delivery tracking to infer employees' medical visits. Which check provides the strongest diagnostic evidence?
- Review anomalous access logs, credential exposure, response records and retention.
- Test different identities through both dashboards and direct data access paths.
- Review documented purpose, foreseeable harms, permissions and impacted stakeholders.
- Inspect classification lineage, access grants and unauthorized read attempts.
Explanation
Correct Answer
C:Review documented purpose, foreseeable harms, permissions and impacted stakeholders. This test checks the relevant business and technical failure rather than assuming its cause. Ethical data handling asks whether a use is fair and justified even when technically possible. Expected control result: The use is rejected or redesigned with appropriate authorization, minimization and safeguards.
Incorrect Answers
A:Review anomalous access logs, credential exposure, response records and retention. This check would investigate another issue (An unauthorized service account downloads a large restricted dataset overnight.), not the immediate case. The direct diagnostic is: Review documented purpose, foreseeable harms, permissions and impacted stakeholders.
B:Test different identities through both dashboards and direct data access paths. This check would investigate another issue (Regional sales managers can query all customer records despite regional authorization rules.), not the immediate case. The direct diagnostic is: Review documented purpose, foreseeable harms, permissions and impacted stakeholders.
D:Inspect classification lineage, access grants and unauthorized read attempts. This check would investigate another issue (A developer stores payment account numbers in a general-purpose dataset tagged public.), not the immediate case. The direct diagnostic is: Review documented purpose, foreseeable harms, permissions and impacted stakeholders.
Question 607
Consider this organizational data problem: The customer's tier is gold in billing but silver in the loyalty platform on the same date. What action is most defensible?
- Add input validation with clear user feedback and exception override governance.
- Reconcile tier definitions and synchronization logic using a defined authoritative source.
- Run repeatable data profiling with representative population and documented limitations.
- Apply referential integrity or explicit orphan reconciliation across source and target.
Explanation
Correct Answer
B:Reconcile tier definitions and synchronization logic using a defined authoritative source. Consistency is agreement across representations under comparable meaning and time. Evidence to obtain: Tier values agree for the same customer and effective period across systems.
Incorrect Answers
A:Add input validation with clear user feedback and exception override governance. This response fits a separate situation (Bad dates are entered during onboarding and corrected only after monthly reporting failures.), but does not resolve the stated case. The targeted response is: Reconcile tier definitions and synchronization logic using a defined authoritative source.
C:Run repeatable data profiling with representative population and documented limitations. This response fits a separate situation (A data team wants to set quality targets before knowing null, duplicate and value distributions.), but does not resolve the stated case. The targeted response is: Reconcile tier definitions and synchronization logic using a defined authoritative source.
D:Apply referential integrity or explicit orphan reconciliation across source and target. This response fits a separate situation (An invoice line appears without an invoice header after a partial load.), but does not resolve the stated case. The targeted response is: Reconcile tier definitions and synchronization logic using a defined authoritative source.
Question 608
Consider this organizational data problem: A federated enterprise wants local stewards but must preserve consistent enterprise rules. What action is most defensible?
- Define federated decision boundaries, central standards and locally accountable execution.
- Assess maturity against defined capabilities with artifacts, repeatable evidence and gaps.
- Map the regulation to governed policies, accountable controls and effective dates.
- Require authorized risk assessment, expiry, compensating controls and documented acceptance.
Explanation
Correct Answer
A:Define federated decision boundaries, central standards and locally accountable execution. Governance operating models balance local agility with cross-enterprise consistency. Evidence to obtain: Local issues are resolved within authority and enterprise conflicts have a clear escalation route.
Incorrect Answers
B:Assess maturity against defined capabilities with artifacts, repeatable evidence and gaps. This response fits a separate situation (A consultant rates governance mature from interview opinions without supporting operational evidence.), but does not resolve the stated case. The targeted response is: Define federated decision boundaries, central standards and locally accountable execution.
C:Map the regulation to governed policies, accountable controls and effective dates. This response fits a separate situation (A new privacy requirement affects data collection across products but no governance owner tracks applicability.), but does not resolve the stated case. The targeted response is: Define federated decision boundaries, central standards and locally accountable execution.
D:Require authorized risk assessment, expiry, compensating controls and documented acceptance. This response fits a separate situation (A business requests a temporary deviation from a sensitive data retention standard.), but does not resolve the stated case. The targeted response is: Define federated decision boundaries, central standards and locally accountable execution.
Question 609
The data program reviews the following failure: Reports join unrelated entities because business dimensions lack a mapped semantic model. Which change should be prioritized?
- Use dependency lineage to assess downstream impact and coordinate migration.
- Define approved semantic relationships, metric calculations and valid join paths.
- Define and approve a glossary term with qualified variants and linked calculations.
- Use a governed repository or catalog with stewardship workflows and controlled synchronization.
Explanation
Correct Answer
B:Define approved semantic relationships, metric calculations and valid join paths. Semantic metadata bridges technical schemas and business interpretation. Evidence to obtain: Users get consistent results and invalid joins are rejected or flagged.
Incorrect Answers
A:Use dependency lineage to assess downstream impact and coordinate migration. This response fits a separate situation (A team plans to remove a source column that feeds several dashboards and fraud rules.), but does not resolve the stated case. The targeted response is: Define approved semantic relationships, metric calculations and valid join paths.
C:Define and approve a glossary term with qualified variants and linked calculations. This response fits a separate situation (A term called revenue means gross receipts in one team and net receipts in another.), but does not resolve the stated case. The targeted response is: Define approved semantic relationships, metric calculations and valid join paths.
D:Use a governed repository or catalog with stewardship workflows and controlled synchronization. This response fits a separate situation (Metadata lives in individual spreadsheets that differ on owners and field meanings.), but does not resolve the stated case. The targeted response is: Define approved semantic relationships, metric calculations and valid join paths.
Question 610
In reviewing this data risk, select the LEAST defensible practice: A multinational has legal requirements to keep certain data local while enabling group analytics.
- Respect active legal holds before scheduling record disposition.
- Escalate material unresolved issues to an accountable business decision owner.
- Replicate all raw personal data centrally without examining location restrictions.
- Retain a rollback or recovery plan before making destructive data changes.
Explanation
Correct Answer
C:Replicate all raw personal data centrally without examining location restrictions. Architecture must balance enterprise interoperability with local legal and operational constraints. A sound response instead: Use a federated architecture with governed metadata and lawful cross-border access patterns.
Incorrect Answers
A:Respect active legal holds before scheduling record disposition. Preservation duties may override scheduled destruction. The case-specific response is: Use a federated architecture with governed metadata and lawful cross-border access patterns.
B:Escalate material unresolved issues to an accountable business decision owner. Accountability prevents silent acceptance of consequential risk. The case-specific response is: Use a federated architecture with governed metadata and lawful cross-border access patterns.
D:Retain a rollback or recovery plan before making destructive data changes. Recoverability reduces the consequences of incorrect remediation. The case-specific response is: Use a federated architecture with governed metadata and lawful cross-border access patterns.