CDMP DMF Practice Test 12
Question 110
After addressing this problem, what evidence would justify closure? Marketing requests full birth dates for a campaign that only needs age bands.
- The campaign operates while recipients cannot retrieve unnecessary full dates.
- The analyst can perform the report but cannot alter or see unrelated sensitive records.
- Investigation records affected datasets, containment, timeline and obligations.
- A test export captures actor, dataset, time and authorized action in immutable evidence.
Explanation
Correct Answer
A:It tests the action: Share only derived age ranges under approved purpose and retention controls.
Incorrect Answers
B:The analyst can perform the report but cannot alter or see unrelated sensitive records. This would verify a different control (A BI analyst receives administrator access to production customer tables for simple reporting.), not the one in the question. The required evidence is: The campaign operates while recipients cannot retrieve unnecessary full dates.
C:Investigation records affected datasets, containment, timeline and obligations. This would verify a different control (An unauthorized service account downloads a large restricted dataset overnight.), not the one in the question. The required evidence is: The campaign operates while recipients cannot retrieve unnecessary full dates.
D: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: The campaign operates while recipients cannot retrieve unnecessary full dates.
Question 111
The data management team encounters this situation: Data-quality defects recur because workers close tickets without addressing causes. Which intervention BEST addresses the actual problem?
- Use a governed issue workflow with severity, ownership, root cause and independent closure validation.
- Require authorized risk assessment, expiry, compensating controls and documented acceptance.
- Report meaningful risk, issue aging, quality compliance and business-value outcomes.
- Translate principles into measurable standards, owner responsibilities and repeatable procedures.
Explanation
Correct Answer
A:Use a governed issue workflow with severity, ownership, root cause and independent closure validation. Governance issue management must address root causes and accountability. Evidence to obtain: Aged high-impact defects are escalated and recurrence decreases after verified remediation.
Incorrect Answers
B:This response fits a separate situation (A business requests a temporary deviation from a sensitive data retention standard.), but does not resolve the stated case.
C:This response fits a separate situation (Leadership receives the total number of stewardship meetings as the sole effectiveness KPI.), but does not resolve the stated case. Report meaningful risk, issue aging, quality compliance and business-value outcomes.
D:This response fits a separate situation (A company has a general policy promising accurate data but no operational validation thresholds.), but does not resolve the stated case. Translate principles into measurable standards, owner responsibilities and repeatable procedures.
Question 112
Consider this data-management scenario: Finance reports omit transactions because an extraction job silently skips late-arriving records. Which underlying principle MOST directly explains the preferred response?
- Integration pipelines create new security exposure at movement and landing points.
- Data interoperability requires shared semantics even when field names differ.
- Data integration reliability requires observable completeness and repeatable recovery.
- At-least-once delivery requires consumers to tolerate duplicate messages.
Explanation
Correct Answer
C:Data integration reliability requires observable completeness and repeatable recovery. This concept explains the reason for the proposed control. Appropriate intervention: Add completeness reconciliation, lateness handling and replay controls to the ETL pipeline.
Incorrect Answers
A:Integration pipelines create new security exposure at movement and landing points. This is a defensible principle in another context (A file-transfer integration includes confidential customer attributes in an unsecured staging bucket.), not the most relevant rationale here. For the stated issue: Data integration reliability requires observable completeness and repeatable recovery.
B:This is a defensible principle in another context (One interface calls a field supplier_id while another calls it vendor_code with different identifier rules.), not the most relevant rationale here. For the stated issue: Data integration reliability requires observable completeness and repeatable recovery.
D:At-least-once delivery requires consumers to tolerate duplicate messages. This is a defensible principle in another context (An event consumer processes a payment notification twice after retry and creates duplicate ledger postings.), not the most relevant rationale here. For the stated issue: Data integration reliability requires observable completeness and repeatable recovery.
Question 113
A governance review considers the following: A catalog lists every dataset but half of its owners and descriptions are outdated. Which proposal would create an avoidable risk?
- Keep approved reference mappings versioned and traceable.
- Escalate material unresolved issues to an accountable business decision owner.
- Check that the proposed procedure has an identified operator and approval path.
- Claim catalog success solely because every table name was ingested.
Explanation
Correct Answer
D:Claim catalog success solely because every table name was ingested. Metadata quality is a governable data-quality problem with measurable dimensions. A sound response instead: Measure metadata completeness, freshness and accuracy for high-value entries.
Incorrect Answers
A:Keep approved reference mappings versioned and traceable. Value meaning can change across time and applications. The case-specific response is: Measure metadata completeness, freshness and accuracy for high-value entries.
B:Escalate material unresolved issues to an accountable business decision owner. Accountability prevents silent acceptance of consequential risk. The case-specific response is: Measure metadata completeness, freshness and accuracy for high-value entries.
C:Check that the proposed procedure has an identified operator and approval path. Operational responsibility prevents undocumented workarounds. The case-specific response is: Measure metadata completeness, freshness and accuracy for high-value entries.
Question 114
Before changing procedures, the team investigates: A daily tax report and a live fraud decision service share one nightly transfer mechanism. Which review or test MOST directly locates the relevant failure?
- Inspect raw landing zones, transformation versions and reconciliation checks.
- Review latency budgets, recovery tests, consistency constraints and failure modes.
- Inspect transfer encryption, bucket permissions, retention and operational logs.
- Replay contract examples through old and new consumers and inspect validation failures.
Explanation
Correct Answer
B:Review latency budgets, recovery tests, consistency constraints and failure modes. This test checks the relevant business and technical failure rather than assuming its cause. Batch, messaging and service APIs meet different business service levels. Expected control result: The fraud service receives timely events while tax reporting reconciles its complete batch.
Incorrect Answers
A:Inspect raw landing zones, transformation versions and reconciliation checks. This check would investigate another issue (An analytics platform loads source extracts into a warehouse then performs transformations there.), not the immediate case. The direct diagnostic is: Review latency budgets, recovery tests, consistency constraints and failure modes.
C:Inspect transfer encryption, bucket permissions, retention and operational logs. This check would investigate another issue (A file-transfer integration includes confidential customer attributes in an unsecured staging bucket.), not the immediate case. The direct diagnostic is: Review latency budgets, recovery tests, consistency constraints and failure modes.
D: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: Review latency budgets, recovery tests, consistency constraints and failure modes.
Question 115
The data program reviews the following failure: An enterprise needs rules for customer-to-contract cardinality without choosing a database product. Which change should be prioritized?
- Introduce a stable key and manage mutable natural identifiers as governed attributes.
- Model phone numbers as atomic repeating child records with appropriate identifiers.
- Define correct one-to-many customer-to-order cardinality and mandatory participation.
- Define entities, attributes, relationships, optionality and business keys in a logical model.
Explanation
Correct Answer
D:Define entities, attributes, relationships, optionality and business keys in a logical model. Logical modeling formalizes business data structure separate from storage technology. Evidence to obtain: The logical model expresses cardinality and integrity rules independent of vendor syntax.
Incorrect Answers
A:This response fits a separate situation (A customer table identifies rows by mutable email address, causing broken relationships after updates.), but does not resolve the stated case.
B: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: Define entities, attributes, relationships, optionality and business keys in a logical model.
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: Define entities, attributes, relationships, optionality and business keys in a logical model.
Question 116
A proposed shortcut is offered for this situation: A team proposes proprietary event fields that cannot be interpreted by other platforms. Which choice is the CLEAREST mistake?
- Inspect lineage and source context before changing a derived report.
- Assume identical field names imply identical business meaning across all systems.
- Check relevant business definitions before joining independently sourced data.
- Protect relevant audit records while investigating data problems.
Explanation
Correct Answer
B:Assume identical field names imply identical business meaning across all systems. Standards reduce integration ambiguity when implementations use different technologies. A sound response instead: Define canonical field semantics and versioned interface contracts with consumers.
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: Define canonical field semantics and versioned interface contracts with consumers.
C:Check relevant business definitions before joining independently sourced data. Semantic agreements prevent incorrect cross-system correlations. The case-specific response is: Define canonical field semantics and versioned interface contracts with consumers.
D:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Define canonical field semantics and versioned interface contracts with consumers.
Question 117
Select TWO appropriate statements, one intervention and one verification, for this data management case: A read-heavy dashboard suffers repeated expensive joins but operational source integrity is sound.
- Verification: Dashboard latency improves and redundant values stay consistent under updates.
- Action: Consider controlled denormalization with refresh ownership and reconciliation.
- Shortcut: Duplicate every attribute indefinitely without a maintenance strategy.
- Verification: Shared identity fields are unified and subtype-specific validation is enforced.
- Action: Define correct one-to-many customer-to-order cardinality and mandatory participation.
Explanation
Correct Answers
A:Verification: Dashboard latency improves and redundant values stay consistent under updates. The observed result demonstrates whether the correction operates as intended. Denormalization trades simpler reads for additional synchronization and anomaly risk.
B:Action: Consider controlled denormalization with refresh ownership and reconciliation. The proposed intervention targets the reported issue. Denormalization trades simpler reads for additional synchronization and anomaly risk.
Incorrect Answers
C:Shortcut: Duplicate every attribute indefinitely without a maintenance strategy. This shortcut is not a sound remediation. Denormalization trades simpler reads for additional synchronization and anomaly risk. The appropriate action is: Consider controlled denormalization with refresh ownership and reconciliation.
D:Verification: Shared identity fields are unified and subtype-specific validation is enforced. This evidence is for a separate context (A party table mixes person birthdate with organization registration number, leaving ambiguous rules.), not this case. The valid outcome is: Dashboard latency improves and redundant values stay consistent under updates.
E:Action: Define correct one-to-many customer-to-order cardinality and mandatory participation. This intervention is for a different scenario (A model incorrectly allows each order to have many unrelated customer owners.), not the one stated. Appropriate action here: Consider controlled denormalization with refresh ownership and reconciliation.
Question 118
A data steward challenges an assumption in this case: A security patch must be applied to a data store with a strict availability commitment. Which verification should be performed first?
- Run a controlled restore, verify row counts and record recovery time.
- Inspect slow query logs, wait statistics, resource metrics and alert history.
- Review patch matrix, test plan, recovery procedure and production results.
- Measure loss of last committed data and duration to service recovery separately.
Explanation
Correct Answer
C:Review patch matrix, test plan, recovery procedure and production results. This test checks the relevant business and technical failure rather than assuming its cause. Storage operations changes require controlled rollout and recoverability. Expected control result: Patched instances pass regression checks without violating availability constraints.
Incorrect Answers
A:Run a controlled restore, verify row counts and record recovery time. This check would investigate another issue (A production database has daily backups but no successful restore has been performed.), not the immediate case. The direct diagnostic is: Review patch matrix, test plan, recovery procedure and production results.
B:Inspect slow query logs, wait statistics, resource metrics and alert history. This check would investigate another issue (A database service is slow but monitoring records only whether its process is up.), not the immediate case. The direct diagnostic is: Review patch matrix, test plan, recovery procedure and production results.
D:This check would investigate another issue (A service can tolerate one hour of data loss but must return within fifteen minutes of outage.), not the immediate case. The direct diagnostic is: Review patch matrix, test plan, recovery procedure and production results.
Question 119
Select TWO appropriate statements, one intervention and one verification, for this data management case: New business stewards do not understand how to document definitions or resolve data defects.
- Verification: Completed exercises demonstrate consistent definition updates and issue routing.
- Verification: A legal obligation register connects affected datasets to owners, tests and evidence.
- Shortcut: List every employee as a steward without explaining responsibilities.
- Action: Translate principles into measurable standards, owner responsibilities and repeatable procedures.
- Action: Provide role-based training and supervised examples matched to assigned stewardship duties.
Explanation
Correct Answers
A:Verification: Completed exercises demonstrate consistent definition updates and issue routing. The observed result demonstrates whether the correction operates as intended. Stewardship capability requires practice and accountability, not titles alone.
E:Action: Provide role-based training and supervised examples matched to assigned stewardship duties. The proposed intervention targets the reported issue. Stewardship capability requires practice and accountability, not titles alone.
Incorrect Answers
B:Verification: A legal obligation register connects affected datasets to owners, tests and evidence. This evidence is for a separate context (A new privacy requirement affects data collection across products but no governance owner tracks applicability.), not this case. The valid outcome is: Completed exercises demonstrate consistent definition updates and issue routing.
C:Shortcut: List every employee as a steward without explaining responsibilities. This shortcut is not a sound remediation. Stewardship capability requires practice and accountability, not titles alone. The appropriate action is: Provide role-based training and supervised examples matched to assigned stewardship duties.
D:Action: Translate principles into measurable standards, owner responsibilities and repeatable procedures. This intervention is for a different scenario (A company has a general policy promising accurate data but no operational validation thresholds.), not the one stated. Appropriate action here: Provide role-based training and supervised examples matched to assigned stewardship duties.
Question 120
Consider this data-management scenario: A party table mixes person birthdate with organization registration number, leaving ambiguous rules. Which underlying principle MOST directly explains the preferred response?
- Dimensional modeling requires an unambiguous grain for additive measures.
- Subtype modeling represents common identity while preserving different business attributes.
- Naming standards improve understandability but must reflect precise meanings.
- A stable primary key should preserve record identity across ordinary attribute changes.
Explanation
Correct Answer
B:Subtype modeling represents common identity while preserving different business attributes. This concept explains the reason for the proposed control. Appropriate intervention: Use a common party supertype with justified person and organization subtypes.
Incorrect Answers
A:Dimensional modeling requires an unambiguous grain for additive measures. This is a defensible principle in another context (A warehouse fact table mixes one-row-per-order and one-row-per-order-line measures.), not the most relevant rationale here. For the stated issue: Subtype modeling represents common identity while preserving different business attributes.
C: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: Subtype modeling represents common identity while preserving different business attributes.
D:This is a defensible principle in another context (A customer table identifies rows by mutable email address, causing broken relationships after updates.), not the most relevant rationale here. For the stated issue: Subtype modeling represents common identity while preserving different business attributes.