CDMP DMF Practice Test 44
Question 430
A data steward examines this condition: Retail and service systems each assign different IDs to the same real-world customer. What concept best justifies the corrective approach?
- Master data management provides consistent core business entity views across systems.
- Golden-record construction applies business rules to conflicting source attributes.
- Reference data supplies standardized allowable values rather than individual business entities.
- Coexistence combines shared mastering with retained local application data maintenance.
Explanation
Correct Answer
A:Master data management provides consistent core business entity views across systems. This concept explains the reason for the proposed control. Appropriate intervention: Create a governed master-customer identity strategy with matching and cross-reference rules.
Incorrect Answers
B:Golden-record construction applies business rules to conflicting source attributes. This is a defensible principle in another context (Two customer sources disagree about legal name after one verifies recent government ID.), not the most relevant rationale here. For the stated issue: Master data management provides consistent core business entity views across systems.
C:This is a defensible principle in another context (Three regions encode country using names, ISO codes and private numeric lists.), not the most relevant rationale here.
D:Coexistence combines shared mastering with retained local application data maintenance. This is a defensible principle in another context (Business units need local writes but also expect synchronized approved enterprise attributes.), not the most relevant rationale here. For the stated issue: Master data management provides consistent core business entity views across systems.
Question 431
A business owner identifies this issue: An enterprise data model removes a field still used in multiple integration contracts. What is the MOST appropriate data management response?
- Model phone numbers as atomic repeating child records with appropriate identifiers.
- Perform versioned change impact analysis across physical schemas and consumers before rollout.
- Define entities, attributes, relationships, optionality and business keys in a logical model.
- Create a conceptual model of core business entities and relationships without implementation details.
Explanation
Correct Answer
B:Perform versioned change impact analysis across physical schemas and consumers before rollout. Data model evolution needs governed compatibility and dependency awareness. Evidence to obtain: Consumers migrate deliberately and production queries avoid unexpected breakage.
Incorrect Answers
A:Model phone numbers as atomic repeating child records with appropriate identifiers. This response fits a separate situation (A contact table stores three comma-separated telephone numbers in one column.), but does not resolve the stated case. The targeted response is: Perform versioned change impact analysis across physical schemas and consumers before rollout.
C:Define entities, attributes, relationships, optionality and business keys in a logical model. This response fits a separate situation (An enterprise needs rules for customer-to-contract cardinality without choosing a database product.), but does not resolve the stated case. The targeted response is: Perform versioned change impact analysis across physical schemas and consumers before rollout.
D:Create a conceptual model of core business entities and relationships without implementation details. This response fits a separate situation (Business stakeholders cannot agree which things should be treated as customers, accounts or products.), but does not resolve the stated case. The targeted response is: Perform versioned change impact analysis across physical schemas and consumers before rollout.
Question 432
A governance committee needs a defensible plan and proof: Bad dates are entered during onboarding and corrected only after monthly reporting failures. Which paired proposal is appropriate?
- Action: Add input validation with clear user feedback and exception override governance. Verification: Invalid dates are blocked at entry and legitimate exceptions are traceable.
- Action: Combine validity metrics with completeness of data delivery and denominator controls. Verification: Quality scores include expected records and flag unavailable populations.
- 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.
- Action: Run repeatable data profiling with representative population and documented limitations. Verification: The baseline includes measured distributions, anomalies and reliability of sampling.
Explanation
Correct Answer
A:Action: Add input validation with clear user feedback and exception override governance. Verification: Invalid dates are blocked at entry and legitimate exceptions are traceable. Both the intervention and measurable outcome are directly relevant. Preventive quality controls act earlier than downstream detective cleanup.
Incorrect Answers
B:This plan addresses a different situation (A scorecard reports 99 percent valid rows but excludes an entire failed daily feed.), not the targeted problem. Here, action and evidence must match: Action: Add input validation with clear user feedback and exception override governance.
C:This plan addresses a different situation (An invoice line appears without an invoice header after a partial load.), not the targeted problem. Here, action and evidence must match: Action: Add input validation with clear user feedback and exception override governance.
D:This plan addresses a different situation (A data team wants to set quality targets before knowing null, duplicate and value distributions.), not the targeted problem.
Question 433
Before changing procedures, the team investigates: A credit model has similar overall accuracy but rejects an underserved population disproportionately. Which review or test MOST directly locates the relevant failure?
- Attempt reidentification on samples and check masking transformations and access.
- Examine notice clarity, choice mechanisms, sensitive inferences and contestability.
- Inspect TLS negotiation, certificate trust and representative network capture.
- Compare subgroup error, approval rates, data quality and governance decisions.
Explanation
Correct Answer
D:Compare subgroup error, approval rates, data quality and governance decisions. This test checks the relevant business and technical failure rather than assuming its cause. Ethical analytics considers disparate impact and context beyond average model accuracy. Expected control result: Fairness metrics and decisions document identified disparities and corrective monitoring.
Incorrect Answers
A:Attempt reidentification on samples and check masking transformations and access. This check would investigate another issue (Test developers need representative orders but a test export includes real customer identity numbers.), not the immediate case. The direct diagnostic is: Compare subgroup error, approval rates, data quality and governance decisions.
B:Examine notice clarity, choice mechanisms, sensitive inferences and contestability. This check would investigate another issue (A firm builds individualized prices from personal browsing histories without meaningful customer explanation.), not the immediate case. The direct diagnostic is: Compare subgroup error, approval rates, data quality and governance decisions.
C:Inspect TLS negotiation, certificate trust and representative network capture. This check would investigate another issue (A service transfers customer attributes over unencrypted HTTP between data centers.), not the immediate case. The direct diagnostic is: Compare subgroup error, approval rates, data quality and governance decisions.
Question 434
A data steward examines this condition: An enterprise needs rules for customer-to-contract cardinality without choosing a database product. What concept best justifies the corrective approach?
- Logical modeling formalizes business data structure separate from storage technology.
- Naming standards improve understandability but must reflect precise meanings.
- Third normal form reduces non-key transitive dependencies and update anomalies.
- Temporal modeling preserves time-dependent truth needed for historical analysis.
Explanation
Correct Answer
A:Logical modeling formalizes business data structure separate from storage technology. This concept explains the reason for the proposed control. Appropriate intervention: Define entities, attributes, relationships, optionality and business keys in a logical model.
Incorrect Answers
B: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: Logical modeling formalizes business data structure separate from storage technology.
C:Third normal form reduces non-key transitive dependencies and update anomalies. This is a defensible principle in another context (An employee table stores department name determined by department_id, causing inconsistent renames.), not the most relevant rationale here. For the stated issue: Logical modeling formalizes business data structure separate from storage technology.
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: Logical modeling formalizes business data structure separate from storage technology.
Question 435
An accountable team must correct this problem and prove results. Select TWO sound statements: An order line references a product identifier that does not exist in the product table.
- Verification: Consumers migrate deliberately and production queries avoid unexpected breakage.
- Shortcut: Remove all foreign-key checks to allow broken transactions through.
- Verification: Invalid references are rejected or handled under an explicit business rule.
- Action: Create a conceptual model of core business entities and relationships without implementation details.
- Action: Enforce appropriate referential integrity and define valid deletion behavior.
Explanation
Correct Answers
C:Verification: Invalid references are rejected or handled under an explicit business rule. The observed result demonstrates whether the correction operates as intended. Foreign keys protect relationships between dependent and referenced entities.
E:Action: Enforce appropriate referential integrity and define valid deletion behavior. The proposed intervention targets the reported issue. Foreign keys protect relationships between dependent and referenced entities.
Incorrect Answers
A:Verification: Consumers migrate deliberately and production queries avoid unexpected breakage. This evidence is for a separate context (An enterprise data model removes a field still used in multiple integration contracts.), not this case. The valid outcome is: Invalid references are rejected or handled under an explicit business rule.
B:Shortcut: Remove all foreign-key checks to allow broken transactions through. This shortcut is not a sound remediation. Foreign keys protect relationships between dependent and referenced entities. The appropriate action is: Enforce appropriate referential integrity and define valid deletion behavior.
D:Action: Create a conceptual model of core business entities and relationships without implementation details. This intervention is for a different scenario (Business stakeholders cannot agree which things should be treated as customers, accounts or products.), not the one stated. Appropriate action here: Enforce appropriate referential integrity and define valid deletion behavior.
Question 436
After addressing this problem, what evidence would justify closure? Project teams repeatedly pick conflicting data integration styles for identical business needs.
- Decision records show when a common pattern is followed and why exceptions are justified.
- Conformance tests show field meanings and changes remain compatible with consuming systems.
- Auditors can trace the metric through transformations and responsible systems.
- Architecture decisions document common identifiers and approved exchange patterns across systems.
Explanation
Correct Answer
A:It tests the action: Create agreed architecture principles and review exceptions through a decision process.
Incorrect Answers
B:Conformance tests show field meanings and changes remain compatible with consuming systems. This would verify a different control (A team proposes proprietary event fields that cannot be interpreted by other platforms.), not the one in the question. The required evidence is: Decision records show when a common pattern is followed and why exceptions are justified.
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: Decision records show when a common pattern is followed and why exceptions are justified.
D:Architecture decisions document common identifiers and approved exchange patterns across systems. This would verify a different control (Customer identifiers differ across sales, billing and support, preventing consistent reporting.), not the one in the question. The required evidence is: Decision records show when a common pattern is followed and why exceptions are justified.
Question 437
A data steward challenges an assumption in this case: A customer platform needs low-latency updates without repeatedly scanning entire operational tables. Which verification should be performed first?
- Replay contract examples through old and new consumers and inspect validation failures.
- Compare source log positions, captured changes and target application results.
- Test source outages, federated query plans, data permissions and cache behavior.
- Check representative identifier mappings, exception cases and contract tests.
Explanation
Correct Answer
B:Compare source log positions, captured changes and target application results. This test checks the relevant business and technical failure rather than assuming its cause. CDC depends on correct change ordering and consumption state across failures. Expected control result: Changed rows propagate with acceptable lag and no missing or duplicate business effects.
Incorrect Answers
A:This check would investigate another issue (An upstream API changes a numeric customer status code into a text value and breaks consumers.), not the immediate case. The direct diagnostic is: Compare source log positions, captured changes and target application results.
C: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: Compare source log positions, captured changes and target application results.
D:Check representative identifier mappings, exception cases and contract tests. This check would investigate another issue (One interface calls a field supplier_id while another calls it vendor_code with different identifier rules.), not the immediate case. The direct diagnostic is: Compare source log positions, captured changes and target application results.
Question 438
Select TWO appropriate statements, one intervention and one verification, for this data management case: A team plans to remove a source column that feeds several dashboards and fraud rules.
- Action: Establish end-to-end field-level lineage covering sources, transforms and reports.
- Shortcut: Delete the column before checking whether any consumer uses it.
- Verification: Users get consistent results and invalid joins are rejected or flagged.
- Verification: Affected consumers are notified and changed logic passes compatibility tests.
- Action: Use dependency lineage to assess downstream impact and coordinate migration.
Explanation
Correct Answers
D:Verification: Affected consumers are notified and changed logic passes compatibility tests. The observed result demonstrates whether the correction operates as intended. Metadata dependency mapping enables informed change management.
E:Action: Use dependency lineage to assess downstream impact and coordinate migration. The proposed intervention targets the reported issue. Metadata dependency mapping enables informed change management.
Incorrect Answers
A:Action: Establish end-to-end field-level lineage covering sources, transforms and reports. This intervention is for a different scenario (A compliance report is wrong but no one knows which source change introduced the value.), not the one stated. Appropriate action here: Use dependency lineage to assess downstream impact and coordinate migration.
B:Shortcut: Delete the column before checking whether any consumer uses it. This shortcut is not a sound remediation. Metadata dependency mapping enables informed change management. The appropriate action is: Use dependency lineage to assess downstream impact and coordinate migration.
C:Verification: Users get consistent results and invalid joins are rejected or flagged. This evidence is for a separate context (Reports join unrelated entities because business dimensions lack a mapped semantic model.), not this case. The valid outcome is: Affected consumers are notified and changed logic passes compatibility tests.
Question 439
The data program reviews the following failure: A company has a general policy promising accurate data but no operational validation thresholds. Which change should be prioritized?
- Translate principles into measurable standards, owner responsibilities and repeatable procedures.
- Assess maturity against defined capabilities with artifacts, repeatable evidence and gaps.
- Map the regulation to governed policies, accountable controls and effective dates.
- Identify critical data elements according to material reporting, operational and risk impact.
Explanation
Correct Answer
A:Translate principles into measurable standards, owner responsibilities and repeatable procedures. Policies express intent; standards set rules and procedures define execution. Evidence to obtain: Teams implement specified checks and exception workflows tied to an approved policy.
Incorrect Answers
B:Assess maturity against defined capabilities with artifacts, repeatable evidence and gaps. This response fits a separate situation (A consultant rates governance mature from interview opinions without supporting operational evidence.), but does not resolve the stated case. The targeted response is: Translate principles into measurable standards, owner responsibilities and repeatable procedures.
C:Map the regulation to governed policies, accountable controls and effective dates. This response fits a separate situation (A new privacy requirement affects data collection across products but no governance owner tracks applicability.), but does not resolve the stated case. The targeted response is: Translate principles into measurable standards, owner responsibilities and repeatable procedures.
D:This response fits a separate situation (A governance team treats every data field as equally critical, overwhelming its controls program.), but does not resolve the stated case. Identify critical data elements according to material reporting, operational and risk impact.
Question 440
Before changing procedures, the team investigates: A customer changes region but analysts need sales under the region valid at each transaction date. Which review or test MOST directly locates the relevant failure?
- Test enrollments, composite uniqueness and independent student/course updates.
- Inspect subtype constraints, shared keys and invalid category combinations.
- Inspect effective windows, surrogate dimension keys and time-bound fact joins.
- Test updates to natural identifiers while inspecting referential consistency.
Explanation
Correct Answer
C:Inspect effective windows, surrogate dimension keys and time-bound fact joins. This test checks the relevant business and technical failure rather than assuming its cause. Temporal modeling preserves time-dependent truth needed for historical analysis. Expected control result: Historical sales continue to use the correct prior region while current records use the new one.
Incorrect Answers
A:Test enrollments, composite uniqueness and independent student/course updates. This check would investigate another issue (A student can enroll in many courses and a course can enroll many students.), not the immediate case. The direct diagnostic is: Inspect effective windows, surrogate dimension keys and time-bound fact joins.
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: Inspect effective windows, surrogate dimension keys and time-bound fact joins.
D:Test updates to natural identifiers while inspecting referential consistency. This check would investigate another issue (A customer table identifies rows by mutable email address, causing broken relationships after updates.), not the immediate case. The direct diagnostic is: Inspect effective windows, surrogate dimension keys and time-bound fact joins.