CDMP DMF Practice Test 82
Question 810
A governance committee needs a defensible plan and proof: An automated seven-year purge is about to remove correspondence covered by an active litigation hold. Which paired proposal is appropriate?
- Action: Suspend disposition for in-scope content until an authorized hold release is recorded. Verification: Held content survives purge jobs and hold decisions have a traceable case reference.
- 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: Validate extraction confidence and route uncertain fields to authorized human review. Verification: Reconciled records document original images, reviewed exceptions and corrected values.
- Action: Use controlled document versioning with approval, access and supersession metadata. Verification: Users find the currently approved policy and earlier revisions remain traceable.
Explanation
Correct Answer
A:Action: Suspend disposition for in-scope content until an authorized hold release is recorded. Verification: Held content survives purge jobs and hold decisions have a traceable case reference. Both the intervention and measurable outcome are directly relevant. Legal holds can override routine retention disposition for specified records.
Incorrect Answers
B:This plan addresses a different situation (A repository mixes invoices, procedures and complaints under inconsistent free-text tags.), not the targeted problem.
C: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: Suspend disposition for in-scope content until an authorized hold release is recorded.
D:This plan addresses a different situation (Staff collaborate on a policy but several copied files are called final and no approved version is clear.), not the targeted problem. Here, action and evidence must match: Action: Suspend disposition for in-scope content until an authorized hold release is recorded.
Question 811
After addressing this problem, what evidence would justify closure? Raw clickstream files are dumped into an object store without ownership, schema or discovery metadata.
- Changed rows propagate with acceptable lag and no missing or duplicate business effects.
- Consumers can discover trustworthy datasets and distinguish approved from abandoned assets.
- The fraud service receives timely events while tax reporting reconciles its complete batch.
- Staging access is restricted, audit logged and temporary files expire as approved.
Explanation
Correct Answer
B:It tests the action: Introduce ingestion metadata, dataset ownership, cataloging and quality checks for the lake.
Incorrect Answers
A:Changed rows propagate with acceptable lag and no missing or duplicate business effects. This would verify a different control (A customer platform needs low-latency updates without repeatedly scanning entire operational tables.), not the one in the question. The required evidence is: Consumers can discover trustworthy datasets and distinguish approved from abandoned assets.
C:The fraud service receives timely events while tax reporting reconciles its complete batch. This would verify a different control (A daily tax report and a live fraud decision service share one nightly transfer mechanism.), not the one in the question. The required evidence is: Consumers can discover trustworthy datasets and distinguish approved from abandoned assets.
D:Staging access is restricted, audit logged and temporary files expire as approved. This would verify a different control (A file-transfer integration includes confidential customer attributes in an unsecured staging bucket.), not the one in the question. The required evidence is: Consumers can discover trustworthy datasets and distinguish approved from abandoned assets.
Question 812
Consider this data-management scenario: A read-heavy dashboard suffers repeated expensive joins but operational source integrity is sound. Which underlying principle MOST directly explains the preferred response?
- Null can denote absent or unknown information and is not automatically a numeric zero.
- Denormalization trades simpler reads for additional synchronization and anomaly risk.
- Conceptual models communicate business understanding before logical and physical detail.
- Temporal modeling preserves time-dependent truth needed for historical analysis.
Explanation
Correct Answer
B:Denormalization trades simpler reads for additional synchronization and anomaly risk. This concept explains the reason for the proposed control. Appropriate intervention: Consider controlled denormalization with refresh ownership and reconciliation.
Incorrect Answers
A:This is a defensible principle in another context (A registration field is blank, but downstream calculations treat unknown age as zero.), not the most relevant rationale here. For the stated issue: Denormalization trades simpler reads for additional synchronization and anomaly risk.
C:This is a defensible principle in another context (Business stakeholders cannot agree which things should be treated as customers, accounts or products.), not the most relevant rationale here. For the stated issue: Denormalization trades simpler reads for additional synchronization and anomaly risk.
D:This is a defensible principle in another context (A customer changes region but analysts need sales under the region valid at each transaction date.), not the most relevant rationale here. For the stated issue: Denormalization trades simpler reads for additional synchronization and anomaly risk.
Question 813
A data analyst must confirm the cause of this issue: Analysts cannot tell whether customer_age means current age or age at first purchase. Which check provides the strongest diagnostic evidence?
- Compare live database schema with harvested metadata and review tasks.
- Inspect business glossary entries, owners and sample semantic interpretation.
- Test catalog search and preview using low-privilege identities.
- Inspect column-level lineage graph and controlled schema change tests.
Explanation
Correct Answer
B:Inspect business glossary entries, owners and sample semantic interpretation. This test checks the relevant business and technical failure rather than assuming its cause. Business metadata describes meaning, purpose, ownership and policy context. Expected control result: Users understand the term and can link it to approved datasets and business rules.
Incorrect Answers
A:Compare live database schema with harvested metadata and review tasks. This check would investigate another issue (A source database gains fields but the catalog schema remains unchanged for months.), not the immediate case. The direct diagnostic is: Inspect business glossary entries, owners and sample semantic interpretation.
C: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: Inspect business glossary entries, owners and sample semantic interpretation.
D: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: Inspect business glossary entries, owners and sample semantic interpretation.
Question 814
A data analyst must confirm the cause of this issue: A file-transfer integration includes confidential customer attributes in an unsecured staging bucket. Which check provides the strongest diagnostic evidence?
- Test source outages, federated query plans, data permissions and cache behavior.
- Compare source watermarks, late-arrival counts and target reconciliation results.
- Inspect transfer encryption, bucket permissions, retention and operational logs.
- Compare source log positions, captured changes and target application results.
Explanation
Correct Answer
C:Inspect transfer encryption, bucket permissions, retention and operational logs. This test checks the relevant business and technical failure rather than assuming its cause. Integration pipelines create new security exposure at movement and landing points. Expected control result: Staging access is restricted, audit logged and temporary files expire as approved.
Incorrect Answers
A:Test source outages, federated query plans, data permissions and cache behavior. This check would investigate another issue (An organization wants live access to distributed records without copying every source table.), not the immediate case. The direct diagnostic is: Inspect transfer encryption, bucket permissions, retention and operational logs.
B:Compare source watermarks, late-arrival counts and target reconciliation results. This check would investigate another issue (Finance reports omit transactions because an extraction job silently skips late-arriving records.), not the immediate case. The direct diagnostic is: Inspect transfer encryption, bucket permissions, retention and operational logs.
D:Compare source log positions, captured changes and target application results. This check would investigate another issue (A customer platform needs low-latency updates without repeatedly scanning entire operational tables.), not the immediate case. The direct diagnostic is: Inspect transfer encryption, bucket permissions, retention and operational logs.
Question 815
A data steward challenges an assumption in this case: A new privacy requirement affects data collection across products but no governance owner tracks applicability. Which verification should be performed first?
- Review governance charter, ownership map and approved definition changes.
- Review obligation mapping, dates, exception handling and control-testing records.
- Trace metric definition versions, impacted reports and approval history.
- Check that catalog ownership links to actual issue decisions and approved definitions.
Explanation
Correct Answer
B:Review obligation mapping, dates, exception handling and control-testing records. This test checks the relevant business and technical failure rather than assuming its cause. Regulatory obligations need explicit translation into controlled operating practice. Expected control result: A legal obligation register connects affected datasets to owners, tests and evidence.
Incorrect Answers
A:Review governance charter, ownership map and approved definition changes. This check would investigate another issue (Two departments disagree about the authoritative definition of an active customer and neither can decide.), not the immediate case. The direct diagnostic is: Review obligation mapping, dates, exception handling and control-testing records.
C: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: Review obligation mapping, dates, exception handling and control-testing records.
D: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 obligation mapping, dates, exception handling and control-testing records.
Question 816
For this situation, which combined intervention and validation MOST directly addresses the issue? A service can tolerate one hour of data loss but must return within fifteen minutes of outage.
- Action: Evaluate query plans and appropriate indexes while considering write and storage overhead. Verification: Representative query time improves without unacceptable ingestion regression.
- Action: Apply versioned, protected backups with retention, isolation and tested restore points. Verification: A pre-incident restore point survives attack and recovers clean data.
- Action: Test a recovery using approved backups and validate application data consistency. Verification: The restored service meets recovery objectives and critical transactions reconcile.
- Action: Define one-hour RPO and fifteen-minute RTO, then choose replication and recovery controls accordingly. Verification: Recovery exercises meet both distinct time and data-loss targets.
Explanation
Correct Answer
D:Action: Define one-hour RPO and fifteen-minute RTO, then choose replication and recovery controls accordingly. Verification: Recovery exercises meet both distinct time and data-loss targets. Both the intervention and measurable outcome are directly relevant. RPO limits acceptable data loss while RTO limits acceptable service downtime.
Incorrect Answers
A:This plan addresses a different situation (A report scans millions of rows although its date filter is selective and frequent.), not the targeted problem. Here, action and evidence must match: Action: Define one-hour RPO and fifteen-minute RTO, then choose replication and recovery controls accordingly.
B:This plan addresses a different situation (A company keeps only the latest backup copy, leaving no way to recover before ransomware encryption.), not the targeted problem. Here, action and evidence must match: Action: Define one-hour RPO and fifteen-minute RTO, then choose replication and recovery controls accordingly.
C:This plan addresses a different situation (A production database has daily backups but no successful restore has been performed.), not the targeted problem. Here, action and evidence must match: Action: Define one-hour RPO and fifteen-minute RTO, then choose replication and recovery controls accordingly.
Question 817
A data steward challenges an assumption in this case: Regional sales managers can query all customer records despite regional authorization rules. Which verification should be performed first?
- Test different identities through both dashboards and direct data access paths.
- Perform a permitted test export and trace it through retained security logs.
- Compare requested fields with campaign needs and recipient entitlements.
- Review anomalous access logs, credential exposure, response records and retention.
Explanation
Correct Answer
A:Test different identities through both dashboards and direct data access paths. This test checks the relevant business and technical failure rather than assuming its cause. Row-level controls enforce instance-specific access beyond coarse table grants. Expected control result: An authorized manager sees own-region rows and cannot access other regions.
Incorrect Answers
B:Perform a permitted test export and trace it through retained security logs. This check would investigate another issue (Privileged database exports are possible but no one records who initiated them.), not the immediate case. The direct diagnostic is: Test different identities through both dashboards and direct data access paths.
C: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: Test different identities through both dashboards and direct data access paths.
D: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: Test different identities through both dashboards and direct data access paths.
Question 818
A data analyst must confirm the cause of this issue: A customer table identifies rows by mutable email address, causing broken relationships after updates. Which check provides the strongest diagnostic evidence?
- Inspect relation structure and test adding or removing a single number.
- Inspect effective windows, surrogate dimension keys and time-bound fact joins.
- Test updates to natural identifiers while inspecting referential consistency.
- Inspect logical relationships, cardinalities and valid business-key examples.
Explanation
Correct Answer
C:Test updates to natural identifiers while inspecting referential consistency. This test checks the relevant business and technical failure rather than assuming its cause. A stable primary key should preserve record identity across ordinary attribute changes. Expected control result: Email changes leave entity identity and referencing foreign keys intact.
Incorrect Answers
A:Inspect relation structure and test adding or removing a single number. This check would investigate another issue (A contact table stores three comma-separated telephone numbers in one column.), not the immediate case. The direct diagnostic is: Test updates to natural identifiers while inspecting referential consistency.
B:Inspect effective windows, surrogate dimension keys and time-bound fact joins. This check would investigate another issue (A customer changes region but analysts need sales under the region valid at each transaction date.), not the immediate case. The direct diagnostic is: Test updates to natural identifiers while inspecting referential consistency.
D:Inspect logical relationships, cardinalities and valid business-key examples. This check would investigate another issue (An enterprise needs rules for customer-to-contract cardinality without choosing a database product.), not the immediate case. The direct diagnostic is: Test updates to natural identifiers while inspecting referential consistency.
Question 819
Consider this data-management scenario: Employees cannot find approved procedures because files lack titles, tags and indexed text. Which underlying principle MOST directly explains the preferred response?
- Enterprise content discoverability depends on metadata and indexing quality.
- Controlled classification improves discovery and consistent handling of unstructured assets.
- Legal holds can override routine retention disposition for specified records.
- Extracted content is derived data whose accuracy and provenance require verification.
Explanation
Correct Answer
A:Enterprise content discoverability depends on metadata and indexing quality. This concept explains the reason for the proposed control. Appropriate intervention: Improve indexing, controlled metadata, search relevance and authoritative-source labeling.
Incorrect Answers
B:Controlled classification improves discovery and consistent handling of unstructured assets. This is a defensible principle in another context (A repository mixes invoices, procedures and complaints under inconsistent free-text tags.), not the most relevant rationale here. For the stated issue: Enterprise content discoverability depends on metadata and indexing quality.
C:This is a defensible principle in another context (An automated seven-year purge is about to remove correspondence covered by an active litigation hold.), not the most relevant rationale here. For the stated issue: Enterprise content discoverability depends on metadata and indexing quality.
D: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: Enterprise content discoverability depends on metadata and indexing quality.
Question 820
A reviewer asks for proof of improvement: A public catalog description reveals restricted patient identities in sample values. Which result MOST convincingly demonstrates that the control works?
- Reports cite approved term versions and consumers can identify differences.
- Unauthorized users see discovery descriptions but no confidential samples.
- Catalog times convert consistently with time zone and source provenance retained.
- A single discovery workflow retrieves consistent definitions and authoritative owners.
Explanation
Correct Answer
B:It tests the action: Classify metadata and restrict previews, samples and access to sensitive catalog fields.
Incorrect Answers
A:Reports cite approved term versions and consumers can identify differences. This would verify a different control (A term called revenue means gross receipts in one team and net receipts in another.), not the one in the question. The required evidence is: Unauthorized users see discovery descriptions but no confidential samples.
C:Catalog times convert consistently with time zone and source provenance retained. This would verify a different control (Three systems record table creation dates in incompatible time zones and formats.), not the one in the question. The required evidence is: Unauthorized users see discovery descriptions but no confidential samples.
D:A single discovery workflow retrieves consistent definitions and authoritative owners. This would verify a different control (Metadata lives in individual spreadsheets that differ on owners and field meanings.), not the one in the question. The required evidence is: Unauthorized users see discovery descriptions but no confidential samples.