CDMP DMF Practice Test 1
Question 1
A proposed shortcut is offered for this situation: Operational logs contain sensitive identifiers beyond the allowed retention period. Which choice is the CLEAREST mistake?
- Monitor control outcomes after deployment rather than relying only on design intent.
- Validate critical changes against representative positive and negative examples.
- Keep all log copies indefinitely without review or documented exception.
- Protect relevant audit records while investigating data problems.
Explanation
Correct Answer
C:Keep all log copies indefinitely without review or documented exception. Operational retention should satisfy business, privacy and preservation obligations. A sound response instead: Implement scheduled retention with legal holds, access controls and verifiable deletion.
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: Implement scheduled retention with legal holds, access controls and verifiable deletion.
B:Validate critical changes against representative positive and negative examples. Controlled tests provide more reliable proof than untested assumptions. The case-specific response is: Implement scheduled retention with legal holds, access controls and verifiable deletion.
D:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Implement scheduled retention with legal holds, access controls and verifiable deletion.
Question 2
The data management team encounters this situation: A credit model has similar overall accuracy but rejects an underserved population disproportionately. Which intervention BEST addresses the actual problem?
- Evaluate the new use against purpose, notice, proportionality and potential harm before access.
- Test subgroup outcomes, data representativeness and remediations with accountable review.
- Revoke relevant access, preserve evidence, assess scope and follow incident notification policy.
- Enforce row-level security using authoritative user-to-region mapping.
Explanation
Correct Answer
B:Test subgroup outcomes, data representativeness and remediations with accountable review. Ethical analytics considers disparate impact and context beyond average model accuracy. Evidence to obtain: Fairness metrics and decisions document identified disparities and corrective monitoring.
Incorrect Answers
A:This response fits a separate situation (An analytics team reuses location records collected for delivery tracking to infer employees' medical visits.), but does not resolve the stated case.
C:Revoke relevant access, preserve evidence, assess scope and follow incident notification policy. This response fits a separate situation (An unauthorized service account downloads a large restricted dataset overnight.), but does not resolve the stated case. The targeted response is: Test subgroup outcomes, data representativeness and remediations with accountable review.
D:Enforce row-level security using authoritative user-to-region mapping. This response fits a separate situation (Regional sales managers can query all customer records despite regional authorization rules.), but does not resolve the stated case. The targeted response is: Test subgroup outcomes, data representativeness and remediations with accountable review.
Question 3
A governance review considers the following: Employees cannot find approved procedures because files lack titles, tags and indexed text. Which proposal would create an avoidable risk?
- Retain a rollback or recovery plan before making destructive data changes.
- Validate critical changes against representative positive and negative examples.
- Increase repository capacity without fixing discoverability.
- Preserve source evidence and document why any exception was approved.
Explanation
Correct Answer
C:Increase repository capacity without fixing discoverability. Enterprise content discoverability depends on metadata and indexing quality. A sound response instead: Improve indexing, controlled metadata, search relevance and authoritative-source labeling.
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: Improve indexing, controlled metadata, search relevance and authoritative-source labeling.
B:Validate critical changes against representative positive and negative examples. Controlled tests provide more reliable proof than untested assumptions. The case-specific response is: Improve indexing, controlled metadata, search relevance and authoritative-source labeling.
D:Preserve source evidence and document why any exception was approved. Traceability enables independent review of exceptions. The case-specific response is: Improve indexing, controlled metadata, search relevance and authoritative-source labeling.
Question 4
The data program reviews the following failure: Customer identifiers differ across sales, billing and support, preventing consistent reporting. Which change should be prioritized?
- Assess patterns against consistency, latency, autonomy, cost, governance and security needs.
- Use a federated architecture with governed metadata and lawful cross-border access patterns.
- Agree enterprise-level business concepts and relationships before mapping physical application schemas.
- Publish target enterprise data architecture with shared identity principles and integration boundaries.
Explanation
Correct Answer
D:Publish target enterprise data architecture with shared identity principles and integration boundaries. Data architecture provides enterprise-wide direction for how data is structured and flows. Evidence to obtain: Architecture decisions document common identifiers and approved exchange patterns across systems.
Incorrect Answers
A:This response fits a separate situation (An organization compares central warehouse, decentralized data products and a virtualization layer for analytics.), but does not resolve the stated case. Assess patterns against consistency, latency, autonomy, cost, governance and security needs.
B:This response fits a separate situation (A multinational has legal requirements to keep certain data local while enabling group analytics.), but does not resolve the stated case. Use a federated architecture with governed metadata and lawful cross-border access patterns.
C:This response fits a separate situation (Two departments use the term account for unrelated concepts and merge records incorrectly.), but does not resolve the stated case. Agree enterprise-level business concepts and relationships before mapping physical application schemas.
Question 5
A data steward examines this condition: Sales cannot roll up revenue because the customer parent-child corporate hierarchy differs across reports. What concept best justifies the corrective approach?
- Master data management provides consistent core business entity views across systems.
- Centralized mastering makes the hub the system of entry for core entity changes.
- Master data includes controlled relationships and hierarchies, not only flat attributes.
- Reference-data changes can alter meaning across time and require controlled versions.
Explanation
Correct Answer
C:Master data includes controlled relationships and hierarchies, not only flat attributes. This concept explains the reason for the proposed control. Appropriate intervention: Govern effective-dated entity relationships and hierarchy ownership.
Incorrect Answers
A:This is a defensible principle in another context (Retail and service systems each assign different IDs to the same real-world customer.), not the most relevant rationale here. For the stated issue: Master data includes controlled relationships and hierarchies, not only flat attributes.
B:This is a defensible principle in another context (A new platform requires all customer master updates to occur through one governed service.), not the most relevant rationale here. For the stated issue: Master data includes controlled relationships and hierarchies, not only flat attributes.
D:This is a defensible principle in another context (A product taxonomy changes in January but last year's reports must preserve prior category assignments.), not the most relevant rationale here. For the stated issue: Master data includes controlled relationships and hierarchies, not only flat attributes.
Question 6
Which statement best describes the governing idea behind the response to this case: An enterprise data model removes a field still used in multiple integration contracts.
- Data model evolution needs governed compatibility and dependency awareness.
- Many-to-many relationships are implemented using associative structures in relational designs.
- Cardinality and optionality encode business relationship constraints.
- Naming standards improve understandability but must reflect precise meanings.
Explanation
Correct Answer
A:Data model evolution needs governed compatibility and dependency awareness. This concept explains the reason for the proposed control. Appropriate intervention: Perform versioned change impact analysis across physical schemas and consumers before rollout.
Incorrect Answers
B:Many-to-many relationships are implemented using associative structures in relational designs. This is a defensible principle in another context (A student can enroll in many courses and a course can enroll many students.), not the most relevant rationale here. For the stated issue: Data model evolution needs governed compatibility and dependency awareness.
C:Cardinality and optionality encode business relationship constraints. This is a defensible principle in another context (A model incorrectly allows each order to have many unrelated customer owners.), not the most relevant rationale here. For the stated issue: Data model evolution needs governed compatibility and dependency awareness.
D:Naming standards improve understandability but must reflect precise meanings. This is a defensible principle in another context (Teams use inconsistent definitions for status and state across logical models.), not the most relevant rationale here. For the stated issue: Data model evolution needs governed compatibility and dependency awareness.
Question 7
Select TWO appropriate statements, one intervention and one verification, for this data management case: An invoice line appears without an invoice header after a partial load.
- Action: Apply referential integrity or explicit orphan reconciliation across source and target.
- Verification: Every accepted line references a valid invoice or has an owned exception.
- Verification: A sampled comparison confirms the stored address reflects current real-world facts.
- Action: Evaluate quality against the specific consumer's required provenance and interpretability.
- Shortcut: Ignore orphan lines because their monetary amounts look plausible.
Explanation
Correct Answers
A:Action: Apply referential integrity or explicit orphan reconciliation across source and target. The proposed intervention targets the reported issue. Integrity preserves valid relationships and structural constraints.
B:Verification: Every accepted line references a valid invoice or has an owned exception. The observed result demonstrates whether the correction operates as intended. Integrity preserves valid relationships and structural constraints.
Incorrect Answers
C:Verification: A sampled comparison confirms the stored address reflects current real-world facts. This evidence is for a separate context (A customer's billing address is validly formatted but refers to a previous residence.), not this case. The valid outcome is: Every accepted line references a valid invoice or has an owned exception.
D:Action: Evaluate quality against the specific consumer's required provenance and interpretability. This intervention is for a different scenario (A scientific dataset has fine precision but lacks metadata required for the regulator's audit.), not the one stated. Appropriate action here: Apply referential integrity or explicit orphan reconciliation across source and target.
E:Shortcut: Ignore orphan lines because their monetary amounts look plausible. This shortcut is not a sound remediation. Integrity preserves valid relationships and structural constraints. The appropriate action is: Apply referential integrity or explicit orphan reconciliation across source and target.
Question 8
Which statement best describes the governing idea behind the response to this case: A postal address field is 100 percent complete but several entries are no longer current.
- High performance on one data-quality dimension does not establish overall fitness.
- Integrity preserves valid relationships and structural constraints.
- Completeness measures presence of required information for a defined purpose.
- Data-quality issue processes should prioritize consequential defects and accountable response.
Explanation
Correct Answer
A:High performance on one data-quality dimension does not establish overall fitness. This concept explains the reason for the proposed control. Appropriate intervention: Assess completeness and timeliness separately, then choose remediation based on use.
Incorrect Answers
B:Integrity preserves valid relationships and structural constraints. This is a defensible principle in another context (An invoice line appears without an invoice header after a partial load.), not the most relevant rationale here. For the stated issue: High performance on one data-quality dimension does not establish overall fitness.
C:This is a defensible principle in another context (Loan applications often omit annual income even though policy requires it for underwriting.), not the most relevant rationale here. For the stated issue: High performance on one data-quality dimension does not establish overall fitness.
D:Data-quality issue processes should prioritize consequential defects and accountable response. This is a defensible principle in another context (High-impact reconciliation defects are buried among hundreds of cosmetic warnings.), not the most relevant rationale here. For the stated issue: High performance on one data-quality dimension does not establish overall fitness.
Question 9
Consider this organizational data problem: A party table mixes person birthdate with organization registration number, leaving ambiguous rules. What action is most defensible?
- Separate attributes dependent on only part of a composite key into their proper relation.
- Enforce appropriate referential integrity and define valid deletion behavior.
- Use a common party supertype with justified person and organization subtypes.
- Apply naming, glossary mapping and controlled definitions to important model elements.
Explanation
Correct Answer
C:Use a common party supertype with justified person and organization subtypes. Subtype modeling represents common identity while preserving different business attributes. Evidence to obtain: Shared identity fields are unified and subtype-specific validation is enforced.
Incorrect Answers
A: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. Separate attributes dependent on only part of a composite key into their proper relation.
B:This response fits a separate situation (An order line references a product identifier that does not exist in the product table.), but does not resolve the stated case. Enforce appropriate referential integrity and define valid deletion behavior.
D: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: Use a common party supertype with justified person and organization subtypes.
Question 10
A data steward examines this condition: Two customer sources disagree about legal name after one verifies recent government ID. What concept best justifies the corrective approach?
- Consolidation offers a harmonized downstream master view without mandatory operational writeback.
- Registry MDM can manage identity linkage without necessarily storing all mastered attributes.
- Entity resolution must balance false positive merges against missed duplicates.
- Golden-record construction applies business rules to conflicting source attributes.
Explanation
Correct Answer
D:Golden-record construction applies business rules to conflicting source attributes. This concept explains the reason for the proposed control. Appropriate intervention: Define survivorship rules that favor verified recent evidence with traceable provenance.
Incorrect Answers
A:This is a defensible principle in another context (A company wants a central analytical customer view while operational systems continue owning updates.), not the most relevant rationale here. For the stated issue: Golden-record construction applies business rules to conflicting source attributes.
B:This is a defensible principle in another context (Several applications retain their own customer stores but need a shared identity index.), not the most relevant rationale here. For the stated issue: Golden-record construction applies business rules to conflicting source attributes.
C:This is a defensible principle in another context (A matching algorithm merges a parent and child solely because they share surname and address.), not the most relevant rationale here. For the stated issue: Golden-record construction applies business rules to conflicting source attributes.