CDMP DMF Practice Test 53
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.
Question 521
Before changing procedures, the team investigates: A student can enroll in many courses and a course can enroll many students. Which review or test MOST directly locates the relevant failure?
- Review model annotations, glossary bindings and conflict-resolution decisions.
- Check functional dependencies and update anomalies across enrollment data.
- Test enrollments, composite uniqueness and independent student/course updates.
- Inspect subtype constraints, shared keys and invalid category combinations.
Explanation
Correct Answer
C:Test enrollments, composite uniqueness and independent student/course updates. This test checks the relevant business and technical failure rather than assuming its cause. Many-to-many relationships are implemented using associative structures in relational designs. Expected control result: Enrolments are uniquely recorded without duplicate student or course entities.
Incorrect Answers
A:Review model annotations, glossary bindings and conflict-resolution decisions. This check would investigate another issue (Teams use inconsistent definitions for status and state across logical models.), not the immediate case. The direct diagnostic is: Test enrollments, composite uniqueness and independent student/course updates.
B:Check functional dependencies and update anomalies across enrollment data. This check would investigate another issue (A composite-key enrollment table repeats course title determined by course_id alone.), not the immediate case. The direct diagnostic is: Test enrollments, composite uniqueness and independent student/course updates.
D:Inspect subtype constraints, shared keys and invalid category combinations. This check would investigate another issue (A party table mixes person birthdate with organization registration number, leaving ambiguous rules.), not the immediate case. The direct diagnostic is: Test enrollments, composite uniqueness and independent student/course updates.
Question 522
A data analyst must confirm the cause of this issue: A production database has daily backups but no successful restore has been performed. Which check provides the strongest diagnostic evidence?
- Measure loss of last committed data and duration to service recovery separately.
- Run a controlled restore, verify row counts and record recovery time.
- Inspect backup immutability, retention history and recovery point selection.
- Conduct failover rehearsal and compare replica lag, transactions and client health.
Explanation
Correct Answer
B:Run a controlled restore, verify row counts and record recovery time. This test checks the relevant business and technical failure rather than assuming its cause. A backup is not demonstrably useful until recoverability has been tested. Expected control result: The restored service meets recovery objectives and critical transactions reconcile.
Incorrect Answers
A:This check would investigate another issue (A service can tolerate one hour of data loss but must return within fifteen minutes of outage.), not the immediate case. The direct diagnostic is: Run a controlled restore, verify row counts and record recovery time.
C: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: Run a controlled restore, verify row counts and record recovery time.
D:Conduct failover rehearsal and compare replica lag, transactions and client health. This check would investigate another issue (A replica exists for critical reads but failover has never been validated.), not the immediate case. The direct diagnostic is: Run a controlled restore, verify row counts and record recovery time.
Question 523
A business owner identifies this issue: A data team wants to set quality targets before knowing null, duplicate and value distributions. What is the MOST appropriate data management response?
- Define business uniqueness and controlled entity matching rather than exact-row equality.
- Apply referential integrity or explicit orphan reconciliation across source and target.
- Run repeatable data profiling with representative population and documented limitations.
- Add input validation with clear user feedback and exception override governance.
Explanation
Correct Answer
C:Run repeatable data profiling with representative population and documented limitations. Data profiling provides empirical evidence before quality thresholds are selected. Evidence to obtain: The baseline includes measured distributions, anomalies and reliability of sampling.
Incorrect Answers
A:Define business uniqueness and controlled entity matching rather than exact-row equality. This response fits a separate situation (A CRM has duplicate contact records with different punctuation in their names.), but does not resolve the stated case. The targeted response is: Run repeatable data profiling with representative population and documented limitations.
B:Apply referential integrity or explicit orphan reconciliation across source and target. This response fits a separate situation (An invoice line appears without an invoice header after a partial load.), but does not resolve the stated case. The targeted response is: Run repeatable data profiling with representative population and documented limitations.
D:Add input validation with clear user feedback and exception override governance. This response fits a separate situation (Bad dates are entered during onboarding and corrected only after monthly reporting failures.), but does not resolve the stated case. The targeted response is: Run repeatable data profiling with representative population and documented limitations.
Question 524
In reviewing this data risk, select the LEAST defensible practice: A published regulatory dashboard cannot explain why last month's total changed after a source correction.
- Verify a new interface using a controlled sample and reconciliation.
- Overwrite historical aggregates without recording revisions or reasons.
- Separate short-term issue containment from durable root-cause correction.
- Check that the proposed procedure has an identified operator and approval path.
Explanation
Correct Answer
B:Overwrite historical aggregates without recording revisions or reasons. Trusted BI requires reproducible metrics and transparent revision histories. A sound response instead: Preserve run versions, source snapshots and transformation lineage with approved restatement rules.
Incorrect Answers
A:Verify a new interface using a controlled sample and reconciliation. Testing reveals mismatches before broad deployment. The case-specific response is: Preserve run versions, source snapshots and transformation lineage with approved restatement rules.
C:Separate short-term issue containment from durable root-cause correction. An immediate workaround rarely proves the defect cannot recur. The case-specific response is: Preserve run versions, source snapshots and transformation lineage with approved restatement rules.
D:Check that the proposed procedure has an identified operator and approval path. Operational responsibility prevents undocumented workarounds. The case-specific response is: Preserve run versions, source snapshots and transformation lineage with approved restatement rules.
Question 525
Consider this organizational data problem: A model incorrectly allows each order to have many unrelated customer owners. What action is most defensible?
- Create a conceptual model of core business entities and relationships without implementation details.
- Define correct one-to-many customer-to-order cardinality and mandatory participation.
- Separate attributes dependent on only part of a composite key into their proper relation.
- Apply naming, glossary mapping and controlled definitions to important model elements.
Explanation
Correct Answer
B:Define correct one-to-many customer-to-order cardinality and mandatory participation. Cardinality and optionality encode business relationship constraints. Evidence to obtain: Invalid multi-owner orders are prevented and valid customer orders remain supported.
Incorrect Answers
A:Create a conceptual model of core business entities and relationships without implementation details. This response fits a separate situation (Business stakeholders cannot agree which things should be treated as customers, accounts or products.), but does not resolve the stated case. The targeted response is: Define correct one-to-many customer-to-order cardinality and mandatory participation.
C: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: Define correct one-to-many customer-to-order cardinality and mandatory participation.
D:Apply naming, glossary mapping and controlled definitions to important model elements. This response fits a separate situation (Teams use inconsistent definitions for status and state across logical models.), but does not resolve the stated case. The targeted response is: Define correct one-to-many customer-to-order cardinality and mandatory participation.
Question 526
Consider this organizational data problem: A fraud team receives transaction events forty minutes after its five-minute alert deadline. What action is most defensible?
- Define data-quality service levels for material fields with ownership and escalation.
- Reconcile tier definitions and synchronization logic using a defined authoritative source.
- Measure freshness and repair event-delivery latency against business requirements.
- Publish reusable data-quality rules with owners, thresholds and exceptions.
Explanation
Correct Answer
C:Measure freshness and repair event-delivery latency against business requirements. Timeliness is fitness of information at the required decision moment. Evidence to obtain: End-to-end event latency meets the defined threshold for relevant transactions.
Incorrect Answers
A:Define data-quality service levels for material fields with ownership and escalation. This response fits a separate situation (A shared customer dataset has no agreed defect response or availability expectations.), but does not resolve the stated case. The targeted response is: Measure freshness and repair event-delivery latency against business requirements.
B:Reconcile tier definitions and synchronization logic using a defined authoritative source. This response fits a separate situation (The customer's tier is gold in billing but silver in the loyalty platform on the same date.), but does not resolve the stated case. The targeted response is: Measure freshness and repair event-delivery latency against business requirements.
D:Publish reusable data-quality rules with owners, thresholds and exceptions. This response fits a separate situation (Different pipelines enforce different allowable values for the same governed country field.), but does not resolve the stated case. The targeted response is: Measure freshness and repair event-delivery latency against business requirements.
Question 527
After addressing this problem, what evidence would justify closure? A production database has daily backups but no successful restore has been performed.
- The restored service meets recovery objectives and critical transactions reconcile.
- Recovery exercises meet both distinct time and data-loss targets.
- A simulated primary outage transfers service within the target and avoids unacceptable data loss.
- Representative query time improves without unacceptable ingestion regression.
Explanation
Correct Answer
A:It tests the action: Test a recovery using approved backups and validate application data consistency.
Incorrect Answers
B: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: The restored service meets recovery objectives and critical transactions reconcile.
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: The restored service meets recovery objectives and critical transactions reconcile.
D:Representative query time improves without unacceptable ingestion regression. This would verify a different control (A report scans millions of rows although its date filter is selective and frequent.), not the one in the question. The required evidence is: The restored service meets recovery objectives and critical transactions reconcile.
Question 528
Which statement best describes the governing idea behind the response to this case: One organization can be both a supplier and customer, but systems duplicate its legal entity per role.
- Reference-data changes can alter meaning across time and require controlled versions.
- Registry MDM can manage identity linkage without necessarily storing all mastered attributes.
- A master party entity and its roles are distinct modeling concepts.
- Master relationship governance must enforce structural integrity constraints.
Explanation
Correct Answer
C:A master party entity and its roles are distinct modeling concepts. This concept explains the reason for the proposed control. Appropriate intervention: Model party identity separately from business roles and maintain role-specific attributes.
Incorrect Answers
A: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: A master party entity and its roles are distinct modeling concepts.
B:This is a defensible principle in another context (Several applications retain their own customer stores but need a shared identity index.), not the most relevant rationale here. For the stated issue: A master party entity and its roles are distinct modeling concepts.
D:This is a defensible principle in another context (A new organizational hierarchy update accidentally makes Division A the parent of itself through B.), not the most relevant rationale here. For the stated issue: A master party entity and its roles are distinct modeling concepts.
Question 529
Select THREE statements that correctly identify the needed action, underlying concept and validation evidence: A retired system's catalog entries remain marked active, misleading new project teams.
- Action: Capture metadata linking transformed fields to versioned reference-data mappings.
- Verification: Consumers see retirement dates, replacements and appropriate access warnings.
- Principle: Metadata must reflect the lifecycle of the assets it describes.
- Action: Introduce active, deprecated and archived lifecycle states with accountable approval.
- Verification: An analyst traces a suspect field back to its origin and responsible transformation.
- Shortcut: Leave all retired entries certified forever because removal is inconvenient.
Explanation
Correct Answers
B:Verification: Consumers see retirement dates, replacements and appropriate access warnings. The observed result demonstrates whether the correction operates as intended. Metadata must reflect the lifecycle of the assets it describes.
C:Principle: Metadata must reflect the lifecycle of the assets it describes. This is the governing concept explaining the selected correction and expected outcome.
D:Action: Introduce active, deprecated and archived lifecycle states with accountable approval. The proposed intervention targets the reported issue. Metadata must reflect the lifecycle of the assets it describes.
Incorrect Answers
A:Action: Capture metadata linking transformed fields to versioned reference-data mappings. This intervention is for a different scenario (A risk report uses an old industry code mapping but its catalog does not record which version.), not the one stated. Appropriate action here: Introduce active, deprecated and archived lifecycle states with accountable approval.
E:This evidence is for a separate context (A compliance report is wrong but no one knows which source change introduced the value.), not this case. The valid outcome is: Consumers see retirement dates, replacements and appropriate access warnings.
F:Shortcut: Leave all retired entries certified forever because removal is inconvenient. This shortcut is not a sound remediation. Metadata must reflect the lifecycle of the assets it describes. The appropriate action is: Introduce active, deprecated and archived lifecycle states with accountable approval.
Question 530
The data management team encounters this situation: An upstream API changes a numeric customer status code into a text value and breaks consumers. Which intervention BEST addresses the actual problem?
- Evaluate governed federation or virtualization with source access, query pushdown and performance limits.
- Define an agreed canonical mapping with meaning, transform ownership and validation.
- Govern landing, transformation logic, lineage and compute costs in a controlled ELT workflow.
- Establish a versioned API contract and compatibility tests before deploying breaking changes.
Explanation
Correct Answer
D:Evidence to obtain: Consumer integration tests pass or the incompatible change is deliberately migrated.
Incorrect Answers
A:Evaluate governed federation or virtualization with source access, query pushdown and performance limits. 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. The targeted response is: Establish a versioned API contract and compatibility tests before deploying breaking changes.
B:Define an agreed canonical mapping with meaning, transform ownership and validation. 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. The targeted response is: Establish a versioned API contract and compatibility tests before deploying breaking changes.
C:Govern landing, transformation logic, lineage and compute costs in a controlled ELT workflow.