CDMP DMF Practice Test 54
Question 530
The data management team encounters this situation: An upstream API changes a numeric customer status code into a text value and breaks consumers. Which intervention BEST addresses the actual problem?
- Evaluate governed federation or virtualization with source access, query pushdown and performance limits.
- Define an agreed canonical mapping with meaning, transform ownership and validation.
- Govern landing, transformation logic, lineage and compute costs in a controlled ELT workflow.
- Establish a versioned API contract and compatibility tests before deploying breaking changes.
Explanation
Correct Answer
D:Evidence to obtain: Consumer integration tests pass or the incompatible change is deliberately migrated.
Incorrect Answers
A:Evaluate governed federation or virtualization with source access, query pushdown and performance limits. This response fits a separate situation (An organization wants live access to distributed records without copying every source table.), but does not resolve the stated case. The targeted response is: Establish a versioned API contract and compatibility tests before deploying breaking changes.
B:Define an agreed canonical mapping with meaning, transform ownership and validation. This response fits a separate situation (One interface calls a field supplier_id while another calls it vendor_code with different identifier rules.), but does not resolve the stated case. The targeted response is: Establish a versioned API contract and compatibility tests before deploying breaking changes.
C:Govern landing, transformation logic, lineage and compute costs in a controlled ELT workflow.
Question 531
A business owner identifies this issue: Retail and service systems each assign different IDs to the same real-world customer. What is the MOST appropriate data management response?
- Assign a data owner and stewardship process for supplier master definitions and changes.
- Create a governed master-customer identity strategy with matching and cross-reference rules.
- Validate hierarchy acyclicity, permitted parents and effective dates before publishing.
- Manage reference data as effective-dated versions with historical mapping support.
Explanation
Correct Answer
B:Create a governed master-customer identity strategy with matching and cross-reference rules. Master data management provides consistent core business entity views across systems. Evidence to obtain: Applications resolve one trusted customer identity while retaining source identifiers.
Incorrect Answers
A:This response fits a separate situation (Marketing and finance disagree on who approves supplier legal entity identifiers.), but does not resolve the stated case. Assign a data owner and stewardship process for supplier master definitions and changes.
C:This response fits a separate situation (A new organizational hierarchy update accidentally makes Division A the parent of itself through B.), but does not resolve the stated case. Validate hierarchy acyclicity, permitted parents and effective dates before publishing.
D:This response fits a separate situation (A product taxonomy changes in January but last year's reports must preserve prior category assignments.), but does not resolve the stated case. Manage reference data as effective-dated versions with historical mapping support.
Question 532
In reviewing this data risk, select the LEAST defensible practice: An enterprise needs rules for customer-to-contract cardinality without choosing a database product.
- Respect active legal holds before scheduling record disposition.
- Check that the proposed procedure has an identified operator and approval path.
- Apply access controls proportional to the sensitivity of business information.
- Use physical storage engine settings as the only description of business rules.
Explanation
Correct Answer
D:Use physical storage engine settings as the only description of business rules. Logical modeling formalizes business data structure separate from storage technology. A sound response instead: Define entities, attributes, relationships, optionality and business keys in a logical model.
Incorrect Answers
A:Respect active legal holds before scheduling record disposition. Preservation duties may override scheduled destruction. The case-specific response is: Define entities, attributes, relationships, optionality and business keys in a logical model.
B:Check that the proposed procedure has an identified operator and approval path. Operational responsibility prevents undocumented workarounds. The case-specific response is: Define entities, attributes, relationships, optionality and business keys in a logical model.
C:Apply access controls proportional to the sensitivity of business information. Confidentiality obligations still apply during quality improvements. The case-specific response is: Define entities, attributes, relationships, optionality and business keys in a logical model.
Question 533
After addressing this problem, what evidence would justify closure? A service transfers customer attributes over unencrypted HTTP between data centers.
- Stored backups are unreadable without authorized key access and restores succeed.
- Traffic capture reveals no plaintext sensitive fields and valid endpoint trust is enforced.
- An authorized manager sees own-region rows and cannot access other regions.
- Investigation records affected datasets, containment, timeline and obligations.
Explanation
Correct Answer
B:It tests the action: Require authenticated encrypted transport using supported TLS configuration.
Incorrect Answers
A:Stored backups are unreadable without authorized key access and restores succeed. This would verify a different control (A backup contains confidential employee salaries and is stored without encryption controls.), not the one in the question. The required evidence is: Traffic capture reveals no plaintext sensitive fields and valid endpoint trust is enforced.
C: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: Traffic capture reveals no plaintext sensitive fields and valid endpoint trust is enforced.
D: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: Traffic capture reveals no plaintext sensitive fields and valid endpoint trust is enforced.
Question 534
A data management leader must justify a testable improvement: Analysts cannot tell whether customer_age means current age or age at first purchase. Which prioritized decision and validation combination is BEST?
- Action: Establish end-to-end field-level lineage covering sources, transforms and reports. Verification: An analyst traces a suspect field back to its origin and responsible transformation.
- Action: Publish business metadata with precise glossary definitions and stewardship approval. Verification: Users understand the term and can link it to approved datasets and business rules.
- Action: Assign accountable metadata stewards and automated review reminders for priority assets. Verification: Owner, definition and quality metadata stay current after system changes.
- Action: Improve catalog classification, search relevance and certified-asset indicators. Verification: Representative searches surface approved datasets and disclose archival alternatives.
Explanation
Correct Answer
B:Action: Publish business metadata with precise glossary definitions and stewardship approval. Verification: Users understand the term and can link it to approved datasets and business rules. Both the intervention and measurable outcome are directly relevant. Business metadata describes meaning, purpose, ownership and policy context.
Incorrect Answers
A:This plan addresses a different situation (A compliance report is wrong but no one knows which source change introduced the value.), not the targeted problem. Here, action and evidence must match: Action: Publish business metadata with precise glossary definitions and stewardship approval.
C:This plan addresses a different situation (Catalog entries become stale because their data owners were never assigned responsibility.), not the targeted problem.
D:This plan addresses a different situation (Users search for a customer dataset but see dozens of unlabeled backups ahead of certified sources.), not the targeted problem. Here, action and evidence must match: Action: Publish business metadata with precise glossary definitions and stewardship approval.
Question 535
A data management auditor evaluates this situation: A pipeline silently stopped after a weekend but no one tracks run status or freshness. Which observable finding supports successful remediation?
- Unauthorized users see discovery descriptions but no confidential samples.
- Owners detect late or failed loads using observable pipeline execution history.
- Representative searches surface approved datasets and disclose archival alternatives.
- Risk report runs identify applicable mapping versions and affected records.
Explanation
Correct Answer
B:It tests the action: Collect operational metadata such as run timestamps, row counts and failure states.
Incorrect Answers
A:Unauthorized users see discovery descriptions but no confidential samples. This would verify a different control (A public catalog description reveals restricted patient identities in sample values.), not the one in the question. The required evidence is: Owners detect late or failed loads using observable pipeline execution history.
C:Representative searches surface approved datasets and disclose archival alternatives. This would verify a different control (Users search for a customer dataset but see dozens of unlabeled backups ahead of certified sources.), not the one in the question. The required evidence is: Owners detect late or failed loads using observable pipeline execution history.
D:Risk report runs identify applicable mapping versions and affected records. This would verify a different control (A risk report uses an old industry code mapping but its catalog does not record which version.), not the one in the question. The required evidence is: Owners detect late or failed loads using observable pipeline execution history.
Question 536
The data management team encounters this situation: A registration field is blank, but downstream calculations treat unknown age as zero. Which intervention BEST addresses the actual problem?
- Model history with effective-dated dimension versions when historical attribution matters.
- Enforce appropriate referential integrity and define valid deletion behavior.
- Use a common party supertype with justified person and organization subtypes.
- Represent missingness according to explicit semantic rules and validate downstream behavior.
Explanation
Correct Answer
D:Represent missingness according to explicit semantic rules and validate downstream behavior. Null can denote absent or unknown information and is not automatically a numeric zero. Evidence to obtain: Unknown values remain distinguishable from legitimate zero and inappropriate imputations are flagged.
Incorrect Answers
A:Model history with effective-dated dimension versions when historical attribution matters. This response fits a separate situation (A customer changes region but analysts need sales under the region valid at each transaction date.), but does not resolve the stated case. The targeted response is: Represent missingness according to explicit semantic rules and validate downstream behavior.
B: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: Represent missingness according to explicit semantic rules and validate downstream behavior.
C: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: Represent missingness according to explicit semantic rules and validate downstream behavior.
Question 537
Select TWO appropriate statements, one intervention and one verification, for this data management case: A new payments division launches products without agreeing how customer data supports business objectives.
- Action: Map the data lifecycle from creation and use through retention, archival and lawful deletion.
- Action: Establish a data management strategy tied to business outcomes and accountable stakeholders.
- Verification: Quarterly measures show adoption, fewer material defects and demonstrable business value.
- Verification: Approved objectives identify priority data capabilities, owners, measures and funded milestones.
- Shortcut: Buy a catalog first and treat deployment as the entire strategy.
Explanation
Correct Answers
B:Action: Establish a data management strategy tied to business outcomes and accountable stakeholders. The proposed intervention targets the reported issue. Data management creates value when its activities align with enterprise strategy rather than isolated tooling.
D:Verification: Approved objectives identify priority data capabilities, owners, measures and funded milestones. The observed result demonstrates whether the correction operates as intended. Data management creates value when its activities align with enterprise strategy rather than isolated tooling.
Incorrect Answers
A:This intervention is for a different scenario (A product team knows how records are created but has no plan for use, retention or disposal.), not the one stated. Appropriate action here: Establish a data management strategy tied to business outcomes and accountable stakeholders.
C:Verification: Quarterly measures show adoption, fewer material defects and demonstrable business value. This evidence is for a separate context (A chief data officer proposes a program measured only by number of dashboards published.), not this case. The valid outcome is: Approved objectives identify priority data capabilities, owners, measures and funded milestones.
E:Shortcut: Buy a catalog first and treat deployment as the entire strategy. This shortcut is not a sound remediation. Data management creates value when its activities align with enterprise strategy rather than isolated tooling. The appropriate action is: Establish a data management strategy tied to business outcomes and accountable stakeholders.
Question 538
In reviewing this data risk, select the LEAST defensible practice: Raw clickstream files are dumped into an object store without ownership, schema or discovery metadata.
- Preserve source evidence and document why any exception was approved.
- Document which dataset version was used in a material decision.
- Keep all raw files unlabeled and let analysts guess their meaning.
- Protect relevant audit records while investigating data problems.
Explanation
Correct Answer
C:Keep all raw files unlabeled and let analysts guess their meaning. A data lake becomes unusable when uncontrolled ingestion creates a data swamp. A sound response instead: Introduce ingestion metadata, dataset ownership, cataloging and quality checks for the lake.
Incorrect Answers
A:Preserve source evidence and document why any exception was approved. Traceability enables independent review of exceptions. The case-specific response is: Introduce ingestion metadata, dataset ownership, cataloging and quality checks for the lake.
B:Document which dataset version was used in a material decision. Version records support reproducible decisions. The case-specific response is: Introduce ingestion metadata, dataset ownership, cataloging and quality checks for the lake.
D:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Introduce ingestion metadata, dataset ownership, cataloging and quality checks for the lake.
Question 539
A proposed shortcut is offered for this situation: Executives need consistent historical revenue despite frequent transactional schema changes. Which choice is the CLEAREST mistake?
- Validate critical changes against representative positive and negative examples.
- Run expensive historical joins against production tables without design review.
- Document which dataset version was used in a material decision.
- Check that the proposed procedure has an identified operator and approval path.
Explanation
Correct Answer
B:Run expensive historical joins against production tables without design review. A warehouse supports integrated historical analysis distinct from operational transactions. A sound response instead: Build governed analytical integration and conformed business measures for reporting.
Incorrect Answers
A:Validate critical changes against representative positive and negative examples. Controlled tests provide more reliable proof than untested assumptions. The case-specific response is: Build governed analytical integration and conformed business measures for reporting.
C:Document which dataset version was used in a material decision. Version records support reproducible decisions. The case-specific response is: Build governed analytical integration and conformed business measures for reporting.
D:Check that the proposed procedure has an identified operator and approval path. Operational responsibility prevents undocumented workarounds. The case-specific response is: Build governed analytical integration and conformed business measures for reporting.
Question 540
A reviewer asks for proof of improvement: Leadership receives the total number of stewardship meetings as the sole effectiveness KPI. Which result MOST convincingly demonstrates that the control works?
- The exception has a named owner, time limit and independently monitored mitigation.
- The scorecard demonstrates measurable improvement and flags unresolved control failures.
- The ownership matrix identifies decision rights and contractual handoffs for each critical field.
- Teams implement specified checks and exception workflows tied to an approved policy.
Explanation
Correct Answer
B:It tests the action: Report meaningful risk, issue aging, quality compliance and business-value outcomes.
Incorrect Answers
A:The exception has a named owner, time limit and independently monitored mitigation. This would verify a different control (A business requests a temporary deviation from a sensitive data retention standard.), not the one in the question. The required evidence is: The scorecard demonstrates measurable improvement and flags unresolved control failures.
C:The ownership matrix identifies decision rights and contractual handoffs for each critical field. This would verify a different control (A dataset is copied into three systems and each team claims another group owns quality.), not the one in the question. The required evidence is: The scorecard demonstrates measurable improvement and flags unresolved control failures.
D:Teams implement specified checks and exception workflows tied to an approved policy. This would verify a different control (A company has a general policy promising accurate data but no operational validation thresholds.), not the one in the question. The required evidence is: The scorecard demonstrates measurable improvement and flags unresolved control failures.