CDMP DMF Practice Test 50
Question 490
The data program reviews the following failure: An employee table stores department name determined by department_id, causing inconsistent renames. Which change should be prioritized?
- Enforce appropriate referential integrity and define valid deletion behavior.
- Separate transitive department attributes into a referenced department relation.
- Define correct one-to-many customer-to-order cardinality and mandatory participation.
- Use a common party supertype with justified person and organization subtypes.
Explanation
Correct Answer
B:Separate transitive department attributes into a referenced department relation. Third normal form reduces non-key transitive dependencies and update anomalies. Evidence to obtain: Renaming a department updates one authoritative record without conflicting employee copies.
Incorrect Answers
A:Enforce appropriate referential integrity and define valid deletion behavior. 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. The targeted response is: Separate transitive department attributes into a referenced department relation.
C:Define correct one-to-many customer-to-order cardinality and mandatory participation. This response fits a separate situation (A model incorrectly allows each order to have many unrelated customer owners.), but does not resolve the stated case. The targeted response is: Separate transitive department attributes into a referenced department relation.
D:Use a common party supertype with justified person and organization subtypes. This response fits a separate situation (A party table mixes person birthdate with organization registration number, leaving ambiguous rules.), but does not resolve the stated case. The targeted response is: Separate transitive department attributes into a referenced department relation.
Question 491
After addressing this problem, what evidence would justify closure? An order line references a product identifier that does not exist in the product table.
- Enrolments are uniquely recorded without duplicate student or course entities.
- Invalid references are rejected or handled under an explicit business rule.
- The logical model expresses cardinality and integrity rules independent of vendor syntax.
- Unknown values remain distinguishable from legitimate zero and inappropriate imputations are flagged.
Explanation
Correct Answer
B:It tests the action: Enforce appropriate referential integrity and define valid deletion behavior.
Incorrect Answers
A:Enrolments are uniquely recorded without duplicate student or course entities. This would verify a different control (A student can enroll in many courses and a course can enroll many students.), not the one in the question. The required evidence is: Invalid references are rejected or handled under an explicit business rule.
C:The logical model expresses cardinality and integrity rules independent of vendor syntax. This would verify a different control (An enterprise needs rules for customer-to-contract cardinality without choosing a database product.), not the one in the question. The required evidence is: Invalid references are rejected or handled under an explicit business rule.
D:Unknown values remain distinguishable from legitimate zero and inappropriate imputations are flagged. This would verify a different control (A registration field is blank, but downstream calculations treat unknown age as zero.), not the one in the question. The required evidence is: Invalid references are rejected or handled under an explicit business rule.
Question 492
For this situation, which combined intervention and validation MOST directly addresses the issue? An enterprise needs rules for customer-to-contract cardinality without choosing a database product.
- Action: Enforce appropriate referential integrity and define valid deletion behavior. Verification: Invalid references are rejected or handled under an explicit business rule.
- Action: Use a common party supertype with justified person and organization subtypes. Verification: Shared identity fields are unified and subtype-specific validation is enforced.
- Action: Define entities, attributes, relationships, optionality and business keys in a logical model. Verification: The logical model expresses cardinality and integrity rules independent of vendor syntax.
- Action: Introduce a stable key and manage mutable natural identifiers as governed attributes. Verification: Email changes leave entity identity and referencing foreign keys intact.
Explanation
Correct Answer
C:Action: Define entities, attributes, relationships, optionality and business keys in a logical model. Verification: The logical model expresses cardinality and integrity rules independent of vendor syntax. Both the intervention and measurable outcome are directly relevant. Logical modeling formalizes business data structure separate from storage technology.
Incorrect Answers
A:This plan addresses a different situation (An order line references a product identifier that does not exist in the product table.), not the targeted problem. Here, action and evidence must match: Action: Define entities, attributes, relationships, optionality and business keys in a logical model.
B:This plan addresses a different situation (A party table mixes person birthdate with organization registration number, leaving ambiguous rules.), not the targeted problem. Here, action and evidence must match: Action: Define entities, attributes, relationships, optionality and business keys in a logical model.
D:This plan addresses a different situation (A customer table identifies rows by mutable email address, causing broken relationships after updates.), not the targeted problem. Here, action and evidence must match: Action: Define entities, attributes, relationships, optionality and business keys in a logical model.
Question 493
After addressing this problem, what evidence would justify closure? A term called revenue means gross receipts in one team and net receipts in another.
- Owners detect late or failed loads using observable pipeline execution history.
- An analyst traces a suspect field back to its origin and responsible transformation.
- Reports cite approved term versions and consumers can identify differences.
- Owner, definition and quality metadata stay current after system changes.
Explanation
Correct Answer
C:It tests the action: Define and approve a glossary term with qualified variants and linked calculations.
Incorrect Answers
A:Owners detect late or failed loads using observable pipeline execution history. This would verify a different control (A pipeline silently stopped after a weekend but no one tracks run status or freshness.), not the one in the question. The required evidence is: Reports cite approved term versions and consumers can identify differences.
B:An analyst traces a suspect field back to its origin and responsible transformation. This would verify a different control (A compliance report is wrong but no one knows which source change introduced the value.), not the one in the question. The required evidence is: Reports cite approved term versions and consumers can identify differences.
D:Owner, definition and quality metadata stay current after system changes. This would verify a different control (Catalog entries become stale because their data owners were never assigned responsibility.), not the one in the question. The required evidence is: Reports cite approved term versions and consumers can identify differences.
Question 494
A proposed shortcut is offered for this situation: One interface calls a field supplier_id while another calls it vendor_code with different identifier rules. Which choice is the CLEAREST mistake?
- Retain a rollback or recovery plan before making destructive data changes.
- Join values by matching-looking column names without defining identity rules.
- Preserve source evidence and document why any exception was approved.
- Monitor control outcomes after deployment rather than relying only on design intent.
Explanation
Correct Answer
B:Join values by matching-looking column names without defining identity rules. Data interoperability requires shared semantics even when field names differ. A sound response instead: Define an agreed canonical mapping with meaning, transform ownership and validation.
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: Define an agreed canonical mapping with meaning, transform ownership and validation.
C:Preserve source evidence and document why any exception was approved. Traceability enables independent review of exceptions. The case-specific response is: Define an agreed canonical mapping with meaning, transform ownership and validation.
D: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: Define an agreed canonical mapping with meaning, transform ownership and validation.
Question 495
A data steward challenges an assumption in this case: Project teams repeatedly pick conflicting data integration styles for identical business needs. Which verification should be performed first?
- Trace a customer identity across reference models, interface contracts and target standards.
- Inspect architecture decision records, exception approvals and deployed interfaces.
- Inspect data contracts, schema-version changes and consumer integration tests.
- Test representative queries, change ownership, consistency and operating costs.
Explanation
Correct Answer
B:Inspect architecture decision records, exception approvals and deployed interfaces. This test checks the relevant business and technical failure rather than assuming its cause. Architecture principles make cross-project decisions consistent without prohibiting justified exceptions. Expected control result: Decision records show when a common pattern is followed and why exceptions are justified.
Incorrect Answers
A:Trace a customer identity across reference models, interface contracts and target standards. This check would investigate another issue (Customer identifiers differ across sales, billing and support, preventing consistent reporting.), not the immediate case. The direct diagnostic is: Inspect architecture decision records, exception approvals and deployed interfaces.
C:Inspect data contracts, schema-version changes and consumer integration tests. This check would investigate another issue (A team proposes proprietary event fields that cannot be interpreted by other platforms.), not the immediate case. The direct diagnostic is: Inspect architecture decision records, exception approvals and deployed interfaces.
D:Test representative queries, change ownership, consistency and operating costs. This check would investigate another issue (An organization compares central warehouse, decentralized data products and a virtualization layer for analytics.), not the immediate case. The direct diagnostic is: Inspect architecture decision records, exception approvals and deployed interfaces.
Question 496
The data management team encounters this situation: A business requests a temporary deviation from a sensitive data retention standard. Which intervention BEST addresses the actual problem?
- Assign policy decision rights to a business data owner with steward-led coordination.
- Require authorized risk assessment, expiry, compensating controls and documented acceptance.
- Provide role-based training and supervised examples matched to assigned stewardship duties.
- Identify critical data elements according to material reporting, operational and risk impact.
Explanation
Correct Answer
B:Require authorized risk assessment, expiry, compensating controls and documented acceptance. Governed exceptions prevent informal departures from becoming permanent invisible risk. Evidence to obtain: The exception has a named owner, time limit and independently monitored mitigation.
Incorrect Answers
A:Assign policy decision rights to a business data owner with steward-led coordination. This response fits a separate situation (Two departments disagree about the authoritative definition of an active customer and neither can decide.), but does not resolve the stated case. The targeted response is: Require authorized risk assessment, expiry, compensating controls and documented acceptance.
C:Provide role-based training and supervised examples matched to assigned stewardship duties. This response fits a separate situation (New business stewards do not understand how to document definitions or resolve data defects.), but does not resolve the stated case. The targeted response is: Require authorized risk assessment, expiry, compensating controls and documented acceptance.
D:Identify critical data elements according to material reporting, operational and risk impact. 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. The targeted response is: Require authorized risk assessment, expiry, compensating controls and documented acceptance.
Question 497
A data steward examines this condition: A scientific dataset has fine precision but lacks metadata required for the regulator's audit. What concept best justifies the corrective approach?
- Fitness for purpose includes contextual requirements beyond numeric precision.
- Integrity preserves valid relationships and structural constraints.
- Quality commitments should reflect consuming business needs and operational accountability.
- Preventive quality controls act earlier than downstream detective cleanup.
Explanation
Correct Answer
A:Fitness for purpose includes contextual requirements beyond numeric precision. This concept explains the reason for the proposed control. Appropriate intervention: Evaluate quality against the specific consumer's required provenance and interpretability.
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: Fitness for purpose includes contextual requirements beyond numeric precision.
C:Quality commitments should reflect consuming business needs and operational accountability. This is a defensible principle in another context (A shared customer dataset has no agreed defect response or availability expectations.), not the most relevant rationale here. For the stated issue: Fitness for purpose includes contextual requirements beyond numeric precision.
D:Preventive quality controls act earlier than downstream detective cleanup. This is a defensible principle in another context (Bad dates are entered during onboarding and corrected only after monthly reporting failures.), not the most relevant rationale here. For the stated issue: Fitness for purpose includes contextual requirements beyond numeric precision.
Question 498
Before changing procedures, the team investigates: Two departments use the term account for unrelated concepts and merge records incorrectly. Which review or test MOST directly locates the relevant failure?
- Review data residency rules, data products, permitted transfers and access test logs.
- Review project decision history, principle conformance and remediation evidence.
- Compare glossary concepts, logical entities and application mappings for semantic agreement.
- Review current-state flows, target-state interfaces, interim controls and transition gates.
Explanation
Correct Answer
C:Compare glossary concepts, logical entities and application mappings for semantic agreement. This test checks the relevant business and technical failure rather than assuming its cause. Logical enterprise architecture clarifies shared meaning independently of vendor databases. Expected control result: An approved logical model distinguishes party, agreement and financial account semantics.
Incorrect Answers
A:Review data residency rules, data products, permitted transfers and access test logs. This check would investigate another issue (A multinational has legal requirements to keep certain data local while enabling group analytics.), not the immediate case. The direct diagnostic is: Compare glossary concepts, logical entities and application mappings for semantic agreement.
B:Review project decision history, principle conformance and remediation evidence. This check would investigate another issue (A transformation program has diagrams but no one decides whether new platforms meet enterprise principles.), not the immediate case. The direct diagnostic is: Compare glossary concepts, logical entities and application mappings for semantic agreement.
D:This check would investigate another issue (A bank intends to retire a reporting platform but has no inventory of upstream sources or dependencies.), not the immediate case. The direct diagnostic is: Compare glossary concepts, logical entities and application mappings for semantic agreement.
Question 499
A data steward examines this condition: A credit model has similar overall accuracy but rejects an underserved population disproportionately. What concept best justifies the corrective approach?
- Least privilege provides only the access required for an authorized purpose.
- Auditability complements prevention by making sensitive operations attributable.
- Row-level controls enforce instance-specific access beyond coarse table grants.
- Ethical analytics considers disparate impact and context beyond average model accuracy.
Explanation
Correct Answer
D:Ethical analytics considers disparate impact and context beyond average model accuracy. This concept explains the reason for the proposed control. Appropriate intervention: Test subgroup outcomes, data representativeness and remediations with accountable review.
Incorrect Answers
A:This is a defensible principle in another context (A BI analyst receives administrator access to production customer tables for simple reporting.), not the most relevant rationale here. For the stated issue: Ethical analytics considers disparate impact and context beyond average model accuracy.
B:Auditability complements prevention by making sensitive operations attributable. This is a defensible principle in another context (Privileged database exports are possible but no one records who initiated them.), not the most relevant rationale here. For the stated issue: Ethical analytics considers disparate impact and context beyond average model accuracy.
C:Row-level controls enforce instance-specific access beyond coarse table grants. This is a defensible principle in another context (Regional sales managers can query all customer records despite regional authorization rules.), not the most relevant rationale here. For the stated issue: Ethical analytics considers disparate impact and context beyond average model accuracy.
Question 500
Select TWO appropriate statements, one intervention and one verification, for this data management case: Contract PDFs are retained indefinitely after business use with no destruction rules.
- Shortcut: Delete records whenever storage pressure rises without checking legal duties.
- Action: Classify documents and apply approved creation, review, retention, archive and disposal procedures.
- Verification: Evidence lists eligible records, authorization, method, time and any exception.
- Action: Suspend disposition for in-scope content until an authorized hold release is recorded.
- Verification: Records have retention schedules and disposal evidence while active holds are respected.
Explanation
Correct Answers
B:Action: Classify documents and apply approved creation, review, retention, archive and disposal procedures. The proposed intervention targets the reported issue. Document and content management governs unstructured information across its lifecycle.
E:Verification: Records have retention schedules and disposal evidence while active holds are respected. The observed result demonstrates whether the correction operates as intended. Document and content management governs unstructured information across its lifecycle.
Incorrect Answers
A:Shortcut: Delete records whenever storage pressure rises without checking legal duties. This shortcut is not a sound remediation. Document and content management governs unstructured information across its lifecycle. The appropriate action is: Classify documents and apply approved creation, review, retention, archive and disposal procedures.
C:The valid outcome is: Records have retention schedules and disposal evidence while active holds are respected.
D:This intervention is for a different scenario (An automated seven-year purge is about to remove correspondence covered by an active litigation hold.), not the one stated. Appropriate action here: Classify documents and apply approved creation, review, retention, archive and disposal procedures.