CDMP DMF Practice Test 17
Question 160
A data analyst must confirm the cause of this issue: An enterprise data model removes a field still used in multiple integration contracts. Which check provides the strongest diagnostic evidence?
- Review grain statement, keys and reconciliation with source order totals.
- Review DDL, foreign keys, indexes and query plans against the logical model.
- Attempt controlled orphan inserts and verify configured delete behavior.
- Trace model-field lineage, interface consumers and staged migration tests.
Explanation
Correct Answer
D:Trace model-field lineage, interface consumers and staged migration tests. This test checks the relevant business and technical failure rather than assuming its cause. Data model evolution needs governed compatibility and dependency awareness. Expected control result: Consumers migrate deliberately and production queries avoid unexpected breakage.
Incorrect Answers
A:Review grain statement, keys and reconciliation with source order totals. This check would investigate another issue (A warehouse fact table mixes one-row-per-order and one-row-per-order-line measures.), not the immediate case. The direct diagnostic is: Trace model-field lineage, interface consumers and staged migration tests.
B:Review DDL, foreign keys, indexes and query plans against the logical model. This check would investigate another issue (A logical model is approved but a PostgreSQL implementation needs columns and access paths.), not the immediate case. The direct diagnostic is: Trace model-field lineage, interface consumers and staged migration tests.
C:Attempt controlled orphan inserts and verify configured delete behavior. This check would investigate another issue (An order line references a product identifier that does not exist in the product table.), not the immediate case. The direct diagnostic is: Trace model-field lineage, interface consumers and staged migration tests.
Question 161
In reviewing this data risk, select the LEAST defensible practice: Catalog entries become stale because their data owners were never assigned responsibility.
- Apply access controls proportional to the sensitivity of business information.
- Keep approved reference mappings versioned and traceable.
- Import all metadata once and disable future review or updates.
- Retain a rollback or recovery plan before making destructive data changes.
Explanation
Correct Answer
C:Import all metadata once and disable future review or updates. Metadata quality depends on ongoing stewardship rather than one-time catalog loading. A sound response instead: Assign accountable metadata stewards and automated review reminders for priority assets.
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: Assign accountable metadata stewards and automated review reminders for priority assets.
B:Keep approved reference mappings versioned and traceable. Value meaning can change across time and applications. The case-specific response is: Assign accountable metadata stewards and automated review reminders for priority assets.
D:Retain a rollback or recovery plan before making destructive data changes. Recoverability reduces the consequences of incorrect remediation. The case-specific response is: Assign accountable metadata stewards and automated review reminders for priority assets.
Question 162
A data analyst must confirm the cause of this issue: A nightly warehouse load rereads the entire history and repeatedly misses its completion window. Which check provides the strongest diagnostic evidence?
- Simulate retry after partial failure and compare source/target completeness.
- Trace sample source facts through grain rules to report totals.
- Validate rollups, drilldowns, level definitions and source read-only access.
- Check nonoverlapping effective windows and historical fact joins.
Explanation
Correct Answer
A:Simulate retry after partial failure and compare source/target completeness. This test checks the relevant business and technical failure rather than assuming its cause. Incremental loads reduce cost but depend on correct change tracking and recovery. Expected control result: Run duration falls while incremental totals match the authoritative source.
Incorrect Answers
B:Trace sample source facts through grain rules to report totals. This check would investigate another issue (A sales fact table mixes shipment-level and order-line-level amounts, doubling totals.), not the immediate case. The direct diagnostic is: Simulate retry after partial failure and compare source/target completeness.
C:Validate rollups, drilldowns, level definitions and source read-only access. This check would investigate another issue (A financial analyst needs totals by region and quarter without modifying source orders.), not the immediate case. The direct diagnostic is: Simulate retry after partial failure and compare source/target completeness.
D:Check nonoverlapping effective windows and historical fact joins. This check would investigate another issue (A salesperson moves territories and historical sales must remain attributed to prior territory.), not the immediate case. The direct diagnostic is: Simulate retry after partial failure and compare source/target completeness.
Question 163
A data management auditor evaluates this situation: A mobile app uses a currency-code list six months older than the payments platform. Which observable finding supports successful remediation?
- Country values map consistently and invalid codes fail controlled validation.
- The organization links to multiple roles without conflating role-specific permissions.
- Each approved update follows the master service and downstream consumers receive consistent versions.
- Consumers use supported versions and invalid currency codes trigger clear exceptions.
Explanation
Correct Answer
D:It tests the action: Distribute reference versions through a governed publish/subscribe or release process.
Incorrect Answers
A:Country values map consistently and invalid codes fail controlled validation. This would verify a different control (Three regions encode country using names, ISO codes and private numeric lists.), not the one in the question. The required evidence is: Consumers use supported versions and invalid currency codes trigger clear exceptions.
B:The organization links to multiple roles without conflating role-specific permissions. This would verify a different control (One organization can be both a supplier and customer, but systems duplicate its legal entity per role.), not the one in the question. The required evidence is: Consumers use supported versions and invalid currency codes trigger clear exceptions.
C:Each approved update follows the master service and downstream consumers receive consistent versions. This would verify a different control (A new platform requires all customer master updates to occur through one governed service.), not the one in the question. The required evidence is: Consumers use supported versions and invalid currency codes trigger clear exceptions.
Question 164
Select TWO appropriate statements, one intervention and one verification, for this data management case: Raw clickstream files are dumped into an object store without ownership, schema or discovery metadata.
- Action: Introduce ingestion metadata, dataset ownership, cataloging and quality checks for the lake.
- Action: Use a governed low-latency event stream for alerts and a scheduled batch path for the summary.
- Shortcut: Keep all raw files unlabeled and let analysts guess their meaning.
- Verification: The distributed job completes correctly within the required window and reconciles counts.
- Verification: Consumers can discover trustworthy datasets and distinguish approved from abandoned assets.
Explanation
Correct Answers
A:Action: Introduce ingestion metadata, dataset ownership, cataloging and quality checks for the lake. The proposed intervention targets the reported issue. A data lake becomes unusable when uncontrolled ingestion creates a data swamp.
E:Verification: Consumers can discover trustworthy datasets and distinguish approved from abandoned assets. The observed result demonstrates whether the correction operates as intended. A data lake becomes unusable when uncontrolled ingestion creates a data swamp.
Incorrect Answers
B:This intervention is for a different scenario (A fraud-alert service must evaluate new events within seconds while a monthly financial summary tolerates delay.), not the one stated.
C:Shortcut: Keep all raw files unlabeled and let analysts guess their meaning. This shortcut is not a sound remediation. A data lake becomes unusable when uncontrolled ingestion creates a data swamp. The appropriate action is: Introduce ingestion metadata, dataset ownership, cataloging and quality checks for the lake.
D:Verification: The distributed job completes correctly within the required window and reconciles counts. This evidence is for a separate context (A nightly billion-event aggregation exceeds single-machine memory and now misses its SLA.), not this case. The valid outcome is: Consumers can discover trustworthy datasets and distinguish approved from abandoned assets.
Question 165
A business owner identifies this issue: Business units need local writes but also expect synchronized approved enterprise attributes. What is the MOST appropriate data management response?
- Design coexistence MDM with controlled bidirectional synchronization and conflict handling.
- Define survivorship rules that favor verified recent evidence with traceable provenance.
- Govern a shared country reference set with mappings, definitions and permitted changes.
- Choose a consolidation MDM approach with governed ingestion and survivorship.
Explanation
Correct Answer
A:Design coexistence MDM with controlled bidirectional synchronization and conflict handling. Coexistence combines shared mastering with retained local application data maintenance. Evidence to obtain: Update conflicts are resolved under stated rules and master attributes converge.
Incorrect Answers
B:Define survivorship rules that favor verified recent evidence with traceable provenance. This response fits a separate situation (Two customer sources disagree about legal name after one verifies recent government ID.), but does not resolve the stated case. The targeted response is: Design coexistence MDM with controlled bidirectional synchronization and conflict handling.
C:Govern a shared country reference set with mappings, definitions and permitted changes. This response fits a separate situation (Three regions encode country using names, ISO codes and private numeric lists.), but does not resolve the stated case. The targeted response is: Design coexistence MDM with controlled bidirectional synchronization and conflict handling.
D:Choose a consolidation MDM approach with governed ingestion and survivorship. This response fits a separate situation (A company wants a central analytical customer view while operational systems continue owning updates.), but does not resolve the stated case. The targeted response is: Design coexistence MDM with controlled bidirectional synchronization and conflict handling.
Question 166
A governance review considers the following: A matching algorithm merges a parent and child solely because they share surname and address. Which proposal would create an avoidable risk?
- Treat a single shared surname as conclusive person identity.
- Protect relevant audit records while investigating data problems.
- Separate short-term issue containment from durable root-cause correction.
- Validate critical changes against representative positive and negative examples.
Explanation
Correct Answer
A:Treat a single shared surname as conclusive person identity. Entity resolution must balance false positive merges against missed duplicates. A sound response instead: Use multiple discriminating attributes and calibrated match thresholds with review for uncertain pairs.
Incorrect Answers
B:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Use multiple discriminating attributes and calibrated match thresholds with review for uncertain pairs.
C: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: Use multiple discriminating attributes and calibrated match thresholds with review for uncertain pairs.
D:Validate critical changes against representative positive and negative examples. Controlled tests provide more reliable proof than untested assumptions. The case-specific response is: Use multiple discriminating attributes and calibrated match thresholds with review for uncertain pairs.
Question 167
A data steward examines this condition: An order line references a product identifier that does not exist in the product table. What concept best justifies the corrective approach?
- Conceptual models communicate business understanding before logical and physical detail.
- Logical modeling formalizes business data structure separate from storage technology.
- First normal form discourages repeating groups and multi-valued atomic fields.
- Foreign keys protect relationships between dependent and referenced entities.
Explanation
Correct Answer
D:Foreign keys protect relationships between dependent and referenced entities. This concept explains the reason for the proposed control. Appropriate intervention: Enforce appropriate referential integrity and define valid deletion behavior.
Incorrect Answers
A: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: Foreign keys protect relationships between dependent and referenced entities.
B:Logical modeling formalizes business data structure separate from storage technology. This is a defensible principle in another context (An enterprise needs rules for customer-to-contract cardinality without choosing a database product.), not the most relevant rationale here. For the stated issue: Foreign keys protect relationships between dependent and referenced entities.
C:First normal form discourages repeating groups and multi-valued atomic fields. This is a defensible principle in another context (A contact table stores three comma-separated telephone numbers in one column.), not the most relevant rationale here. For the stated issue: Foreign keys protect relationships between dependent and referenced entities.
Question 168
In reviewing this data risk, select the LEAST defensible practice: Project teams repeatedly pick conflicting data integration styles for identical business needs.
- Escalate material unresolved issues to an accountable business decision owner.
- Approve whichever design is newest without comparing governance tradeoffs.
- Preserve source evidence and document why any exception was approved.
- Validate critical changes against representative positive and negative examples.
Explanation
Correct Answer
B:Approve whichever design is newest without comparing governance tradeoffs. Architecture principles make cross-project decisions consistent without prohibiting justified exceptions. A sound response instead: Create agreed architecture principles and review exceptions through a decision process.
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: Create agreed architecture principles and review exceptions through a decision process.
C:Preserve source evidence and document why any exception was approved. Traceability enables independent review of exceptions. The case-specific response is: Create agreed architecture principles and review exceptions through a decision process.
D:Validate critical changes against representative positive and negative examples. Controlled tests provide more reliable proof than untested assumptions. The case-specific response is: Create agreed architecture principles and review exceptions through a decision process.
Question 169
A reviewer asks for proof of improvement: Three systems record table creation dates in incompatible time zones and formats. Which result MOST convincingly demonstrates that the control works?
- Representative searches surface approved datasets and disclose archival alternatives.
- Unauthorized users see discovery descriptions but no confidential samples.
- Catalog times convert consistently with time zone and source provenance retained.
- Owner, definition and quality metadata stay current after system changes.
Explanation
Correct Answer
C:It tests the action: Define common timestamp semantics and metadata exchange conventions.
Incorrect Answers
A:Representative searches surface approved datasets and disclose archival alternatives. This would verify a different control (Users search for a customer dataset but see dozens of unlabeled backups ahead of certified sources.), not the one in the question. The required evidence is: Catalog times convert consistently with time zone and source provenance retained.
B:Unauthorized users see discovery descriptions but no confidential samples. This would verify a different control (A public catalog description reveals restricted patient identities in sample values.), not the one in the question. The required evidence is: Catalog times convert consistently with time zone and source provenance retained.
D: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: Catalog times convert consistently with time zone and source provenance retained.
Question 170
Consider this data-management scenario: A matching algorithm merges a parent and child solely because they share surname and address. Which underlying principle MOST directly explains the preferred response?
- Entity resolution must balance false positive merges against missed duplicates.
- Master-data stewardship needs business authority for accepted entity definitions.
- Preventing duplicate creation is usually cheaper than repeated downstream reconciliation.
- Reference data consistency requires controlled publication and consumer adoption.
Explanation
Correct Answer
A:Entity resolution must balance false positive merges against missed duplicates. This concept explains the reason for the proposed control. Appropriate intervention: Use multiple discriminating attributes and calibrated match thresholds with review for uncertain pairs.
Incorrect Answers
B:Master-data stewardship needs business authority for accepted entity definitions. This is a defensible principle in another context (Marketing and finance disagree on who approves supplier legal entity identifiers.), not the most relevant rationale here. For the stated issue: Entity resolution must balance false positive merges against missed duplicates.
C:This is a defensible principle in another context (New customer onboarding creates a second record when spacing differs in a business name.), not the most relevant rationale here. For the stated issue: Entity resolution must balance false positive merges against missed duplicates.
D:Reference data consistency requires controlled publication and consumer adoption. This is a defensible principle in another context (A mobile app uses a currency-code list six months older than the payments platform.), not the most relevant rationale here. For the stated issue: Entity resolution must balance false positive merges against missed duplicates.