CDMP DMF Practice Test 76
Question 750
A reviewer asks for proof of improvement: Executives need consistent historical revenue despite frequent transactional schema changes. Which result MOST convincingly demonstrates that the control works?
- Historical reports reconcile and are insulated from irrelevant transactional changes.
- The invoice appears in the appropriate business period with reconciliation and audit history.
- Cross-mart comparisons reconcile categories for equivalent reporting periods.
- Run duration falls while incremental totals match the authoritative source.
Explanation
Correct Answer
A:It tests the action: Build governed analytical integration and conformed business measures for reporting.
Incorrect Answers
B:The invoice appears in the appropriate business period with reconciliation and audit history. This would verify a different control (A vendor invoice from last month arrives after the monthly warehouse close.), not the one in the question. The required evidence is: Historical reports reconcile and are insulated from irrelevant transactional changes.
C:Cross-mart comparisons reconcile categories for equivalent reporting periods. This would verify a different control (Finance and sales marts use different definitions of product category for the same item.), not the one in the question. The required evidence is: Historical reports reconcile and are insulated from irrelevant transactional changes.
D:Run duration falls while incremental totals match the authoritative source. This would verify a different control (A nightly warehouse load rereads the entire history and repeatedly misses its completion window.), not the one in the question. The required evidence is: Historical reports reconcile and are insulated from irrelevant transactional changes.
Question 751
Before changing procedures, the team investigates: A firm builds individualized prices from personal browsing histories without meaningful customer explanation. Which review or test MOST directly locates the relevant failure?
- Review documented purpose, foreseeable harms, permissions and impacted stakeholders.
- Test role grants with allowed reporting and prohibited update queries.
- Examine notice clarity, choice mechanisms, sensitive inferences and contestability.
- Review anomalous access logs, credential exposure, response records and retention.
Explanation
Correct Answer
C:Examine notice clarity, choice mechanisms, sensitive inferences and contestability. This test checks the relevant business and technical failure rather than assuming its cause. Responsible data use respects agency and transparency in addition to legal minimums. Expected control result: People receive intelligible information and the team records a lawful, ethical justification.
Incorrect Answers
A:Review documented purpose, foreseeable harms, permissions and impacted stakeholders. This check would investigate another issue (An analytics team reuses location records collected for delivery tracking to infer employees' medical visits.), not the immediate case. The direct diagnostic is: Examine notice clarity, choice mechanisms, sensitive inferences and contestability.
B:Test role grants with allowed reporting and prohibited update queries. This check would investigate another issue (A BI analyst receives administrator access to production customer tables for simple reporting.), not the immediate case. The direct diagnostic is: Examine notice clarity, choice mechanisms, sensitive inferences and contestability.
D:Review anomalous access logs, credential exposure, response records and retention. This check would investigate another issue (An unauthorized service account downloads a large restricted dataset overnight.), not the immediate case. The direct diagnostic is: Examine notice clarity, choice mechanisms, sensitive inferences and contestability.
Question 752
A data steward challenges an assumption in this case: An enterprise needs rules for customer-to-contract cardinality without choosing a database product. Which verification should be performed first?
- Inspect logical relationships, cardinalities and valid business-key examples.
- Inspect missing-value rules and test calculations with unknown and genuine zero.
- Review model annotations, glossary bindings and conflict-resolution decisions.
- Test enrollments, composite uniqueness and independent student/course updates.
Explanation
Correct Answer
A:Inspect logical relationships, cardinalities and valid business-key examples. This test checks the relevant business and technical failure rather than assuming its cause. Logical modeling formalizes business data structure separate from storage technology. Expected control result: The logical model expresses cardinality and integrity rules independent of vendor syntax.
Incorrect Answers
B:Inspect missing-value rules and test calculations with unknown and genuine zero. This check would investigate another issue (A registration field is blank, but downstream calculations treat unknown age as zero.), not the immediate case. The direct diagnostic is: Inspect logical relationships, cardinalities and valid business-key examples.
C:Review model annotations, glossary bindings and conflict-resolution decisions. This check would investigate another issue (Teams use inconsistent definitions for status and state across logical models.), not the immediate case. The direct diagnostic is: Inspect logical relationships, cardinalities and valid business-key examples.
D:Test enrollments, composite uniqueness and independent student/course updates. This check would investigate another issue (A student can enroll in many courses and a course can enroll many students.), not the immediate case. The direct diagnostic is: Inspect logical relationships, cardinalities and valid business-key examples.
Question 753
A data steward challenges an assumption in this case: A fraud-alert service must evaluate new events within seconds while a monthly financial summary tolerates delay. Which verification should be performed first?
- Measure event-time latency, late-event handling and reconciliation between paths.
- Inspect partition sizes, shuffle metrics, retries and end-to-end output reconciliation.
- Inject retries and inspect deduplication keys and final ledger balances.
- Sample lake objects for provenance, schema, owner, freshness and access policy.
Explanation
Correct Answer
A:Measure event-time latency, late-event handling and reconciliation between paths. This test checks the relevant business and technical failure rather than assuming its cause. Processing architecture should match latency, correctness and replay requirements of each use case. Expected control result: Alert latency meets its threshold while batch reports reconcile with recorded events.
Incorrect Answers
B:Inspect partition sizes, shuffle metrics, retries and end-to-end output reconciliation. This check would investigate another issue (A nightly billion-event aggregation exceeds single-machine memory and now misses its SLA.), not the immediate case. The direct diagnostic is: Measure event-time latency, late-event handling and reconciliation between paths.
C: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: Measure event-time latency, late-event handling and reconciliation between paths.
D:Sample lake objects for provenance, schema, owner, freshness and access policy. This check would investigate another issue (Raw clickstream files are dumped into an object store without ownership, schema or discovery metadata.), not the immediate case. The direct diagnostic is: Measure event-time latency, late-event handling and reconciliation between paths.
Question 754
Before changing procedures, the team investigates: Business units need local writes but also expect synchronized approved enterprise attributes. Which review or test MOST directly locates the relevant failure?
- Sample cross-system customer matches and evaluate false merges and misses.
- Simulate conflicting source updates and inspect synchronization audit records.
- Check supplier change workflow, approvals and downstream exception decisions.
- Inspect labeled pairs, match probabilities and manual-review outcomes.
Explanation
Correct Answer
B:Simulate conflicting source updates and inspect synchronization audit records. This test checks the relevant business and technical failure rather than assuming its cause. Coexistence combines shared mastering with retained local application data maintenance. Expected control result: Update conflicts are resolved under stated rules and master attributes converge.
Incorrect Answers
A:Sample cross-system customer matches and evaluate false merges and misses. This check would investigate another issue (Retail and service systems each assign different IDs to the same real-world customer.), not the immediate case. The direct diagnostic is: Simulate conflicting source updates and inspect synchronization audit records.
C:Check supplier change workflow, approvals and downstream exception decisions. This check would investigate another issue (Marketing and finance disagree on who approves supplier legal entity identifiers.), not the immediate case. The direct diagnostic is: Simulate conflicting source updates and inspect synchronization audit records.
D:Inspect labeled pairs, match probabilities and manual-review outcomes. This check would investigate another issue (A matching algorithm merges a parent and child solely because they share surname and address.), not the immediate case. The direct diagnostic is: Simulate conflicting source updates and inspect synchronization audit records.
Question 755
A data steward examines this condition: Teams use inconsistent definitions for status and state across logical models. What concept best justifies the corrective approach?
- Naming standards improve understandability but must reflect precise meanings.
- Denormalization trades simpler reads for additional synchronization and anomaly risk.
- Temporal modeling preserves time-dependent truth needed for historical analysis.
- Physical modeling implements logical structures under actual platform constraints.
Explanation
Correct Answer
A:Naming standards improve understandability but must reflect precise meanings. This concept explains the reason for the proposed control. Appropriate intervention: Apply naming, glossary mapping and controlled definitions to important model elements.
Incorrect Answers
B:Denormalization trades simpler reads for additional synchronization and anomaly risk. This is a defensible principle in another context (A read-heavy dashboard suffers repeated expensive joins but operational source integrity is sound.), not the most relevant rationale here. For the stated issue: Naming standards improve understandability but must reflect precise meanings.
C:This is a defensible principle in another context (A customer changes region but analysts need sales under the region valid at each transaction date.), not the most relevant rationale here. For the stated issue: Naming standards improve understandability but must reflect precise meanings.
D:Physical modeling implements logical structures under actual platform constraints. This is a defensible principle in another context (A logical model is approved but a PostgreSQL implementation needs columns and access paths.), not the most relevant rationale here. For the stated issue: Naming standards improve understandability but must reflect precise meanings.
Question 756
A data steward examines this condition: A data team wants to set quality targets before knowing null, duplicate and value distributions. What concept best justifies the corrective approach?
- Timeliness is fitness of information at the required decision moment.
- Integrity preserves valid relationships and structural constraints.
- Data profiling provides empirical evidence before quality thresholds are selected.
- Quality rules need documented semantics and controlled reuse across systems.
Explanation
Correct Answer
C:Data profiling provides empirical evidence before quality thresholds are selected. This concept explains the reason for the proposed control. Appropriate intervention: Run repeatable data profiling with representative population and documented limitations.
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: Data profiling provides empirical evidence before quality thresholds are selected.
B:Integrity preserves valid relationships and structural constraints. This is a defensible principle in another context (An invoice line appears without an invoice header after a partial load.), not the most relevant rationale here. For the stated issue: Data profiling provides empirical evidence before quality thresholds are selected.
D:Quality rules need documented semantics and controlled reuse across systems. This is a defensible principle in another context (Different pipelines enforce different allowable values for the same governed country field.), not the most relevant rationale here. For the stated issue: Data profiling provides empirical evidence before quality thresholds are selected.
Question 757
Which statement best describes the governing idea behind the response to this case: An analytics team reuses location records collected for delivery tracking to infer employees' medical visits.
- Ethical data handling asks whether a use is fair and justified even when technically possible.
- Data security incidents require containment, evidence and accountable escalation.
- Least privilege provides only the access required for an authorized purpose.
- Responsible data use respects agency and transparency in addition to legal minimums.
Explanation
Correct Answer
A:Ethical data handling asks whether a use is fair and justified even when technically possible. This concept explains the reason for the proposed control. Appropriate intervention: Evaluate the new use against purpose, notice, proportionality and potential harm before access.
Incorrect Answers
B:This is a defensible principle in another context (An unauthorized service account downloads a large restricted dataset overnight.), not the most relevant rationale here.
C:This is a defensible principle in another context (A BI analyst receives administrator access to production customer tables for simple reporting.), not the most relevant rationale here. For the stated issue: Ethical data handling asks whether a use is fair and justified even when technically possible.
D:This is a defensible principle in another context (A firm builds individualized prices from personal browsing histories without meaningful customer explanation.), not the most relevant rationale here.
Question 758
Consider this data-management scenario: Leadership receives the total number of stewardship meetings as the sole effectiveness KPI. Which underlying principle MOST directly explains the preferred response?
- Data accountability must remain clear when information crosses system boundaries.
- Governance of shared language prevents silent semantic drift.
- Policies express intent; standards set rules and procedures define execution.
- Governance effectiveness is measured by outcomes rather than meeting frequency.
Explanation
Correct Answer
D:Governance effectiveness is measured by outcomes rather than meeting frequency. This concept explains the reason for the proposed control. Appropriate intervention: Report meaningful risk, issue aging, quality compliance and business-value outcomes.
Incorrect Answers
A:This is a defensible principle in another context (A dataset is copied into three systems and each team claims another group owns quality.), not the most relevant rationale here. For the stated issue: Governance effectiveness is measured by outcomes rather than meeting frequency.
B:Governance of shared language prevents silent semantic drift. This is a defensible principle in another context (Different regions change the meaning of a sales metric without notifying downstream consumers.), not the most relevant rationale here. For the stated issue: Governance effectiveness is measured by outcomes rather than meeting frequency.
C:This is a defensible principle in another context (A company has a general policy promising accurate data but no operational validation thresholds.), not the most relevant rationale here. For the stated issue: Governance effectiveness is measured by outcomes rather than meeting frequency.
Question 759
After addressing this problem, what evidence would justify closure? A new governance office attempts simultaneous enterprise rollout with no prioritization or adoption plan.
- Completed exercises demonstrate consistent definition updates and issue routing.
- A reproducible score references controls, owners and improvement actions.
- Milestones show ownership uptake and validated quality/control improvements.
- The exception has a named owner, time limit and independently monitored mitigation.
Explanation
Correct Answer
C:It tests the action: Stage the roadmap around high-risk data domains, sponsors, capabilities and measurable wins.
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: Milestones show ownership uptake and validated quality/control improvements.
B:A reproducible score references controls, owners and improvement actions. This would verify a different control (A consultant rates governance mature from interview opinions without supporting operational evidence.), not the one in the question. The required evidence is: Milestones show ownership uptake and validated quality/control improvements.
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: Milestones show ownership uptake and validated quality/control improvements.
Question 760
A data steward challenges an assumption in this case: A pipeline silently stopped after a weekend but no one tracks run status or freshness. Which verification should be performed first?
- Sample owner contacts, definitions, update dates and verified accuracy.
- Trace a report row to mapping versions, key lookups and source codes.
- Inspect run logs, watermarks, failure alerts and last-successful-load times.
- Test catalog search and preview using low-privilege identities.
Explanation
Correct Answer
C:Inspect run logs, watermarks, failure alerts and last-successful-load times. This test checks the relevant business and technical failure rather than assuming its cause. Operational metadata describes execution, frequency, health and processing events. Expected control result: Owners detect late or failed loads using observable pipeline execution history.
Incorrect Answers
A:Sample owner contacts, definitions, update dates and verified accuracy. This check would investigate another issue (A catalog lists every dataset but half of its owners and descriptions are outdated.), not the immediate case. The direct diagnostic is: Inspect run logs, watermarks, failure alerts and last-successful-load times.
B:This check would investigate another issue (A risk report uses an old industry code mapping but its catalog does not record which version.), not the immediate case. The direct diagnostic is: Inspect run logs, watermarks, failure alerts and last-successful-load times.
D:Test catalog search and preview using low-privilege identities. This check would investigate another issue (A public catalog description reveals restricted patient identities in sample values.), not the immediate case. The direct diagnostic is: Inspect run logs, watermarks, failure alerts and last-successful-load times.