CDMP DMF Practice Test 83
Question 820
A reviewer asks for proof of improvement: A public catalog description reveals restricted patient identities in sample values. Which result MOST convincingly demonstrates that the control works?
- Reports cite approved term versions and consumers can identify differences.
- Unauthorized users see discovery descriptions but no confidential samples.
- Catalog times convert consistently with time zone and source provenance retained.
- A single discovery workflow retrieves consistent definitions and authoritative owners.
Explanation
Correct Answer
B:It tests the action: Classify metadata and restrict previews, samples and access to sensitive catalog fields.
Incorrect Answers
A:Reports cite approved term versions and consumers can identify differences. This would verify a different control (A term called revenue means gross receipts in one team and net receipts in another.), not the one in the question. The required evidence is: Unauthorized users see discovery descriptions but no confidential samples.
C:Catalog times convert consistently with time zone and source provenance retained. This would verify a different control (Three systems record table creation dates in incompatible time zones and formats.), not the one in the question. The required evidence is: Unauthorized users see discovery descriptions but no confidential samples.
D:A single discovery workflow retrieves consistent definitions and authoritative owners. This would verify a different control (Metadata lives in individual spreadsheets that differ on owners and field meanings.), not the one in the question. The required evidence is: Unauthorized users see discovery descriptions but no confidential samples.
Question 821
Select TWO appropriate statements, one intervention and one verification, for this data management case: New customer onboarding creates a second record when spacing differs in a business name.
- Action: Distribute reference versions through a governed publish/subscribe or release process.
- Action: Normalize relevant fields and check probable duplicates before creating master identities.
- Shortcut: Use only exact string equality and ignore documented variants.
- Verification: Known duplicate test cases are flagged while legitimate similar companies remain distinct.
- Verification: Country values map consistently and invalid codes fail controlled validation.
Explanation
Correct Answers
B:Action: Normalize relevant fields and check probable duplicates before creating master identities. The proposed intervention targets the reported issue. Preventing duplicate creation is usually cheaper than repeated downstream reconciliation.
D:Verification: Known duplicate test cases are flagged while legitimate similar companies remain distinct. The observed result demonstrates whether the correction operates as intended. Preventing duplicate creation is usually cheaper than repeated downstream reconciliation.
Incorrect Answers
A:Action: Distribute reference versions through a governed publish/subscribe or release process. This intervention is for a different scenario (A mobile app uses a currency-code list six months older than the payments platform.), not the one stated. Appropriate action here: Normalize relevant fields and check probable duplicates before creating master identities.
C:Shortcut: Use only exact string equality and ignore documented variants. This shortcut is not a sound remediation. Preventing duplicate creation is usually cheaper than repeated downstream reconciliation. The appropriate action is: Normalize relevant fields and check probable duplicates before creating master identities.
E:Verification: Country values map consistently and invalid codes fail controlled validation. This evidence is for a separate context (Three regions encode country using names, ISO codes and private numeric lists.), not this case. The valid outcome is: Known duplicate test cases are flagged while legitimate similar companies remain distinct.
Question 822
In reviewing this data risk, select the LEAST defensible practice: A sales fact table mixes shipment-level and order-line-level amounts, doubling totals.
- Multiply each order amount by the number of shipments when summarizing.
- Keep approved reference mappings versioned and traceable.
- Protect relevant audit records while investigating data problems.
- Check relevant business definitions before joining independently sourced data.
Explanation
Correct Answer
A:Multiply each order amount by the number of shipments when summarizing. This is the unsafe shortcut because it ignores the control logic. A consistent fact grain is required for correct dimensional aggregation. A sound response instead: State the fact grain explicitly and separate incompatible measures or aggregate correctly.
Incorrect Answers
B:Keep approved reference mappings versioned and traceable. Value meaning can change across time and applications. The case-specific response is: State the fact grain explicitly and separate incompatible measures or aggregate correctly.
C:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: State the fact grain explicitly and separate incompatible measures or aggregate correctly.
D:Check relevant business definitions before joining independently sourced data. Semantic agreements prevent incorrect cross-system correlations. The case-specific response is: State the fact grain explicitly and separate incompatible measures or aggregate correctly.
Question 823
Select TWO appropriate statements, one intervention and one verification, for this data management case: A customer changes region but analysts need sales under the region valid at each transaction date.
- Shortcut: Overwrite past region values and silently restate historical metrics.
- Action: Model phone numbers as atomic repeating child records with appropriate identifiers.
- Verification: Consumers migrate deliberately and production queries avoid unexpected breakage.
- Action: Model history with effective-dated dimension versions when historical attribution matters.
- Verification: Historical sales continue to use the correct prior region while current records use the new one.
Explanation
Correct Answers
D:Action: Model history with effective-dated dimension versions when historical attribution matters. The proposed intervention targets the reported issue. Temporal modeling preserves time-dependent truth needed for historical analysis.
E:Verification: Historical sales continue to use the correct prior region while current records use the new one. The observed result demonstrates whether the correction operates as intended. Temporal modeling preserves time-dependent truth needed for historical analysis.
Incorrect Answers
A:Shortcut: Overwrite past region values and silently restate historical metrics. This shortcut is not a sound remediation. Temporal modeling preserves time-dependent truth needed for historical analysis. The appropriate action is: Model history with effective-dated dimension versions when historical attribution matters.
B:Action: Model phone numbers as atomic repeating child records with appropriate identifiers. This intervention is for a different scenario (A contact table stores three comma-separated telephone numbers in one column.), not the one stated. Appropriate action here: Model history with effective-dated dimension versions when historical attribution matters.
C:The valid outcome is: Historical sales continue to use the correct prior region while current records use the new one.
Question 824
A reviewer asks for proof of improvement: Different pipelines enforce different allowable values for the same governed country field. Which result MOST convincingly demonstrates that the control works?
- Equivalent datasets are evaluated against the same approved country-code version.
- Disallowed statuses are rejected or recorded in an exception workflow.
- End-to-end event latency meets the defined threshold for relevant transactions.
- A sampled comparison confirms the stored address reflects current real-world facts.
Explanation
Correct Answer
A:It tests the action: Publish reusable data-quality rules with owners, thresholds and exceptions.
Incorrect Answers
B:Disallowed statuses are rejected or recorded in an exception workflow. This would verify a different control (A product status field contains values archived and disabled although only active and retired are approved.), not the one in the question. The required evidence is: Equivalent datasets are evaluated against the same approved country-code version.
C:End-to-end event latency meets the defined threshold for relevant transactions. This would verify a different control (A fraud team receives transaction events forty minutes after its five-minute alert deadline.), not the one in the question. The required evidence is: Equivalent datasets are evaluated against the same approved country-code version.
D:A sampled comparison confirms the stored address reflects current real-world facts. This would verify a different control (A customer's billing address is validly formatted but refers to a previous residence.), not the one in the question. The required evidence is: Equivalent datasets are evaluated against the same approved country-code version.
Question 825
A data steward challenges an assumption in this case: An upstream API changes a numeric customer status code into a text value and breaks consumers. Which verification should be performed first?
- Inspect transfer encryption, bucket permissions, retention and operational logs.
- Review latency budgets, recovery tests, consistency constraints and failure modes.
- Replay contract examples through old and new consumers and inspect validation failures.
- Compare source watermarks, late-arrival counts and target reconciliation results.
Explanation
Correct Answer
C:This test checks the relevant business and technical failure rather than assuming its cause. Expected control result: Consumer integration tests pass or the incompatible change is deliberately migrated.
Incorrect Answers
A: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: Replay contract examples through old and new consumers and inspect validation failures.
B:Review latency budgets, recovery tests, consistency constraints and failure modes. This check would investigate another issue (A daily tax report and a live fraud decision service share one nightly transfer mechanism.), not the immediate case. The direct diagnostic is: Replay contract examples through old and new consumers and inspect validation failures.
D:Compare source watermarks, late-arrival counts and target reconciliation results. This check would investigate another issue (Finance reports omit transactions because an extraction job silently skips late-arriving records.), not the immediate case. The direct diagnostic is: Replay contract examples through old and new consumers and inspect validation failures.
Question 826
Before changing procedures, the team investigates: A risk report uses an old industry code mapping but its catalog does not record which version. Which review or test MOST directly locates the relevant failure?
- Compare catalog schemas with actual source files and pipeline expectations.
- Audit catalog freshness and ownership against active application inventories.
- Test semantic queries, metric totals and join validity against sample facts.
- Trace a report row to mapping versions, key lookups and source codes.
Explanation
Correct Answer
D:Trace a report row to mapping versions, key lookups and source codes. This test checks the relevant business and technical failure rather than assuming its cause. Lineage includes reference transformations, not just source-to-target copying. Expected control result: Risk report runs identify applicable mapping versions and affected records.
Incorrect Answers
A: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 a report row to mapping versions, key lookups and source codes.
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 a report row to mapping versions, key lookups and source codes.
C:Test semantic queries, metric totals and join validity against sample facts. This check would investigate another issue (Reports join unrelated entities because business dimensions lack a mapped semantic model.), not the immediate case. The direct diagnostic is: Trace a report row to mapping versions, key lookups and source codes.
Question 827
Consider this organizational data problem: A product description contains a typo and historic analytics do not need the old spelling. What action is most defensible?
- Use a Type 1 overwrite for the corrected descriptive attribute under change control.
- Publish a conformed product dimension with agreed business categories and history rules.
- Govern mart sourcing and shared dimensions while allowing fit-for-purpose views.
- Apply consistent currency conversion rules with effective rates and labeled units.
Explanation
Correct Answer
A:Use a Type 1 overwrite for the corrected descriptive attribute under change control. Type 1 slowly changing dimensions replace values when historical changes are unnecessary. Evidence to obtain: Current and historical queries show the corrected description without extra history rows.
Incorrect Answers
B:Publish a conformed product dimension with agreed business categories and history rules. This response fits a separate situation (Finance and sales marts use different definitions of product category for the same item.), but does not resolve the stated case. The targeted response is: Use a Type 1 overwrite for the corrected descriptive attribute under change control.
C:Govern mart sourcing and shared dimensions while allowing fit-for-purpose views. This response fits a separate situation (Business units create separate departmental marts from inconsistent extracts of customer master data.), but does not resolve the stated case. The targeted response is: Use a Type 1 overwrite for the corrected descriptive attribute under change control.
D:Apply consistent currency conversion rules with effective rates and labeled units. This response fits a separate situation (A dashboard shows revenue increasing sharply because source currency values are mixed without conversion.), but does not resolve the stated case. The targeted response is: Use a Type 1 overwrite for the corrected descriptive attribute under change control.
Question 828
A data steward challenges an assumption in this case: A star-schema dashboard query repeatedly scans granular facts for the same monthly totals. Which verification should be performed first?
- Inspect dimension record count and description after controlled correction.
- Recompute representative totals using source currency, rates and period.
- Compare aggregate totals to detail and monitor refresh delay.
- Review historical fact loads, source reconciliation and business metric conformance.
Explanation
Correct Answer
C:Compare aggregate totals to detail and monitor refresh delay. This test checks the relevant business and technical failure rather than assuming its cause. Preaggregation trades computation cost for maintenance and freshness requirements. Expected control result: Frequent monthly queries speed up while aggregates remain current and correct.
Incorrect Answers
A:Inspect dimension record count and description after controlled correction. This check would investigate another issue (A product description contains a typo and historic analytics do not need the old spelling.), not the immediate case. The direct diagnostic is: Compare aggregate totals to detail and monitor refresh delay.
B:Recompute representative totals using source currency, rates and period. This check would investigate another issue (A dashboard shows revenue increasing sharply because source currency values are mixed without conversion.), not the immediate case. The direct diagnostic is: Compare aggregate totals to detail and monitor refresh delay.
D:Review historical fact loads, source reconciliation and business metric conformance. This check would investigate another issue (Executives need consistent historical revenue despite frequent transactional schema changes.), not the immediate case. The direct diagnostic is: Compare aggregate totals to detail and monitor refresh delay.
Question 829
An accountable team must correct this problem and prove results. Select TWO sound statements: A contact table stores three comma-separated telephone numbers in one column.
- Action: Derive physical tables, constraints, indexes and data types for the target workload.
- Shortcut: Add more delimiter characters to hold additional phone values in one cell.
- Action: Model phone numbers as atomic repeating child records with appropriate identifiers.
- Verification: Consumers distinguish business lifecycle state from technical processing status.
- Verification: Each number is independently searchable and maintained without string parsing.
Explanation
Correct Answers
C:Action: Model phone numbers as atomic repeating child records with appropriate identifiers. The proposed intervention targets the reported issue. First normal form discourages repeating groups and multi-valued atomic fields.
E:Verification: Each number is independently searchable and maintained without string parsing. The observed result demonstrates whether the correction operates as intended. First normal form discourages repeating groups and multi-valued atomic fields.
Incorrect Answers
A:This intervention is for a different scenario (A logical model is approved but a PostgreSQL implementation needs columns and access paths.), not the one stated.
B:Shortcut: Add more delimiter characters to hold additional phone values in one cell. This shortcut is not a sound remediation. First normal form discourages repeating groups and multi-valued atomic fields. The appropriate action is: Model phone numbers as atomic repeating child records with appropriate identifiers.
D:Verification: Consumers distinguish business lifecycle state from technical processing status. This evidence is for a separate context (Teams use inconsistent definitions for status and state across logical models.), not this case. The valid outcome is: Each number is independently searchable and maintained without string parsing.
Question 830
The data management team encounters this situation: A product status field contains values archived and disabled although only active and retired are approved. Which intervention BEST addresses the actual problem?
- Enforce governed domain rules at ingestion and monitor invalid values.
- Apply referential integrity or explicit orphan reconciliation across source and target.
- Combine validity metrics with completeness of data delivery and denominator controls.
- Assess completeness and timeliness separately, then choose remediation based on use.
Explanation
Correct Answer
A:Enforce governed domain rules at ingestion and monitor invalid values. Validity measures conformance to allowed formats, domains and business rules. Evidence to obtain: Disallowed statuses are rejected or recorded in an exception workflow.
Incorrect Answers
B:Apply referential integrity or explicit orphan reconciliation across source and target. This response fits a separate situation (An invoice line appears without an invoice header after a partial load.), but does not resolve the stated case. The targeted response is: Enforce governed domain rules at ingestion and monitor invalid values.
C:This response fits a separate situation (A scorecard reports 99 percent valid rows but excludes an entire failed daily feed.), but does not resolve the stated case.
D:Assess completeness and timeliness separately, then choose remediation based on use. This response fits a separate situation (A postal address field is 100 percent complete but several entries are no longer current.), but does not resolve the stated case. The targeted response is: Enforce governed domain rules at ingestion and monitor invalid values.