CDMP DMF Practice Test 41
Question 400
In reviewing this data risk, select the LEAST defensible practice: A customer table identifies rows by mutable email address, causing broken relationships after updates.
- Inspect lineage and source context before changing a derived report.
- Retain a rollback or recovery plan before making destructive data changes.
- Use a frequently changing descriptive attribute as the permanent relational key.
- Document which dataset version was used in a material decision.
Explanation
Correct Answer
C:Use a frequently changing descriptive attribute as the permanent relational key. A stable primary key should preserve record identity across ordinary attribute changes. A sound response instead: Introduce a stable key and manage mutable natural identifiers as governed attributes.
Incorrect Answers
A:Inspect lineage and source context before changing a derived report. Provenance analysis distinguishes source errors from transformations. The case-specific response is: Introduce a stable key and manage mutable natural identifiers as governed attributes.
B:Retain a rollback or recovery plan before making destructive data changes. Recoverability reduces the consequences of incorrect remediation. The case-specific response is: Introduce a stable key and manage mutable natural identifiers as governed attributes.
D:Document which dataset version was used in a material decision. Version records support reproducible decisions. The case-specific response is: Introduce a stable key and manage mutable natural identifiers as governed attributes.
Question 401
A reviewer asks for proof of improvement: Operational logs contain sensitive identifiers beyond the allowed retention period. Which result MOST convincingly demonstrates that the control works?
- Recovery exercises meet both distinct time and data-loss targets.
- A simulated primary outage transfers service within the target and avoids unacceptable data loss.
- Representative query time improves without unacceptable ingestion regression.
- Expired eligible logs are deleted while hold-protected records remain preserved.
Explanation
Correct Answer
D:It tests the action: Implement scheduled retention with legal holds, access controls and verifiable deletion.
Incorrect Answers
A:Recovery exercises meet both distinct time and data-loss targets. This would verify a different control (A service can tolerate one hour of data loss but must return within fifteen minutes of outage.), not the one in the question. The required evidence is: Expired eligible logs are deleted while hold-protected records remain preserved.
B: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: Expired eligible logs are deleted while hold-protected records remain preserved.
C:Representative query time improves without unacceptable ingestion regression. This would verify a different control (A report scans millions of rows although its date filter is selective and frequent.), not the one in the question. The required evidence is: Expired eligible logs are deleted while hold-protected records remain preserved.
Question 402
A proposed shortcut is offered for this situation: Retail and service systems each assign different IDs to the same real-world customer. Which choice is the CLEAREST mistake?
- Respect active legal holds before scheduling record disposition.
- Preserve source evidence and document why any exception was approved.
- Assume each transactional key uniquely represents a real person enterprise-wide.
- Retain a rollback or recovery plan before making destructive data changes.
Explanation
Correct Answer
C:Assume each transactional key uniquely represents a real person enterprise-wide. Master data management provides consistent core business entity views across systems. A sound response instead: Create a governed master-customer identity strategy with matching and cross-reference rules.
Incorrect Answers
A:Respect active legal holds before scheduling record disposition. Preservation duties may override scheduled destruction. The case-specific response is: Create a governed master-customer identity strategy with matching and cross-reference rules.
B:Preserve source evidence and document why any exception was approved. Traceability enables independent review of exceptions. The case-specific response is: Create a governed master-customer identity strategy with matching and cross-reference rules.
D:Retain a rollback or recovery plan before making destructive data changes. Recoverability reduces the consequences of incorrect remediation. The case-specific response is: Create a governed master-customer identity strategy with matching and cross-reference rules.
Question 403
Before changing procedures, the team investigates: Business stakeholders cannot agree which things should be treated as customers, accounts or products. Which review or test MOST directly locates the relevant failure?
- Inspect missing-value rules and test calculations with unknown and genuine zero.
- Review concept definitions and stakeholders' interpretation of entity relationships.
- Inspect subtype constraints, shared keys and invalid category combinations.
- Inspect effective windows, surrogate dimension keys and time-bound fact joins.
Explanation
Correct Answer
B:Review concept definitions and stakeholders' interpretation of entity relationships. This test checks the relevant business and technical failure rather than assuming its cause. Conceptual models communicate business understanding before logical and physical detail. Expected control result: Stakeholders approve shared concepts and relationship definitions.
Incorrect Answers
A:Inspect missing-value rules and test calculations with unknown and genuine zero. This check would investigate another issue (A registration field is blank, but downstream calculations treat unknown age as zero.), not the immediate case. The direct diagnostic is: Review concept definitions and stakeholders' interpretation of entity relationships.
C: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: Review concept definitions and stakeholders' interpretation of entity relationships.
D:Inspect effective windows, surrogate dimension keys and time-bound fact joins. This check would investigate another issue (A customer changes region but analysts need sales under the region valid at each transaction date.), not the immediate case. The direct diagnostic is: Review concept definitions and stakeholders' interpretation of entity relationships.
Question 404
Consider this data-management scenario: A customer's billing address is validly formatted but refers to a previous residence. Which underlying principle MOST directly explains the preferred response?
- Quality commitments should reflect consuming business needs and operational accountability.
- Accuracy concerns correspondence to reality; valid formatting alone cannot prove accuracy.
- Validity measures conformance to allowed formats, domains and business rules.
- Fitness for purpose includes contextual requirements beyond numeric precision.
Explanation
Correct Answer
B:Accuracy concerns correspondence to reality; valid formatting alone cannot prove accuracy. This concept explains the reason for the proposed control. Appropriate intervention: Verify the address against a trusted recent source and update the authoritative record.
Incorrect Answers
A: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: Accuracy concerns correspondence to reality; valid formatting alone cannot prove accuracy.
C:This is a defensible principle in another context (A product status field contains values archived and disabled although only active and retired are approved.), not the most relevant rationale here. For the stated issue: Accuracy concerns correspondence to reality; valid formatting alone cannot prove accuracy.
D:This is a defensible principle in another context (A scientific dataset has fine precision but lacks metadata required for the regulator's audit.), not the most relevant rationale here. For the stated issue: Accuracy concerns correspondence to reality; valid formatting alone cannot prove accuracy.
Question 405
The data program reviews the following failure: A new payments division launches products without agreeing how customer data supports business objectives. Which change should be prioritized?
- Establish a data management strategy tied to business outcomes and accountable stakeholders.
- Assign policy decision rights to a business data owner with steward-led coordination.
- Define outcome measures for data reliability, regulatory risk reduction and decision usefulness.
- Establish audience-specific data literacy guidance and approved metric interpretation.
Explanation
Correct Answer
A:Establish a data management strategy tied to business outcomes and accountable stakeholders. Data management creates value when its activities align with enterprise strategy rather than isolated tooling. Evidence to obtain: Approved objectives identify priority data capabilities, owners, measures and funded milestones.
Incorrect Answers
B: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. Assign policy decision rights to a business data owner with steward-led coordination.
C:Define outcome measures for data reliability, regulatory risk reduction and decision usefulness.
D:Establish audience-specific data literacy guidance and approved metric interpretation. This response fits a separate situation (Executives regularly misinterpret dashboards because they confuse current records with historical cohorts.), but does not resolve the stated case. The targeted response is: Establish a data management strategy tied to business outcomes and accountable stakeholders.
Question 406
A data management auditor evaluates this situation: An unauthorized service account downloads a large restricted dataset overnight. Which observable finding supports successful remediation?
- Investigation records affected datasets, containment, timeline and obligations.
- An authorized manager sees own-region rows and cannot access other regions.
- A test export captures actor, dataset, time and authorized action in immutable evidence.
- Test datasets retain required distributions while direct identifiers cannot be recovered.
Explanation
Correct Answer
A:It tests the action: Revoke relevant access, preserve evidence, assess scope and follow incident notification policy.
Incorrect Answers
B:An authorized manager sees own-region rows and cannot access other regions. This would verify a different control (Regional sales managers can query all customer records despite regional authorization rules.), not the one in the question. The required evidence is: Investigation records affected datasets, containment, timeline and obligations.
C:A test export captures actor, dataset, time and authorized action in immutable evidence. This would verify a different control (Privileged database exports are possible but no one records who initiated them.), not the one in the question. The required evidence is: Investigation records affected datasets, containment, timeline and obligations.
D:Test datasets retain required distributions while direct identifiers cannot be recovered. This would verify a different control (Test developers need representative orders but a test export includes real customer identity numbers.), not the one in the question. The required evidence is: Investigation records affected datasets, containment, timeline and obligations.
Question 407
An accountable team must correct this problem and prove results. Select TWO sound statements: A student can enroll in many courses and a course can enroll many students.
- Action: Apply naming, glossary mapping and controlled definitions to important model elements.
- Action: Model an associative enrollment entity with both relationships and enrollment attributes.
- Verification: Enrolments are uniquely recorded without duplicate student or course entities.
- Shortcut: Store each student's courses as a semicolon-delimited field in the student row.
- Verification: Each number is independently searchable and maintained without string parsing.
Explanation
Correct Answers
B:Action: Model an associative enrollment entity with both relationships and enrollment attributes. The proposed intervention targets the reported issue. Many-to-many relationships are implemented using associative structures in relational designs.
C:Verification: Enrolments are uniquely recorded without duplicate student or course entities. The observed result demonstrates whether the correction operates as intended. Many-to-many relationships are implemented using associative structures in relational designs.
Incorrect Answers
A:Action: Apply naming, glossary mapping and controlled definitions to important model elements. This intervention is for a different scenario (Teams use inconsistent definitions for status and state across logical models.), not the one stated. Appropriate action here: Model an associative enrollment entity with both relationships and enrollment attributes.
D:Shortcut: Store each student's courses as a semicolon-delimited field in the student row. This shortcut is not a sound remediation. Many-to-many relationships are implemented using associative structures in relational designs. The appropriate action is: Model an associative enrollment entity with both relationships and enrollment attributes.
E:Verification: Each number is independently searchable and maintained without string parsing. This evidence is for a separate context (A contact table stores three comma-separated telephone numbers in one column.), not this case. The valid outcome is: Enrolments are uniquely recorded without duplicate student or course entities.
Question 408
A proposed shortcut is offered for this situation: Two departments use the term account for unrelated concepts and merge records incorrectly. Which choice is the CLEAREST mistake?
- Verify a new interface using a controlled sample and reconciliation.
- Preserve source evidence and document why any exception was approved.
- Retain a rollback or recovery plan before making destructive data changes.
- Rename one physical table and assume conflicting business definitions disappear.
Explanation
Correct Answer
D:Rename one physical table and assume conflicting business definitions disappear. Logical enterprise architecture clarifies shared meaning independently of vendor databases. A sound response instead: Agree enterprise-level business concepts and relationships before mapping physical application schemas.
Incorrect Answers
A:Verify a new interface using a controlled sample and reconciliation. Testing reveals mismatches before broad deployment. The case-specific response is: Agree enterprise-level business concepts and relationships before mapping physical application schemas.
B:Preserve source evidence and document why any exception was approved. Traceability enables independent review of exceptions. The case-specific response is: Agree enterprise-level business concepts and relationships before mapping physical application schemas.
C:Retain a rollback or recovery plan before making destructive data changes. Recoverability reduces the consequences of incorrect remediation. The case-specific response is: Agree enterprise-level business concepts and relationships before mapping physical application schemas.
Question 409
An accountable team must correct this problem and prove results. Select TWO sound statements: A credit model has similar overall accuracy but rejects an underserved population disproportionately.
- Action: Assess meaningful disclosure, user expectations and controls for intrusive profiling.
- Verification: The use is rejected or redesigned with appropriate authorization, minimization and safeguards.
- Action: Test subgroup outcomes, data representativeness and remediations with accountable review.
- Shortcut: Declare the model fair solely because its total accuracy exceeds ninety percent.
- Verification: Fairness metrics and decisions document identified disparities and corrective monitoring.
Explanation
Correct Answers
C:Action: Test subgroup outcomes, data representativeness and remediations with accountable review. The proposed intervention targets the reported issue. Ethical analytics considers disparate impact and context beyond average model accuracy.
E:Verification: Fairness metrics and decisions document identified disparities and corrective monitoring. The observed result demonstrates whether the correction operates as intended. Ethical analytics considers disparate impact and context beyond average model accuracy.
Incorrect Answers
A:Action: Assess meaningful disclosure, user expectations and controls for intrusive profiling. This intervention is for a different scenario (A firm builds individualized prices from personal browsing histories without meaningful customer explanation.), not the one stated. Appropriate action here: Test subgroup outcomes, data representativeness and remediations with accountable review.
B:This evidence is for a separate context (An analytics team reuses location records collected for delivery tracking to infer employees' medical visits.), not this case.
D:Shortcut: Declare the model fair solely because its total accuracy exceeds ninety percent. This shortcut is not a sound remediation. Ethical analytics considers disparate impact and context beyond average model accuracy. The appropriate action is: Test subgroup outcomes, data representativeness and remediations with accountable review.
Question 410
Before changing procedures, the team investigates: A retired system's catalog entries remain marked active, misleading new project teams. Which review or test MOST directly locates the relevant failure?
- Audit catalog freshness and ownership against active application inventories.
- Audit current systems against catalog lifecycle labels and successor links.
- Inspect glossary approval, term hierarchy and linked metric definitions.
- Inspect column-level lineage graph and controlled schema change tests.
Explanation
Correct Answer
B:Audit current systems against catalog lifecycle labels and successor links. This test checks the relevant business and technical failure rather than assuming its cause. Metadata must reflect the lifecycle of the assets it describes. Expected control result: Consumers see retirement dates, replacements and appropriate access warnings.
Incorrect Answers
A:Audit catalog freshness and ownership against active application inventories. This check would investigate another issue (Catalog entries become stale because their data owners were never assigned responsibility.), not the immediate case. The direct diagnostic is: Audit current systems against catalog lifecycle labels and successor links.
C:Inspect glossary approval, term hierarchy and linked metric definitions. This check would investigate another issue (A term called revenue means gross receipts in one team and net receipts in another.), not the immediate case. The direct diagnostic is: Audit current systems against catalog lifecycle labels and successor links.
D:Inspect column-level lineage graph and controlled schema change tests. This check would investigate another issue (A team plans to remove a source column that feeds several dashboards and fraud rules.), not the immediate case. The direct diagnostic is: Audit current systems against catalog lifecycle labels and successor links.