CDMP DMF Practice Test 8
Question 70
An accountable team must correct this problem and prove results. Select TWO sound statements: A product taxonomy changes in January but last year's reports must preserve prior category assignments.
- Shortcut: Replace historical code descriptions in place and recalculate old reports silently.
- Action: Design coexistence MDM with controlled bidirectional synchronization and conflict handling.
- Verification: The organization links to multiple roles without conflating role-specific permissions.
- Verification: Historical reports use previous mappings while current queries use approved new categories.
- Action: Manage reference data as effective-dated versions with historical mapping support.
Explanation
Correct Answers
D:Verification: Historical reports use previous mappings while current queries use approved new categories. The observed result demonstrates whether the correction operates as intended. Reference-data changes can alter meaning across time and require controlled versions.
E:Action: Manage reference data as effective-dated versions with historical mapping support. The proposed intervention targets the reported issue. Reference-data changes can alter meaning across time and require controlled versions.
Incorrect Answers
A:Shortcut: Replace historical code descriptions in place and recalculate old reports silently. This shortcut is not a sound remediation. Reference-data changes can alter meaning across time and require controlled versions. The appropriate action is: Manage reference data as effective-dated versions with historical mapping support.
B:Action: Design coexistence MDM with controlled bidirectional synchronization and conflict handling. This intervention is for a different scenario (Business units need local writes but also expect synchronized approved enterprise attributes.), not the one stated. Appropriate action here: Manage reference data as effective-dated versions with historical mapping support.
C:This evidence is for a separate context (One organization can be both a supplier and customer, but systems duplicate its legal entity per role.), not this case. The valid outcome is: Historical reports use previous mappings while current queries use approved new categories.
Question 71
A data steward examines this condition: A replica exists for critical reads but failover has never been validated. What concept best justifies the corrective approach?
- Operational retention should satisfy business, privacy and preservation obligations.
- Replication improves availability only when failover and consistency assumptions are tested.
- A backup is not demonstrably useful until recoverability has been tested.
- RPO limits acceptable data loss while RTO limits acceptable service downtime.
Explanation
Correct Answer
B:Replication improves availability only when failover and consistency assumptions are tested. This concept explains the reason for the proposed control. Appropriate intervention: Design and test failover, client reconnection and replica consistency under representative faults.
Incorrect Answers
A:Operational retention should satisfy business, privacy and preservation obligations. This is a defensible principle in another context (Operational logs contain sensitive identifiers beyond the allowed retention period.), not the most relevant rationale here. For the stated issue: Replication improves availability only when failover and consistency assumptions are tested.
C:This is a defensible principle in another context (A production database has daily backups but no successful restore has been performed.), not the most relevant rationale here. For the stated issue: Replication improves availability only when failover and consistency assumptions are tested.
D:This is a defensible principle in another context (A service can tolerate one hour of data loss but must return within fifteen minutes of outage.), not the most relevant rationale here.
Question 72
In reviewing this data risk, select the LEAST defensible practice: Customer identifiers differ across sales, billing and support, preventing consistent reporting.
- Keep approved reference mappings versioned and traceable.
- Define the intended data population before interpreting quality percentages.
- Let every application invent permanent customer semantics without reconciliation.
- Apply access controls proportional to the sensitivity of business information.
Explanation
Correct Answer
C:Let every application invent permanent customer semantics without reconciliation. Data architecture provides enterprise-wide direction for how data is structured and flows. A sound response instead: Publish target enterprise data architecture with shared identity principles and integration boundaries.
Incorrect Answers
A:Keep approved reference mappings versioned and traceable. Value meaning can change across time and applications. The case-specific response is: Publish target enterprise data architecture with shared identity principles and integration boundaries.
B:Define the intended data population before interpreting quality percentages. An undisclosed denominator can make strong scores misleading. The case-specific response is: Publish target enterprise data architecture with shared identity principles and integration boundaries.
D:Apply access controls proportional to the sensitivity of business information. Confidentiality obligations still apply during quality improvements. The case-specific response is: Publish target enterprise data architecture with shared identity principles and integration boundaries.
Question 73
The data program reviews the following failure: Finance reports omit transactions because an extraction job silently skips late-arriving records. Which change should be prioritized?
- Add completeness reconciliation, lateness handling and replay controls to the ETL pipeline.
- Use idempotent processing and durable identifiers with explicit delivery semantics.
- Establish a versioned API contract and compatibility tests before deploying breaking changes.
- Apply data minimization, encryption, scoped access and deletion controls across the transfer path.
Explanation
Correct Answer
A:Add completeness reconciliation, lateness handling and replay controls to the ETL pipeline. Data integration reliability requires observable completeness and repeatable recovery. Evidence to obtain: Source-to-target counts and financial totals reconcile after late batches are processed.
Incorrect Answers
B:Use idempotent processing and durable identifiers with explicit delivery semantics. This response fits a separate situation (An event consumer processes a payment notification twice after retry and creates duplicate ledger postings.), but does not resolve the stated case. The targeted response is: Add completeness reconciliation, lateness handling and replay controls to the ETL pipeline.
C:This response fits a separate situation (An upstream API changes a numeric customer status code into a text value and breaks consumers.), but does not resolve the stated case. Establish a versioned API contract and compatibility tests before deploying breaking changes.
D:Apply data minimization, encryption, scoped access and deletion controls across the transfer path.
Question 74
A data steward challenges an assumption in this case: Finance reports omit transactions because an extraction job silently skips late-arriving records. Which verification should be performed first?
- Inject retries and inspect deduplication keys and final ledger balances.
- Test source outages, federated query plans, data permissions and cache behavior.
- Compare source watermarks, late-arrival counts and target reconciliation results.
- Compare source log positions, captured changes and target application results.
Explanation
Correct Answer
C:Compare source watermarks, late-arrival counts and target reconciliation results. This test checks the relevant business and technical failure rather than assuming its cause. Data integration reliability requires observable completeness and repeatable recovery. Expected control result: Source-to-target counts and financial totals reconcile after late batches are processed.
Incorrect Answers
A:Inject retries and inspect deduplication keys and final ledger balances. This check would investigate another issue (An event consumer processes a payment notification twice after retry and creates duplicate ledger postings.), not the immediate case. The direct diagnostic is: Compare source watermarks, late-arrival counts and target reconciliation results.
B:Test source outages, federated query plans, data permissions and cache behavior. This check would investigate another issue (An organization wants live access to distributed records without copying every source table.), not the immediate case. The direct diagnostic is: Compare source watermarks, late-arrival counts and target reconciliation results.
D:Compare source log positions, captured changes and target application results. This check would investigate another issue (A customer platform needs low-latency updates without repeatedly scanning entire operational tables.), not the immediate case. The direct diagnostic is: Compare source watermarks, late-arrival counts and target reconciliation results.
Question 75
The data program reviews the following failure: Finance and sales marts use different definitions of product category for the same item. Which change should be prioritized?
- Publish a conformed product dimension with agreed business categories and history rules.
- Apply consistent currency conversion rules with effective rates and labeled units.
- Use Type 2 dimension rows with effective dates, surrogate keys and validity checks.
- Govern KPI definitions, filters, denominator and time rules across reporting tools.
Explanation
Correct Answer
A:Publish a conformed product dimension with agreed business categories and history rules. Conformed dimensions enable consistent analyses across multiple facts and marts. Evidence to obtain: Cross-mart comparisons reconcile categories for equivalent reporting periods.
Incorrect Answers
B: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. Apply consistent currency conversion rules with effective rates and labeled units.
C:This response fits a separate situation (A salesperson moves territories and historical sales must remain attributed to prior territory.), but does not resolve the stated case. Use Type 2 dimension rows with effective dates, surrogate keys and validity checks.
D:This response fits a separate situation (Two executive dashboards both show profit margin but use different numerator adjustments.), but does not resolve the stated case.
Question 76
Consider this organizational data problem: Marketing requests full birth dates for a campaign that only needs age bands. What action is most defensible?
- Classify sensitive fields and apply controls aligned to business and regulatory risk.
- Share only derived age ranges under approved purpose and retention controls.
- Enable protected access and export audit logs with appropriate retention and review.
- Grant narrow read access to approved views instead of broad administrative rights.
Explanation
Correct Answer
B:Share only derived age ranges under approved purpose and retention controls. Data minimization limits processing to what the justified purpose requires. Evidence to obtain: The campaign operates while recipients cannot retrieve unnecessary full dates.
Incorrect Answers
A:This response fits a separate situation (A developer stores payment account numbers in a general-purpose dataset tagged public.), but does not resolve the stated case. Classify sensitive fields and apply controls aligned to business and regulatory risk.
C:This response fits a separate situation (Privileged database exports are possible but no one records who initiated them.), but does not resolve the stated case. Enable protected access and export audit logs with appropriate retention and review.
D:Grant narrow read access to approved views instead of broad administrative rights.
Question 77
Which statement best describes the governing idea behind the response to this case: A term called revenue means gross receipts in one team and net receipts in another.
- Technical metadata records how data is structurally represented and processed.
- Metadata catalogs should support discovery and trust, not merely list files.
- A metadata repository supports shared, managed descriptions across assets.
- A business glossary aligns organizational terminology and semantic context.
Explanation
Correct Answer
D:A business glossary aligns organizational terminology and semantic context. This concept explains the reason for the proposed control. Appropriate intervention: Define and approve a glossary term with qualified variants and linked calculations.
Incorrect Answers
A:This is a defensible principle in another context (A data engineering team cannot determine the format and schema of a nightly inbound file.), not the most relevant rationale here. For the stated issue: A business glossary aligns organizational terminology and semantic context.
B:This is a defensible principle in another context (Users search for a customer dataset but see dozens of unlabeled backups ahead of certified sources.), not the most relevant rationale here. For the stated issue: A business glossary aligns organizational terminology and semantic context.
C:A metadata repository supports shared, managed descriptions across assets. This is a defensible principle in another context (Metadata lives in individual spreadsheets that differ on owners and field meanings.), not the most relevant rationale here. For the stated issue: A business glossary aligns organizational terminology and semantic context.
Question 78
Consider this organizational data problem: A regulatory metric cannot be reconciled to the systems that initially captured its values. What action is most defensible?
- Establish an architecture review board with documented authority and exception controls.
- Agree enterprise-level business concepts and relationships before mapping physical application schemas.
- Publish target enterprise data architecture with shared identity principles and integration boundaries.
- Create an end-to-end logical data flow mapping origin, processing, stores and consumers.
Explanation
Correct Answer
D:Create an end-to-end logical data flow mapping origin, processing, stores and consumers. Architecture flow maps make hidden dependencies and control points observable. Evidence to obtain: Auditors can trace the metric through transformations and responsible systems.
Incorrect Answers
A:This response fits a separate situation (A transformation program has diagrams but no one decides whether new platforms meet enterprise principles.), but does not resolve the stated case. Establish an architecture review board with documented authority and exception controls.
B:Agree enterprise-level business concepts and relationships before mapping physical application schemas. This response fits a separate situation (Two departments use the term account for unrelated concepts and merge records incorrectly.), but does not resolve the stated case. The targeted response is: Create an end-to-end logical data flow mapping origin, processing, stores and consumers.
C:This response fits a separate situation (Customer identifiers differ across sales, billing and support, preventing consistent reporting.), but does not resolve the stated case. Publish target enterprise data architecture with shared identity principles and integration boundaries.
Question 79
A business owner identifies this issue: A report scans millions of rows although its date filter is selective and frequent. What is the MOST appropriate data management response?
- Implement scheduled retention with legal holds, access controls and verifiable deletion.
- Plan compatibility tests, backup, failover or maintenance strategy and rollback verification.
- Add performance monitoring for query latency, locks, throughput and resource saturation.
- Evaluate query plans and appropriate indexes while considering write and storage overhead.
Explanation
Correct Answer
D:Evaluate query plans and appropriate indexes while considering write and storage overhead. Indexes speed selective access but impose maintenance and write costs. Evidence to obtain: Representative query time improves without unacceptable ingestion regression.
Incorrect Answers
A:Implement scheduled retention with legal holds, access controls and verifiable deletion. This response fits a separate situation (Operational logs contain sensitive identifiers beyond the allowed retention period.), but does not resolve the stated case. The targeted response is: Evaluate query plans and appropriate indexes while considering write and storage overhead.
B:This response fits a separate situation (A security patch must be applied to a data store with a strict availability commitment.), but does not resolve the stated case. Plan compatibility tests, backup, failover or maintenance strategy and rollback verification.
C:This response fits a separate situation (A database service is slow but monitoring records only whether its process is up.), but does not resolve the stated case. Add performance monitoring for query latency, locks, throughput and resource saturation.
Question 80
Select THREE statements that correctly identify the needed action, underlying concept and validation evidence: A customer's billing address is validly formatted but refers to a previous residence.
- Shortcut: Mark the address accurate simply because postal syntax checks pass.
- Action: Add input validation with clear user feedback and exception override governance.
- Verification: A sampled comparison confirms the stored address reflects current real-world facts.
- Verification: Equivalent datasets are evaluated against the same approved country-code version.
- Action: Verify the address against a trusted recent source and update the authoritative record.
- Principle: Accuracy concerns correspondence to reality; valid formatting alone cannot prove accuracy.
Explanation
Correct Answers
C:Verification: A sampled comparison confirms the stored address reflects current real-world facts. The observed result demonstrates whether the correction operates as intended. Accuracy concerns correspondence to reality; valid formatting alone cannot prove accuracy.
E:Action: Verify the address against a trusted recent source and update the authoritative record. The proposed intervention targets the reported issue. Accuracy concerns correspondence to reality; valid formatting alone cannot prove accuracy.
F:Principle: Accuracy concerns correspondence to reality; valid formatting alone cannot prove accuracy. This is the governing concept explaining the selected correction and expected outcome.
Incorrect Answers
A:Shortcut: Mark the address accurate simply because postal syntax checks pass. This shortcut is not a sound remediation. Accuracy concerns correspondence to reality; valid formatting alone cannot prove accuracy. The appropriate action is: Verify the address against a trusted recent source and update the authoritative record.
B:This intervention is for a different scenario (Bad dates are entered during onboarding and corrected only after monthly reporting failures.), not the one stated.
D:Verification: Equivalent datasets are evaluated against the same approved country-code version. This evidence is for a separate context (Different pipelines enforce different allowable values for the same governed country field.), not this case. The valid outcome is: A sampled comparison confirms the stored address reflects current real-world facts.