CDMP DMF Practice Test 52
Question 510
A data steward challenges an assumption in this case: A service can tolerate one hour of data loss but must return within fifteen minutes of outage. Which verification should be performed first?
- Review disk growth curves, peak utilization and maintenance approvals.
- Review patch matrix, test plan, recovery procedure and production results.
- Measure loss of last committed data and duration to service recovery separately.
- Inspect backup immutability, retention history and recovery point selection.
Explanation
Correct Answer
C:Measure loss of last committed data and duration to service recovery separately. This test checks the relevant business and technical failure rather than assuming its cause. RPO limits acceptable data loss while RTO limits acceptable service downtime. Expected control result: Recovery exercises meet both distinct time and data-loss targets.
Incorrect Answers
A:Review disk growth curves, peak utilization and maintenance approvals. This check would investigate another issue (A database approaches disk exhaustion during a seasonal reporting surge.), not the immediate case. The direct diagnostic is: Measure loss of last committed data and duration to service recovery separately.
B:Review patch matrix, test plan, recovery procedure and production results. This check would investigate another issue (A security patch must be applied to a data store with a strict availability commitment.), not the immediate case. The direct diagnostic is: Measure loss of last committed data and duration to service recovery separately.
D:Inspect backup immutability, retention history and recovery point selection. This check would investigate another issue (A company keeps only the latest backup copy, leaving no way to recover before ransomware encryption.), not the immediate case. The direct diagnostic is: Measure loss of last committed data and duration to service recovery separately.
Question 511
Which statement best describes the governing idea behind the response to this case: An employee table stores department name determined by department_id, causing inconsistent renames.
- Dimensional modeling requires an unambiguous grain for additive measures.
- Foreign keys protect relationships between dependent and referenced entities.
- Conceptual models communicate business understanding before logical and physical detail.
- Third normal form reduces non-key transitive dependencies and update anomalies.
Explanation
Correct Answer
D:Third normal form reduces non-key transitive dependencies and update anomalies. This concept explains the reason for the proposed control. Appropriate intervention: Separate transitive department attributes into a referenced department relation.
Incorrect Answers
A:Dimensional modeling requires an unambiguous grain for additive measures. This is a defensible principle in another context (A warehouse fact table mixes one-row-per-order and one-row-per-order-line measures.), not the most relevant rationale here. For the stated issue: Third normal form reduces non-key transitive dependencies and update anomalies.
B:This is a defensible principle in another context (An order line references a product identifier that does not exist in the product table.), not the most relevant rationale here. For the stated issue: Third normal form reduces non-key transitive dependencies and update anomalies.
C:This is a defensible principle in another context (Business stakeholders cannot agree which things should be treated as customers, accounts or products.), not the most relevant rationale here. For the stated issue: Third normal form reduces non-key transitive dependencies and update anomalies.
Question 512
A data steward examines this condition: A product team knows how records are created but has no plan for use, retention or disposal. What concept best justifies the corrective approach?
- Policies express intent; standards set rules and procedures define execution.
- Governed exceptions prevent informal departures from becoming permanent invisible risk.
- Data management spans data creation, use, maintenance and eventual disposition.
- Data management performance should be measured through outcomes and risks, not output counts alone.
Explanation
Correct Answer
C:Data management spans data creation, use, maintenance and eventual disposition. This concept explains the reason for the proposed control. Appropriate intervention: Map the data lifecycle from creation and use through retention, archival and lawful deletion.
Incorrect Answers
A: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: Data management spans data creation, use, maintenance and eventual disposition.
B: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: Data management spans data creation, use, maintenance and eventual disposition.
D:This is a defensible principle in another context (A chief data officer proposes a program measured only by number of dashboards published.), not the most relevant rationale here.
Question 513
Which statement best describes the governing idea behind the response to this case: A mobile app uses a currency-code list six months older than the payments platform.
- Coexistence combines shared mastering with retained local application data maintenance.
- Reference data consistency requires controlled publication and consumer adoption.
- Reference-data changes can alter meaning across time and require controlled versions.
- Entity resolution must balance false positive merges against missed duplicates.
Explanation
Correct Answer
B:Reference data consistency requires controlled publication and consumer adoption. This concept explains the reason for the proposed control. Appropriate intervention: Distribute reference versions through a governed publish/subscribe or release process.
Incorrect Answers
A: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: Reference data consistency requires controlled publication and consumer adoption.
C:This is a defensible principle in another context (A product taxonomy changes in January but last year's reports must preserve prior category assignments.), not the most relevant rationale here. For the stated issue: Reference data consistency requires controlled publication and consumer adoption.
D: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: Reference data consistency requires controlled publication and consumer adoption.
Question 514
A governance review considers the following: New customer onboarding creates a second record when spacing differs in a business name. Which proposal would create an avoidable risk?
- Use only exact string equality and ignore documented variants.
- Check relevant business definitions before joining independently sourced data.
- Define the intended data population before interpreting quality percentages.
- Respect active legal holds before scheduling record disposition.
Explanation
Correct Answer
A:Use only exact string equality and ignore documented variants. Preventing duplicate creation is usually cheaper than repeated downstream reconciliation. A sound response instead: Normalize relevant fields and check probable duplicates before creating master identities.
Incorrect Answers
B:Check relevant business definitions before joining independently sourced data. Semantic agreements prevent incorrect cross-system correlations. The case-specific response is: Normalize relevant fields and check probable duplicates before creating master identities.
C:Define the intended data population before interpreting quality percentages. An undisclosed denominator can make strong scores misleading. The case-specific response is: Normalize relevant fields and check probable duplicates before creating master identities.
D:Respect active legal holds before scheduling record disposition. Preservation duties may override scheduled destruction. The case-specific response is: Normalize relevant fields and check probable duplicates before creating master identities.
Question 515
A reviewer asks for proof of improvement: A source database gains fields but the catalog schema remains unchanged for months. Which result MOST convincingly demonstrates that the control works?
- Ingestion validation matches recorded technical structures and flags incompatible changes.
- Users understand the term and can link it to approved datasets and business rules.
- Owner, definition and quality metadata stay current after system changes.
- New schema fields appear promptly with change events and review status.
Explanation
Correct Answer
D:It tests the action: Automate metadata harvesting with change detection and controlled owner validation.
Incorrect Answers
A:Ingestion validation matches recorded technical structures and flags incompatible changes. This would verify a different control (A data engineering team cannot determine the format and schema of a nightly inbound file.), not the one in the question. The required evidence is: New schema fields appear promptly with change events and review status.
B:Users understand the term and can link it to approved datasets and business rules. This would verify a different control (Analysts cannot tell whether customer_age means current age or age at first purchase.), not the one in the question. The required evidence is: New schema fields appear promptly with change events and review status.
C:Owner, definition and quality metadata stay current after system changes. This would verify a different control (Catalog entries become stale because their data owners were never assigned responsibility.), not the one in the question. The required evidence is: New schema fields appear promptly with change events and review status.
Question 516
Consider this organizational data problem: A catalog lists every dataset but half of its owners and descriptions are outdated. What action is most defensible?
- Use a governed repository or catalog with stewardship workflows and controlled synchronization.
- Improve catalog classification, search relevance and certified-asset indicators.
- Measure metadata completeness, freshness and accuracy for high-value entries.
- Assign accountable metadata stewards and automated review reminders for priority assets.
Explanation
Correct Answer
C:Measure metadata completeness, freshness and accuracy for high-value entries. Metadata quality is a governable data-quality problem with measurable dimensions. Evidence to obtain: Quality metrics identify stale records and verified repairs improve trust.
Incorrect Answers
A:Use a governed repository or catalog with stewardship workflows and controlled synchronization. This response fits a separate situation (Metadata lives in individual spreadsheets that differ on owners and field meanings.), but does not resolve the stated case. The targeted response is: Measure metadata completeness, freshness and accuracy for high-value entries.
B:Improve catalog classification, search relevance and certified-asset indicators. This response fits a separate situation (Users search for a customer dataset but see dozens of unlabeled backups ahead of certified sources.), but does not resolve the stated case. The targeted response is: Measure metadata completeness, freshness and accuracy for high-value entries.
D:Assign accountable metadata stewards and automated review reminders for priority assets. This response fits a separate situation (Catalog entries become stale because their data owners were never assigned responsibility.), but does not resolve the stated case. The targeted response is: Measure metadata completeness, freshness and accuracy for high-value entries.
Question 517
A data steward examines this condition: Marketing requests full birth dates for a campaign that only needs age bands. What concept best justifies the corrective approach?
- Least privilege provides only the access required for an authorized purpose.
- Data minimization limits processing to what the justified purpose requires.
- Row-level controls enforce instance-specific access beyond coarse table grants.
- Auditability complements prevention by making sensitive operations attributable.
Explanation
Correct Answer
B:Data minimization limits processing to what the justified purpose requires. This concept explains the reason for the proposed control. Appropriate intervention: Share only derived age ranges under approved purpose and retention controls.
Incorrect Answers
A: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: Data minimization limits processing to what the justified purpose requires.
C:Row-level controls enforce instance-specific access beyond coarse table grants. This is a defensible principle in another context (Regional sales managers can query all customer records despite regional authorization rules.), not the most relevant rationale here. For the stated issue: Data minimization limits processing to what the justified purpose requires.
D:Auditability complements prevention by making sensitive operations attributable. This is a defensible principle in another context (Privileged database exports are possible but no one records who initiated them.), not the most relevant rationale here. For the stated issue: Data minimization limits processing to what the justified purpose requires.
Question 518
A governance review considers the following: A firm builds individualized prices from personal browsing histories without meaningful customer explanation. Which proposal would create an avoidable risk?
- Verify a new interface using a controlled sample and reconciliation.
- Preserve source evidence and document why any exception was approved.
- Keep the pricing logic secret and assume opaque collection cannot harm consumers.
- Escalate material unresolved issues to an accountable business decision owner.
Explanation
Correct Answer
C:Keep the pricing logic secret and assume opaque collection cannot harm consumers. Responsible data use respects agency and transparency in addition to legal minimums. A sound response instead: Assess meaningful disclosure, user expectations and controls for intrusive profiling.
Incorrect Answers
A:Verify a new interface using a controlled sample and reconciliation. Testing reveals mismatches before broad deployment. The case-specific response is: Assess meaningful disclosure, user expectations and controls for intrusive profiling.
B:Preserve source evidence and document why any exception was approved. Traceability enables independent review of exceptions. The case-specific response is: Assess meaningful disclosure, user expectations and controls for intrusive profiling.
D:Escalate material unresolved issues to an accountable business decision owner. Accountability prevents silent acceptance of consequential risk. The case-specific response is: Assess meaningful disclosure, user expectations and controls for intrusive profiling.
Question 519
A data steward examines this condition: A data engineering team cannot determine the format and schema of a nightly inbound file. What concept best justifies the corrective approach?
- Business metadata describes meaning, purpose, ownership and policy context.
- Metadata must reflect the lifecycle of the assets it describes.
- Technical metadata records how data is structurally represented and processed.
- Operational metadata describes execution, frequency, health and processing events.
Explanation
Correct Answer
C:Technical metadata records how data is structurally represented and processed. This concept explains the reason for the proposed control. Appropriate intervention: Capture technical metadata describing schemas, types, partitions and interfaces.
Incorrect Answers
A:Business metadata describes meaning, purpose, ownership and policy context. This is a defensible principle in another context (Analysts cannot tell whether customer_age means current age or age at first purchase.), not the most relevant rationale here. For the stated issue: Technical metadata records how data is structurally represented and processed.
B: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: Technical metadata records how data is structurally represented and processed.
D:This is a defensible principle in another context (A pipeline silently stopped after a weekend but no one tracks run status or freshness.), not the most relevant rationale here. For the stated issue: Technical metadata records how data is structurally represented and processed.
Question 520
The data management team encounters this situation: A transformation program has diagrams but no one decides whether new platforms meet enterprise principles. Which intervention BEST addresses the actual problem?
- Model the current and target data states and a sequenced transition roadmap.
- Create agreed architecture principles and review exceptions through a decision process.
- Publish target enterprise data architecture with shared identity principles and integration boundaries.
- Establish an architecture review board with documented authority and exception controls.
Explanation
Correct Answer
D:Establish an architecture review board with documented authority and exception controls. Architecture decisions need accountability and review, not just documentation. Evidence to obtain: Design reviews record compliance, rationale, owners and remediation for deviations.
Incorrect Answers
A:Model the current and target data states and a sequenced transition roadmap.
B:Create agreed architecture principles and review exceptions through a decision process. This response fits a separate situation (Project teams repeatedly pick conflicting data integration styles for identical business needs.), but does not resolve the stated case. The targeted response is: Establish an architecture review board with documented authority and exception controls.
C:Publish target enterprise data architecture with shared identity principles and integration boundaries. This response fits a separate situation (Customer identifiers differ across sales, billing and support, preventing consistent reporting.), but does not resolve the stated case. The targeted response is: Establish an architecture review board with documented authority and exception controls.