CDMP DMF Practice Test 77
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.
Question 761
For this situation, which combined intervention and validation MOST directly addresses the issue? A data engineering team cannot determine the format and schema of a nightly inbound file.
- Action: Use dependency lineage to assess downstream impact and coordinate migration. Verification: Affected consumers are notified and changed logic passes compatibility tests.
- Action: Publish business metadata with precise glossary definitions and stewardship approval. Verification: Users understand the term and can link it to approved datasets and business rules.
- Action: Capture technical metadata describing schemas, types, partitions and interfaces. Verification: Ingestion validation matches recorded technical structures and flags incompatible changes.
- Action: Define and approve a glossary term with qualified variants and linked calculations. Verification: Reports cite approved term versions and consumers can identify differences.
Explanation
Correct Answer
C:Recommended action: Capture technical metadata describing schemas, types, partitions and interfaces. How to verify: Ingestion validation matches recorded technical structures and flags incompatible changes. Both the intervention and measurable outcome are directly relevant. Technical metadata records how data is structurally represented and processed.
Incorrect Answers
A:This plan addresses a different situation (A team plans to remove a source column that feeds several dashboards and fraud rules.), not the targeted problem.
B:This plan addresses a different situation (Analysts cannot tell whether customer_age means current age or age at first purchase.), not the targeted problem. Here, action and evidence must match: Action: Capture technical metadata describing schemas, types, partitions and interfaces.
D:This plan addresses a different situation (A term called revenue means gross receipts in one team and net receipts in another.), not the targeted problem. Here, action and evidence must match: Action: Capture technical metadata describing schemas, types, partitions and interfaces.
Question 762
A data steward challenges an assumption in this case: A new governance office attempts simultaneous enterprise rollout with no prioritization or adoption plan. Which verification should be performed first?
- Review charter decisions on local exceptions, enterprise controls and escalation tests.
- Compare outcome baselines, escalation rates and business decision consequences.
- Inspect roadmap dependencies, funding, adoption measures and change readiness.
- Inspect exception approval dates, scope, mitigation and renewal decisions.
Explanation
Correct Answer
C:Inspect roadmap dependencies, funding, adoption measures and change readiness. This test checks the relevant business and technical failure rather than assuming its cause. A governance program needs achievable adoption and sustainable operating capacity. Expected control result: Milestones show ownership uptake and validated quality/control improvements.
Incorrect Answers
A:Review charter decisions on local exceptions, enterprise controls and escalation tests. This check would investigate another issue (A federated enterprise wants local stewards but must preserve consistent enterprise rules.), not the immediate case. The direct diagnostic is: Inspect roadmap dependencies, funding, adoption measures and change readiness.
B:Compare outcome baselines, escalation rates and business decision consequences. This check would investigate another issue (Leadership receives the total number of stewardship meetings as the sole effectiveness KPI.), not the immediate case. The direct diagnostic is: Inspect roadmap dependencies, funding, adoption measures and change readiness.
D:Inspect exception approval dates, scope, mitigation and renewal decisions. This check would investigate another issue (A business requests a temporary deviation from a sensitive data retention standard.), not the immediate case. The direct diagnostic is: Inspect roadmap dependencies, funding, adoption measures and change readiness.
Question 763
A proposed shortcut is offered for this situation: A pipeline silently stopped after a weekend but no one tracks run status or freshness. Which choice is the CLEAREST mistake?
- Separate short-term issue containment from durable root-cause correction.
- Document the table schema and assume that proves yesterday's load succeeded.
- Apply access controls proportional to the sensitivity of business information.
- Verify a new interface using a controlled sample and reconciliation.
Explanation
Correct Answer
B:Document the table schema and assume that proves yesterday's load succeeded. Operational metadata describes execution, frequency, health and processing events. A sound response instead: Collect operational metadata such as run timestamps, row counts and failure states.
Incorrect Answers
A:Separate short-term issue containment from durable root-cause correction. An immediate workaround rarely proves the defect cannot recur. The case-specific response is: Collect operational metadata such as run timestamps, row counts and failure states.
C:Apply access controls proportional to the sensitivity of business information. Confidentiality obligations still apply during quality improvements. The case-specific response is: Collect operational metadata such as run timestamps, row counts and failure states.
D:Verify a new interface using a controlled sample and reconciliation. Testing reveals mismatches before broad deployment. The case-specific response is: Collect operational metadata such as run timestamps, row counts and failure states.
Question 764
A governance review considers the following: Business units need local writes but also expect synchronized approved enterprise attributes. Which proposal would create an avoidable risk?
- Keep approved reference mappings versioned and traceable.
- Inspect lineage and source context before changing a derived report.
- Allow every system to overwrite the master without conflict rules.
- Protect relevant audit records while investigating data problems.
Explanation
Correct Answer
C:Allow every system to overwrite the master without conflict rules. Coexistence combines shared mastering with retained local application data maintenance. A sound response instead: Design coexistence MDM with controlled bidirectional synchronization and conflict handling.
Incorrect Answers
A:Keep approved reference mappings versioned and traceable. Value meaning can change across time and applications. The case-specific response is: Design coexistence MDM with controlled bidirectional synchronization and conflict handling.
B:Inspect lineage and source context before changing a derived report. Provenance analysis distinguishes source errors from transformations. The case-specific response is: Design coexistence MDM with controlled bidirectional synchronization and conflict handling.
D:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Design coexistence MDM with controlled bidirectional synchronization and conflict handling.
Question 765
After addressing this problem, what evidence would justify closure? Business stakeholders cannot agree which things should be treated as customers, accounts or products.
- Stakeholders approve shared concepts and relationship definitions.
- Consumers migrate deliberately and production queries avoid unexpected breakage.
- Database DDL enforces approved integrity and meets representative performance tests.
- Email changes leave entity identity and referencing foreign keys intact.
Explanation
Correct Answer
A:It tests the action: Create a conceptual model of core business entities and relationships without implementation details.
Incorrect Answers
B:Consumers migrate deliberately and production queries avoid unexpected breakage. This would verify a different control (An enterprise data model removes a field still used in multiple integration contracts.), not the one in the question. The required evidence is: Stakeholders approve shared concepts and relationship definitions.
C:Database DDL enforces approved integrity and meets representative performance tests. This would verify a different control (A logical model is approved but a PostgreSQL implementation needs columns and access paths.), not the one in the question. The required evidence is: Stakeholders approve shared concepts and relationship definitions.
D:Email changes leave entity identity and referencing foreign keys intact. This would verify a different control (A customer table identifies rows by mutable email address, causing broken relationships after updates.), not the one in the question. The required evidence is: Stakeholders approve shared concepts and relationship definitions.
Question 766
Before changing procedures, the team investigates: Executives regularly misinterpret dashboards because they confuse current records with historical cohorts. Which review or test MOST directly locates the relevant failure?
- Inspect CDE selection criteria, downstream use and impact assessment.
- Test user understanding of cohort, metric definition and reporting timeframe.
- Compare claimed maturity with audit samples, repeatability and control operation.
- Review charter decisions on local exceptions, enterprise controls and escalation tests.
Explanation
Correct Answer
B:This test checks the relevant business and technical failure rather than assuming its cause. Expected control result: Users correctly interpret sample measures and challenge misleading comparisons.
Incorrect Answers
A:Inspect CDE selection criteria, downstream use and impact assessment. This check would investigate another issue (A governance team treats every data field as equally critical, overwhelming its controls program.), not the immediate case. The direct diagnostic is: Test user understanding of cohort, metric definition and reporting timeframe.
C:Compare claimed maturity with audit samples, repeatability and control operation. This check would investigate another issue (A consultant rates governance mature from interview opinions without supporting operational evidence.), not the immediate case. The direct diagnostic is: Test user understanding of cohort, metric definition and reporting timeframe.
D:Review charter decisions on local exceptions, enterprise controls and escalation tests. This check would investigate another issue (A federated enterprise wants local stewards but must preserve consistent enterprise rules.), not the immediate case. The direct diagnostic is: Test user understanding of cohort, metric definition and reporting timeframe.
Question 767
After addressing this problem, what evidence would justify closure? An upstream API changes a numeric customer status code into a text value and breaks consumers.
- The fraud service receives timely events while tax reporting reconciles its complete batch.
- Consumer integration tests pass or the incompatible change is deliberately migrated.
- Queries return authorized current results within documented latency and availability bounds.
- Staging access is restricted, audit logged and temporary files expire as approved.
Explanation
Correct Answer
B:It tests the action: Establish a versioned API contract and compatibility tests before deploying breaking changes.
Incorrect Answers
A:The fraud service receives timely events while tax reporting reconciles its complete batch. This would verify a different control (A daily tax report and a live fraud decision service share one nightly transfer mechanism.), not the one in the question. The required evidence is: Consumer integration tests pass or the incompatible change is deliberately migrated.
C:Queries return authorized current results within documented latency and availability bounds. This would verify a different control (An organization wants live access to distributed records without copying every source table.), not the one in the question. The required evidence is: Consumer integration tests pass or the incompatible change is deliberately migrated.
D:Staging access is restricted, audit logged and temporary files expire as approved. This would verify a different control (A file-transfer integration includes confidential customer attributes in an unsecured staging bucket.), not the one in the question. The required evidence is: Consumer integration tests pass or the incompatible change is deliberately migrated.
Question 768
A data steward challenges an assumption in this case: A chief data officer proposes a program measured only by number of dashboards published. Which verification should be performed first?
- Review strategy approval, business goals, funding and metrics with business and data leaders.
- Inspect roadmap dependencies, funding, adoption measures and change readiness.
- Compare baseline defect impact and user decisions with post-program verified results.
- Review obligation mapping, dates, exception handling and control-testing records.
Explanation
Correct Answer
C:Compare baseline defect impact and user decisions with post-program verified results. This test checks the relevant business and technical failure rather than assuming its cause. Data management performance should be measured through outcomes and risks, not output counts alone. Expected control result: Quarterly measures show adoption, fewer material defects and demonstrable business value.
Incorrect Answers
A:This check would investigate another issue (A new payments division launches products without agreeing how customer data supports business objectives.), not the immediate case.
B:Inspect roadmap dependencies, funding, adoption measures and change readiness. This check would investigate another issue (A new governance office attempts simultaneous enterprise rollout with no prioritization or adoption plan.), not the immediate case. The direct diagnostic is: Compare baseline defect impact and user decisions with post-program verified results.
D:Review obligation mapping, dates, exception handling and control-testing records. This check would investigate another issue (A new privacy requirement affects data collection across products but no governance owner tracks applicability.), not the immediate case. The direct diagnostic is: Compare baseline defect impact and user decisions with post-program verified results.
Question 769
Select TWO appropriate statements, one intervention and one verification, for this data management case: A nightly billion-event aggregation exceeds single-machine memory and now misses its SLA.
- Verification: The distributed job completes correctly within the required window and reconciles counts.
- Shortcut: Move the workload to a slightly larger laptop and stop monitoring skew.
- Action: Choose partitioned distributed processing with measured shuffle and skew behavior.
- Action: Introduce ingestion metadata, dataset ownership, cataloging and quality checks for the lake.
- Verification: Alert latency meets its threshold while batch reports reconcile with recorded events.
Explanation
Correct Answers
A:Verification: The distributed job completes correctly within the required window and reconciles counts. The observed result demonstrates whether the correction operates as intended. Big-data computation relies on parallelism and careful data partitioning rather than unlimited node memory.
C:Action: Choose partitioned distributed processing with measured shuffle and skew behavior. The proposed intervention targets the reported issue. Big-data computation relies on parallelism and careful data partitioning rather than unlimited node memory.
Incorrect Answers
B:Shortcut: Move the workload to a slightly larger laptop and stop monitoring skew. This shortcut is not a sound remediation. Big-data computation relies on parallelism and careful data partitioning rather than unlimited node memory. The appropriate action is: Choose partitioned distributed processing with measured shuffle and skew behavior.
D:This intervention is for a different scenario (Raw clickstream files are dumped into an object store without ownership, schema or discovery metadata.), not the one stated.
E:This evidence is for a separate context (A fraud-alert service must evaluate new events within seconds while a monthly financial summary tolerates delay.), not this case.
Question 770
For this situation, which combined intervention and validation MOST directly addresses the issue? A product team knows how records are created but has no plan for use, retention or disposal.
- Action: Define outcome measures for data reliability, regulatory risk reduction and decision usefulness. Verification: Quarterly measures show adoption, fewer material defects and demonstrable business value.
- Action: Establish a data management strategy tied to business outcomes and accountable stakeholders. Verification: Approved objectives identify priority data capabilities, owners, measures and funded milestones.
- Action: Provide role-based training and supervised examples matched to assigned stewardship duties. Verification: Completed exercises demonstrate consistent definition updates and issue routing.
- Action: Map the data lifecycle from creation and use through retention, archival and lawful deletion. Verification: Lifecycle documentation identifies ownership, preservation rules and disposal events.
Explanation
Correct Answer
D:Action: Map the data lifecycle from creation and use through retention, archival and lawful deletion. Verification: Lifecycle documentation identifies ownership, preservation rules and disposal events. Both the intervention and measurable outcome are directly relevant. Data management spans data creation, use, maintenance and eventual disposition.
Incorrect Answers
A:This plan addresses a different situation (A chief data officer proposes a program measured only by number of dashboards published.), not the targeted problem.
B:This plan addresses a different situation (A new payments division launches products without agreeing how customer data supports business objectives.), not the targeted problem.
C:This plan addresses a different situation (New business stewards do not understand how to document definitions or resolve data defects.), not the targeted problem. Here, action and evidence must match: Action: Map the data lifecycle from creation and use through retention, archival and lawful deletion.