CDMP DMF Practice Test 38
Question 370
A proposed shortcut is offered for this situation: A chief data officer proposes a program measured only by number of dashboards published. Which choice is the CLEAREST mistake?
- Separate short-term issue containment from durable root-cause correction.
- Retain a rollback or recovery plan before making destructive data changes.
- Apply access controls proportional to the sensitivity of business information.
- Declare success whenever another dashboard is delivered regardless of use.
Explanation
Correct Answer
D:Declare success whenever another dashboard is delivered regardless of use. Data management performance should be measured through outcomes and risks, not output counts alone. A sound response instead: Define outcome measures for data reliability, regulatory risk reduction and decision usefulness.
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 outcome measures for data reliability, regulatory risk reduction and decision usefulness.
B:Retain a rollback or recovery plan before making destructive data changes. Recoverability reduces the consequences of incorrect remediation. The case-specific response is: Define outcome measures for data reliability, regulatory risk reduction and decision usefulness.
C:Apply access controls proportional to the sensitivity of business information. Confidentiality obligations still apply during quality improvements. The case-specific response is: Define outcome measures for data reliability, regulatory risk reduction and decision usefulness.
Question 371
Consider this data-management scenario: A scorecard reports 99 percent valid rows but excludes an entire failed daily feed. Which underlying principle MOST directly explains the preferred response?
- Consistency is agreement across representations under comparable meaning and time.
- Completeness measures presence of required information for a defined purpose.
- A quality score can be misleading when its monitored population is incomplete.
- Fitness for purpose includes contextual requirements beyond numeric precision.
Explanation
Correct Answer
C:A quality score can be misleading when its monitored population is incomplete. This concept explains the reason for the proposed control. Appropriate intervention: Combine validity metrics with completeness of data delivery and denominator controls.
Incorrect Answers
A: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: A quality score can be misleading when its monitored population is incomplete.
B:This is a defensible principle in another context (Loan applications often omit annual income even though policy requires it for underwriting.), not the most relevant rationale here. For the stated issue: A quality score can be misleading when its monitored population is incomplete.
D:This is a defensible principle in another context (A scientific dataset has fine precision but lacks metadata required for the regulator's audit.), not the most relevant rationale here. For the stated issue: A quality score can be misleading when its monitored population is incomplete.
Question 372
The data management team encounters this situation: A public catalog description reveals restricted patient identities in sample values. Which intervention BEST addresses the actual problem?
- Establish end-to-end field-level lineage covering sources, transforms and reports.
- Capture technical metadata describing schemas, types, partitions and interfaces.
- Define and approve a glossary term with qualified variants and linked calculations.
- Classify metadata and restrict previews, samples and access to sensitive catalog fields.
Explanation
Correct Answer
D:Classify metadata and restrict previews, samples and access to sensitive catalog fields. Metadata itself can contain sensitive values and requires access safeguards. Evidence to obtain: Unauthorized users see discovery descriptions but no confidential samples.
Incorrect Answers
A: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. Establish end-to-end field-level lineage covering sources, transforms and reports.
B:Capture technical metadata describing schemas, types, partitions and interfaces. This response fits a separate situation (A data engineering team cannot determine the format and schema of a nightly inbound file.), but does not resolve the stated case. The targeted response is: Classify metadata and restrict previews, samples and access to sensitive catalog fields.
C:Define and approve a glossary term with qualified variants and linked calculations.
Question 373
A data steward challenges an assumption in this case: A logical model is approved but a PostgreSQL implementation needs columns and access paths. Which verification should be performed first?
- Review DDL, foreign keys, indexes and query plans against the logical model.
- Review concept definitions and stakeholders' interpretation of entity relationships.
- Inspect missing-value rules and test calculations with unknown and genuine zero.
- Inspect key dependencies, normalization and a department rename test.
Explanation
Correct Answer
A:Review DDL, foreign keys, indexes and query plans against the logical model. This test checks the relevant business and technical failure rather than assuming its cause. Physical modeling implements logical structures under actual platform constraints. Expected control result: Database DDL enforces approved integrity and meets representative performance tests.
Incorrect Answers
B:Review concept definitions and stakeholders' interpretation of entity relationships. This check would investigate another issue (Business stakeholders cannot agree which things should be treated as customers, accounts or products.), not the immediate case. The direct diagnostic is: Review DDL, foreign keys, indexes and query plans against the logical model.
C:Inspect missing-value rules and test calculations with unknown and genuine zero. This check would investigate another issue (A registration field is blank, but downstream calculations treat unknown age as zero.), not the immediate case. The direct diagnostic is: Review DDL, foreign keys, indexes and query plans against the logical model.
D:Inspect key dependencies, normalization and a department rename test. This check would investigate another issue (An employee table stores department name determined by department_id, causing inconsistent renames.), not the immediate case. The direct diagnostic is: Review DDL, foreign keys, indexes and query plans against the logical model.
Question 374
A reviewer asks for proof of improvement: A composite-key enrollment table repeats course title determined by course_id alone. Which result MOST convincingly demonstrates that the control works?
- Shared identity fields are unified and subtype-specific validation is enforced.
- Email changes leave entity identity and referencing foreign keys intact.
- Renaming a department updates one authoritative record without conflicting employee copies.
- Course title updates occur once and enrollment rows retain correct course links.
Explanation
Correct Answer
D:It tests the action: Separate attributes dependent on only part of a composite key into their proper relation.
Incorrect Answers
A:Shared identity fields are unified and subtype-specific validation is enforced. This would verify a different control (A party table mixes person birthdate with organization registration number, leaving ambiguous rules.), not the one in the question. The required evidence is: Course title updates occur once and enrollment rows retain correct course links.
B:Email changes leave entity identity and referencing foreign keys intact. This would verify a different control (A customer table identifies rows by mutable email address, causing broken relationships after updates.), not the one in the question. The required evidence is: Course title updates occur once and enrollment rows retain correct course links.
C:Renaming a department updates one authoritative record without conflicting employee copies. This would verify a different control (An employee table stores department name determined by department_id, causing inconsistent renames.), not the one in the question. The required evidence is: Course title updates occur once and enrollment rows retain correct course links.
Question 375
A data steward examines this condition: An analyst manually fixes the same missing supplier IDs every week. What concept best justifies the corrective approach?
- Data-quality issue processes should prioritize consequential defects and accountable response.
- Sustainable data quality improvement addresses causes rather than repeated symptoms.
- Fitness for purpose includes contextual requirements beyond numeric precision.
- Completeness measures presence of required information for a defined purpose.
Explanation
Correct Answer
B:Sustainable data quality improvement addresses causes rather than repeated symptoms. This concept explains the reason for the proposed control. Appropriate intervention: Identify the upstream source-process failure and implement a preventive correction.
Incorrect Answers
A:Data-quality issue processes should prioritize consequential defects and accountable response. This is a defensible principle in another context (High-impact reconciliation defects are buried among hundreds of cosmetic warnings.), not the most relevant rationale here. For the stated issue: Sustainable data quality improvement addresses causes rather than repeated symptoms.
C:Fitness for purpose includes contextual requirements beyond numeric precision. This is a defensible principle in another context (A scientific dataset has fine precision but lacks metadata required for the regulator's audit.), not the most relevant rationale here. For the stated issue: Sustainable data quality improvement addresses causes rather than repeated symptoms.
D:Completeness measures presence of required information for a defined purpose. This is a defensible principle in another context (Loan applications often omit annual income even though policy requires it for underwriting.), not the most relevant rationale here. For the stated issue: Sustainable data quality improvement addresses causes rather than repeated symptoms.
Question 376
The data management team encounters this situation: A database approaches disk exhaustion during a seasonal reporting surge. Which intervention BEST addresses the actual problem?
- Implement scheduled retention with legal holds, access controls and verifiable deletion.
- Evaluate query plans and appropriate indexes while considering write and storage overhead.
- Add performance monitoring for query latency, locks, throughput and resource saturation.
- Monitor growth, plan capacity headroom and tune storage before outage.
Explanation
Correct Answer
D:Monitor growth, plan capacity headroom and tune storage before outage. Storage operations need proactive capacity management, not crisis-only expansion. Evidence to obtain: Forecasted and observed capacity stay within safe thresholds under peak workloads.
Incorrect Answers
A:Implement scheduled retention with legal holds, access controls and verifiable deletion. This response fits a separate situation (Operational logs contain sensitive identifiers beyond the allowed retention period.), but does not resolve the stated case. The targeted response is: Monitor growth, plan capacity headroom and tune storage before outage.
B:Evaluate query plans and appropriate indexes while considering write and storage overhead.
C:Add performance monitoring for query latency, locks, throughput and resource saturation. This response fits a separate situation (A database service is slow but monitoring records only whether its process is up.), but does not resolve the stated case. The targeted response is: Monitor growth, plan capacity headroom and tune storage before outage.
Question 377
A data steward examines this condition: A shared customer dataset has no agreed defect response or availability expectations. What concept best justifies the corrective approach?
- Completeness measures presence of required information for a defined purpose.
- Timeliness is fitness of information at the required decision moment.
- Quality commitments should reflect consuming business needs and operational accountability.
- Sustainable data quality improvement addresses causes rather than repeated symptoms.
Explanation
Correct Answer
C:Quality commitments should reflect consuming business needs and operational accountability. This concept explains the reason for the proposed control. Appropriate intervention: Define data-quality service levels for material fields with ownership and escalation.
Incorrect Answers
A:Completeness measures presence of required information for a defined purpose. This is a defensible principle in another context (Loan applications often omit annual income even though policy requires it for underwriting.), not the most relevant rationale here. For the stated issue: Quality commitments should reflect consuming business needs and operational accountability.
B:Timeliness is fitness of information at the required decision moment. This is a defensible principle in another context (A fraud team receives transaction events forty minutes after its five-minute alert deadline.), not the most relevant rationale here. For the stated issue: Quality commitments should reflect consuming business needs and operational accountability.
D:Sustainable data quality improvement addresses causes rather than repeated symptoms. This is a defensible principle in another context (An analyst manually fixes the same missing supplier IDs every week.), not the most relevant rationale here. For the stated issue: Quality commitments should reflect consuming business needs and operational accountability.
Question 378
Select THREE statements that correctly identify the needed action, underlying concept and validation evidence: A new privacy requirement affects data collection across products but no governance owner tracks applicability.
- Action: Assess maturity against defined capabilities with artifacts, repeatable evidence and gaps.
- Principle: Regulatory obligations need explicit translation into controlled operating practice.
- Shortcut: Assume a generic data policy automatically satisfies every jurisdiction.
- Verification: A legal obligation register connects affected datasets to owners, tests and evidence.
- Verification: The exception has a named owner, time limit and independently monitored mitigation.
- Action: Map the regulation to governed policies, accountable controls and effective dates.
Explanation
Correct Answers
B:Principle: Regulatory obligations need explicit translation into controlled operating practice. This is the governing concept explaining the selected correction and expected outcome.
D:Verification: A legal obligation register connects affected datasets to owners, tests and evidence. The observed result demonstrates whether the correction operates as intended. Regulatory obligations need explicit translation into controlled operating practice.
F:Action: Map the regulation to governed policies, accountable controls and effective dates. The proposed intervention targets the reported issue. Regulatory obligations need explicit translation into controlled operating practice.
Incorrect Answers
A:Action: Assess maturity against defined capabilities with artifacts, repeatable evidence and gaps. This intervention is for a different scenario (A consultant rates governance mature from interview opinions without supporting operational evidence.), not the one stated. Appropriate action here: Map the regulation to governed policies, accountable controls and effective dates.
C:Shortcut: Assume a generic data policy automatically satisfies every jurisdiction. This shortcut is not a sound remediation. Regulatory obligations need explicit translation into controlled operating practice. The appropriate action is: Map the regulation to governed policies, accountable controls and effective dates.
E:Verification: The exception has a named owner, time limit and independently monitored mitigation. This evidence is for a separate context (A business requests a temporary deviation from a sensitive data retention standard.), not this case. The valid outcome is: A legal obligation register connects affected datasets to owners, tests and evidence.
Question 379
After addressing this problem, what evidence would justify closure? A security patch must be applied to a data store with a strict availability commitment.
- A simulated primary outage transfers service within the target and avoids unacceptable data loss.
- Patched instances pass regression checks without violating availability constraints.
- Alerts identify bottlenecks and response resolves tested workload degradation.
- Recovery exercises meet both distinct time and data-loss targets.
Explanation
Correct Answer
B:It tests the action: Plan compatibility tests, backup, failover or maintenance strategy and rollback verification.
Incorrect Answers
A: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: Patched instances pass regression checks without violating availability constraints.
C:Alerts identify bottlenecks and response resolves tested workload degradation. This would verify a different control (A database service is slow but monitoring records only whether its process is up.), not the one in the question. The required evidence is: Patched instances pass regression checks without violating availability constraints.
D:Recovery exercises meet both distinct time and data-loss targets. This would verify a different control (A service can tolerate one hour of data loss but must return within fifteen minutes of outage.), not the one in the question. The required evidence is: Patched instances pass regression checks without violating availability constraints.
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.