CDMP DMF Practice Test 4
Question 30
A business owner identifies this issue: Test developers need representative orders but a test export includes real customer identity numbers. What is the MOST appropriate data management response?
- Apply governed masking or synthetic data that preserves testing requirements without exposing identities.
- Share only derived age ranges under approved purpose and retention controls.
- Grant narrow read access to approved views instead of broad administrative rights.
- Revoke relevant access, preserve evidence, assess scope and follow incident notification policy.
Explanation
Correct Answer
A:Apply governed masking or synthetic data that preserves testing requirements without exposing identities. Non-production use should minimize exposure of real sensitive data. Evidence to obtain: Test datasets retain required distributions while direct identifiers cannot be recovered.
Incorrect Answers
B:This response fits a separate situation (Marketing requests full birth dates for a campaign that only needs age bands.), but does not resolve the stated case.
C:This response fits a separate situation (A BI analyst receives administrator access to production customer tables for simple reporting.), but does not resolve the stated case. Grant narrow read access to approved views instead of broad administrative rights.
D:This response fits a separate situation (An unauthorized service account downloads a large restricted dataset overnight.), but does not resolve the stated case.
Question 31
Consider this data-management scenario: Marketing and finance disagree on who approves supplier legal entity identifiers. Which underlying principle MOST directly explains the preferred response?
- Reference data supplies standardized allowable values rather than individual business entities.
- Master-data stewardship needs business authority for accepted entity definitions.
- Entity resolution must balance false positive merges against missed duplicates.
- Golden-record construction applies business rules to conflicting source attributes.
Explanation
Correct Answer
B:Master-data stewardship needs business authority for accepted entity definitions. This concept explains the reason for the proposed control. Appropriate intervention: Assign a data owner and stewardship process for supplier master definitions and changes.
Incorrect Answers
A:Reference data supplies standardized allowable values rather than individual business entities. 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. For the stated issue: Master-data stewardship needs business authority for accepted entity definitions.
C:This is a defensible principle in another context (A matching algorithm merges a parent and child solely because they share surname and address.), not the most relevant rationale here. For the stated issue: Master-data stewardship needs business authority for accepted entity definitions.
D: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 stewardship needs business authority for accepted entity definitions.
Question 32
A governance review considers the following: A product taxonomy changes in January but last year's reports must preserve prior category assignments. Which proposal would create an avoidable risk?
- Escalate material unresolved issues to an accountable business decision owner.
- Respect active legal holds before scheduling record disposition.
- Replace historical code descriptions in place and recalculate old reports silently.
- Protect relevant audit records while investigating data problems.
Explanation
Correct Answer
C:Replace historical code descriptions in place and recalculate old reports silently. Reference-data changes can alter meaning across time and require controlled versions. A sound response instead: Manage reference data as effective-dated versions with historical mapping support.
Incorrect Answers
A:Escalate material unresolved issues to an accountable business decision owner. Accountability prevents silent acceptance of consequential risk. The case-specific response is: Manage reference data as effective-dated versions with historical mapping support.
B:Respect active legal holds before scheduling record disposition. Preservation duties may override scheduled destruction. The case-specific response is: Manage reference data as effective-dated versions with historical mapping support.
D:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Manage reference data as effective-dated versions with historical mapping support.
Question 33
A data analyst must confirm the cause of this issue: Marketing requests full birth dates for a campaign that only needs age bands. Which check provides the strongest diagnostic evidence?
- Inspect TLS negotiation, certificate trust and representative network capture.
- Test role grants with allowed reporting and prohibited update queries.
- Compare requested fields with campaign needs and recipient entitlements.
- Inspect storage encryption status, key access logs and a restoration test.
Explanation
Correct Answer
C:Compare requested fields with campaign needs and recipient entitlements. This test checks the relevant business and technical failure rather than assuming its cause. Data minimization limits processing to what the justified purpose requires. Expected control result: The campaign operates while recipients cannot retrieve unnecessary full dates.
Incorrect Answers
A:Inspect TLS negotiation, certificate trust and representative network capture. This check would investigate another issue (A service transfers customer attributes over unencrypted HTTP between data centers.), not the immediate case. The direct diagnostic is: Compare requested fields with campaign needs and recipient entitlements.
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: Compare requested fields with campaign needs and recipient entitlements.
D:Inspect storage encryption status, key access logs and a restoration test. This check would investigate another issue (A backup contains confidential employee salaries and is stored without encryption controls.), not the immediate case. The direct diagnostic is: Compare requested fields with campaign needs and recipient entitlements.
Question 34
Which statement best describes the governing idea behind the response to this case: An upstream API changes a numeric customer status code into a text value and breaks consumers.
- Data integration reliability requires observable completeness and repeatable recovery.
- Batch, messaging and service APIs meet different business service levels.
- At-least-once delivery requires consumers to tolerate duplicate messages.
- Interfaces require semantic and schema compatibility, not merely network availability.
Explanation
Correct Answer
D:Appropriate intervention: Establish a versioned API contract and compatibility tests before deploying breaking changes.
Incorrect Answers
A:This is a defensible principle in another context (Finance reports omit transactions because an extraction job silently skips late-arriving records.), not the most relevant rationale here. Data integration reliability requires observable completeness and repeatable recovery.
B:This is a defensible principle in another context (A daily tax report and a live fraud decision service share one nightly transfer mechanism.), not the most relevant rationale here. For the stated issue: Interfaces require semantic and schema compatibility, not merely network availability.
C:This is a defensible principle in another context (An event consumer processes a payment notification twice after retry and creates duplicate ledger postings.), not the most relevant rationale here. For the stated issue: Interfaces require semantic and schema compatibility, not merely network availability.
Question 35
A data analyst must confirm the cause of this issue: An analyst manually fixes the same missing supplier IDs every week. Which check provides the strongest diagnostic evidence?
- Review quality agreements, monitoring windows, breaches and corrective actions.
- Trace missing IDs to upstream forms, interfaces and repeated source events.
- Compare rule IDs, accepted domains and exception handling across pipelines.
- Run reference-set validation and count invalid statuses by producer.
Explanation
Correct Answer
B:Trace missing IDs to upstream forms, interfaces and repeated source events. This test checks the relevant business and technical failure rather than assuming its cause. Sustainable data quality improvement addresses causes rather than repeated symptoms. Expected control result: New records arrive with supplier IDs and recurrence drops after monitoring.
Incorrect Answers
A:Review quality agreements, monitoring windows, breaches and corrective actions. This check would investigate another issue (A shared customer dataset has no agreed defect response or availability expectations.), not the immediate case. The direct diagnostic is: Trace missing IDs to upstream forms, interfaces and repeated source events.
C:Compare rule IDs, accepted domains and exception handling across pipelines. This check would investigate another issue (Different pipelines enforce different allowable values for the same governed country field.), not the immediate case. The direct diagnostic is: Trace missing IDs to upstream forms, interfaces and repeated source events.
D:Run reference-set validation and count invalid statuses by producer. This check would investigate another issue (A product status field contains values archived and disabled although only active and retired are approved.), not the immediate case. The direct diagnostic is: Trace missing IDs to upstream forms, interfaces and repeated source events.
Question 36
Consider this organizational data problem: An order line references a product identifier that does not exist in the product table. What action is most defensible?
- Enforce appropriate referential integrity and define valid deletion behavior.
- Separate attributes dependent on only part of a composite key into their proper relation.
- Separate transitive department attributes into a referenced department relation.
- Create a conceptual model of core business entities and relationships without implementation details.
Explanation
Correct Answer
A:Enforce appropriate referential integrity and define valid deletion behavior. Foreign keys protect relationships between dependent and referenced entities. Evidence to obtain: Invalid references are rejected or handled under an explicit business rule.
Incorrect Answers
B:Separate attributes dependent on only part of a composite key into their proper relation. This response fits a separate situation (A composite-key enrollment table repeats course title determined by course_id alone.), but does not resolve the stated case. The targeted response is: Enforce appropriate referential integrity and define valid deletion behavior.
C:Separate transitive department attributes into a referenced department relation. This response fits a separate situation (An employee table stores department name determined by department_id, causing inconsistent renames.), but does not resolve the stated case. The targeted response is: Enforce appropriate referential integrity and define valid deletion behavior.
D:This response fits a separate situation (Business stakeholders cannot agree which things should be treated as customers, accounts or products.), but does not resolve the stated case. Create a conceptual model of core business entities and relationships without implementation details.
Question 37
In reviewing this data risk, select the LEAST defensible practice: Two customer sources disagree about legal name after one verifies recent government ID.
- Separate short-term issue containment from durable root-cause correction.
- Always prefer the first source ingested regardless of reliability or currency.
- Retain a rollback or recovery plan before making destructive data changes.
- Preserve source evidence and document why any exception was approved.
Explanation
Correct Answer
B:Always prefer the first source ingested regardless of reliability or currency. Golden-record construction applies business rules to conflicting source attributes. A sound response instead: Define survivorship rules that favor verified recent evidence with traceable provenance.
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: Define survivorship rules that favor verified recent evidence with traceable provenance.
C:Retain a rollback or recovery plan before making destructive data changes. Recoverability reduces the consequences of incorrect remediation. The case-specific response is: Define survivorship rules that favor verified recent evidence with traceable provenance.
D:Preserve source evidence and document why any exception was approved. Traceability enables independent review of exceptions. The case-specific response is: Define survivorship rules that favor verified recent evidence with traceable provenance.
Question 38
Consider this data-management scenario: A database approaches disk exhaustion during a seasonal reporting surge. Which underlying principle MOST directly explains the preferred response?
- A backup is not demonstrably useful until recoverability has been tested.
- Recovery needs retained trustworthy recovery points as well as available replicas.
- Operational retention should satisfy business, privacy and preservation obligations.
- Storage operations need proactive capacity management, not crisis-only expansion.
Explanation
Correct Answer
D:Storage operations need proactive capacity management, not crisis-only expansion. This concept explains the reason for the proposed control. Appropriate intervention: Monitor growth, plan capacity headroom and tune storage before outage.
Incorrect Answers
A:A backup is not demonstrably useful until recoverability has been tested. This is a defensible principle in another context (A production database has daily backups but no successful restore has been performed.), not the most relevant rationale here. For the stated issue: Storage operations need proactive capacity management, not crisis-only expansion.
B:This is a defensible principle in another context (A company keeps only the latest backup copy, leaving no way to recover before ransomware encryption.), not the most relevant rationale here. For the stated issue: Storage operations need proactive capacity management, not crisis-only expansion.
C:Operational retention should satisfy business, privacy and preservation obligations. This is a defensible principle in another context (Operational logs contain sensitive identifiers beyond the allowed retention period.), not the most relevant rationale here. For the stated issue: Storage operations need proactive capacity management, not crisis-only expansion.
Question 39
A data steward examines this condition: Business units create separate departmental marts from inconsistent extracts of customer master data. What concept best justifies the corrective approach?
- Data marts should not undermine enterprise definitions or trusted master sources.
- Type 2 dimensions preserve attribute history by versioning rows.
- Preaggregation trades computation cost for maintenance and freshness requirements.
- BI comparability depends on consistent business metric semantics, not chart style.
Explanation
Correct Answer
A:Data marts should not undermine enterprise definitions or trusted master sources. This concept explains the reason for the proposed control. Appropriate intervention: Govern mart sourcing and shared dimensions while allowing fit-for-purpose views.
Incorrect Answers
B:Type 2 dimensions preserve attribute history by versioning rows. This is a defensible principle in another context (A salesperson moves territories and historical sales must remain attributed to prior territory.), not the most relevant rationale here. For the stated issue: Data marts should not undermine enterprise definitions or trusted master sources.
C:Preaggregation trades computation cost for maintenance and freshness requirements. This is a defensible principle in another context (A star-schema dashboard query repeatedly scans granular facts for the same monthly totals.), not the most relevant rationale here. For the stated issue: Data marts should not undermine enterprise definitions or trusted master sources.
D: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: Data marts should not undermine enterprise definitions or trusted master sources.
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.