CDMP DMF Practice Test 89
Question 880
Consider this data-management scenario: A firm builds individualized prices from personal browsing histories without meaningful customer explanation. Which underlying principle MOST directly explains the preferred response?
- Non-production use should minimize exposure of real sensitive data.
- Ethical analytics considers disparate impact and context beyond average model accuracy.
- Least privilege provides only the access required for an authorized purpose.
- Responsible data use respects agency and transparency in addition to legal minimums.
Explanation
Correct Answer
D:Responsible data use respects agency and transparency in addition to legal minimums. This concept explains the reason for the proposed control. Appropriate intervention: Assess meaningful disclosure, user expectations and controls for intrusive profiling.
Incorrect Answers
A:This is a defensible principle in another context (Test developers need representative orders but a test export includes real customer identity numbers.), not the most relevant rationale here.
B:This is a defensible principle in another context (A credit model has similar overall accuracy but rejects an underserved population disproportionately.), not the most relevant rationale here.
C: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: Responsible data use respects agency and transparency in addition to legal minimums.
Question 881
For this situation, which combined intervention and validation MOST directly addresses the issue? Several applications retain their own customer stores but need a shared identity index.
- Action: Adopt a registry-style MDM where appropriate, linking identifiers without assuming data centralization. Verification: A lookup resolves cross-system references while authoritative attributes remain in sources.
- Action: Create a governed master-customer identity strategy with matching and cross-reference rules. Verification: Applications resolve one trusted customer identity while retaining source identifiers.
- Action: Model party identity separately from business roles and maintain role-specific attributes. Verification: The organization links to multiple roles without conflating role-specific permissions.
- Action: Govern a shared country reference set with mappings, definitions and permitted changes. Verification: Country values map consistently and invalid codes fail controlled validation.
Explanation
Correct Answer
A:Action: Adopt a registry-style MDM where appropriate, linking identifiers without assuming data centralization. Verification: A lookup resolves cross-system references while authoritative attributes remain in sources. Both the intervention and measurable outcome are directly relevant. Registry MDM can manage identity linkage without necessarily storing all mastered attributes.
Incorrect Answers
B:This plan addresses a different situation (Retail and service systems each assign different IDs to the same real-world customer.), not the targeted problem.
C:This plan addresses a different situation (One organization can be both a supplier and customer, but systems duplicate its legal entity per role.), not the targeted problem.
D:This plan addresses a different situation (Three regions encode country using names, ISO codes and private numeric lists.), not the targeted problem. Here, action and evidence must match: Action: Adopt a registry-style MDM where appropriate, linking identifiers without assuming data centralization.
Question 882
A data management auditor evaluates this situation: Different regions change the meaning of a sales metric without notifying downstream consumers. Which observable finding supports successful remediation?
- A reproducible score references controls, owners and improvement actions.
- A legal obligation register connects affected datasets to owners, tests and evidence.
- An approved definition, accountable owner and escalation path resolve cross-team disagreements.
- All regions use a versioned approved term or documented qualified exception.
Explanation
Correct Answer
D:It tests the action: Control glossary definitions and semantic changes with approval and impact analysis.
Incorrect Answers
A:A reproducible score references controls, owners and improvement actions. This would verify a different control (A consultant rates governance mature from interview opinions without supporting operational evidence.), not the one in the question. The required evidence is: All regions use a versioned approved term or documented qualified exception.
B:A legal obligation register connects affected datasets to owners, tests and evidence. This would verify a different control (A new privacy requirement affects data collection across products but no governance owner tracks applicability.), not the one in the question. The required evidence is: All regions use a versioned approved term or documented qualified exception.
C:An approved definition, accountable owner and escalation path resolve cross-team disagreements. This would verify a different control (Two departments disagree about the authoritative definition of an active customer and neither can decide.), not the one in the question. The required evidence is: All regions use a versioned approved term or documented qualified exception.
Question 883
Which statement best describes the governing idea behind the response to this case: An unauthorized service account downloads a large restricted dataset overnight.
- Data minimization limits processing to what the justified purpose requires.
- Encryption at rest reduces exposure of stored sensitive information but requires key governance.
- Non-production use should minimize exposure of real sensitive data.
- Data security incidents require containment, evidence and accountable escalation.
Explanation
Correct Answer
D:Data security incidents require containment, evidence and accountable escalation. This concept explains the reason for the proposed control. Appropriate intervention: Revoke relevant access, preserve evidence, assess scope and follow incident notification policy.
Incorrect Answers
A: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: Data security incidents require containment, evidence and accountable escalation.
B: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: Data security incidents require containment, evidence and accountable escalation.
C:Non-production use should minimize exposure of real sensitive data. This is a defensible principle in another context (Test developers need representative orders but a test export includes real customer identity numbers.), not the most relevant rationale here. For the stated issue: Data security incidents require containment, evidence and accountable escalation.
Question 884
Which statement best describes the governing idea behind the response to this case: A catalog tool identifies data owners but cannot force them to decide disputed definitions.
- Governance effectiveness is measured by outcomes rather than meeting frequency.
- Technology enables governance but cannot replace business authority and decisions.
- Policies express intent; standards set rules and procedures define execution.
- Governed exceptions prevent informal departures from becoming permanent invisible risk.
Explanation
Correct Answer
B:Technology enables governance but cannot replace business authority and decisions. This concept explains the reason for the proposed control. Appropriate intervention: Integrate governance decisions and stewardship workflows with technology support.
Incorrect Answers
A:Governance effectiveness is measured by outcomes rather than meeting frequency. This is a defensible principle in another context (Leadership receives the total number of stewardship meetings as the sole effectiveness KPI.), not the most relevant rationale here. For the stated issue: Technology enables governance but cannot replace business authority and decisions.
C:This is a defensible principle in another context (A company has a general policy promising accurate data but no operational validation thresholds.), not the most relevant rationale here. For the stated issue: Technology enables governance but cannot replace business authority and decisions.
D:Governed exceptions prevent informal departures from becoming permanent invisible risk. This is a defensible principle in another context (A business requests a temporary deviation from a sensitive data retention standard.), not the most relevant rationale here. For the stated issue: Technology enables governance but cannot replace business authority and decisions.
Question 885
Consider this data-management scenario: Regional sales managers can query all customer records despite regional authorization rules. Which underlying principle MOST directly explains the preferred response?
- Secure data movement must protect confidentiality and integrity in transit.
- Encryption at rest reduces exposure of stored sensitive information but requires key governance.
- Non-production use should minimize exposure of real sensitive data.
- Row-level controls enforce instance-specific access beyond coarse table grants.
Explanation
Correct Answer
D:Row-level controls enforce instance-specific access beyond coarse table grants. This concept explains the reason for the proposed control. Appropriate intervention: Enforce row-level security using authoritative user-to-region mapping.
Incorrect Answers
A:Secure data movement must protect confidentiality and integrity in transit. This is a defensible principle in another context (A service transfers customer attributes over unencrypted HTTP between data centers.), not the most relevant rationale here. For the stated issue: Row-level controls enforce instance-specific access beyond coarse table grants.
B: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: Row-level controls enforce instance-specific access beyond coarse table grants.
C:Non-production use should minimize exposure of real sensitive data. This is a defensible principle in another context (Test developers need representative orders but a test export includes real customer identity numbers.), not the most relevant rationale here. For the stated issue: Row-level controls enforce instance-specific access beyond coarse table grants.
Question 886
After addressing this problem, what evidence would justify closure? A contact table stores three comma-separated telephone numbers in one column.
- Dashboard latency improves and redundant values stay consistent under updates.
- Stakeholders approve shared concepts and relationship definitions.
- Each number is independently searchable and maintained without string parsing.
- Consumers distinguish business lifecycle state from technical processing status.
Explanation
Correct Answer
C:It tests the action: Model phone numbers as atomic repeating child records with appropriate identifiers.
Incorrect Answers
A:Dashboard latency improves and redundant values stay consistent under updates. This would verify a different control (A read-heavy dashboard suffers repeated expensive joins but operational source integrity is sound.), not the one in the question. The required evidence is: Each number is independently searchable and maintained without string parsing.
B:Stakeholders approve shared concepts and relationship definitions. This would verify a different control (Business stakeholders cannot agree which things should be treated as customers, accounts or products.), not the one in the question. The required evidence is: Each number is independently searchable and maintained without string parsing.
D:Consumers distinguish business lifecycle state from technical processing status. This would verify a different control (Teams use inconsistent definitions for status and state across logical models.), not the one in the question. The required evidence is: Each number is independently searchable and maintained without string parsing.
Question 887
A reviewer asks for proof of improvement: A report scans millions of rows although its date filter is selective and frequent. Which result MOST convincingly demonstrates that the control works?
- Representative query time improves without unacceptable ingestion regression.
- Forecasted and observed capacity stay within safe thresholds under peak workloads.
- A simulated primary outage transfers service within the target and avoids unacceptable data loss.
- A pre-incident restore point survives attack and recovers clean data.
Explanation
Correct Answer
A:It tests the action: Evaluate query plans and appropriate indexes while considering write and storage overhead.
Incorrect Answers
B:Forecasted and observed capacity stay within safe thresholds under peak workloads. This would verify a different control (A database approaches disk exhaustion during a seasonal reporting surge.), not the one in the question. The required evidence is: Representative query time improves without unacceptable ingestion regression.
C:A simulated primary outage transfers service within the target and avoids unacceptable data loss. This would verify a different control (A replica exists for critical reads but failover has never been validated.), not the one in the question. The required evidence is: Representative query time improves without unacceptable ingestion regression.
D:A pre-incident restore point survives attack and recovers clean data. This would verify a different control (A company keeps only the latest backup copy, leaving no way to recover before ransomware encryption.), not the one in the question. The required evidence is: Representative query time improves without unacceptable ingestion regression.
Question 888
A data steward challenges an assumption in this case: A governance team treats every data field as equally critical, overwhelming its controls program. Which verification should be performed first?
- Inspect exception approval dates, scope, mitigation and renewal decisions.
- Review council charter, quorum, action log and overdue escalations.
- Sample defects for root-cause evidence, risk acceptance and post-fix monitoring.
- Inspect CDE selection criteria, downstream use and impact assessment.
Explanation
Correct Answer
D:Inspect CDE selection criteria, downstream use and impact assessment. This test checks the relevant business and technical failure rather than assuming its cause. Critical data designation should target elements whose failure materially affects outcomes. Expected control result: A justified CDE register prioritizes measurable quality, ownership and controls.
Incorrect Answers
A: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 CDE selection criteria, downstream use and impact assessment.
B:Review council charter, quorum, action log and overdue escalations. This check would investigate another issue (Customer and finance functions cannot agree on shared priority data rules.), not the immediate case. The direct diagnostic is: Inspect CDE selection criteria, downstream use and impact assessment.
C:Sample defects for root-cause evidence, risk acceptance and post-fix monitoring. This check would investigate another issue (Data-quality defects recur because workers close tickets without addressing causes.), not the immediate case. The direct diagnostic is: Inspect CDE selection criteria, downstream use and impact assessment.
Question 889
A governance review considers the following: Sales cannot roll up revenue because the customer parent-child corporate hierarchy differs across reports. Which proposal would create an avoidable risk?
- Apply access controls proportional to the sensitivity of business information.
- Separate short-term issue containment from durable root-cause correction.
- Overwrite historical parent relationships without retaining effective dates.
- Respect active legal holds before scheduling record disposition.
Explanation
Correct Answer
C:Overwrite historical parent relationships without retaining effective dates. Master data includes controlled relationships and hierarchies, not only flat attributes. A sound response instead: Govern effective-dated entity relationships and hierarchy ownership.
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: Govern effective-dated entity relationships and hierarchy ownership.
B:Separate short-term issue containment from durable root-cause correction. This is a defensible supporting safeguard, rather than the proposed mistake. An immediate workaround rarely proves the defect cannot recur. The case-specific response is: Govern effective-dated entity relationships and hierarchy ownership.
D:Respect active legal holds before scheduling record disposition. Preservation duties may override scheduled destruction. The case-specific response is: Govern effective-dated entity relationships and hierarchy ownership.
Question 890
In reviewing this data risk, select the LEAST defensible practice: A scientific dataset has fine precision but lacks metadata required for the regulator's audit.
- Escalate material unresolved issues to an accountable business decision owner.
- Inspect lineage and source context before changing a derived report.
- Declare the dataset fit for every purpose because numbers have many decimal places.
- Separate short-term issue containment from durable root-cause correction.
Explanation
Correct Answer
C:Declare the dataset fit for every purpose because numbers have many decimal places. Fitness for purpose includes contextual requirements beyond numeric precision. A sound response instead: Evaluate quality against the specific consumer's required provenance and interpretability.
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: Evaluate quality against the specific consumer's required provenance and interpretability.
B:Inspect lineage and source context before changing a derived report. Provenance analysis distinguishes source errors from transformations. The case-specific response is: Evaluate quality against the specific consumer's required provenance and interpretability.
D:Separate short-term issue containment from durable root-cause correction. This is a defensible supporting safeguard, rather than the proposed mistake. An immediate workaround rarely proves the defect cannot recur. The case-specific response is: Evaluate quality against the specific consumer's required provenance and interpretability.