CDMP DMF Practice Test 49
Question 480
Before changing procedures, the team investigates: A replica exists for critical reads but failover has never been validated. Which review or test MOST directly locates the relevant failure?
- Review disk growth curves, peak utilization and maintenance approvals.
- Run a controlled restore, verify row counts and record recovery time.
- Conduct failover rehearsal and compare replica lag, transactions and client health.
- Inspect retention settings, held records, deletion jobs and audit evidence.
Explanation
Correct Answer
C:Conduct failover rehearsal and compare replica lag, transactions and client health. This test checks the relevant business and technical failure rather than assuming its cause. Replication improves availability only when failover and consistency assumptions are tested. Expected control result: A simulated primary outage transfers service within the target and avoids unacceptable data loss.
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: Conduct failover rehearsal and compare replica lag, transactions and client health.
B:Run a controlled restore, verify row counts and record recovery time. This check would investigate another issue (A production database has daily backups but no successful restore has been performed.), not the immediate case. The direct diagnostic is: Conduct failover rehearsal and compare replica lag, transactions and client health.
D:Inspect retention settings, held records, deletion jobs and audit evidence. This check would investigate another issue (Operational logs contain sensitive identifiers beyond the allowed retention period.), not the immediate case. The direct diagnostic is: Conduct failover rehearsal and compare replica lag, transactions and client health.
Question 481
Select TWO appropriate statements, one intervention and one verification, for this data management case: A product data owner expects the data steward to set commercial policy unilaterally.
- Action: Separate accountable owner decisions from stewardship coordination and operational execution.
- Verification: Role descriptions and approvals reflect owner authority and steward implementation.
- Action: Assess maturity against defined capabilities with artifacts, repeatable evidence and gaps.
- Shortcut: Make a steward solely responsible for every unresolved funding and policy choice.
- Verification: The scorecard demonstrates measurable improvement and flags unresolved control failures.
Explanation
Correct Answers
A:Action: Separate accountable owner decisions from stewardship coordination and operational execution. The proposed intervention targets the reported issue. Owners are accountable for business decisions while stewards coordinate data management practice.
B:Verification: Role descriptions and approvals reflect owner authority and steward implementation. The observed result demonstrates whether the correction operates as intended. Owners are accountable for business decisions while stewards coordinate data management practice.
Incorrect Answers
C: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: Separate accountable owner decisions from stewardship coordination and operational execution.
D:Shortcut: Make a steward solely responsible for every unresolved funding and policy choice. This shortcut is not a sound remediation. Owners are accountable for business decisions while stewards coordinate data management practice. The appropriate action is: Separate accountable owner decisions from stewardship coordination and operational execution.
E:Verification: The scorecard demonstrates measurable improvement and flags unresolved control failures. This evidence is for a separate context (Leadership receives the total number of stewardship meetings as the sole effectiveness KPI.), not this case. The valid outcome is: Role descriptions and approvals reflect owner authority and steward implementation.
Question 482
Consider this organizational data problem: A risk report uses an old industry code mapping but its catalog does not record which version. What action is most defensible?
- Introduce active, deprecated and archived lifecycle states with accountable approval.
- Define approved semantic relationships, metric calculations and valid join paths.
- Capture metadata linking transformed fields to versioned reference-data mappings.
- Use dependency lineage to assess downstream impact and coordinate migration.
Explanation
Correct Answer
C:Capture metadata linking transformed fields to versioned reference-data mappings. Lineage includes reference transformations, not just source-to-target copying. Evidence to obtain: Risk report runs identify applicable mapping versions and affected records.
Incorrect Answers
A:Introduce active, deprecated and archived lifecycle states with accountable approval. This response fits a separate situation (A retired system's catalog entries remain marked active, misleading new project teams.), but does not resolve the stated case. The targeted response is: Capture metadata linking transformed fields to versioned reference-data mappings.
B:Define approved semantic relationships, metric calculations and valid join paths. This response fits a separate situation (Reports join unrelated entities because business dimensions lack a mapped semantic model.), but does not resolve the stated case. The targeted response is: Capture metadata linking transformed fields to versioned reference-data mappings.
D:Use dependency lineage to assess downstream impact and coordinate migration. This response fits a separate situation (A team plans to remove a source column that feeds several dashboards and fraud rules.), but does not resolve the stated case. The targeted response is: Capture metadata linking transformed fields to versioned reference-data mappings.
Question 483
For this situation, which combined intervention and validation MOST directly addresses the issue? Leadership receives the total number of stewardship meetings as the sole effectiveness KPI.
- Action: Establish audience-specific data literacy guidance and approved metric interpretation. Verification: Users correctly interpret sample measures and challenge misleading comparisons.
- Action: Translate principles into measurable standards, owner responsibilities and repeatable procedures. Verification: Teams implement specified checks and exception workflows tied to an approved policy.
- Action: Require authorized risk assessment, expiry, compensating controls and documented acceptance. Verification: The exception has a named owner, time limit and independently monitored mitigation.
- Action: Report meaningful risk, issue aging, quality compliance and business-value outcomes. Verification: The scorecard demonstrates measurable improvement and flags unresolved control failures.
Explanation
Correct Answer
D:Action: Report meaningful risk, issue aging, quality compliance and business-value outcomes. Verification: The scorecard demonstrates measurable improvement and flags unresolved control failures. Both the intervention and measurable outcome are directly relevant. Governance effectiveness is measured by outcomes rather than meeting frequency.
Incorrect Answers
A:This plan addresses a different situation (Executives regularly misinterpret dashboards because they confuse current records with historical cohorts.), not the targeted problem.
B:This plan addresses a different situation (A company has a general policy promising accurate data but no operational validation thresholds.), not the targeted problem.
C:This plan addresses a different situation (A business requests a temporary deviation from a sensitive data retention standard.), not the targeted problem.
Question 484
Consider this data-management scenario: A model incorrectly allows each order to have many unrelated customer owners. Which underlying principle MOST directly explains the preferred response?
- Cardinality and optionality encode business relationship constraints.
- Data model evolution needs governed compatibility and dependency awareness.
- Conceptual models communicate business understanding before logical and physical detail.
- Foreign keys protect relationships between dependent and referenced entities.
Explanation
Correct Answer
A:Cardinality and optionality encode business relationship constraints. This concept explains the reason for the proposed control. Appropriate intervention: Define correct one-to-many customer-to-order cardinality and mandatory participation.
Incorrect Answers
B:Data model evolution needs governed compatibility and dependency awareness. This is a defensible principle in another context (An enterprise data model removes a field still used in multiple integration contracts.), not the most relevant rationale here. For the stated issue: Cardinality and optionality encode business relationship constraints.
C:Conceptual models communicate business understanding before logical and physical detail. 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: Cardinality and optionality encode business relationship constraints.
D:Foreign keys protect relationships between dependent and referenced entities. 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: Cardinality and optionality encode business relationship constraints.
Question 485
A data analyst must confirm the cause of this issue: Several applications retain their own customer stores but need a shared identity index. Which check provides the strongest diagnostic evidence?
- Validate parent-child paths, cycle detection and period-specific aggregate totals.
- Test match/link coverage and trace mastered fields to their actual systems of record.
- Sample cross-system customer matches and evaluate false merges and misses.
- Test normalized names, identifiers, negative matches and manual overrides.
Explanation
Correct Answer
B:Test match/link coverage and trace mastered fields to their actual systems of record. This test checks the relevant business and technical failure rather than assuming its cause. Registry MDM can manage identity linkage without necessarily storing all mastered attributes. Expected control result: A lookup resolves cross-system references while authoritative attributes remain in sources.
Incorrect Answers
A:Validate parent-child paths, cycle detection and period-specific aggregate totals. This check would investigate another issue (Sales cannot roll up revenue because the customer parent-child corporate hierarchy differs across reports.), not the immediate case. The direct diagnostic is: Test match/link coverage and trace mastered fields to their actual systems of record.
C:Sample cross-system customer matches and evaluate false merges and misses. This check would investigate another issue (Retail and service systems each assign different IDs to the same real-world customer.), not the immediate case. The direct diagnostic is: Test match/link coverage and trace mastered fields to their actual systems of record.
D:Test normalized names, identifiers, negative matches and manual overrides. This check would investigate another issue (New customer onboarding creates a second record when spacing differs in a business name.), not the immediate case. The direct diagnostic is: Test match/link coverage and trace mastered fields to their actual systems of record.
Question 486
Consider this organizational data problem: A logical model is approved but a PostgreSQL implementation needs columns and access paths. What action is most defensible?
- Separate transitive department attributes into a referenced department relation.
- Separate attributes dependent on only part of a composite key into their proper relation.
- Model phone numbers as atomic repeating child records with appropriate identifiers.
- Derive physical tables, constraints, indexes and data types for the target workload.
Explanation
Correct Answer
D:Derive physical tables, constraints, indexes and data types for the target workload. Physical modeling implements logical structures under actual platform constraints. Evidence to obtain: Database DDL enforces approved integrity and meets representative performance tests.
Incorrect Answers
A: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: Derive physical tables, constraints, indexes and data types for the target workload.
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: Derive physical tables, constraints, indexes and data types for the target workload.
C:Model phone numbers as atomic repeating child records with appropriate identifiers. This response fits a separate situation (A contact table stores three comma-separated telephone numbers in one column.), but does not resolve the stated case. The targeted response is: Derive physical tables, constraints, indexes and data types for the target workload.
Question 487
Which statement best describes the governing idea behind the response to this case: Operational logs contain sensitive identifiers beyond the allowed retention period.
- Operational retention should satisfy business, privacy and preservation obligations.
- Replication improves availability only when failover and consistency assumptions are tested.
- Indexes speed selective access but impose maintenance and write costs.
- A backup is not demonstrably useful until recoverability has been tested.
Explanation
Correct Answer
A:Operational retention should satisfy business, privacy and preservation obligations. This concept explains the reason for the proposed control. Appropriate intervention: Implement scheduled retention with legal holds, access controls and verifiable deletion.
Incorrect Answers
B:Replication improves availability only when failover and consistency assumptions are tested. This is a defensible principle in another context (A replica exists for critical reads but failover has never been validated.), not the most relevant rationale here. For the stated issue: Operational retention should satisfy business, privacy and preservation obligations.
C:Indexes speed selective access but impose maintenance and write costs. This is a defensible principle in another context (A report scans millions of rows although its date filter is selective and frequent.), not the most relevant rationale here. For the stated issue: Operational retention should satisfy business, privacy and preservation obligations.
D: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: Operational retention should satisfy business, privacy and preservation obligations.
Question 488
A governance review considers the following: Citizen analysts build dashboards using tables with unknown sensitivity and ambiguous joins. Which proposal would create an avoidable risk?
- Document which dataset version was used in a material decision.
- Escalate material unresolved issues to an accountable business decision owner.
- Give every analyst unrestricted production access to accelerate exploration.
- Check relevant business definitions before joining independently sourced data.
Explanation
Correct Answer
C:Give every analyst unrestricted production access to accelerate exploration. Self-service BI requires trusted reusable semantics and controlled access. A sound response instead: Provide certified datasets, semantic layer guidance and role-based BI access.
Incorrect Answers
A:Document which dataset version was used in a material decision. Version records support reproducible decisions. The case-specific response is: Provide certified datasets, semantic layer guidance and role-based BI access.
B:Escalate material unresolved issues to an accountable business decision owner. Accountability prevents silent acceptance of consequential risk. The case-specific response is: Provide certified datasets, semantic layer guidance and role-based BI access.
D:Check relevant business definitions before joining independently sourced data. Semantic agreements prevent incorrect cross-system correlations. The case-specific response is: Provide certified datasets, semantic layer guidance and role-based BI access.
Question 489
Before changing procedures, the team investigates: A dataset is copied into three systems and each team claims another group owns quality. Which review or test MOST directly locates the relevant failure?
- Inspect exception approval dates, scope, mitigation and renewal decisions.
- Trace critical attributes through source systems, contracts and owner approvals.
- Test user understanding of cohort, metric definition and reporting timeframe.
- Review charter decisions on local exceptions, enterprise controls and escalation tests.
Explanation
Correct Answer
B:Trace critical attributes through source systems, contracts and owner approvals. This test checks the relevant business and technical failure rather than assuming its cause. Data accountability must remain clear when information crosses system boundaries. Expected control result: The ownership matrix identifies decision rights and contractual handoffs for each critical field.
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: Trace critical attributes through source systems, contracts and owner approvals.
C:Test user understanding of cohort, metric definition and reporting timeframe. This check would investigate another issue (Executives regularly misinterpret dashboards because they confuse current records with historical cohorts.), not the immediate case. The direct diagnostic is: Trace critical attributes through source systems, contracts and owner approvals.
D:Review charter decisions on local exceptions, enterprise controls and escalation tests. This check would investigate another issue (A federated enterprise wants local stewards but must preserve consistent enterprise rules.), not the immediate case. The direct diagnostic is: Trace critical attributes through source systems, contracts and owner approvals.
Question 490
The data program reviews the following failure: An employee table stores department name determined by department_id, causing inconsistent renames. Which change should be prioritized?
- Enforce appropriate referential integrity and define valid deletion behavior.
- Separate transitive department attributes into a referenced department relation.
- Define correct one-to-many customer-to-order cardinality and mandatory participation.
- Use a common party supertype with justified person and organization subtypes.
Explanation
Correct Answer
B:Separate transitive department attributes into a referenced department relation. Third normal form reduces non-key transitive dependencies and update anomalies. Evidence to obtain: Renaming a department updates one authoritative record without conflicting employee copies.
Incorrect Answers
A:Enforce appropriate referential integrity and define valid deletion behavior. This response fits a separate situation (An order line references a product identifier that does not exist in the product table.), but does not resolve the stated case. The targeted response is: Separate transitive department attributes into a referenced department relation.
C:Define correct one-to-many customer-to-order cardinality and mandatory participation. This response fits a separate situation (A model incorrectly allows each order to have many unrelated customer owners.), but does not resolve the stated case. The targeted response is: Separate transitive department attributes into a referenced department relation.
D:Use a common party supertype with justified person and organization subtypes. This response fits a separate situation (A party table mixes person birthdate with organization registration number, leaving ambiguous rules.), but does not resolve the stated case. The targeted response is: Separate transitive department attributes into a referenced department relation.