CDMP DMF Practice Test 43
Question 420
Which statement best describes the governing idea behind the response to this case: A pipeline silently stopped after a weekend but no one tracks run status or freshness.
- Interoperable metadata requires shared representations and semantics.
- Technical metadata records how data is structurally represented and processed.
- Metadata must reflect the lifecycle of the assets it describes.
- Operational metadata describes execution, frequency, health and processing events.
Explanation
Correct Answer
D:Operational metadata describes execution, frequency, health and processing events. This concept explains the reason for the proposed control. Appropriate intervention: Collect operational metadata such as run timestamps, row counts and failure states.
Incorrect Answers
A:Interoperable metadata requires shared representations and semantics. This is a defensible principle in another context (Three systems record table creation dates in incompatible time zones and formats.), not the most relevant rationale here. For the stated issue: Operational metadata describes execution, frequency, health and processing events.
B: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: Operational metadata describes execution, frequency, health and processing events.
C:Metadata must reflect the lifecycle of the assets it describes. This is a defensible principle in another context (A retired system's catalog entries remain marked active, misleading new project teams.), not the most relevant rationale here. For the stated issue: Operational metadata describes execution, frequency, health and processing events.
Question 421
A data steward examines this condition: High-impact reconciliation defects are buried among hundreds of cosmetic warnings. What concept best justifies the corrective approach?
- Integrity preserves valid relationships and structural constraints.
- Accuracy concerns correspondence to reality; valid formatting alone cannot prove accuracy.
- Data-quality issue processes should prioritize consequential defects and accountable response.
- Consistency is agreement across representations under comparable meaning and time.
Explanation
Correct Answer
C:Data-quality issue processes should prioritize consequential defects and accountable response. This concept explains the reason for the proposed control. Appropriate intervention: Risk-rank defects by business impact, assign owners and track remediation.
Incorrect Answers
A: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-quality issue processes should prioritize consequential defects and accountable response.
B:This is a defensible principle in another context (A customer's billing address is validly formatted but refers to a previous residence.), not the most relevant rationale here.
D:This is a defensible principle in another context (The customer's tier is gold in billing but silver in the loyalty platform on the same date.), not the most relevant rationale here. For the stated issue: Data-quality issue processes should prioritize consequential defects and accountable response.
Question 422
A data steward challenges an assumption in this case: A BI analyst receives administrator access to production customer tables for simple reporting. Which verification should be performed first?
- Review anomalous access logs, credential exposure, response records and retention.
- Compare requested fields with campaign needs and recipient entitlements.
- Test different identities through both dashboards and direct data access paths.
- Test role grants with allowed reporting and prohibited update queries.
Explanation
Correct Answer
D:Test role grants with allowed reporting and prohibited update queries. This test checks the relevant business and technical failure rather than assuming its cause. Least privilege provides only the access required for an authorized purpose. Expected control result: The analyst can perform the report but cannot alter or see unrelated sensitive records.
Incorrect Answers
A: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: Test role grants with allowed reporting and prohibited update queries.
B:Compare requested fields with campaign needs and recipient entitlements. This check would investigate another issue (Marketing requests full birth dates for a campaign that only needs age bands.), not the immediate case. The direct diagnostic is: Test role grants with allowed reporting and prohibited update queries.
C:Test different identities through both dashboards and direct data access paths. This check would investigate another issue (Regional sales managers can query all customer records despite regional authorization rules.), not the immediate case. The direct diagnostic is: Test role grants with allowed reporting and prohibited update queries.
Question 423
Consider this data-management scenario: A published regulatory dashboard cannot explain why last month's total changed after a source correction. Which underlying principle MOST directly explains the preferred response?
- Trusted BI requires reproducible metrics and transparent revision histories.
- BI comparability depends on consistent business metric semantics, not chart style.
- Type 1 slowly changing dimensions replace values when historical changes are unnecessary.
- A consistent fact grain is required for correct dimensional aggregation.
Explanation
Correct Answer
A:Trusted BI requires reproducible metrics and transparent revision histories. This concept explains the reason for the proposed control. Appropriate intervention: Preserve run versions, source snapshots and transformation lineage with approved restatement rules.
Incorrect Answers
B:BI comparability depends on consistent business metric semantics, not chart style. 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: Trusted BI requires reproducible metrics and transparent revision histories.
C:This is a defensible principle in another context (A product description contains a typo and historic analytics do not need the old spelling.), not the most relevant rationale here. For the stated issue: Trusted BI requires reproducible metrics and transparent revision histories.
D:A consistent fact grain is required for correct dimensional aggregation. This is a defensible principle in another context (A sales fact table mixes shipment-level and order-line-level amounts, doubling totals.), not the most relevant rationale here. For the stated issue: Trusted BI requires reproducible metrics and transparent revision histories.
Question 424
A data steward challenges an assumption in this case: A public sharing link exposes sensitive human resources documents to contractors. Which verification should be performed first?
- Compare sampled extraction results with source documents and exception logs.
- Test inherited permissions, external links, revocation and audit events.
- Inspect version history, effective dates, approval chain and supersession links.
- Test hold scoping and a simulated purge on records subject to preservation.
Explanation
Correct Answer
B:Test inherited permissions, external links, revocation and audit events. This test checks the relevant business and technical failure rather than assuming its cause. Content repositories require classification-based access and sharing restrictions. Expected control result: Unauthorized test users cannot open sensitive documents and approved users retain access.
Incorrect Answers
A:Compare sampled extraction results with source documents and exception logs. This check would investigate another issue (A team runs OCR on handwritten forms and loads extracted values directly into an account ledger.), not the immediate case. The direct diagnostic is: Test inherited permissions, external links, revocation and audit events.
C:Inspect version history, effective dates, approval chain and supersession links. This check would investigate another issue (Staff collaborate on a policy but several copied files are called final and no approved version is clear.), not the immediate case. The direct diagnostic is: Test inherited permissions, external links, revocation and audit events.
D:Test hold scoping and a simulated purge on records subject to preservation. This check would investigate another issue (An automated seven-year purge is about to remove correspondence covered by an active litigation hold.), not the immediate case. The direct diagnostic is: Test inherited permissions, external links, revocation and audit events.
Question 425
A data analyst must confirm the cause of this issue: Business units create separate departmental marts from inconsistent extracts of customer master data. Which check provides the strongest diagnostic evidence?
- Compare aggregate totals to detail and monitor refresh delay.
- Trace mart inputs, transformations and shared dimensional keys.
- Validate rollups, drilldowns, level definitions and source read-only access.
- Test certified data products, user entitlements and join path validation.
Explanation
Correct Answer
B:Trace mart inputs, transformations and shared dimensional keys. This test checks the relevant business and technical failure rather than assuming its cause. Data marts should not undermine enterprise definitions or trusted master sources. Expected control result: Department reports reconcile common customer and product metrics.
Incorrect Answers
A:Compare aggregate totals to detail and monitor refresh delay. This check would investigate another issue (A star-schema dashboard query repeatedly scans granular facts for the same monthly totals.), not the immediate case. The direct diagnostic is: Trace mart inputs, transformations and shared dimensional keys.
C:Validate rollups, drilldowns, level definitions and source read-only access. This check would investigate another issue (A financial analyst needs totals by region and quarter without modifying source orders.), not the immediate case. The direct diagnostic is: Trace mart inputs, transformations and shared dimensional keys.
D:Test certified data products, user entitlements and join path validation. This check would investigate another issue (Citizen analysts build dashboards using tables with unknown sensitivity and ambiguous joins.), not the immediate case. The direct diagnostic is: Trace mart inputs, transformations and shared dimensional keys.
Question 426
A proposed shortcut is offered for this situation: A company wants a central analytical customer view while operational systems continue owning updates. Which choice is the CLEAREST mistake?
- Assume edits to the analytical hub always update every application immediately.
- Check that the proposed procedure has an identified operator and approval path.
- Retain a rollback or recovery plan before making destructive data changes.
- Document which dataset version was used in a material decision.
Explanation
Correct Answer
A:Assume edits to the analytical hub always update every application immediately. Consolidation offers a harmonized downstream master view without mandatory operational writeback. A sound response instead: Choose a consolidation MDM approach with governed ingestion and survivorship.
Incorrect Answers
B:Check that the proposed procedure has an identified operator and approval path. Operational responsibility prevents undocumented workarounds. The case-specific response is: Choose a consolidation MDM approach with governed ingestion and survivorship.
C:Retain a rollback or recovery plan before making destructive data changes. Recoverability reduces the consequences of incorrect remediation. The case-specific response is: Choose a consolidation MDM approach with governed ingestion and survivorship.
D:Document which dataset version was used in a material decision. Version records support reproducible decisions. The case-specific response is: Choose a consolidation MDM approach with governed ingestion and survivorship.
Question 427
After addressing this problem, what evidence would justify closure? A dashboard shows revenue increasing sharply because source currency values are mixed without conversion.
- Auditors reproduce the original total and explain the changed figure from documented inputs.
- Comparisons reconcile to source currency and approved FX conversion methods.
- Current and historical queries show the corrected description without extra history rows.
- Department reports reconcile common customer and product metrics.
Explanation
Correct Answer
B:It tests the action: Apply consistent currency conversion rules with effective rates and labeled units.
Incorrect Answers
A:Auditors reproduce the original total and explain the changed figure from documented inputs. This would verify a different control (A published regulatory dashboard cannot explain why last month's total changed after a source correction.), not the one in the question. The required evidence is: Comparisons reconcile to source currency and approved FX conversion methods.
C:Current and historical queries show the corrected description without extra history rows. This would verify a different control (A product description contains a typo and historic analytics do not need the old spelling.), not the one in the question. The required evidence is: Comparisons reconcile to source currency and approved FX conversion methods.
D:Department reports reconcile common customer and product metrics. This would verify a different control (Business units create separate departmental marts from inconsistent extracts of customer master data.), not the one in the question. The required evidence is: Comparisons reconcile to source currency and approved FX conversion methods.
Question 428
A data management auditor evaluates this situation: A student can enroll in many courses and a course can enroll many students. Which observable finding supports successful remediation?
- Each number is independently searchable and maintained without string parsing.
- Course title updates occur once and enrollment rows retain correct course links.
- Enrolments are uniquely recorded without duplicate student or course entities.
- Unknown values remain distinguishable from legitimate zero and inappropriate imputations are flagged.
Explanation
Correct Answer
C:It tests the action: Model an associative enrollment entity with both relationships and enrollment attributes.
Incorrect Answers
A:Each number is independently searchable and maintained without string parsing. This would verify a different control (A contact table stores three comma-separated telephone numbers in one column.), not the one in the question. The required evidence is: Enrolments are uniquely recorded without duplicate student or course entities.
B:Course title updates occur once and enrollment rows retain correct course links. This would verify a different control (A composite-key enrollment table repeats course title determined by course_id alone.), not the one in the question. The required evidence is: Enrolments are uniquely recorded without duplicate student or course entities.
D:Unknown values remain distinguishable from legitimate zero and inappropriate imputations are flagged. This would verify a different control (A registration field is blank, but downstream calculations treat unknown age as zero.), not the one in the question. The required evidence is: Enrolments are uniquely recorded without duplicate student or course entities.
Question 429
The data management team encounters this situation: A governance team treats every data field as equally critical, overwhelming its controls program. Which intervention BEST addresses the actual problem?
- Stage the roadmap around high-risk data domains, sponsors, capabilities and measurable wins.
- Separate accountable owner decisions from stewardship coordination and operational execution.
- Identify critical data elements according to material reporting, operational and risk impact.
- Translate principles into measurable standards, owner responsibilities and repeatable procedures.
Explanation
Correct Answer
C:Identify critical data elements according to material reporting, operational and risk impact. Critical data designation should target elements whose failure materially affects outcomes. Evidence to obtain: A justified CDE register prioritizes measurable quality, ownership and controls.
Incorrect Answers
A:Stage the roadmap around high-risk data domains, sponsors, capabilities and measurable wins.
B:Separate accountable owner decisions from stewardship coordination and operational execution. This response fits a separate situation (A product data owner expects the data steward to set commercial policy unilaterally.), but does not resolve the stated case. The targeted response is: Identify critical data elements according to material reporting, operational and risk impact.
D:Translate principles into measurable standards, owner responsibilities and repeatable procedures. This response fits a separate situation (A company has a general policy promising accurate data but no operational validation thresholds.), but does not resolve the stated case. The targeted response is: Identify critical data elements according to material reporting, operational and risk impact.
Question 430
A data steward examines this condition: Retail and service systems each assign different IDs to the same real-world customer. What concept best justifies the corrective approach?
- Master data management provides consistent core business entity views across systems.
- Golden-record construction applies business rules to conflicting source attributes.
- Reference data supplies standardized allowable values rather than individual business entities.
- Coexistence combines shared mastering with retained local application data maintenance.
Explanation
Correct Answer
A:Master data management provides consistent core business entity views across systems. This concept explains the reason for the proposed control. Appropriate intervention: Create a governed master-customer identity strategy with matching and cross-reference rules.
Incorrect Answers
B:Golden-record construction applies business rules to conflicting source attributes. This is a defensible principle in another context (Two customer sources disagree about legal name after one verifies recent government ID.), not the most relevant rationale here. For the stated issue: Master data management provides consistent core business entity views across systems.
C:This is a defensible principle in another context (Three regions encode country using names, ISO codes and private numeric lists.), not the most relevant rationale here.
D:Coexistence combines shared mastering with retained local application data maintenance. This is a defensible principle in another context (Business units need local writes but also expect synchronized approved enterprise attributes.), not the most relevant rationale here. For the stated issue: Master data management provides consistent core business entity views across systems.