CDMP DMF Practice Test 39
Question 380
A data management auditor evaluates this situation: A consultant rates governance mature from interview opinions without supporting operational evidence. Which observable finding supports successful remediation?
- All regions use a versioned approved term or documented qualified exception.
- Users correctly interpret sample measures and challenge misleading comparisons.
- The ownership matrix identifies decision rights and contractual handoffs for each critical field.
- A reproducible score references controls, owners and improvement actions.
Explanation
Correct Answer
D:It tests the action: Assess maturity against defined capabilities with artifacts, repeatable evidence and gaps.
Incorrect Answers
A:All regions use a versioned approved term or documented qualified exception. This would verify a different control (Different regions change the meaning of a sales metric without notifying downstream consumers.), not the one in the question. The required evidence is: A reproducible score references controls, owners and improvement actions.
B: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: A reproducible score references controls, owners and improvement actions.
C:The ownership matrix identifies decision rights and contractual handoffs for each critical field. This would verify a different control (A dataset is copied into three systems and each team claims another group owns quality.), not the one in the question. The required evidence is: A reproducible score references controls, owners and improvement actions.
Question 381
An accountable team must correct this problem and prove results. Select TWO sound statements: A chief data officer proposes a program measured only by number of dashboards published.
- Shortcut: Declare success whenever another dashboard is delivered regardless of use.
- Verification: Approved objectives identify priority data capabilities, owners, measures and funded milestones.
- Verification: Quarterly measures show adoption, fewer material defects and demonstrable business value.
- Action: Define outcome measures for data reliability, regulatory risk reduction and decision usefulness.
- Action: Map the data lifecycle from creation and use through retention, archival and lawful deletion.
Explanation
Correct Answers
C:Verification: Quarterly measures show adoption, fewer material defects and demonstrable business value. The observed result demonstrates whether the correction operates as intended. Data management performance should be measured through outcomes and risks, not output counts alone.
D:Action: Define outcome measures for data reliability, regulatory risk reduction and decision usefulness. The proposed intervention targets the reported issue. Data management performance should be measured through outcomes and risks, not output counts alone.
Incorrect Answers
A:Shortcut: Declare success whenever another dashboard is delivered regardless of use. This shortcut is not a sound remediation. Data management performance should be measured through outcomes and risks, not output counts alone. The appropriate action is: Define outcome measures for data reliability, regulatory risk reduction and decision usefulness.
B:Verification: Approved objectives identify priority data capabilities, owners, measures and funded milestones. This evidence is for a separate context (A new payments division launches products without agreeing how customer data supports business objectives.), not this case. The valid outcome is: Quarterly measures show adoption, fewer material defects and demonstrable business value.
E:This intervention is for a different scenario (A product team knows how records are created but has no plan for use, retention or disposal.), not the one stated. Appropriate action here: Define outcome measures for data reliability, regulatory risk reduction and decision usefulness.
Question 382
Consider this data-management scenario: A product description contains a typo and historic analytics do not need the old spelling. Which underlying principle MOST directly explains the preferred response?
- Warehouse pipelines must distinguish event/business time from loading time.
- BI comparability depends on consistent business metric semantics, not chart style.
- Type 1 slowly changing dimensions replace values when historical changes are unnecessary.
- OLAP supports multidimensional analysis separate from OLTP transaction processing.
Explanation
Correct Answer
C:Type 1 slowly changing dimensions replace values when historical changes are unnecessary. This concept explains the reason for the proposed control. Appropriate intervention: Use a Type 1 overwrite for the corrected descriptive attribute under change control.
Incorrect Answers
A:Warehouse pipelines must distinguish event/business time from loading time. This is a defensible principle in another context (A vendor invoice from last month arrives after the monthly warehouse close.), not the most relevant rationale here. For the stated issue: Type 1 slowly changing dimensions replace values when historical changes are unnecessary.
B:This is a defensible principle in another context (Two executive dashboards both show profit margin but use different numerator adjustments.), not the most relevant rationale here. For the stated issue: Type 1 slowly changing dimensions replace values when historical changes are unnecessary.
D:This is a defensible principle in another context (A financial analyst needs totals by region and quarter without modifying source orders.), not the most relevant rationale here.
Question 383
A data steward examines this condition: An event consumer processes a payment notification twice after retry and creates duplicate ledger postings. What concept best justifies the corrective approach?
- At-least-once delivery requires consumers to tolerate duplicate messages.
- CDC depends on correct change ordering and consumption state across failures.
- Data interoperability requires shared semantics even when field names differ.
- Interfaces require semantic and schema compatibility, not merely network availability.
Explanation
Correct Answer
A:At-least-once delivery requires consumers to tolerate duplicate messages. This concept explains the reason for the proposed control. Appropriate intervention: Use idempotent processing and durable identifiers with explicit delivery semantics.
Incorrect Answers
B:CDC depends on correct change ordering and consumption state across failures. This is a defensible principle in another context (A customer platform needs low-latency updates without repeatedly scanning entire operational tables.), not the most relevant rationale here. For the stated issue: At-least-once delivery requires consumers to tolerate duplicate messages.
C:Data interoperability requires shared semantics even when field names differ. This is a defensible principle in another context (One interface calls a field supplier_id while another calls it vendor_code with different identifier rules.), not the most relevant rationale here. For the stated issue: At-least-once delivery requires consumers to tolerate duplicate messages.
D:This is a defensible principle in another context (An upstream API changes a numeric customer status code into a text value and breaks consumers.), not the most relevant rationale here. For the stated issue: At-least-once delivery requires consumers to tolerate duplicate messages.
Question 384
A data management auditor evaluates this situation: A multinational has legal requirements to keep certain data local while enabling group analytics. Which observable finding supports successful remediation?
- Architecture artifacts identify dependencies, gap owners and a credible migration path.
- The selected pattern has recorded tradeoffs and meets representative end-to-end workload tests.
- Queries respect localization constraints and approved shared views expose necessary aggregates.
- Auditors can trace the metric through transformations and responsible systems.
Explanation
Correct Answer
C:It tests the action: Use a federated architecture with governed metadata and lawful cross-border access patterns.
Incorrect Answers
A:Architecture artifacts identify dependencies, gap owners and a credible migration path. This would verify a different control (A bank intends to retire a reporting platform but has no inventory of upstream sources or dependencies.), not the one in the question. The required evidence is: Queries respect localization constraints and approved shared views expose necessary aggregates.
B:The selected pattern has recorded tradeoffs and meets representative end-to-end workload tests. This would verify a different control (An organization compares central warehouse, decentralized data products and a virtualization layer for analytics.), not the one in the question. The required evidence is: Queries respect localization constraints and approved shared views expose necessary aggregates.
D:Auditors can trace the metric through transformations and responsible systems. This would verify a different control (A regulatory metric cannot be reconciled to the systems that initially captured its values.), not the one in the question. The required evidence is: Queries respect localization constraints and approved shared views expose necessary aggregates.
Question 385
Consider this organizational data problem: A pipeline silently stopped after a weekend but no one tracks run status or freshness. What action is most defensible?
- Establish end-to-end field-level lineage covering sources, transforms and reports.
- Collect operational metadata such as run timestamps, row counts and failure states.
- Assign accountable metadata stewards and automated review reminders for priority assets.
- Automate metadata harvesting with change detection and controlled owner validation.
Explanation
Correct Answer
B:Collect operational metadata such as run timestamps, row counts and failure states. Operational metadata describes execution, frequency, health and processing events. Evidence to obtain: Owners detect late or failed loads using observable pipeline execution history.
Incorrect Answers
A:Establish end-to-end field-level lineage covering sources, transforms and reports. This response fits a separate situation (A compliance report is wrong but no one knows which source change introduced the value.), but does not resolve the stated case. The targeted response is: Collect operational metadata such as run timestamps, row counts and failure states.
C:Assign accountable metadata stewards and automated review reminders for priority assets. This response fits a separate situation (Catalog entries become stale because their data owners were never assigned responsibility.), but does not resolve the stated case. The targeted response is: Collect operational metadata such as run timestamps, row counts and failure states.
D:This response fits a separate situation (A source database gains fields but the catalog schema remains unchanged for months.), but does not resolve the stated case.
Question 386
A proposed shortcut is offered for this situation: A risk report uses an old industry code mapping but its catalog does not record which version. Which choice is the CLEAREST mistake?
- Keep approved reference mappings versioned and traceable.
- Separate short-term issue containment from durable root-cause correction.
- Validate critical changes against representative positive and negative examples.
- Store only the transformed code with no mapping rule or effective date.
Explanation
Correct Answer
D:Store only the transformed code with no mapping rule or effective date. Lineage includes reference transformations, not just source-to-target copying. A sound response instead: Capture metadata linking transformed fields to versioned reference-data mappings.
Incorrect Answers
A:Keep approved reference mappings versioned and traceable. Value meaning can change across time and applications. The case-specific response is: Capture metadata linking transformed fields to versioned reference-data mappings.
B:Separate short-term issue containment from durable root-cause correction. An immediate workaround rarely proves the defect cannot recur. The case-specific response is: Capture metadata linking transformed fields to versioned reference-data mappings.
C:Validate critical changes against representative positive and negative examples. Controlled tests provide more reliable proof than untested assumptions. The case-specific response is: Capture metadata linking transformed fields to versioned reference-data mappings.
Question 387
A governance review considers the following: Users search for a customer dataset but see dozens of unlabeled backups ahead of certified sources. Which proposal would create an avoidable risk?
- Protect relevant audit records while investigating data problems.
- Verify a new interface using a controlled sample and reconciliation.
- Sort solely by file name and claim users can distinguish authoritative data.
- Validate critical changes against representative positive and negative examples.
Explanation
Correct Answer
C:This is the unsafe shortcut because it ignores the control logic. A sound response instead: Improve catalog classification, search relevance and certified-asset indicators.
Incorrect Answers
A:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Improve catalog classification, search relevance and certified-asset indicators.
B:Verify a new interface using a controlled sample and reconciliation. Testing reveals mismatches before broad deployment. The case-specific response is: Improve catalog classification, search relevance and certified-asset indicators.
D:Validate critical changes against representative positive and negative examples. Controlled tests provide more reliable proof than untested assumptions. The case-specific response is: Improve catalog classification, search relevance and certified-asset indicators.
Question 388
A data steward examines this condition: A new payments division launches products without agreeing how customer data supports business objectives. What concept best justifies the corrective approach?
- Data accountability must remain clear when information crosses system boundaries.
- Technology enables governance but cannot replace business authority and decisions.
- Data management creates value when its activities align with enterprise strategy rather than isolated tooling.
- Governance includes enabling informed use of data, not merely producing datasets.
Explanation
Correct Answer
C:Data management creates value when its activities align with enterprise strategy rather than isolated tooling. This concept explains the reason for the proposed control. Appropriate intervention: Establish a data management strategy tied to business outcomes and accountable stakeholders.
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: Data management creates value when its activities align with enterprise strategy rather than isolated tooling.
B:This is a defensible principle in another context (A catalog tool identifies data owners but cannot force them to decide disputed definitions.), not the most relevant rationale here. For the stated issue: Data management creates value when its activities align with enterprise strategy rather than isolated tooling.
D:This is a defensible principle in another context (Executives regularly misinterpret dashboards because they confuse current records with historical cohorts.), not the most relevant rationale here. For the stated issue: Data management creates value when its activities align with enterprise strategy rather than isolated tooling.
Question 389
An accountable team must correct this problem and prove results. Select TWO sound statements: Regional sales managers can query all customer records despite regional authorization rules.
- Verification: Investigation records affected datasets, containment, timeline and obligations.
- Shortcut: Rely only on dashboard filters that users can bypass with direct SQL.
- Action: Require authenticated encrypted transport using supported TLS configuration.
- Verification: An authorized manager sees own-region rows and cannot access other regions.
- Action: Enforce row-level security using authoritative user-to-region mapping.
Explanation
Correct Answers
D:Verification: An authorized manager sees own-region rows and cannot access other regions. The observed result demonstrates whether the correction operates as intended. Row-level controls enforce instance-specific access beyond coarse table grants.
E:Action: Enforce row-level security using authoritative user-to-region mapping. The proposed intervention targets the reported issue. Row-level controls enforce instance-specific access beyond coarse table grants.
Incorrect Answers
A:Verification: Investigation records affected datasets, containment, timeline and obligations. This evidence is for a separate context (An unauthorized service account downloads a large restricted dataset overnight.), not this case. The valid outcome is: An authorized manager sees own-region rows and cannot access other regions.
B:Shortcut: Rely only on dashboard filters that users can bypass with direct SQL. This shortcut is not a sound remediation. Row-level controls enforce instance-specific access beyond coarse table grants. The appropriate action is: Enforce row-level security using authoritative user-to-region mapping.
C:Action: Require authenticated encrypted transport using supported TLS configuration. This intervention is for a different scenario (A service transfers customer attributes over unencrypted HTTP between data centers.), not the one stated. Appropriate action here: Enforce row-level security using authoritative user-to-region mapping.
Question 390
A governance review considers the following: The customer's tier is gold in billing but silver in the loyalty platform on the same date. Which proposal would create an avoidable risk?
- Separate short-term issue containment from durable root-cause correction.
- Treat disagreement as harmless because both values are allowed codes.
- Protect relevant audit records while investigating data problems.
- Retain a rollback or recovery plan before making destructive data changes.
Explanation
Correct Answer
B:Treat disagreement as harmless because both values are allowed codes. Consistency is agreement across representations under comparable meaning and time. A sound response instead: Reconcile tier definitions and synchronization logic using a defined authoritative source.
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: Reconcile tier definitions and synchronization logic using a defined authoritative source.
C:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Reconcile tier definitions and synchronization logic using a defined authoritative source.
D:Retain a rollback or recovery plan before making destructive data changes. Recoverability reduces the consequences of incorrect remediation. The case-specific response is: Reconcile tier definitions and synchronization logic using a defined authoritative source.