CDMP DMF Practice Test 31
Question 300
A governance committee needs a defensible plan and proof: A matching algorithm merges a parent and child solely because they share surname and address. Which paired proposal is appropriate?
- Action: Use multiple discriminating attributes and calibrated match thresholds with review for uncertain pairs. Verification: Verified false merges decrease without unacceptable missed true matches.
- Action: Assign a data owner and stewardship process for supplier master definitions and changes. Verification: Change requests are approved by an accountable owner and validated before distribution.
- Action: Manage reference data as effective-dated versions with historical mapping support. Verification: Historical reports use previous mappings while current queries use approved new categories.
- Action: Distribute reference versions through a governed publish/subscribe or release process. Verification: Consumers use supported versions and invalid currency codes trigger clear exceptions.
Explanation
Correct Answer
A:Action: Use multiple discriminating attributes and calibrated match thresholds with review for uncertain pairs. Verification: Verified false merges decrease without unacceptable missed true matches. Both the intervention and measurable outcome are directly relevant. Entity resolution must balance false positive merges against missed duplicates.
Incorrect Answers
B:This plan addresses a different situation (Marketing and finance disagree on who approves supplier legal entity identifiers.), not the targeted problem.
C:This plan addresses a different situation (A product taxonomy changes in January but last year's reports must preserve prior category assignments.), not the targeted problem.
D:This plan addresses a different situation (A mobile app uses a currency-code list six months older than the payments platform.), not the targeted problem. Here, action and evidence must match: Action: Use multiple discriminating attributes and calibrated match thresholds with review for uncertain pairs.
Question 301
The data program reviews the following failure: A warehouse fact table mixes one-row-per-order and one-row-per-order-line measures. Which change should be prioritized?
- Declare a single fact grain and separate or aggregate measures consistently.
- Create a conceptual model of core business entities and relationships without implementation details.
- Model history with effective-dated dimension versions when historical attribution matters.
- Define entities, attributes, relationships, optionality and business keys in a logical model.
Explanation
Correct Answer
A:Declare a single fact grain and separate or aggregate measures consistently. Dimensional modeling requires an unambiguous grain for additive measures. Evidence to obtain: Totals reconcile without double-counting headers across line-level analysis.
Incorrect Answers
B:Create a conceptual model of core business entities and relationships without implementation details.
C: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. Model history with effective-dated dimension versions when historical attribution matters.
D:Define entities, attributes, relationships, optionality and business keys in a logical model.
Question 302
A proposed shortcut is offered for this situation: An analytics platform loads source extracts into a warehouse then performs transformations there. Which choice is the CLEAREST mistake?
- Assume pushing transformations to the warehouse guarantees semantic consistency.
- Respect active legal holds before scheduling record disposition.
- Keep approved reference mappings versioned and traceable.
- Validate critical changes against representative positive and negative examples.
Explanation
Correct Answer
A:Assume pushing transformations to the warehouse guarantees semantic consistency. ELT moves transformation into the target platform but does not remove data quality obligations. A sound response instead: Govern landing, transformation logic, lineage and compute costs in a controlled ELT workflow.
Incorrect Answers
B:Respect active legal holds before scheduling record disposition. Preservation duties may override scheduled destruction. The case-specific response is: Govern landing, transformation logic, lineage and compute costs in a controlled ELT workflow.
C:Keep approved reference mappings versioned and traceable. Value meaning can change across time and applications. The case-specific response is: Govern landing, transformation logic, lineage and compute costs in a controlled ELT workflow.
D:Validate critical changes against representative positive and negative examples. Controlled tests provide more reliable proof than untested assumptions. The case-specific response is: Govern landing, transformation logic, lineage and compute costs in a controlled ELT workflow.
Question 303
A data steward challenges an assumption in this case: A compliance report is wrong but no one knows which source change introduced the value. Which verification should be performed first?
- Inspect run logs, watermarks, failure alerts and last-successful-load times.
- Audit catalog freshness and ownership against active application inventories.
- Compare catalog schemas with actual source files and pipeline expectations.
- Trace one critical metric through source attributes and transformation code.
Explanation
Correct Answer
D:Trace one critical metric through source attributes and transformation code. This test checks the relevant business and technical failure rather than assuming its cause. Lineage explains data origin and movement through transformation dependencies. Expected control result: An analyst traces a suspect field back to its origin and responsible transformation.
Incorrect Answers
A:Inspect run logs, watermarks, failure alerts and last-successful-load times. This check would investigate another issue (A pipeline silently stopped after a weekend but no one tracks run status or freshness.), not the immediate case. The direct diagnostic is: Trace one critical metric through source attributes and transformation code.
B: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: Trace one critical metric through source attributes and transformation code.
C:Compare catalog schemas with actual source files and pipeline expectations. This check would investigate another issue (A data engineering team cannot determine the format and schema of a nightly inbound file.), not the immediate case. The direct diagnostic is: Trace one critical metric through source attributes and transformation code.
Question 304
An accountable data owner wants both a response and a measurable check: A product status field contains values archived and disabled although only active and retired are approved. Which action-and-evidence pair is BEST?
- Action: Enforce governed domain rules at ingestion and monitor invalid values. Verification: Disallowed statuses are rejected or recorded in an exception workflow.
- Action: Evaluate quality against the specific consumer's required provenance and interpretability. Verification: Regulatory users can reproduce lineage and assess permitted use of each observation.
- Action: Combine validity metrics with completeness of data delivery and denominator controls. Verification: Quality scores include expected records and flag unavailable populations.
- Action: Reconcile tier definitions and synchronization logic using a defined authoritative source. Verification: Tier values agree for the same customer and effective period across systems.
Explanation
Correct Answer
A:Action: Enforce governed domain rules at ingestion and monitor invalid values. Verification: Disallowed statuses are rejected or recorded in an exception workflow. Both the intervention and measurable outcome are directly relevant. Validity measures conformance to allowed formats, domains and business rules.
Incorrect Answers
B:This plan addresses a different situation (A scientific dataset has fine precision but lacks metadata required for the regulator's audit.), not the targeted problem. Here, action and evidence must match: Action: Enforce governed domain rules at ingestion and monitor invalid values.
C: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: Enforce governed domain rules at ingestion and monitor invalid values.
D:This plan addresses a different situation (The customer's tier is gold in billing but silver in the loyalty platform on the same date.), not the targeted problem. Here, action and evidence must match: Action: Enforce governed domain rules at ingestion and monitor invalid values.
Question 305
After addressing this problem, what evidence would justify closure? An organization compares central warehouse, decentralized data products and a virtualization layer for analytics.
- The selected pattern has recorded tradeoffs and meets representative end-to-end workload tests.
- Auditors can trace the metric through transformations and responsible systems.
- Design reviews record compliance, rationale, owners and remediation for deviations.
- Conformance tests show field meanings and changes remain compatible with consuming systems.
Explanation
Correct Answer
A:It tests the action: Assess patterns against consistency, latency, autonomy, cost, governance and security needs.
Incorrect Answers
B: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: The selected pattern has recorded tradeoffs and meets representative end-to-end workload tests.
C:Design reviews record compliance, rationale, owners and remediation for deviations. This would verify a different control (A transformation program has diagrams but no one decides whether new platforms meet enterprise principles.), not the one in the question. The required evidence is: The selected pattern has recorded tradeoffs and meets representative end-to-end workload tests.
D: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: The selected pattern has recorded tradeoffs and meets representative end-to-end workload tests.
Question 306
A proposed shortcut is offered for this situation: A new payments division launches products without agreeing how customer data supports business objectives. Which choice is the CLEAREST mistake?
- Protect relevant audit records while investigating data problems.
- Buy a catalog first and treat deployment as the entire strategy.
- Inspect lineage and source context before changing a derived report.
- Escalate material unresolved issues to an accountable business decision owner.
Explanation
Correct Answer
B:Buy a catalog first and treat deployment as the entire strategy. Data management creates value when its activities align with enterprise strategy rather than isolated tooling. A sound response instead: Establish a data management strategy tied to business outcomes and accountable stakeholders.
Incorrect Answers
A:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Establish a data management strategy tied to business outcomes and accountable stakeholders.
C:Inspect lineage and source context before changing a derived report. Provenance analysis distinguishes source errors from transformations. The case-specific response is: Establish a data management strategy tied to business outcomes and accountable stakeholders.
D:Escalate material unresolved issues to an accountable business decision owner. Accountability prevents silent acceptance of consequential risk. The case-specific response is: Establish a data management strategy tied to business outcomes and accountable stakeholders.
Question 307
A governance review considers the following: Teams use inconsistent definitions for status and state across logical models. Which proposal would create an avoidable risk?
- Rename fields identically while keeping conflicting semantics.
- Document which dataset version was used in a material decision.
- Separate short-term issue containment from durable root-cause correction.
- Check that the proposed procedure has an identified operator and approval path.
Explanation
Correct Answer
A:Rename fields identically while keeping conflicting semantics. Naming standards improve understandability but must reflect precise meanings. A sound response instead: Apply naming, glossary mapping and controlled definitions to important model elements.
Incorrect Answers
B:Document which dataset version was used in a material decision. Version records support reproducible decisions. The case-specific response is: Apply naming, glossary mapping and controlled definitions to important model elements.
C:Separate short-term issue containment from durable root-cause correction. An immediate workaround rarely proves the defect cannot recur. The case-specific response is: Apply naming, glossary mapping and controlled definitions to important model elements.
D:Check that the proposed procedure has an identified operator and approval path. Operational responsibility prevents undocumented workarounds. The case-specific response is: Apply naming, glossary mapping and controlled definitions to important model elements.
Question 308
An accountable team must correct this problem and prove results. Select TWO sound statements: Catalog entries become stale because their data owners were never assigned responsibility.
- Verification: Owner, definition and quality metadata stay current after system changes.
- Shortcut: Import all metadata once and disable future review or updates.
- Action: Automate metadata harvesting with change detection and controlled owner validation.
- Verification: Consumers see retirement dates, replacements and appropriate access warnings.
- Action: Assign accountable metadata stewards and automated review reminders for priority assets.
Explanation
Correct Answers
A:Verification: Owner, definition and quality metadata stay current after system changes. The observed result demonstrates whether the correction operates as intended. Metadata quality depends on ongoing stewardship rather than one-time catalog loading.
E:Action: Assign accountable metadata stewards and automated review reminders for priority assets. The proposed intervention targets the reported issue. Metadata quality depends on ongoing stewardship rather than one-time catalog loading.
Incorrect Answers
B:Shortcut: Import all metadata once and disable future review or updates. This shortcut is not a sound remediation. Metadata quality depends on ongoing stewardship rather than one-time catalog loading. The appropriate action is: Assign accountable metadata stewards and automated review reminders for priority assets.
C:Action: Automate metadata harvesting with change detection and controlled owner validation. This intervention is for a different scenario (A source database gains fields but the catalog schema remains unchanged for months.), not the one stated. Appropriate action here: Assign accountable metadata stewards and automated review reminders for priority assets.
D:Verification: Consumers see retirement dates, replacements and appropriate access warnings. This evidence is for a separate context (A retired system's catalog entries remain marked active, misleading new project teams.), not this case. The valid outcome is: Owner, definition and quality metadata stay current after system changes.
Question 309
A data steward examines this condition: Reports join unrelated entities because business dimensions lack a mapped semantic model. What concept best justifies the corrective approach?
- Lineage explains data origin and movement through transformation dependencies.
- Semantic metadata bridges technical schemas and business interpretation.
- Automated harvesting can reduce catalog staleness but still needs semantic stewardship.
- Metadata quality is a governable data-quality problem with measurable dimensions.
Explanation
Correct Answer
B:Semantic metadata bridges technical schemas and business interpretation. This concept explains the reason for the proposed control. Appropriate intervention: Define approved semantic relationships, metric calculations and valid join paths.
Incorrect Answers
A:Lineage explains data origin and movement through transformation dependencies. This is a defensible principle in another context (A compliance report is wrong but no one knows which source change introduced the value.), not the most relevant rationale here. For the stated issue: Semantic metadata bridges technical schemas and business interpretation.
C:Automated harvesting can reduce catalog staleness but still needs semantic stewardship. This is a defensible principle in another context (A source database gains fields but the catalog schema remains unchanged for months.), not the most relevant rationale here. For the stated issue: Semantic metadata bridges technical schemas and business interpretation.
D:Metadata quality is a governable data-quality problem with measurable dimensions. This is a defensible principle in another context (A catalog lists every dataset but half of its owners and descriptions are outdated.), not the most relevant rationale here. For the stated issue: Semantic metadata bridges technical schemas and business interpretation.
Question 310
A governance review considers the following: Data-quality defects recur because workers close tickets without addressing causes. Which proposal would create an avoidable risk?
- Inspect lineage and source context before changing a derived report.
- Apply access controls proportional to the sensitivity of business information.
- Escalate material unresolved issues to an accountable business decision owner.
- Close all tickets when their SLA clock expires regardless of unresolved data.
Explanation
Correct Answer
D:Close all tickets when their SLA clock expires regardless of unresolved data. Governance issue management must address root causes and accountability. A sound response instead: Use a governed issue workflow with severity, ownership, root cause and independent closure validation.
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: Use a governed issue workflow with severity, ownership, root cause and independent closure validation.
B:Apply access controls proportional to the sensitivity of business information. Confidentiality obligations still apply during quality improvements. The case-specific response is: Use a governed issue workflow with severity, ownership, root cause and independent closure validation.
C:Escalate material unresolved issues to an accountable business decision owner. Accountability prevents silent acceptance of consequential risk. The case-specific response is: Use a governed issue workflow with severity, ownership, root cause and independent closure validation.