CDMP DMF Practice Test 85
Question 840
A data management auditor evaluates this situation: Two customer sources disagree about legal name after one verifies recent government ID. Which observable finding supports successful remediation?
- Rollups follow an approved hierarchy for each reporting period and reconcile to detail.
- Applications resolve one trusted customer identity while retaining source identifiers.
- Each approved update follows the master service and downstream consumers receive consistent versions.
- The golden record uses the justified name and records competing values and sources.
Explanation
Correct Answer
D:It tests the action: Define survivorship rules that favor verified recent evidence with traceable provenance.
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 golden record uses the justified name and records competing values and sources.
B:Applications resolve one trusted customer identity while retaining source identifiers. This would verify a different control (Retail and service systems each assign different IDs to the same real-world customer.), not the one in the question. The required evidence is: The golden record uses the justified name and records competing values and sources.
C:Each approved update follows the master service and downstream consumers receive consistent versions. This would verify a different control (A new platform requires all customer master updates to occur through one governed service.), not the one in the question. The required evidence is: The golden record uses the justified name and records competing values and sources.
Question 841
A data steward challenges an assumption in this case: An unauthorized service account downloads a large restricted dataset overnight. Which verification should be performed first?
- Review anomalous access logs, credential exposure, response records and retention.
- Inspect storage encryption status, key access logs and a restoration test.
- Inspect classification lineage, access grants and unauthorized read attempts.
- Test different identities through both dashboards and direct data access paths.
Explanation
Correct Answer
A:Review anomalous access logs, credential exposure, response records and retention. This test checks the relevant business and technical failure rather than assuming its cause. Data security incidents require containment, evidence and accountable escalation. Expected control result: Investigation records affected datasets, containment, timeline and obligations.
Incorrect Answers
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: Review anomalous access logs, credential exposure, response records and retention.
C: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 anomalous access logs, credential exposure, response records and retention.
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: Review anomalous access logs, credential exposure, response records and retention.
Question 842
After addressing this problem, what evidence would justify closure? A nightly warehouse load rereads the entire history and repeatedly misses its completion window.
- Run duration falls while incremental totals match the authoritative source.
- The invoice appears in the appropriate business period with reconciliation and audit history.
- Frequent monthly queries speed up while aggregates remain current and correct.
- Reports slice measures consistently by conformed dimension attributes.
Explanation
Correct Answer
A:It tests the action: Implement incremental extraction with reliable change checkpoints and periodic full reconciliation.
Incorrect Answers
B:The invoice appears in the appropriate business period with reconciliation and audit history. This would verify a different control (A vendor invoice from last month arrives after the monthly warehouse close.), not the one in the question. The required evidence is: Run duration falls while incremental totals match the authoritative source.
C:Frequent monthly queries speed up while aggregates remain current and correct. This would verify a different control (A star-schema dashboard query repeatedly scans granular facts for the same monthly totals.), not the one in the question. The required evidence is: Run duration falls while incremental totals match the authoritative source.
D:Reports slice measures consistently by conformed dimension attributes. This would verify a different control (Business users need to analyze order revenue by date, product and geography.), not the one in the question. The required evidence is: Run duration falls while incremental totals match the authoritative source.
Question 843
Consider this data-management scenario: A service can tolerate one hour of data loss but must return within fifteen minutes of outage. Which underlying principle MOST directly explains the preferred response?
- A backup is not demonstrably useful until recoverability has been tested.
- RPO limits acceptable data loss while RTO limits acceptable service downtime.
- Storage operations need proactive capacity management, not crisis-only expansion.
- Database availability alone does not establish acceptable operational performance.
Explanation
Correct Answer
B:RPO limits acceptable data loss while RTO limits acceptable service downtime. This concept explains the reason for the proposed control. Appropriate intervention: Define one-hour RPO and fifteen-minute RTO, then choose replication and recovery controls accordingly.
Incorrect Answers
A:This is a defensible principle in another context (A production database has daily backups but no successful restore has been performed.), not the most relevant rationale here. For the stated issue: RPO limits acceptable data loss while RTO limits acceptable service downtime.
C: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: RPO limits acceptable data loss while RTO limits acceptable service downtime.
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: RPO limits acceptable data loss while RTO limits acceptable service downtime.
Question 844
A data analyst must confirm the cause of this issue: Operational logs contain sensitive identifiers beyond the allowed retention period. Which check provides the strongest diagnostic evidence?
- Inspect backup immutability, retention history and recovery point selection.
- Inspect retention settings, held records, deletion jobs and audit evidence.
- Inspect slow query logs, wait statistics, resource metrics and alert history.
- Review disk growth curves, peak utilization and maintenance approvals.
Explanation
Correct Answer
B:Inspect retention settings, held records, deletion jobs and audit evidence. This test checks the relevant business and technical failure rather than assuming its cause. Operational retention should satisfy business, privacy and preservation obligations. Expected control result: Expired eligible logs are deleted while hold-protected records remain preserved.
Incorrect Answers
A:Inspect backup immutability, retention history and recovery point selection. This check would investigate another issue (A company keeps only the latest backup copy, leaving no way to recover before ransomware encryption.), not the immediate case. The direct diagnostic is: Inspect retention settings, held records, deletion jobs and audit evidence.
C:Inspect slow query logs, wait statistics, resource metrics and alert history. This check would investigate another issue (A database service is slow but monitoring records only whether its process is up.), not the immediate case. The direct diagnostic is: Inspect retention settings, held records, deletion jobs and audit evidence.
D:Review disk growth curves, peak utilization and maintenance approvals. This check would investigate another issue (A database approaches disk exhaustion during a seasonal reporting surge.), not the immediate case. The direct diagnostic is: Inspect retention settings, held records, deletion jobs and audit evidence.
Question 845
In reviewing this data risk, select the LEAST defensible practice: A new organizational hierarchy update accidentally makes Division A the parent of itself through B.
- Respect active legal holds before scheduling record disposition.
- Allow cyclic hierarchies and assume reporting engines can infer the intent.
- Keep approved reference mappings versioned and traceable.
- Verify a new interface using a controlled sample and reconciliation.
Explanation
Correct Answer
B:Allow cyclic hierarchies and assume reporting engines can infer the intent. This is the unsafe shortcut because it ignores the control logic. Master relationship governance must enforce structural integrity constraints. A sound response instead: Validate hierarchy acyclicity, permitted parents and effective dates before publishing.
Incorrect Answers
A:Respect active legal holds before scheduling record disposition. Preservation duties may override scheduled destruction. The case-specific response is: Validate hierarchy acyclicity, permitted parents and effective dates before publishing.
C:Keep approved reference mappings versioned and traceable. Value meaning can change across time and applications. The case-specific response is: Validate hierarchy acyclicity, permitted parents and effective dates before publishing.
D:Verify a new interface using a controlled sample and reconciliation. Testing reveals mismatches before broad deployment. The case-specific response is: Validate hierarchy acyclicity, permitted parents and effective dates before publishing.
Question 846
A governance review considers the following: An analytics team reuses location records collected for delivery tracking to infer employees' medical visits. Which proposal would create an avoidable risk?
- Retain a rollback or recovery plan before making destructive data changes.
- Define the intended data population before interpreting quality percentages.
- Assume employment status makes every personal inference acceptable.
- Inspect lineage and source context before changing a derived report.
Explanation
Correct Answer
C:Assume employment status makes every personal inference acceptable. Ethical data handling asks whether a use is fair and justified even when technically possible. A sound response instead: Evaluate the new use against purpose, notice, proportionality and potential harm before access.
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: Evaluate the new use against purpose, notice, proportionality and potential harm before access.
B:Define the intended data population before interpreting quality percentages. An undisclosed denominator can make strong scores misleading. The case-specific response is: Evaluate the new use against purpose, notice, proportionality and potential harm before access.
D:Inspect lineage and source context before changing a derived report. Provenance analysis distinguishes source errors from transformations. The case-specific response is: Evaluate the new use against purpose, notice, proportionality and potential harm before access.
Question 847
A governance review considers the following: A dashboard shows revenue increasing sharply because source currency values are mixed without conversion. Which proposal would create an avoidable risk?
- Monitor control outcomes after deployment rather than relying only on design intent.
- Keep approved reference mappings versioned and traceable.
- Sum numeric amounts across currencies without conversions or labels.
- Validate critical changes against representative positive and negative examples.
Explanation
Correct Answer
C:Sum numeric amounts across currencies without conversions or labels. Analytical measures must use consistent units and time context. A sound response instead: Apply consistent currency conversion rules with effective rates and labeled units.
Incorrect Answers
A: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: Apply consistent currency conversion rules with effective rates and labeled units.
B:Keep approved reference mappings versioned and traceable. Value meaning can change across time and applications. The case-specific response is: Apply consistent currency conversion rules with effective rates and labeled units.
D:Validate critical changes against representative positive and negative examples. Controlled tests provide more reliable proof than untested assumptions. The case-specific response is: Apply consistent currency conversion rules with effective rates and labeled units.
Question 848
A data analyst must confirm the cause of this issue: Leadership receives the total number of stewardship meetings as the sole effectiveness KPI. Which check provides the strongest diagnostic evidence?
- Compare claimed maturity with audit samples, repeatability and control operation.
- Review obligation mapping, dates, exception handling and control-testing records.
- Trace a policy requirement to a standard, test procedure and evidence artifact.
- Compare outcome baselines, escalation rates and business decision consequences.
Explanation
Correct Answer
D:Compare outcome baselines, escalation rates and business decision consequences. This test checks the relevant business and technical failure rather than assuming its cause. Governance effectiveness is measured by outcomes rather than meeting frequency. Expected control result: The scorecard demonstrates measurable improvement and flags unresolved control failures.
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: Compare outcome baselines, escalation rates and business decision consequences.
B:Review obligation mapping, dates, exception handling and control-testing records. This check would investigate another issue (A new privacy requirement affects data collection across products but no governance owner tracks applicability.), not the immediate case. The direct diagnostic is: Compare outcome baselines, escalation rates and business decision consequences.
C:Trace a policy requirement to a standard, test procedure and evidence artifact. This check would investigate another issue (A company has a general policy promising accurate data but no operational validation thresholds.), not the immediate case. The direct diagnostic is: Compare outcome baselines, escalation rates and business decision consequences.
Question 849
A data management auditor evaluates this situation: A registration field is blank, but downstream calculations treat unknown age as zero. Which observable finding supports successful remediation?
- Renaming a department updates one authoritative record without conflicting employee copies.
- Unknown values remain distinguishable from legitimate zero and inappropriate imputations are flagged.
- Historical sales continue to use the correct prior region while current records use the new one.
- Each number is independently searchable and maintained without string parsing.
Explanation
Correct Answer
B:It tests the action: Represent missingness according to explicit semantic rules and validate downstream behavior.
Incorrect Answers
A:Renaming a department updates one authoritative record without conflicting employee copies. This would verify a different control (An employee table stores department name determined by department_id, causing inconsistent renames.), not the one in the question. The required evidence is: Unknown values remain distinguishable from legitimate zero and inappropriate imputations are flagged.
C:Historical sales continue to use the correct prior region while current records use the new one. This would verify a different control (A customer changes region but analysts need sales under the region valid at each transaction date.), not the one in the question. The required evidence is: Unknown values remain distinguishable from legitimate zero and inappropriate imputations are flagged.
D:Each number is independently searchable and maintained without string parsing. This would verify a different control (A contact table stores three comma-separated telephone numbers in one column.), not the one in the question. The required evidence is: Unknown values remain distinguishable from legitimate zero and inappropriate imputations are flagged.
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.