CDMP DMF Practice Test 5
Question 40
Select TWO appropriate statements, one intervention and one verification, for this data management case: A mobile app uses a currency-code list six months older than the payments platform.
- Action: Govern a shared country reference set with mappings, definitions and permitted changes.
- Shortcut: Email a one-off spreadsheet and assume every application updates automatically.
- Verification: Rollups follow an approved hierarchy for each reporting period and reconcile to detail.
- Verification: Consumers use supported versions and invalid currency codes trigger clear exceptions.
- Action: Distribute reference versions through a governed publish/subscribe or release process.
Explanation
Correct Answers
D:Verification: Consumers use supported versions and invalid currency codes trigger clear exceptions. The observed result demonstrates whether the correction operates as intended. Reference data consistency requires controlled publication and consumer adoption.
E:Action: Distribute reference versions through a governed publish/subscribe or release process. The proposed intervention targets the reported issue. Reference data consistency requires controlled publication and consumer adoption.
Incorrect Answers
A:Action: Govern a shared country reference set with mappings, definitions and permitted changes. This intervention is for a different scenario (Three regions encode country using names, ISO codes and private numeric lists.), not the one stated. Appropriate action here: Distribute reference versions through a governed publish/subscribe or release process.
B:Shortcut: Email a one-off spreadsheet and assume every application updates automatically. This shortcut is not a sound remediation. Reference data consistency requires controlled publication and consumer adoption. The appropriate action is: Distribute reference versions through a governed publish/subscribe or release process.
C:This evidence is for a separate context (Sales cannot roll up revenue because the customer parent-child corporate hierarchy differs across reports.), not this case.
Question 41
A reviewer asks for proof of improvement: A credit model has similar overall accuracy but rejects an underserved population disproportionately. Which result MOST convincingly demonstrates that the control works?
- Fairness metrics and decisions document identified disparities and corrective monitoring.
- The analyst can perform the report but cannot alter or see unrelated sensitive records.
- An authorized manager sees own-region rows and cannot access other regions.
- Stored backups are unreadable without authorized key access and restores succeed.
Explanation
Correct Answer
A:It tests the action: Test subgroup outcomes, data representativeness and remediations with accountable review.
Incorrect Answers
B:The analyst can perform the report but cannot alter or see unrelated sensitive records. This would verify a different control (A BI analyst receives administrator access to production customer tables for simple reporting.), not the one in the question. The required evidence is: Fairness metrics and decisions document identified disparities and corrective monitoring.
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: Fairness metrics and decisions document identified disparities and corrective monitoring.
D: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: Fairness metrics and decisions document identified disparities and corrective monitoring.
Question 42
A business owner identifies this issue: A product team knows how records are created but has no plan for use, retention or disposal. What is the MOST appropriate data management response?
- Use a governed issue workflow with severity, ownership, root cause and independent closure validation.
- Map the data lifecycle from creation and use through retention, archival and lawful deletion.
- Define outcome measures for data reliability, regulatory risk reduction and decision usefulness.
- Define authoritative source and attribute-level ownership for producers and consumers.
Explanation
Correct Answer
B:Map the data lifecycle from creation and use through retention, archival and lawful deletion. Data management spans data creation, use, maintenance and eventual disposition. Evidence to obtain: Lifecycle documentation identifies ownership, preservation rules and disposal events.
Incorrect Answers
A:This response fits a separate situation (Data-quality defects recur because workers close tickets without addressing causes.), but does not resolve the stated case.
C:This response fits a separate situation (A chief data officer proposes a program measured only by number of dashboards published.), but does not resolve the stated case. Define outcome measures for data reliability, regulatory risk reduction and decision usefulness.
D:This response fits a separate situation (A dataset is copied into three systems and each team claims another group owns quality.), but does not resolve the stated case. Define authoritative source and attribute-level ownership for producers and consumers.
Question 43
A data management auditor evaluates this situation: The customer's tier is gold in billing but silver in the loyalty platform on the same date. Which observable finding supports successful remediation?
- New records arrive with supplier IDs and recurrence drops after monitoring.
- Tier values agree for the same customer and effective period across systems.
- Every accepted line references a valid invoice or has an owned exception.
- Quality scores include expected records and flag unavailable populations.
Explanation
Correct Answer
B:It tests the action: Reconcile tier definitions and synchronization logic using a defined authoritative source.
Incorrect Answers
A:New records arrive with supplier IDs and recurrence drops after monitoring. This would verify a different control (An analyst manually fixes the same missing supplier IDs every week.), not the one in the question. The required evidence is: Tier values agree for the same customer and effective period across systems.
C: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: Tier values agree for the same customer and effective period across systems.
D:Quality scores include expected records and flag unavailable populations. This would verify a different control (A scorecard reports 99 percent valid rows but excludes an entire failed daily feed.), not the one in the question. The required evidence is: Tier values agree for the same customer and effective period across systems.
Question 44
For this situation, which combined intervention and validation MOST directly addresses the issue? Business users need to analyze order revenue by date, product and geography.
- Action: Provide certified datasets, semantic layer guidance and role-based BI access. Verification: Self-service reports use approved measures and respect data restrictions.
- Action: Create a fact table with appropriate dimension foreign keys for a star schema. Verification: Reports slice measures consistently by conformed dimension attributes.
- Action: Use analytical aggregations and dimensional hierarchies rather than transactional updates. Verification: Slice-and-dice queries reconcile across dimensions and preserve base transaction state.
- Action: Apply consistent currency conversion rules with effective rates and labeled units. Verification: Comparisons reconcile to source currency and approved FX conversion methods.
Explanation
Correct Answer
B:Action: Create a fact table with appropriate dimension foreign keys for a star schema. Verification: Reports slice measures consistently by conformed dimension attributes. Both the intervention and measurable outcome are directly relevant. Star schemas place numeric events in facts and descriptive context in dimensions.
Incorrect Answers
A:This plan addresses a different situation (Citizen analysts build dashboards using tables with unknown sensitivity and ambiguous joins.), not the targeted problem.
C:This plan addresses a different situation (A financial analyst needs totals by region and quarter without modifying source orders.), not the targeted problem. Here, action and evidence must match: Action: Create a fact table with appropriate dimension foreign keys for a star schema.
D:This plan addresses a different situation (A dashboard shows revenue increasing sharply because source currency values are mixed without conversion.), not the targeted problem.
Question 45
The data management team encounters this situation: One interface calls a field supplier_id while another calls it vendor_code with different identifier rules. Which intervention BEST addresses the actual problem?
- Use change data capture with durable offsets, ordering assumptions and replay handling.
- Use idempotent processing and durable identifiers with explicit delivery semantics.
- Define an agreed canonical mapping with meaning, transform ownership and validation.
- Add completeness reconciliation, lateness handling and replay controls to the ETL pipeline.
Explanation
Correct Answer
C:Define an agreed canonical mapping with meaning, transform ownership and validation. Data interoperability requires shared semantics even when field names differ. Evidence to obtain: Translated identifiers reconcile across both systems and erroneous mappings are detected.
Incorrect Answers
A:This response fits a separate situation (A customer platform needs low-latency updates without repeatedly scanning entire operational tables.), but does not resolve the stated case.
B: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. Use idempotent processing and durable identifiers with explicit delivery semantics.
D:This response fits a separate situation (Finance reports omit transactions because an extraction job silently skips late-arriving records.), but does not resolve the stated case. Add completeness reconciliation, lateness handling and replay controls to the ETL pipeline.
Question 46
An accountable data owner wants both a response and a measurable check: Citizen analysts build dashboards using tables with unknown sensitivity and ambiguous joins. Which action-and-evidence pair is BEST?
- Action: Govern KPI definitions, filters, denominator and time rules across reporting tools. Verification: Both dashboards compute equivalent values for the same period and exclusions.
- Action: Provide certified datasets, semantic layer guidance and role-based BI access. Verification: Self-service reports use approved measures and respect data restrictions.
- Action: Apply late-arrival processing with date-correct attribution and controlled restatement if needed. Verification: The invoice appears in the appropriate business period with reconciliation and audit history.
- Action: Use analytical aggregations and dimensional hierarchies rather than transactional updates. Verification: Slice-and-dice queries reconcile across dimensions and preserve base transaction state.
Explanation
Correct Answer
B:Action: Provide certified datasets, semantic layer guidance and role-based BI access. Verification: Self-service reports use approved measures and respect data restrictions. Both the intervention and measurable outcome are directly relevant. Self-service BI requires trusted reusable semantics and controlled access.
Incorrect Answers
A:This plan addresses a different situation (Two executive dashboards both show profit margin but use different numerator adjustments.), not the targeted problem. Here, action and evidence must match: Action: Provide certified datasets, semantic layer guidance and role-based BI access.
C:This plan addresses a different situation (A vendor invoice from last month arrives after the monthly warehouse close.), not the targeted problem.
D:This plan addresses a different situation (A financial analyst needs totals by region and quarter without modifying source orders.), not the targeted problem. Here, action and evidence must match: Action: Provide certified datasets, semantic layer guidance and role-based BI access.
Question 47
A data management auditor evaluates this situation: A new payments division launches products without agreeing how customer data supports business objectives. Which observable finding supports successful remediation?
- Completed exercises demonstrate consistent definition updates and issue routing.
- Approved objectives identify priority data capabilities, owners, measures and funded milestones.
- Users correctly interpret sample measures and challenge misleading comparisons.
- The exception has a named owner, time limit and independently monitored mitigation.
Explanation
Correct Answer
B:It tests the action: Establish a data management strategy tied to business outcomes and accountable stakeholders.
Incorrect Answers
A:Completed exercises demonstrate consistent definition updates and issue routing. This would verify a different control (New business stewards do not understand how to document definitions or resolve data defects.), not the one in the question. The required evidence is: Approved objectives identify priority data capabilities, owners, measures and funded milestones.
C:Users correctly interpret sample measures and challenge misleading comparisons. This would verify a different control (Executives regularly misinterpret dashboards because they confuse current records with historical cohorts.), not the one in the question. The required evidence is: Approved objectives identify priority data capabilities, owners, measures and funded milestones.
D: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: Approved objectives identify priority data capabilities, owners, measures and funded milestones.
Question 48
An accountable team must correct this problem and prove results. Select TWO sound statements: A star-schema dashboard query repeatedly scans granular facts for the same monthly totals.
- Shortcut: Cache totals permanently without refreshing when new facts arrive.
- Action: Apply late-arrival processing with date-correct attribution and controlled restatement if needed.
- Verification: Revenue reconciles at order, line and shipment levels without duplicated values.
- Action: Consider an aggregate table or materialized view with refresh and reconciliation controls.
- Verification: Frequent monthly queries speed up while aggregates remain current and correct.
Explanation
Correct Answers
D:Action: Consider an aggregate table or materialized view with refresh and reconciliation controls. The proposed intervention targets the reported issue. Preaggregation trades computation cost for maintenance and freshness requirements.
E:Verification: Frequent monthly queries speed up while aggregates remain current and correct. The observed result demonstrates whether the correction operates as intended. Preaggregation trades computation cost for maintenance and freshness requirements.
Incorrect Answers
A:Shortcut: Cache totals permanently without refreshing when new facts arrive. This shortcut is not a sound remediation. Preaggregation trades computation cost for maintenance and freshness requirements. The appropriate action is: Consider an aggregate table or materialized view with refresh and reconciliation controls.
B:Action: Apply late-arrival processing with date-correct attribution and controlled restatement if needed. This intervention is for a different scenario (A vendor invoice from last month arrives after the monthly warehouse close.), not the one stated. Appropriate action here: Consider an aggregate table or materialized view with refresh and reconciliation controls.
C:Verification: Revenue reconciles at order, line and shipment levels without duplicated values. This evidence is for a separate context (A sales fact table mixes shipment-level and order-line-level amounts, doubling totals.), not this case. The valid outcome is: Frequent monthly queries speed up while aggregates remain current and correct.
Question 49
A data analyst must confirm the cause of this issue: A database service is slow but monitoring records only whether its process is up. Which check provides the strongest diagnostic evidence?
- Inspect slow query logs, wait statistics, resource metrics and alert history.
- Review patch matrix, test plan, recovery procedure and production results.
- Compare explain plans, write metrics and read latency before/after indexing.
- Inspect backup immutability, retention history and recovery point selection.
Explanation
Correct Answer
A:Inspect slow query logs, wait statistics, resource metrics and alert history. This test checks the relevant business and technical failure rather than assuming its cause. Database availability alone does not establish acceptable operational performance. Expected control result: Alerts identify bottlenecks and response resolves tested workload degradation.
Incorrect Answers
B:Review patch matrix, test plan, recovery procedure and production results. This check would investigate another issue (A security patch must be applied to a data store with a strict availability commitment.), not the immediate case. The direct diagnostic is: Inspect slow query logs, wait statistics, resource metrics and alert history.
C:Compare explain plans, write metrics and read latency before/after indexing. This check would investigate another issue (A report scans millions of rows although its date filter is selective and frequent.), not the immediate case. The direct diagnostic is: Inspect slow query logs, wait statistics, resource metrics and alert history.
D:Inspect backup immutability, retention history and recovery point selection. This check would investigate another issue (A company keeps only the latest backup copy, leaving no way to recover before ransomware encryption.), not the immediate case. The direct diagnostic is: Inspect slow query logs, wait statistics, resource metrics and alert history.
Question 50
In reviewing this data risk, select the LEAST defensible practice: A salesperson moves territories and historical sales must remain attributed to prior territory.
- Overwrite territory in place and attribute last year's sales to the new one.
- Validate critical changes against representative positive and negative examples.
- Retain a rollback or recovery plan before making destructive data changes.
- Define the intended data population before interpreting quality percentages.
Explanation
Correct Answer
A:Overwrite territory in place and attribute last year's sales to the new one. Type 2 dimensions preserve attribute history by versioning rows. A sound response instead: Use Type 2 dimension rows with effective dates, surrogate keys and validity checks.
Incorrect Answers
B:Validate critical changes against representative positive and negative examples. Controlled tests provide more reliable proof than untested assumptions. The case-specific response is: Use Type 2 dimension rows with effective dates, surrogate keys and validity checks.
C:Retain a rollback or recovery plan before making destructive data changes. Recoverability reduces the consequences of incorrect remediation. The case-specific response is: Use Type 2 dimension rows with effective dates, surrogate keys and validity checks.
D:Define the intended data population before interpreting quality percentages. An undisclosed denominator can make strong scores misleading. The case-specific response is: Use Type 2 dimension rows with effective dates, surrogate keys and validity checks.