CDMP DMF Practice Test 73
Question 720
A data analyst must confirm the cause of this issue: An order line references a product identifier that does not exist in the product table. Which check provides the strongest diagnostic evidence?
- Attempt controlled orphan inserts and verify configured delete behavior.
- Inspect subtype constraints, shared keys and invalid category combinations.
- Review concept definitions and stakeholders' interpretation of entity relationships.
- Review model annotations, glossary bindings and conflict-resolution decisions.
Explanation
Correct Answer
A:Attempt controlled orphan inserts and verify configured delete behavior. This test checks the relevant business and technical failure rather than assuming its cause. Foreign keys protect relationships between dependent and referenced entities. Expected control result: Invalid references are rejected or handled under an explicit business rule.
Incorrect Answers
B:Inspect subtype constraints, shared keys and invalid category combinations. This check would investigate another issue (A party table mixes person birthdate with organization registration number, leaving ambiguous rules.), not the immediate case. The direct diagnostic is: Attempt controlled orphan inserts and verify configured delete behavior.
C:Review concept definitions and stakeholders' interpretation of entity relationships. This check would investigate another issue (Business stakeholders cannot agree which things should be treated as customers, accounts or products.), not the immediate case. The direct diagnostic is: Attempt controlled orphan inserts and verify configured delete behavior.
D:Review model annotations, glossary bindings and conflict-resolution decisions. This check would investigate another issue (Teams use inconsistent definitions for status and state across logical models.), not the immediate case. The direct diagnostic is: Attempt controlled orphan inserts and verify configured delete behavior.
Question 721
A governance review considers the following: Marketing and finance disagree on who approves supplier legal entity identifiers. Which proposal would create an avoidable risk?
- Protect relevant audit records while investigating data problems.
- Let vendors choose final enterprise supplier identity rules without governance.
- Separate short-term issue containment from durable root-cause correction.
- Apply access controls proportional to the sensitivity of business information.
Explanation
Correct Answer
B:Let vendors choose final enterprise supplier identity rules without governance. Master-data stewardship needs business authority for accepted entity definitions. A sound response instead: Assign a data owner and stewardship process for supplier master definitions and changes.
Incorrect Answers
A:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Assign a data owner and stewardship process for supplier master definitions and changes.
C:Separate short-term issue containment from durable root-cause correction. An immediate workaround rarely proves the defect cannot recur. The case-specific response is: Assign a data owner and stewardship process for supplier master definitions and changes.
D:Apply access controls proportional to the sensitivity of business information. Confidentiality obligations still apply during quality improvements. The case-specific response is: Assign a data owner and stewardship process for supplier master definitions and changes.
Question 722
A governance review considers the following: Contract PDFs are retained indefinitely after business use with no destruction rules. Which proposal would create an avoidable risk?
- Retain a rollback or recovery plan before making destructive data changes.
- Monitor control outcomes after deployment rather than relying only on design intent.
- Check that the proposed procedure has an identified operator and approval path.
- Delete records whenever storage pressure rises without checking legal duties.
Explanation
Correct Answer
D:Delete records whenever storage pressure rises without checking legal duties. Document and content management governs unstructured information across its lifecycle. A sound response instead: Classify documents and apply approved creation, review, retention, archive and disposal procedures.
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: Classify documents and apply approved creation, review, retention, archive and disposal procedures.
B: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: Classify documents and apply approved creation, review, retention, archive and disposal procedures.
C:Check that the proposed procedure has an identified operator and approval path. Operational responsibility prevents undocumented workarounds. The case-specific response is: Classify documents and apply approved creation, review, retention, archive and disposal procedures.
Question 723
A business owner identifies this issue: Operational logs contain sensitive identifiers beyond the allowed retention period. What is the MOST appropriate data management response?
- Design and test failover, client reconnection and replica consistency under representative faults.
- Evaluate query plans and appropriate indexes while considering write and storage overhead.
- Test a recovery using approved backups and validate application data consistency.
- Implement scheduled retention with legal holds, access controls and verifiable deletion.
Explanation
Correct Answer
D:Implement scheduled retention with legal holds, access controls and verifiable deletion. Operational retention should satisfy business, privacy and preservation obligations. Evidence to obtain: Expired eligible logs are deleted while hold-protected records remain preserved.
Incorrect Answers
A:Design and test failover, client reconnection and replica consistency under representative faults.
B:Evaluate query plans and appropriate indexes while considering write and storage overhead. This response fits a separate situation (A report scans millions of rows although its date filter is selective and frequent.), but does not resolve the stated case. The targeted response is: Implement scheduled retention with legal holds, access controls and verifiable deletion.
C:This response fits a separate situation (A production database has daily backups but no successful restore has been performed.), but does not resolve the stated case. Test a recovery using approved backups and validate application data consistency.
Question 724
Which statement best describes the governing idea behind the response to this case: A security patch must be applied to a data store with a strict availability commitment.
- Recovery needs retained trustworthy recovery points as well as available replicas.
- Storage operations changes require controlled rollout and recoverability.
- Database availability alone does not establish acceptable operational performance.
- Storage operations need proactive capacity management, not crisis-only expansion.
Explanation
Correct Answer
B:Storage operations changes require controlled rollout and recoverability. This concept explains the reason for the proposed control. Appropriate intervention: Plan compatibility tests, backup, failover or maintenance strategy and rollback verification.
Incorrect Answers
A: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: Storage operations changes require controlled rollout and recoverability.
C:Database availability alone does not establish acceptable operational performance. 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: Storage operations changes require controlled rollout and recoverability.
D: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: Storage operations changes require controlled rollout and recoverability.
Question 725
A data steward examines this condition: Executives need consistent historical revenue despite frequent transactional schema changes. What concept best justifies the corrective approach?
- Incremental loads reduce cost but depend on correct change tracking and recovery.
- A consistent fact grain is required for correct dimensional aggregation.
- A warehouse supports integrated historical analysis distinct from operational transactions.
- Conformed dimensions enable consistent analyses across multiple facts and marts.
Explanation
Correct Answer
C:A warehouse supports integrated historical analysis distinct from operational transactions. This concept explains the reason for the proposed control. Appropriate intervention: Build governed analytical integration and conformed business measures for reporting.
Incorrect Answers
A:This is a defensible principle in another context (A nightly warehouse load rereads the entire history and repeatedly misses its completion window.), not the most relevant rationale here. For the stated issue: A warehouse supports integrated historical analysis distinct from operational transactions.
B:A consistent fact grain is required for correct dimensional aggregation. This is a defensible principle in another context (A sales fact table mixes shipment-level and order-line-level amounts, doubling totals.), not the most relevant rationale here. For the stated issue: A warehouse supports integrated historical analysis distinct from operational transactions.
D:This is a defensible principle in another context (Finance and sales marts use different definitions of product category for the same item.), not the most relevant rationale here.
Question 726
A data management auditor evaluates this situation: Marketing and finance disagree on who approves supplier legal entity identifiers. Which observable finding supports successful remediation?
- Known duplicate test cases are flagged while legitimate similar companies remain distinct.
- Consumers use supported versions and invalid currency codes trigger clear exceptions.
- Change requests are approved by an accountable owner and validated before distribution.
- Verified false merges decrease without unacceptable missed true matches.
Explanation
Correct Answer
C:It tests the action: Assign a data owner and stewardship process for supplier master definitions and changes.
Incorrect Answers
A:Known duplicate test cases are flagged while legitimate similar companies remain distinct. This would verify a different control (New customer onboarding creates a second record when spacing differs in a business name.), not the one in the question. The required evidence is: Change requests are approved by an accountable owner and validated before distribution.
B: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: Change requests are approved by an accountable owner and validated before distribution.
D:Verified false merges decrease without unacceptable missed true matches. This would verify a different control (A matching algorithm merges a parent and child solely because they share surname and address.), not the one in the question. The required evidence is: Change requests are approved by an accountable owner and validated before distribution.
Question 727
A governance review considers the following: A product status field contains values archived and disabled although only active and retired are approved. Which proposal would create an avoidable risk?
- Check that the proposed procedure has an identified operator and approval path.
- Treat a plausible spelling as valid regardless of the approved code set.
- Retain a rollback or recovery plan before making destructive data changes.
- Keep approved reference mappings versioned and traceable.
Explanation
Correct Answer
B:Treat a plausible spelling as valid regardless of the approved code set. Validity measures conformance to allowed formats, domains and business rules. A sound response instead: Enforce governed domain rules at ingestion and monitor invalid values.
Incorrect Answers
A:Check that the proposed procedure has an identified operator and approval path. Operational responsibility prevents undocumented workarounds. The case-specific response is: Enforce governed domain rules at ingestion and monitor invalid values.
C:Retain a rollback or recovery plan before making destructive data changes. Recoverability reduces the consequences of incorrect remediation. The case-specific response is: Enforce governed domain rules at ingestion and monitor invalid values.
D:Keep approved reference mappings versioned and traceable. Value meaning can change across time and applications. The case-specific response is: Enforce governed domain rules at ingestion and monitor invalid values.
Question 728
The data program reviews the following failure: A security patch must be applied to a data store with a strict availability commitment. Which change should be prioritized?
- Define one-hour RPO and fifteen-minute RTO, then choose replication and recovery controls accordingly.
- Test a recovery using approved backups and validate application data consistency.
- Evaluate query plans and appropriate indexes while considering write and storage overhead.
- Plan compatibility tests, backup, failover or maintenance strategy and rollback verification.
Explanation
Correct Answer
D:Plan compatibility tests, backup, failover or maintenance strategy and rollback verification. Storage operations changes require controlled rollout and recoverability. Evidence to obtain: Patched instances pass regression checks without violating availability constraints.
Incorrect Answers
A:Define one-hour RPO and fifteen-minute RTO, then choose replication and recovery controls accordingly. This response fits a separate situation (A service can tolerate one hour of data loss but must return within fifteen minutes of outage.), but does not resolve the stated case. The targeted response is: Plan compatibility tests, backup, failover or maintenance strategy and rollback verification.
B:Test a recovery using approved backups and validate application data consistency. This response fits a separate situation (A production database has daily backups but no successful restore has been performed.), but does not resolve the stated case. The targeted response is: Plan compatibility tests, backup, failover or maintenance strategy and rollback verification.
C:Evaluate query plans and appropriate indexes while considering write and storage overhead. This response fits a separate situation (A report scans millions of rows although its date filter is selective and frequent.), but does not resolve the stated case. The targeted response is: Plan compatibility tests, backup, failover or maintenance strategy and rollback verification.
Question 729
An accountable team must correct this problem and prove results. Select TWO sound statements: Two departments disagree about the authoritative definition of an active customer and neither can decide.
- Action: Integrate governance decisions and stewardship workflows with technology support.
- Shortcut: Ask a database administrator to impose a business definition without consultation.
- Action: Assign policy decision rights to a business data owner with steward-led coordination.
- Verification: The exception has a named owner, time limit and independently monitored mitigation.
- Verification: An approved definition, accountable owner and escalation path resolve cross-team disagreements.
Explanation
Correct Answers
C:Action: Assign policy decision rights to a business data owner with steward-led coordination. The proposed intervention targets the reported issue. Data governance establishes authority and accountability for data decisions.
E:Verification: An approved definition, accountable owner and escalation path resolve cross-team disagreements. The observed result demonstrates whether the correction operates as intended. Data governance establishes authority and accountability for data decisions.
Incorrect Answers
A:Action: Integrate governance decisions and stewardship workflows with technology support. This intervention is for a different scenario (A catalog tool identifies data owners but cannot force them to decide disputed definitions.), not the one stated. Appropriate action here: Assign policy decision rights to a business data owner with steward-led coordination.
B:Shortcut: Ask a database administrator to impose a business definition without consultation. This shortcut is not a sound remediation. Data governance establishes authority and accountability for data decisions. The appropriate action is: Assign policy decision rights to a business data owner with steward-led coordination.
D:Verification: The exception has a named owner, time limit and independently monitored mitigation. This evidence is for a separate context (A business requests a temporary deviation from a sensitive data retention standard.), not this case. The valid outcome is: An approved definition, accountable owner and escalation path resolve cross-team disagreements.
Question 730
An accountable team must correct this problem and prove results. Select TWO sound statements: Loan applications often omit annual income even though policy requires it for underwriting.
- Action: Publish reusable data-quality rules with owners, thresholds and exceptions.
- Shortcut: Call the application complete when an optional comments box has any text.
- Verification: The proportion of applications with credible required income rises under a defined rule.
- Action: Measure required-field completeness and introduce appropriate collection checkpoints.
- Verification: Every accepted line references a valid invoice or has an owned exception.
Explanation
Correct Answers
C:Verification: The proportion of applications with credible required income rises under a defined rule. The observed result demonstrates whether the correction operates as intended. Completeness measures presence of required information for a defined purpose.
D:Action: Measure required-field completeness and introduce appropriate collection checkpoints. The proposed intervention targets the reported issue. Completeness measures presence of required information for a defined purpose.
Incorrect Answers
A:Action: Publish reusable data-quality rules with owners, thresholds and exceptions. This intervention is for a different scenario (Different pipelines enforce different allowable values for the same governed country field.), not the one stated. Appropriate action here: Measure required-field completeness and introduce appropriate collection checkpoints.
B:Shortcut: Call the application complete when an optional comments box has any text. This shortcut is not a sound remediation. Completeness measures presence of required information for a defined purpose. The appropriate action is: Measure required-field completeness and introduce appropriate collection checkpoints.
E:This evidence is for a separate context (An invoice line appears without an invoice header after a partial load.), not this case.