CDMP DMF Practice Test 65
Question 640
A data management auditor evaluates this situation: A service can tolerate one hour of data loss but must return within fifteen minutes of outage. Which observable finding supports successful remediation?
- A simulated primary outage transfers service within the target and avoids unacceptable data loss.
- A pre-incident restore point survives attack and recovers clean data.
- Recovery exercises meet both distinct time and data-loss targets.
- Expired eligible logs are deleted while hold-protected records remain preserved.
Explanation
Correct Answer
C:It tests the action: Define one-hour RPO and fifteen-minute RTO, then choose replication and recovery controls accordingly.
Incorrect Answers
A:A simulated primary outage transfers service within the target and avoids unacceptable data loss. This would verify a different control (A replica exists for critical reads but failover has never been validated.), not the one in the question. The required evidence is: Recovery exercises meet both distinct time and data-loss targets.
B:A pre-incident restore point survives attack and recovers clean data. This would verify a different control (A company keeps only the latest backup copy, leaving no way to recover before ransomware encryption.), not the one in the question. The required evidence is: Recovery exercises meet both distinct time and data-loss targets.
D:Expired eligible logs are deleted while hold-protected records remain preserved. This would verify a different control (Operational logs contain sensitive identifiers beyond the allowed retention period.), not the one in the question. The required evidence is: Recovery exercises meet both distinct time and data-loss targets.
Question 641
A proposed shortcut is offered for this situation: A repository mixes invoices, procedures and complaints under inconsistent free-text tags. Which choice is the CLEAREST mistake?
- Protect relevant audit records while investigating data problems.
- Separate short-term issue containment from durable root-cause correction.
- Validate critical changes against representative positive and negative examples.
- Allow every employee to invent incompatible classification terms without mapping.
Explanation
Correct Answer
D:Allow every employee to invent incompatible classification terms without mapping. Controlled classification improves discovery and consistent handling of unstructured assets. A sound response instead: Define a managed content taxonomy and classify documents using validated metadata.
Incorrect Answers
A:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Define a managed content taxonomy and classify documents using validated metadata.
B:Separate short-term issue containment from durable root-cause correction. An immediate workaround rarely proves the defect cannot recur. The case-specific response is: Define a managed content taxonomy and classify documents using validated metadata.
C:Validate critical changes against representative positive and negative examples. Controlled tests provide more reliable proof than untested assumptions. The case-specific response is: Define a managed content taxonomy and classify documents using validated metadata.
Question 642
A data steward examines this condition: Business stakeholders cannot agree which things should be treated as customers, accounts or products. What concept best justifies the corrective approach?
- Denormalization trades simpler reads for additional synchronization and anomaly risk.
- A stable primary key should preserve record identity across ordinary attribute changes.
- Conceptual models communicate business understanding before logical and physical detail.
- Data model evolution needs governed compatibility and dependency awareness.
Explanation
Correct Answer
C:Conceptual models communicate business understanding before logical and physical detail. This concept explains the reason for the proposed control. Appropriate intervention: Create a conceptual model of core business entities and relationships without implementation details.
Incorrect Answers
A:Denormalization trades simpler reads for additional synchronization and anomaly risk. This is a defensible principle in another context (A read-heavy dashboard suffers repeated expensive joins but operational source integrity is sound.), not the most relevant rationale here. For the stated issue: Conceptual models communicate business understanding before logical and physical detail.
B:This is a defensible principle in another context (A customer table identifies rows by mutable email address, causing broken relationships after updates.), not the most relevant rationale here. For the stated issue: Conceptual models communicate business understanding before logical and physical detail.
D:Data model evolution needs governed compatibility and dependency awareness. This is a defensible principle in another context (An enterprise data model removes a field still used in multiple integration contracts.), not the most relevant rationale here. For the stated issue: Conceptual models communicate business understanding before logical and physical detail.
Question 643
A data steward examines this condition: A database service is slow but monitoring records only whether its process is up. What concept best justifies the corrective approach?
- Database availability alone does not establish acceptable operational performance.
- A backup is not demonstrably useful until recoverability has been tested.
- Recovery needs retained trustworthy recovery points as well as available replicas.
- Storage operations changes require controlled rollout and recoverability.
Explanation
Correct Answer
A:Database availability alone does not establish acceptable operational performance. This concept explains the reason for the proposed control. Appropriate intervention: Add performance monitoring for query latency, locks, throughput and resource saturation.
Incorrect Answers
B:A backup is not demonstrably useful until recoverability has been tested. 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: Database availability alone does not establish acceptable operational performance.
C:This is a defensible principle in another context (A company keeps only the latest backup copy, leaving no way to recover before ransomware encryption.), not the most relevant rationale here. For the stated issue: Database availability alone does not establish acceptable operational performance.
D:Storage operations changes require controlled rollout and recoverability. This is a defensible principle in another context (A security patch must be applied to a data store with a strict availability commitment.), not the most relevant rationale here. For the stated issue: Database availability alone does not establish acceptable operational performance.
Question 644
Consider this data-management scenario: A retired system's catalog entries remain marked active, misleading new project teams. Which underlying principle MOST directly explains the preferred response?
- Semantic metadata bridges technical schemas and business interpretation.
- Metadata itself can contain sensitive values and requires access safeguards.
- Metadata must reflect the lifecycle of the assets it describes.
- Business metadata describes meaning, purpose, ownership and policy context.
Explanation
Correct Answer
C:Metadata must reflect the lifecycle of the assets it describes. This concept explains the reason for the proposed control. Appropriate intervention: Introduce active, deprecated and archived lifecycle states with accountable approval.
Incorrect Answers
A:Semantic metadata bridges technical schemas and business interpretation. This is a defensible principle in another context (Reports join unrelated entities because business dimensions lack a mapped semantic model.), not the most relevant rationale here. For the stated issue: Metadata must reflect the lifecycle of the assets it describes.
B:Metadata itself can contain sensitive values and requires access safeguards. This is a defensible principle in another context (A public catalog description reveals restricted patient identities in sample values.), not the most relevant rationale here. For the stated issue: Metadata must reflect the lifecycle of the assets it describes.
D:Business metadata describes meaning, purpose, ownership and policy context. This is a defensible principle in another context (Analysts cannot tell whether customer_age means current age or age at first purchase.), not the most relevant rationale here. For the stated issue: Metadata must reflect the lifecycle of the assets it describes.
Question 645
Select TWO appropriate statements, one intervention and one verification, for this data management case: Three systems record table creation dates in incompatible time zones and formats.
- Verification: Quality metrics identify stale records and verified repairs improve trust.
- Verification: Catalog times convert consistently with time zone and source provenance retained.
- Shortcut: Strip time zones and treat all dates as local without documentation.
- Action: Introduce active, deprecated and archived lifecycle states with accountable approval.
- Action: Define common timestamp semantics and metadata exchange conventions.
Explanation
Correct Answers
B:Verification: Catalog times convert consistently with time zone and source provenance retained. The observed result demonstrates whether the correction operates as intended. Interoperable metadata requires shared representations and semantics.
E:Action: Define common timestamp semantics and metadata exchange conventions. The proposed intervention targets the reported issue. Interoperable metadata requires shared representations and semantics.
Incorrect Answers
A:Verification: Quality metrics identify stale records and verified repairs improve trust. This evidence is for a separate context (A catalog lists every dataset but half of its owners and descriptions are outdated.), not this case. The valid outcome is: Catalog times convert consistently with time zone and source provenance retained.
C:Shortcut: Strip time zones and treat all dates as local without documentation. This shortcut is not a sound remediation. Interoperable metadata requires shared representations and semantics. The appropriate action is: Define common timestamp semantics and metadata exchange conventions.
D:Action: Introduce active, deprecated and archived lifecycle states with accountable approval. This intervention is for a different scenario (A retired system's catalog entries remain marked active, misleading new project teams.), not the one stated. Appropriate action here: Define common timestamp semantics and metadata exchange conventions.
Question 646
A reviewer asks for proof of improvement: Customer identifiers differ across sales, billing and support, preventing consistent reporting. Which result MOST convincingly demonstrates that the control works?
- Architecture decisions document common identifiers and approved exchange patterns across systems.
- An approved logical model distinguishes party, agreement and financial account semantics.
- Auditors can trace the metric through transformations and responsible systems.
- Decision records show when a common pattern is followed and why exceptions are justified.
Explanation
Correct Answer
A:It tests the action: Publish target enterprise data architecture with shared identity principles and integration boundaries.
Incorrect Answers
B:An approved logical model distinguishes party, agreement and financial account semantics. This would verify a different control (Two departments use the term account for unrelated concepts and merge records incorrectly.), not the one in the question. The required evidence is: Architecture decisions document common identifiers and approved exchange patterns across systems.
C: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 decisions document common identifiers and approved exchange patterns across systems.
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 decisions document common identifiers and approved exchange patterns across systems.
Question 647
The data program reviews the following failure: A service can tolerate one hour of data loss but must return within fifteen minutes of outage. Which change should be prioritized?
- Plan compatibility tests, backup, failover or maintenance strategy and rollback verification.
- Add performance monitoring for query latency, locks, throughput and resource saturation.
- Define one-hour RPO and fifteen-minute RTO, then choose replication and recovery controls accordingly.
- Monitor growth, plan capacity headroom and tune storage before outage.
Explanation
Correct Answer
C:Define one-hour RPO and fifteen-minute RTO, then choose replication and recovery controls accordingly. RPO limits acceptable data loss while RTO limits acceptable service downtime. Evidence to obtain: Recovery exercises meet both distinct time and data-loss targets.
Incorrect Answers
A:Plan compatibility tests, backup, failover or maintenance strategy and rollback verification. This response fits a separate situation (A security patch must be applied to a data store with a strict availability commitment.), but does not resolve the stated case. The targeted response is: Define one-hour RPO and fifteen-minute RTO, then choose replication and recovery controls accordingly.
B:Add performance monitoring for query latency, locks, throughput and resource saturation. This response fits a separate situation (A database service is slow but monitoring records only whether its process is up.), but does not resolve the stated case. The targeted response is: Define one-hour RPO and fifteen-minute RTO, then choose replication and recovery controls accordingly.
D:Monitor growth, plan capacity headroom and tune storage before outage. This response fits a separate situation (A database approaches disk exhaustion during a seasonal reporting surge.), but does not resolve the stated case. The targeted response is: Define one-hour RPO and fifteen-minute RTO, then choose replication and recovery controls accordingly.
Question 648
Select TWO appropriate statements, one intervention and one verification, for this data management case: Analysts cannot tell whether customer_age means current age or age at first purchase.
- Verification: Users understand the term and can link it to approved datasets and business rules.
- Action: Define approved semantic relationships, metric calculations and valid join paths.
- Verification: Representative searches surface approved datasets and disclose archival alternatives.
- Action: Publish business metadata with precise glossary definitions and stewardship approval.
- Shortcut: Assume the column label supplies an unambiguous definition.
Explanation
Correct Answers
A:Verification: Users understand the term and can link it to approved datasets and business rules. The observed result demonstrates whether the correction operates as intended. Business metadata describes meaning, purpose, ownership and policy context.
D:Action: Publish business metadata with precise glossary definitions and stewardship approval. The proposed intervention targets the reported issue. Business metadata describes meaning, purpose, ownership and policy context.
Incorrect Answers
B:Action: Define approved semantic relationships, metric calculations and valid join paths. This intervention is for a different scenario (Reports join unrelated entities because business dimensions lack a mapped semantic model.), not the one stated. Appropriate action here: Publish business metadata with precise glossary definitions and stewardship approval.
C:This evidence is for a separate context (Users search for a customer dataset but see dozens of unlabeled backups ahead of certified sources.), not this case.
E:Shortcut: Assume the column label supplies an unambiguous definition. This shortcut is not a sound remediation. Business metadata describes meaning, purpose, ownership and policy context. The appropriate action is: Publish business metadata with precise glossary definitions and stewardship approval.
Question 649
A reviewer asks for proof of improvement: Finance and sales marts use different definitions of product category for the same item. Which result MOST convincingly demonstrates that the control works?
- Department reports reconcile common customer and product metrics.
- Cross-mart comparisons reconcile categories for equivalent reporting periods.
- Both dashboards compute equivalent values for the same period and exclusions.
- Historical reports reconcile and are insulated from irrelevant transactional changes.
Explanation
Correct Answer
B:It tests the action: Publish a conformed product dimension with agreed business categories and history rules.
Incorrect Answers
A:Department reports reconcile common customer and product metrics. This would verify a different control (Business units create separate departmental marts from inconsistent extracts of customer master data.), not the one in the question. The required evidence is: Cross-mart comparisons reconcile categories for equivalent reporting periods.
C:Both dashboards compute equivalent values for the same period and exclusions. This would verify a different control (Two executive dashboards both show profit margin but use different numerator adjustments.), not the one in the question. The required evidence is: Cross-mart comparisons reconcile categories for equivalent reporting periods.
D:Historical reports reconcile and are insulated from irrelevant transactional changes. This would verify a different control (Executives need consistent historical revenue despite frequent transactional schema changes.), not the one in the question. The required evidence is: Cross-mart comparisons reconcile categories for equivalent reporting periods.
Question 650
Consider this data-management scenario: A team proposes proprietary event fields that cannot be interpreted by other platforms. Which underlying principle MOST directly explains the preferred response?
- Data architecture provides enterprise-wide direction for how data is structured and flows.
- Standards reduce integration ambiguity when implementations use different technologies.
- Architecture must balance enterprise interoperability with local legal and operational constraints.
- Logical enterprise architecture clarifies shared meaning independently of vendor databases.
Explanation
Correct Answer
B:Standards reduce integration ambiguity when implementations use different technologies. This concept explains the reason for the proposed control. Appropriate intervention: Define canonical field semantics and versioned interface contracts with consumers.
Incorrect Answers
A:Data architecture provides enterprise-wide direction for how data is structured and flows. This is a defensible principle in another context (Customer identifiers differ across sales, billing and support, preventing consistent reporting.), not the most relevant rationale here. For the stated issue: Standards reduce integration ambiguity when implementations use different technologies.
C: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: Standards reduce integration ambiguity when implementations use different technologies.
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: Standards reduce integration ambiguity when implementations use different technologies.