CDMP DMF Practice Test 3
Question 20
An accountable team must correct this problem and prove results. Select TWO sound statements: An analytics team reuses location records collected for delivery tracking to infer employees' medical visits.
- Shortcut: Assume employment status makes every personal inference acceptable.
- Action: Evaluate the new use against purpose, notice, proportionality and potential harm before access.
- Verification: People receive intelligible information and the team records a lawful, ethical justification.
- Action: Test subgroup outcomes, data representativeness and remediations with accountable review.
- Verification: The use is rejected or redesigned with appropriate authorization, minimization and safeguards.
Explanation
Correct Answers
B:Action: Evaluate the new use against purpose, notice, proportionality and potential harm before access. The proposed intervention targets the reported issue. Ethical data handling asks whether a use is fair and justified even when technically possible.
E:Verification: The use is rejected or redesigned with appropriate authorization, minimization and safeguards. The observed result demonstrates whether the correction operates as intended. Ethical data handling asks whether a use is fair and justified even when technically possible.
Incorrect Answers
A:Shortcut: Assume employment status makes every personal inference acceptable. This shortcut is not a sound remediation. Ethical data handling asks whether a use is fair and justified even when technically possible. The appropriate action is: Evaluate the new use against purpose, notice, proportionality and potential harm before access.
C:The valid outcome is: The use is rejected or redesigned with appropriate authorization, minimization and safeguards.
D:Action: Test subgroup outcomes, data representativeness and remediations with accountable review. This intervention is for a different scenario (A credit model has similar overall accuracy but rejects an underserved population disproportionately.), not the one stated. Appropriate action here: Evaluate the new use against purpose, notice, proportionality and potential harm before access.
Question 21
A data analyst must confirm the cause of this issue: A business requests a temporary deviation from a sensitive data retention standard. Which check provides the strongest diagnostic evidence?
- Trace metric definition versions, impacted reports and approval history.
- Review governance charter, ownership map and approved definition changes.
- Evaluate trained steward issue submissions against a documented handling standard.
- Inspect exception approval dates, scope, mitigation and renewal decisions.
Explanation
Correct Answer
D:Inspect exception approval dates, scope, mitigation and renewal decisions. This test checks the relevant business and technical failure rather than assuming its cause. Governed exceptions prevent informal departures from becoming permanent invisible risk. Expected control result: The exception has a named owner, time limit and independently monitored mitigation.
Incorrect Answers
A:Trace metric definition versions, impacted reports and approval history. This check would investigate another issue (Different regions change the meaning of a sales metric without notifying downstream consumers.), not the immediate case. The direct diagnostic is: Inspect exception approval dates, scope, mitigation and renewal decisions.
B:Review governance charter, ownership map and approved definition changes. This check would investigate another issue (Two departments disagree about the authoritative definition of an active customer and neither can decide.), not the immediate case. The direct diagnostic is: Inspect exception approval dates, scope, mitigation and renewal decisions.
C:Evaluate trained steward issue submissions against a documented handling standard. This check would investigate another issue (New business stewards do not understand how to document definitions or resolve data defects.), not the immediate case. The direct diagnostic is: Inspect exception approval dates, scope, mitigation and renewal decisions.
Question 22
Consider this data-management scenario: Raw clickstream files are dumped into an object store without ownership, schema or discovery metadata. Which underlying principle MOST directly explains the preferred response?
- A data lake becomes unusable when uncontrolled ingestion creates a data swamp.
- CDC depends on correct change ordering and consumption state across failures.
- ELT moves transformation into the target platform but does not remove data quality obligations.
- Data integration reliability requires observable completeness and repeatable recovery.
Explanation
Correct Answer
A:A data lake becomes unusable when uncontrolled ingestion creates a data swamp. This concept explains the reason for the proposed control. Appropriate intervention: Introduce ingestion metadata, dataset ownership, cataloging and quality checks for the lake.
Incorrect Answers
B: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: A data lake becomes unusable when uncontrolled ingestion creates a data swamp.
C:This is a defensible principle in another context (An analytics platform loads source extracts into a warehouse then performs transformations there.), not the most relevant rationale here. For the stated issue: A data lake becomes unusable when uncontrolled ingestion creates a data swamp.
D:Data integration reliability requires observable completeness and repeatable recovery. 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. For the stated issue: A data lake becomes unusable when uncontrolled ingestion creates a data swamp.
Question 23
Consider this organizational data problem: An event consumer processes a payment notification twice after retry and creates duplicate ledger postings. What action is most defensible?
- Apply data minimization, encryption, scoped access and deletion controls across the transfer path.
- Use idempotent processing and durable identifiers with explicit delivery semantics.
- Evaluate governed federation or virtualization with source access, query pushdown and performance limits.
- Define an agreed canonical mapping with meaning, transform ownership and validation.
Explanation
Correct Answer
B:Use idempotent processing and durable identifiers with explicit delivery semantics. At-least-once delivery requires consumers to tolerate duplicate messages. Evidence to obtain: Replayed events do not create duplicate postings and genuine events still post.
Incorrect Answers
A:This response fits a separate situation (A file-transfer integration includes confidential customer attributes in an unsecured staging bucket.), but does not resolve the stated case. Apply data minimization, encryption, scoped access and deletion controls across the transfer path.
C:This response fits a separate situation (An organization wants live access to distributed records without copying every source table.), but does not resolve the stated case. Evaluate governed federation or virtualization with source access, query pushdown and performance limits.
D:This response fits a separate situation (One interface calls a field supplier_id while another calls it vendor_code with different identifier rules.), but does not resolve the stated case. Define an agreed canonical mapping with meaning, transform ownership and validation.
Question 24
After addressing this problem, what evidence would justify closure? A transformation program has diagrams but no one decides whether new platforms meet enterprise principles.
- Architecture decisions document common identifiers and approved exchange patterns across systems.
- Design reviews record compliance, rationale, owners and remediation for deviations.
- Auditors can trace the metric through transformations and responsible systems.
- Decision records show when a common pattern is followed and why exceptions are justified.
Explanation
Correct Answer
B:It tests the action: Establish an architecture review board with documented authority and exception controls.
Incorrect Answers
A:Architecture decisions document common identifiers and approved exchange patterns across systems. This would verify a different control (Customer identifiers differ across sales, billing and support, preventing consistent reporting.), not the one in the question. The required evidence is: Design reviews record compliance, rationale, owners and remediation for deviations.
C: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: Design reviews record compliance, rationale, owners and remediation for deviations.
D:Decision records show when a common pattern is followed and why exceptions are justified. This would verify a different control (Project teams repeatedly pick conflicting data integration styles for identical business needs.), not the one in the question. The required evidence is: Design reviews record compliance, rationale, owners and remediation for deviations.
Question 25
A data management auditor evaluates this situation: A new privacy requirement affects data collection across products but no governance owner tracks applicability. Which observable finding supports successful remediation?
- A legal obligation register connects affected datasets to owners, tests and evidence.
- All regions use a versioned approved term or documented qualified exception.
- The exception has a named owner, time limit and independently monitored mitigation.
- Local issues are resolved within authority and enterprise conflicts have a clear escalation route.
Explanation
Correct Answer
A:It tests the action: Map the regulation to governed policies, accountable controls and effective dates.
Incorrect Answers
B: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 legal obligation register connects affected datasets to owners, tests and evidence.
C: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: A legal obligation register connects affected datasets to owners, tests and evidence.
D:Local issues are resolved within authority and enterprise conflicts have a clear escalation route. This would verify a different control (A federated enterprise wants local stewards but must preserve consistent enterprise rules.), not the one in the question. The required evidence is: A legal obligation register connects affected datasets to owners, tests and evidence.
Question 26
A data steward examines this condition: A service transfers customer attributes over unencrypted HTTP between data centers. What concept best justifies the corrective approach?
- Encryption at rest reduces exposure of stored sensitive information but requires key governance.
- Data minimization limits processing to what the justified purpose requires.
- Secure data movement must protect confidentiality and integrity in transit.
- Least privilege provides only the access required for an authorized purpose.
Explanation
Correct Answer
C:Secure data movement must protect confidentiality and integrity in transit. This concept explains the reason for the proposed control. Appropriate intervention: Require authenticated encrypted transport using supported TLS configuration.
Incorrect Answers
A:This is a defensible principle in another context (A backup contains confidential employee salaries and is stored without encryption controls.), not the most relevant rationale here. For the stated issue: Secure data movement must protect confidentiality and integrity in transit.
B:Data minimization limits processing to what the justified purpose requires. This is a defensible principle in another context (Marketing requests full birth dates for a campaign that only needs age bands.), not the most relevant rationale here. For the stated issue: Secure data movement must protect confidentiality and integrity in transit.
D: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: Secure data movement must protect confidentiality and integrity in transit.
Question 27
After addressing this problem, what evidence would justify closure? Sales cannot roll up revenue because the customer parent-child corporate hierarchy differs across reports.
- Rollups follow an approved hierarchy for each reporting period and reconcile to detail.
- Consumers use supported versions and invalid currency codes trigger clear exceptions.
- Known duplicate test cases are flagged while legitimate similar companies remain distinct.
- Verified false merges decrease without unacceptable missed true matches.
Explanation
Correct Answer
A:It tests the action: Govern effective-dated entity relationships and hierarchy ownership.
Incorrect Answers
B:Consumers use supported versions and invalid currency codes trigger clear exceptions. This would verify a different control (A mobile app uses a currency-code list six months older than the payments platform.), not the one in the question. The required evidence is: Rollups follow an approved hierarchy for each reporting period and reconcile to detail.
C:Known duplicate test cases are flagged while legitimate similar companies remain distinct. This would verify a different control (New customer onboarding creates a second record when spacing differs in a business name.), not the one in the question. The required evidence is: Rollups follow an approved hierarchy for each reporting period and reconcile to detail.
D:Verified false merges decrease without unacceptable missed true matches. This would verify a different control (A matching algorithm merges a parent and child solely because they share surname and address.), not the one in the question. The required evidence is: Rollups follow an approved hierarchy for each reporting period and reconcile to detail.
Question 28
A governance review considers the following: A production database has daily backups but no successful restore has been performed. Which proposal would create an avoidable risk?
- Treat successful backup job status as proof of a complete recovery plan.
- Separate short-term issue containment from durable root-cause correction.
- Validate critical changes against representative positive and negative examples.
- Document which dataset version was used in a material decision.
Explanation
Correct Answer
A:Treat successful backup job status as proof of a complete recovery plan. A backup is not demonstrably useful until recoverability has been tested. A sound response instead: Test a recovery using approved backups and validate application data consistency.
Incorrect Answers
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: Test a recovery using approved backups and validate application data consistency.
C:Validate critical changes against representative positive and negative examples. Controlled tests provide more reliable proof than untested assumptions. The case-specific response is: Test a recovery using approved backups and validate application data consistency.
D:Document which dataset version was used in a material decision. Version records support reproducible decisions. The case-specific response is: Test a recovery using approved backups and validate application data consistency.
Question 29
A proposed shortcut is offered for this situation: A warehouse fact table mixes one-row-per-order and one-row-per-order-line measures. Which choice is the CLEAREST mistake?
- Apply access controls proportional to the sensitivity of business information.
- Check that the proposed procedure has an identified operator and approval path.
- Protect relevant audit records while investigating data problems.
- Join order totals to every line and sum them as though each were unique.
Explanation
Correct Answer
D:Join order totals to every line and sum them as though each were unique. Dimensional modeling requires an unambiguous grain for additive measures. A sound response instead: Declare a single fact grain and separate or aggregate measures consistently.
Incorrect Answers
A:Apply access controls proportional to the sensitivity of business information. Confidentiality obligations still apply during quality improvements. The case-specific response is: Declare a single fact grain and separate or aggregate measures consistently.
B:Check that the proposed procedure has an identified operator and approval path. Operational responsibility prevents undocumented workarounds. The case-specific response is: Declare a single fact grain and separate or aggregate measures consistently.
C:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Declare a single fact grain and separate or aggregate measures consistently.
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.