CDMP DMF Practice Test 86
Question 850
A data management auditor evaluates this situation: A CRM has duplicate contact records with different punctuation in their names. Which observable finding supports successful remediation?
- Confirmed duplicate rates fall without inappropriate merges of distinct customers.
- Disallowed statuses are rejected or recorded in an exception workflow.
- Quality scores include expected records and flag unavailable populations.
- Invalid dates are blocked at entry and legitimate exceptions are traceable.
Explanation
Correct Answer
A:It tests the action: Define business uniqueness and controlled entity matching rather than exact-row equality.
Incorrect Answers
B:Disallowed statuses are rejected or recorded in an exception workflow. This would verify a different control (A product status field contains values archived and disabled although only active and retired are approved.), not the one in the question. The required evidence is: Confirmed duplicate rates fall without inappropriate merges of distinct customers.
C:Quality scores include expected records and flag unavailable populations. This would verify a different control (A scorecard reports 99 percent valid rows but excludes an entire failed daily feed.), not the one in the question. The required evidence is: Confirmed duplicate rates fall without inappropriate merges of distinct customers.
D:Invalid dates are blocked at entry and legitimate exceptions are traceable. This would verify a different control (Bad dates are entered during onboarding and corrected only after monthly reporting failures.), not the one in the question. The required evidence is: Confirmed duplicate rates fall without inappropriate merges of distinct customers.
Question 851
A proposed shortcut is offered for this situation: A scorecard reports 99 percent valid rows but excludes an entire failed daily feed. Which choice is the CLEAREST mistake?
- Remove broken feeds from the denominator without disclosing the exclusion.
- Retain a rollback or recovery plan before making destructive data changes.
- Inspect lineage and source context before changing a derived report.
- Check that the proposed procedure has an identified operator and approval path.
Explanation
Correct Answer
A:Remove broken feeds from the denominator without disclosing the exclusion. A quality score can be misleading when its monitored population is incomplete. A sound response instead: Combine validity metrics with completeness of data delivery and denominator controls.
Incorrect Answers
B:Retain a rollback or recovery plan before making destructive data changes. Recoverability reduces the consequences of incorrect remediation. The case-specific response is: Combine validity metrics with completeness of data delivery and denominator controls.
C:Inspect lineage and source context before changing a derived report. Provenance analysis distinguishes source errors from transformations. The case-specific response is: Combine validity metrics with completeness of data delivery and denominator controls.
D:Check that the proposed procedure has an identified operator and approval path. Operational responsibility prevents undocumented workarounds. The case-specific response is: Combine validity metrics with completeness of data delivery and denominator controls.
Question 852
A governance committee needs a defensible plan and proof: Metadata lives in individual spreadsheets that differ on owners and field meanings. Which paired proposal is appropriate?
- Action: Collect operational metadata such as run timestamps, row counts and failure states. Verification: Owners detect late or failed loads using observable pipeline execution history.
- Action: Publish business metadata with precise glossary definitions and stewardship approval. Verification: Users understand the term and can link it to approved datasets and business rules.
- Action: Use a governed repository or catalog with stewardship workflows and controlled synchronization. Verification: A single discovery workflow retrieves consistent definitions and authoritative owners.
- Action: Classify metadata and restrict previews, samples and access to sensitive catalog fields. Verification: Unauthorized users see discovery descriptions but no confidential samples.
Explanation
Correct Answer
C:Action: Use a governed repository or catalog with stewardship workflows and controlled synchronization. Verification: A single discovery workflow retrieves consistent definitions and authoritative owners. Both the intervention and measurable outcome are directly relevant. A metadata repository supports shared, managed descriptions across assets.
Incorrect Answers
A:This plan addresses a different situation (A pipeline silently stopped after a weekend but no one tracks run status or freshness.), not the targeted problem. Here, action and evidence must match: Action: Use a governed repository or catalog with stewardship workflows and controlled synchronization.
B:This plan addresses a different situation (Analysts cannot tell whether customer_age means current age or age at first purchase.), not the targeted problem. Here, action and evidence must match: Action: Use a governed repository or catalog with stewardship workflows and controlled synchronization.
D:This plan addresses a different situation (A public catalog description reveals restricted patient identities in sample values.), not the targeted problem.
Question 853
Consider this organizational data problem: A customer table identifies rows by mutable email address, causing broken relationships after updates. What action is most defensible?
- Separate transitive department attributes into a referenced department relation.
- Apply naming, glossary mapping and controlled definitions to important model elements.
- Separate attributes dependent on only part of a composite key into their proper relation.
- Introduce a stable key and manage mutable natural identifiers as governed attributes.
Explanation
Correct Answer
D:Introduce a stable key and manage mutable natural identifiers as governed attributes. A stable primary key should preserve record identity across ordinary attribute changes. Evidence to obtain: Email changes leave entity identity and referencing foreign keys intact.
Incorrect Answers
A:Separate transitive department attributes into a referenced department relation. This response fits a separate situation (An employee table stores department name determined by department_id, causing inconsistent renames.), but does not resolve the stated case. The targeted response is: Introduce a stable key and manage mutable natural identifiers as governed attributes.
B:Apply naming, glossary mapping and controlled definitions to important model elements. This response fits a separate situation (Teams use inconsistent definitions for status and state across logical models.), but does not resolve the stated case. The targeted response is: Introduce a stable key and manage mutable natural identifiers as governed attributes.
C:Separate attributes dependent on only part of a composite key into their proper relation. This response fits a separate situation (A composite-key enrollment table repeats course title determined by course_id alone.), but does not resolve the stated case. The targeted response is: Introduce a stable key and manage mutable natural identifiers as governed attributes.
Question 854
An accountable team must correct this problem and prove results. Select TWO sound statements: A company keeps only the latest backup copy, leaving no way to recover before ransomware encryption.
- Shortcut: Overwrite the single backup each night and discard older versions.
- Verification: A pre-incident restore point survives attack and recovers clean data.
- Action: Plan compatibility tests, backup, failover or maintenance strategy and rollback verification.
- Verification: A simulated primary outage transfers service within the target and avoids unacceptable data loss.
- Action: Apply versioned, protected backups with retention, isolation and tested restore points.
Explanation
Correct Answers
B:Verification: A pre-incident restore point survives attack and recovers clean data. The observed result demonstrates whether the correction operates as intended. Recovery needs retained trustworthy recovery points as well as available replicas.
E:Action: Apply versioned, protected backups with retention, isolation and tested restore points. The proposed intervention targets the reported issue. Recovery needs retained trustworthy recovery points as well as available replicas.
Incorrect Answers
A:Shortcut: Overwrite the single backup each night and discard older versions. This shortcut is not a sound remediation. Recovery needs retained trustworthy recovery points as well as available replicas. The appropriate action is: Apply versioned, protected backups with retention, isolation and tested restore points.
C:This intervention is for a different scenario (A security patch must be applied to a data store with a strict availability commitment.), not the one stated. Appropriate action here: Apply versioned, protected backups with retention, isolation and tested restore points.
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: A pre-incident restore point survives attack and recovers clean data.
Question 855
A data management auditor evaluates this situation: One organization can be both a supplier and customer, but systems duplicate its legal entity per role. Which observable finding supports successful remediation?
- Rollups follow an approved hierarchy for each reporting period and reconcile to detail.
- The golden record uses the justified name and records competing values and sources.
- The organization links to multiple roles without conflating role-specific permissions.
- Consumers use supported versions and invalid currency codes trigger clear exceptions.
Explanation
Correct Answer
C:It tests the action: Model party identity separately from business roles and maintain role-specific attributes.
Incorrect Answers
A:Rollups follow an approved hierarchy for each reporting period and reconcile to detail. This would verify a different control (Sales cannot roll up revenue because the customer parent-child corporate hierarchy differs across reports.), not the one in the question. The required evidence is: The organization links to multiple roles without conflating role-specific permissions.
B:The golden record uses the justified name and records competing values and sources. This would verify a different control (Two customer sources disagree about legal name after one verifies recent government ID.), not the one in the question. The required evidence is: The organization links to multiple roles without conflating role-specific permissions.
D:Consumers use supported versions and invalid currency codes trigger clear exceptions. This would verify a different control (A mobile app uses a currency-code list six months older than the payments platform.), not the one in the question. The required evidence is: The organization links to multiple roles without conflating role-specific permissions.
Question 856
Which statement best describes the governing idea behind the response to this case: A regulatory metric cannot be reconciled to the systems that initially captured its values.
- Architecture must balance enterprise interoperability with local legal and operational constraints.
- Architecture flow maps make hidden dependencies and control points observable.
- There is no universally best data architecture; fitness depends on measurable constraints.
- Logical enterprise architecture clarifies shared meaning independently of vendor databases.
Explanation
Correct Answer
B:Architecture flow maps make hidden dependencies and control points observable. This concept explains the reason for the proposed control. Appropriate intervention: Create an end-to-end logical data flow mapping origin, processing, stores and consumers.
Incorrect Answers
A:This is a defensible principle in another context (A multinational has legal requirements to keep certain data local while enabling group analytics.), not the most relevant rationale here. For the stated issue: Architecture flow maps make hidden dependencies and control points observable.
C:This is a defensible principle in another context (An organization compares central warehouse, decentralized data products and a virtualization layer for analytics.), not the most relevant rationale here. For the stated issue: Architecture flow maps make hidden dependencies and control points observable.
D:Logical enterprise architecture clarifies shared meaning independently of vendor databases. This is a defensible principle in another context (Two departments use the term account for unrelated concepts and merge records incorrectly.), not the most relevant rationale here. For the stated issue: Architecture flow maps make hidden dependencies and control points observable.
Question 857
A data management auditor evaluates this situation: A bank intends to retire a reporting platform but has no inventory of upstream sources or dependencies. Which observable finding supports successful remediation?
- Architecture artifacts identify dependencies, gap owners and a credible migration path.
- Auditors can trace the metric through transformations and responsible systems.
- The selected pattern has recorded tradeoffs and meets representative end-to-end workload tests.
- Decision records show when a common pattern is followed and why exceptions are justified.
Explanation
Correct Answer
A:It tests the action: Model the current and target data states and a sequenced transition roadmap.
Incorrect Answers
B:Auditors can trace the metric through transformations and responsible systems. This would verify a different control (A regulatory metric cannot be reconciled to the systems that initially captured its values.), not the one in the question. The required evidence is: Architecture artifacts identify dependencies, gap owners and a credible migration path.
C:The selected pattern has recorded tradeoffs and meets representative end-to-end workload tests. This would verify a different control (An organization compares central warehouse, decentralized data products and a virtualization layer for analytics.), not the one in the question. The required evidence is: Architecture artifacts identify dependencies, gap owners and a credible migration path.
D:Decision records show when a common pattern is followed and why exceptions are justified. This would verify a different control (Project teams repeatedly pick conflicting data integration styles for identical business needs.), not the one in the question. The required evidence is: Architecture artifacts identify dependencies, gap owners and a credible migration path.
Question 858
Before changing procedures, the team investigates: A fraud team receives transaction events forty minutes after its five-minute alert deadline. Which review or test MOST directly locates the relevant failure?
- Inspect profiling SQL, population definitions and sampling coverage.
- Compare governed customer records with independently verified source evidence.
- Inspect event time, ingestion time and alert delivery distributions.
- Calculate required-field null rates by channel and review exception cases.
Explanation
Correct Answer
C:Inspect event time, ingestion time and alert delivery distributions. This test checks the relevant business and technical failure rather than assuming its cause. Timeliness is fitness of information at the required decision moment. Expected control result: End-to-end event latency meets the defined threshold for relevant transactions.
Incorrect Answers
A:Inspect profiling SQL, population definitions and sampling coverage. This check would investigate another issue (A data team wants to set quality targets before knowing null, duplicate and value distributions.), not the immediate case. The direct diagnostic is: Inspect event time, ingestion time and alert delivery distributions.
B:Compare governed customer records with independently verified source evidence. This check would investigate another issue (A customer's billing address is validly formatted but refers to a previous residence.), not the immediate case. The direct diagnostic is: Inspect event time, ingestion time and alert delivery distributions.
D:Calculate required-field null rates by channel and review exception cases. This check would investigate another issue (Loan applications often omit annual income even though policy requires it for underwriting.), not the immediate case. The direct diagnostic is: Inspect event time, ingestion time and alert delivery distributions.
Question 859
A proposed shortcut is offered for this situation: A team runs OCR on handwritten forms and loads extracted values directly into an account ledger. Which choice is the CLEAREST mistake?
- Inspect lineage and source context before changing a derived report.
- Treat every machine-extracted field as certain regardless of legibility.
- Check relevant business definitions before joining independently sourced data.
- Respect active legal holds before scheduling record disposition.
Explanation
Correct Answer
B:Treat every machine-extracted field as certain regardless of legibility. Extracted content is derived data whose accuracy and provenance require verification. A sound response instead: Validate extraction confidence and route uncertain fields to authorized human review.
Incorrect Answers
A:Inspect lineage and source context before changing a derived report. Provenance analysis distinguishes source errors from transformations. The case-specific response is: Validate extraction confidence and route uncertain fields to authorized human review.
C:Check relevant business definitions before joining independently sourced data. Semantic agreements prevent incorrect cross-system correlations. The case-specific response is: Validate extraction confidence and route uncertain fields to authorized human review.
D:Respect active legal holds before scheduling record disposition. Preservation duties may override scheduled destruction. The case-specific response is: Validate extraction confidence and route uncertain fields to authorized human review.
Question 860
A data analyst must confirm the cause of this issue: A published regulatory dashboard cannot explain why last month's total changed after a source correction. Which check provides the strongest diagnostic evidence?
- Check nonoverlapping effective windows and historical fact joins.
- Replay a prior reporting run using captured source and code versions.
- Simulate retry after partial failure and compare source/target completeness.
- Inspect dimension record count and description after controlled correction.
Explanation
Correct Answer
B:Replay a prior reporting run using captured source and code versions. This test checks the relevant business and technical failure rather than assuming its cause. Trusted BI requires reproducible metrics and transparent revision histories. Expected control result: Auditors reproduce the original total and explain the changed figure from documented inputs.
Incorrect Answers
A:Check nonoverlapping effective windows and historical fact joins. This check would investigate another issue (A salesperson moves territories and historical sales must remain attributed to prior territory.), not the immediate case. The direct diagnostic is: Replay a prior reporting run using captured source and code versions.
C:Simulate retry after partial failure and compare source/target completeness. This check would investigate another issue (A nightly warehouse load rereads the entire history and repeatedly misses its completion window.), not the immediate case. The direct diagnostic is: Replay a prior reporting run using captured source and code versions.
D:Inspect dimension record count and description after controlled correction. This check would investigate another issue (A product description contains a typo and historic analytics do not need the old spelling.), not the immediate case. The direct diagnostic is: Replay a prior reporting run using captured source and code versions.