CDMP DMF Practice Test 18
Question 170
Consider this data-management scenario: A matching algorithm merges a parent and child solely because they share surname and address. Which underlying principle MOST directly explains the preferred response?
- Entity resolution must balance false positive merges against missed duplicates.
- Master-data stewardship needs business authority for accepted entity definitions.
- Preventing duplicate creation is usually cheaper than repeated downstream reconciliation.
- Reference data consistency requires controlled publication and consumer adoption.
Explanation
Correct Answer
A:Entity resolution must balance false positive merges against missed duplicates. This concept explains the reason for the proposed control. Appropriate intervention: Use multiple discriminating attributes and calibrated match thresholds with review for uncertain pairs.
Incorrect Answers
B:Master-data stewardship needs business authority for accepted entity definitions. This is a defensible principle in another context (Marketing and finance disagree on who approves supplier legal entity identifiers.), not the most relevant rationale here. For the stated issue: Entity resolution must balance false positive merges against missed duplicates.
C:This is a defensible principle in another context (New customer onboarding creates a second record when spacing differs in a business name.), not the most relevant rationale here. For the stated issue: Entity resolution must balance false positive merges against missed duplicates.
D:Reference data consistency requires controlled publication and consumer adoption. This is a defensible principle in another context (A mobile app uses a currency-code list six months older than the payments platform.), not the most relevant rationale here. For the stated issue: Entity resolution must balance false positive merges against missed duplicates.
Question 171
The data program reviews the following failure: Analysts cannot tell whether customer_age means current age or age at first purchase. Which change should be prioritized?
- Use dependency lineage to assess downstream impact and coordinate migration.
- Collect operational metadata such as run timestamps, row counts and failure states.
- Capture technical metadata describing schemas, types, partitions and interfaces.
- Publish business metadata with precise glossary definitions and stewardship approval.
Explanation
Correct Answer
D:Publish business metadata with precise glossary definitions and stewardship approval. Business metadata describes meaning, purpose, ownership and policy context. Evidence to obtain: Users understand the term and can link it to approved datasets and business rules.
Incorrect Answers
A:This response fits a separate situation (A team plans to remove a source column that feeds several dashboards and fraud rules.), but does not resolve the stated case. Use dependency lineage to assess downstream impact and coordinate migration.
B:This response fits a separate situation (A pipeline silently stopped after a weekend but no one tracks run status or freshness.), but does not resolve the stated case. Collect operational metadata such as run timestamps, row counts and failure states.
C:Capture technical metadata describing schemas, types, partitions and interfaces. This response fits a separate situation (A data engineering team cannot determine the format and schema of a nightly inbound file.), but does not resolve the stated case. The targeted response is: Publish business metadata with precise glossary definitions and stewardship approval.
Question 172
Select TWO appropriate statements, one intervention and one verification, for this data management case: Finance and sales marts use different definitions of product category for the same item.
- Verification: Cross-mart comparisons reconcile categories for equivalent reporting periods.
- Shortcut: Keep conflicting labels and compare the resulting totals as equivalent.
- Action: Publish a conformed product dimension with agreed business categories and history rules.
- Action: Create a fact table with appropriate dimension foreign keys for a star schema.
- Verification: Slice-and-dice queries reconcile across dimensions and preserve base transaction state.
Explanation
Correct Answers
A:Verification: Cross-mart comparisons reconcile categories for equivalent reporting periods. The observed result demonstrates whether the correction operates as intended. Conformed dimensions enable consistent analyses across multiple facts and marts.
C:Action: Publish a conformed product dimension with agreed business categories and history rules. The proposed intervention targets the reported issue. Conformed dimensions enable consistent analyses across multiple facts and marts.
Incorrect Answers
B:Shortcut: Keep conflicting labels and compare the resulting totals as equivalent. This shortcut is not a sound remediation. Conformed dimensions enable consistent analyses across multiple facts and marts. The appropriate action is: Publish a conformed product dimension with agreed business categories and history rules.
D:This intervention is for a different scenario (Business users need to analyze order revenue by date, product and geography.), not the one stated.
E:Verification: Slice-and-dice queries reconcile across dimensions and preserve base transaction state. This evidence is for a separate context (A financial analyst needs totals by region and quarter without modifying source orders.), not this case. The valid outcome is: Cross-mart comparisons reconcile categories for equivalent reporting periods.
Question 173
A governance committee needs a defensible plan and proof: A party table mixes person birthdate with organization registration number, leaving ambiguous rules. Which paired proposal is appropriate?
- Action: Separate transitive department attributes into a referenced department relation. Verification: Renaming a department updates one authoritative record without conflicting employee copies.
- 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: Introduce a stable key and manage mutable natural identifiers as governed attributes. Verification: Email changes leave entity identity and referencing foreign keys intact.
- Action: Model an associative enrollment entity with both relationships and enrollment attributes. Verification: Enrolments are uniquely recorded without duplicate student or course entities.
Explanation
Correct Answer
B:Action: Use a common party supertype with justified person and organization subtypes. Verification: Shared identity fields are unified and subtype-specific validation is enforced. Both the intervention and measurable outcome are directly relevant. Subtype modeling represents common identity while preserving different business attributes.
Incorrect Answers
A:This plan addresses a different situation (An employee table stores department name determined by department_id, causing inconsistent renames.), not the targeted problem.
C: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: Use a common party supertype with justified person and organization subtypes.
D:This plan addresses a different situation (A student can enroll in many courses and a course can enroll many students.), not the targeted problem.
Question 174
A governance review considers the following: A retired system's catalog entries remain marked active, misleading new project teams. Which proposal would create an avoidable risk?
- Retain a rollback or recovery plan before making destructive data changes.
- Leave all retired entries certified forever because removal is inconvenient.
- Preserve source evidence and document why any exception was approved.
- Apply access controls proportional to the sensitivity of business information.
Explanation
Correct Answer
B:Leave all retired entries certified forever because removal is inconvenient. Metadata must reflect the lifecycle of the assets it describes. A sound response instead: Introduce active, deprecated and archived lifecycle states with accountable approval.
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: Introduce active, deprecated and archived lifecycle states with accountable approval.
C:Preserve source evidence and document why any exception was approved. Traceability enables independent review of exceptions. The case-specific response is: Introduce active, deprecated and archived lifecycle states with accountable approval.
D:Apply access controls proportional to the sensitivity of business information. Confidentiality obligations still apply during quality improvements. The case-specific response is: Introduce active, deprecated and archived lifecycle states with accountable approval.
Question 175
A data steward challenges an assumption in this case: Citizen analysts build dashboards using tables with unknown sensitivity and ambiguous joins. Which verification should be performed first?
- Test certified data products, user entitlements and join path validation.
- Trace sample source facts through grain rules to report totals.
- Inspect invoice event date, load watermark and restated monthly totals.
- Validate rollups, drilldowns, level definitions and source read-only access.
Explanation
Correct Answer
A:Test certified data products, user entitlements and join path validation. This test checks the relevant business and technical failure rather than assuming its cause. Self-service BI requires trusted reusable semantics and controlled access. Expected control result: Self-service reports use approved measures and respect data restrictions.
Incorrect Answers
B:Trace sample source facts through grain rules to report totals. This check would investigate another issue (A sales fact table mixes shipment-level and order-line-level amounts, doubling totals.), not the immediate case. The direct diagnostic is: Test certified data products, user entitlements and join path validation.
C:Inspect invoice event date, load watermark and restated monthly totals. This check would investigate another issue (A vendor invoice from last month arrives after the monthly warehouse close.), not the immediate case. The direct diagnostic is: Test certified data products, user entitlements and join path validation.
D:Validate rollups, drilldowns, level definitions and source read-only access. This check would investigate another issue (A financial analyst needs totals by region and quarter without modifying source orders.), not the immediate case. The direct diagnostic is: Test certified data products, user entitlements and join path validation.
Question 176
In reviewing this data risk, select the LEAST defensible practice: A contact table stores three comma-separated telephone numbers in one column.
- Preserve source evidence and document why any exception was approved.
- Add more delimiter characters to hold additional phone values in one cell.
- Retain a rollback or recovery plan before making destructive data changes.
- Inspect lineage and source context before changing a derived report.
Explanation
Correct Answer
B:Add more delimiter characters to hold additional phone values in one cell. First normal form discourages repeating groups and multi-valued atomic fields. A sound response instead: Model phone numbers as atomic repeating child records with appropriate identifiers.
Incorrect Answers
A:Preserve source evidence and document why any exception was approved. Traceability enables independent review of exceptions. The case-specific response is: Model phone numbers as atomic repeating child records with appropriate identifiers.
C:Retain a rollback or recovery plan before making destructive data changes. Recoverability reduces the consequences of incorrect remediation. The case-specific response is: Model phone numbers as atomic repeating child records with appropriate identifiers.
D:Inspect lineage and source context before changing a derived report. Provenance analysis distinguishes source errors from transformations. The case-specific response is: Model phone numbers as atomic repeating child records with appropriate identifiers.
Question 177
Which statement best describes the governing idea behind the response to this case: A product status field contains values archived and disabled although only active and retired are approved.
- Timeliness is fitness of information at the required decision moment.
- Uniqueness depends on the real-world entity being represented, not only string equality.
- Validity measures conformance to allowed formats, domains and business rules.
- Fitness for purpose includes contextual requirements beyond numeric precision.
Explanation
Correct Answer
C:Validity measures conformance to allowed formats, domains and business rules. This concept explains the reason for the proposed control. Appropriate intervention: Enforce governed domain rules at ingestion and monitor invalid values.
Incorrect Answers
A:Timeliness is fitness of information at the required decision moment. This is a defensible principle in another context (A fraud team receives transaction events forty minutes after its five-minute alert deadline.), not the most relevant rationale here. For the stated issue: Validity measures conformance to allowed formats, domains and business rules.
B:This is a defensible principle in another context (A CRM has duplicate contact records with different punctuation in their names.), not the most relevant rationale here. For the stated issue: Validity measures conformance to allowed formats, domains and business rules.
D:Fitness for purpose includes contextual requirements beyond numeric precision. 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: Validity measures conformance to allowed formats, domains and business rules.
Question 178
Select TWO appropriate statements, one intervention and one verification, for this data management case: An event consumer processes a payment notification twice after retry and creates duplicate ledger postings.
- Shortcut: Assume every message broker guarantees exactly-once business transactions end to end.
- Verification: Replayed events do not create duplicate postings and genuine events still post.
- Verification: The fraud service receives timely events while tax reporting reconciles its complete batch.
- Action: Evaluate governed federation or virtualization with source access, query pushdown and performance limits.
- Action: Use idempotent processing and durable identifiers with explicit delivery semantics.
Explanation
Correct Answers
B:Verification: Replayed events do not create duplicate postings and genuine events still post. The observed result demonstrates whether the correction operates as intended. At-least-once delivery requires consumers to tolerate duplicate messages.
E:Action: Use idempotent processing and durable identifiers with explicit delivery semantics. The proposed intervention targets the reported issue. At-least-once delivery requires consumers to tolerate duplicate messages.
Incorrect Answers
A:Shortcut: Assume every message broker guarantees exactly-once business transactions end to end. This shortcut is not a sound remediation. At-least-once delivery requires consumers to tolerate duplicate messages. The appropriate action is: Use idempotent processing and durable identifiers with explicit delivery semantics.
C:This evidence is for a separate context (A daily tax report and a live fraud decision service share one nightly transfer mechanism.), not this case.
D:Action: Evaluate governed federation or virtualization with source access, query pushdown and performance limits. This intervention is for a different scenario (An organization wants live access to distributed records without copying every source table.), not the one stated. Appropriate action here: Use idempotent processing and durable identifiers with explicit delivery semantics.
Question 179
Select TWO appropriate statements, one intervention and one verification, for this data management case: A shared customer dataset has no agreed defect response or availability expectations.
- Action: Reconcile tier definitions and synchronization logic using a defined authoritative source.
- Verification: Invalid dates are blocked at entry and legitimate exceptions are traceable.
- Verification: SLA measures and exceptions trigger response when thresholds are missed.
- Shortcut: Promise perfect quality without defining measurement or response responsibilities.
- Action: Define data-quality service levels for material fields with ownership and escalation.
Explanation
Correct Answers
C:Verification: SLA measures and exceptions trigger response when thresholds are missed. The observed result demonstrates whether the correction operates as intended. Quality commitments should reflect consuming business needs and operational accountability.
E:Action: Define data-quality service levels for material fields with ownership and escalation. The proposed intervention targets the reported issue. Quality commitments should reflect consuming business needs and operational accountability.
Incorrect Answers
A:This intervention is for a different scenario (The customer's tier is gold in billing but silver in the loyalty platform on the same date.), not the one stated.
B:Verification: Invalid dates are blocked at entry and legitimate exceptions are traceable. This evidence is for a separate context (Bad dates are entered during onboarding and corrected only after monthly reporting failures.), not this case. The valid outcome is: SLA measures and exceptions trigger response when thresholds are missed.
D:Shortcut: Promise perfect quality without defining measurement or response responsibilities. This shortcut is not a sound remediation. Quality commitments should reflect consuming business needs and operational accountability. The appropriate action is: Define data-quality service levels for material fields with ownership and escalation.
Question 180
After addressing this problem, what evidence would justify closure? A scientific dataset has fine precision but lacks metadata required for the regulator's audit.
- Every accepted line references a valid invoice or has an owned exception.
- The baseline includes measured distributions, anomalies and reliability of sampling.
- Regulatory users can reproduce lineage and assess permitted use of each observation.
- The proportion of applications with credible required income rises under a defined rule.
Explanation
Correct Answer
C:It tests the action: Evaluate quality against the specific consumer's required provenance and interpretability.
Incorrect Answers
A:Every accepted line references a valid invoice or has an owned exception. This would verify a different control (An invoice line appears without an invoice header after a partial load.), not the one in the question. The required evidence is: Regulatory users can reproduce lineage and assess permitted use of each observation.
B:The baseline includes measured distributions, anomalies and reliability of sampling. This would verify a different control (A data team wants to set quality targets before knowing null, duplicate and value distributions.), not the one in the question. The required evidence is: Regulatory users can reproduce lineage and assess permitted use of each observation.
D:The proportion of applications with credible required income rises under a defined rule. This would verify a different control (Loan applications often omit annual income even though policy requires it for underwriting.), not the one in the question. The required evidence is: Regulatory users can reproduce lineage and assess permitted use of each observation.