CDMP DMF Practice Test 70
Question 690
A proposed shortcut is offered for this situation: A federated enterprise wants local stewards but must preserve consistent enterprise rules. Which choice is the CLEAREST mistake?
- Preserve source evidence and document why any exception was approved.
- Validate critical changes against representative positive and negative examples.
- Either centralize all decisions or eliminate common standards without analysis.
- Inspect lineage and source context before changing a derived report.
Explanation
Correct Answer
C:Either centralize all decisions or eliminate common standards without analysis. Governance operating models balance local agility with cross-enterprise consistency. A sound response instead: Define federated decision boundaries, central standards and locally accountable execution.
Incorrect Answers
A:Preserve source evidence and document why any exception was approved. Traceability enables independent review of exceptions. The case-specific response is: Define federated decision boundaries, central standards and locally accountable execution.
B:Validate critical changes against representative positive and negative examples. Controlled tests provide more reliable proof than untested assumptions. The case-specific response is: Define federated decision boundaries, central standards and locally accountable execution.
D:Inspect lineage and source context before changing a derived report. Provenance analysis distinguishes source errors from transformations. The case-specific response is: Define federated decision boundaries, central standards and locally accountable execution.
Question 691
A data management auditor evaluates this situation: A BI analyst receives administrator access to production customer tables for simple reporting. Which observable finding supports successful remediation?
- The dataset is correctly labeled and unauthorized roles cannot read restricted attributes.
- Stored backups are unreadable without authorized key access and restores succeed.
- Investigation records affected datasets, containment, timeline and obligations.
- The analyst can perform the report but cannot alter or see unrelated sensitive records.
Explanation
Correct Answer
D:It tests the action: Grant narrow read access to approved views instead of broad administrative rights.
Incorrect Answers
A:The dataset is correctly labeled and unauthorized roles cannot read restricted attributes. This would verify a different control (A developer stores payment account numbers in a general-purpose dataset tagged public.), not the one in the question. The required evidence is: The analyst can perform the report but cannot alter or see unrelated sensitive records.
B:Stored backups are unreadable without authorized key access and restores succeed. This would verify a different control (A backup contains confidential employee salaries and is stored without encryption controls.), not the one in the question. The required evidence is: The analyst can perform the report but cannot alter or see unrelated sensitive records.
C:Investigation records affected datasets, containment, timeline and obligations. This would verify a different control (An unauthorized service account downloads a large restricted dataset overnight.), not the one in the question. The required evidence is: The analyst can perform the report but cannot alter or see unrelated sensitive records.
Question 692
An accountable team must correct this problem and prove results. Select TWO sound statements: Business stakeholders cannot agree which things should be treated as customers, accounts or products.
- Verification: Stakeholders approve shared concepts and relationship definitions.
- Action: Create a conceptual model of core business entities and relationships without implementation details.
- Shortcut: Begin with database indexes and infer business terms from column types.
- Action: Use a common party supertype with justified person and organization subtypes.
- Verification: Each number is independently searchable and maintained without string parsing.
Explanation
Correct Answers
A:Verification: Stakeholders approve shared concepts and relationship definitions. The observed result demonstrates whether the correction operates as intended. Conceptual models communicate business understanding before logical and physical detail.
B:Action: Create a conceptual model of core business entities and relationships without implementation details. The proposed intervention targets the reported issue. Conceptual models communicate business understanding before logical and physical detail.
Incorrect Answers
C:Shortcut: Begin with database indexes and infer business terms from column types. This shortcut is not a sound remediation. Conceptual models communicate business understanding before logical and physical detail. The appropriate action is: Create a conceptual model of core business entities and relationships without implementation details.
D:This intervention is for a different scenario (A party table mixes person birthdate with organization registration number, leaving ambiguous rules.), not the one stated.
E:Verification: Each number is independently searchable and maintained without string parsing. This evidence is for a separate context (A contact table stores three comma-separated telephone numbers in one column.), not this case. The valid outcome is: Stakeholders approve shared concepts and relationship definitions.
Question 693
A data analyst must confirm the cause of this issue: A team proposes proprietary event fields that cannot be interpreted by other platforms. Which check provides the strongest diagnostic evidence?
- Trace a customer identity across reference models, interface contracts and target standards.
- Trace one source record through each data movement and transformation edge.
- Inspect data contracts, schema-version changes and consumer integration tests.
- Review current-state flows, target-state interfaces, interim controls and transition gates.
Explanation
Correct Answer
C:Inspect data contracts, schema-version changes and consumer integration tests. This test checks the relevant business and technical failure rather than assuming its cause. Standards reduce integration ambiguity when implementations use different technologies. Expected control result: Conformance tests show field meanings and changes remain compatible with consuming systems.
Incorrect Answers
A:Trace a customer identity across reference models, interface contracts and target standards. This check would investigate another issue (Customer identifiers differ across sales, billing and support, preventing consistent reporting.), not the immediate case. The direct diagnostic is: Inspect data contracts, schema-version changes and consumer integration tests.
B:Trace one source record through each data movement and transformation edge. This check would investigate another issue (A regulatory metric cannot be reconciled to the systems that initially captured its values.), not the immediate case. The direct diagnostic is: Inspect data contracts, schema-version changes and consumer integration tests.
D:Review current-state flows, target-state interfaces, interim controls and transition gates. This check would investigate another issue (A bank intends to retire a reporting platform but has no inventory of upstream sources or dependencies.), not the immediate case. The direct diagnostic is: Inspect data contracts, schema-version changes and consumer integration tests.
Question 694
In reviewing this data risk, select the LEAST defensible practice: A regulatory metric cannot be reconciled to the systems that initially captured its values.
- Separate short-term issue containment from durable root-cause correction.
- Draw only a final dashboard picture and claim that explains provenance.
- Apply access controls proportional to the sensitivity of business information.
- Retain a rollback or recovery plan before making destructive data changes.
Explanation
Correct Answer
B:Draw only a final dashboard picture and claim that explains provenance. Architecture flow maps make hidden dependencies and control points observable. A sound response instead: Create an end-to-end logical data flow mapping origin, processing, stores and consumers.
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: Create an end-to-end logical data flow mapping origin, processing, stores and consumers.
C:Apply access controls proportional to the sensitivity of business information. Confidentiality obligations still apply during quality improvements. The case-specific response is: Create an end-to-end logical data flow mapping origin, processing, stores and consumers.
D:Retain a rollback or recovery plan before making destructive data changes. Recoverability reduces the consequences of incorrect remediation. The case-specific response is: Create an end-to-end logical data flow mapping origin, processing, stores and consumers.
Question 695
A proposed shortcut is offered for this situation: A student can enroll in many courses and a course can enroll many students. Which choice is the CLEAREST mistake?
- Store each student's courses as a semicolon-delimited field in the student row.
- Define the intended data population before interpreting quality percentages.
- Escalate material unresolved issues to an accountable business decision owner.
- Check relevant business definitions before joining independently sourced data.
Explanation
Correct Answer
A:Store each student's courses as a semicolon-delimited field in the student row. Many-to-many relationships are implemented using associative structures in relational designs. A sound response instead: Model an associative enrollment entity with both relationships and enrollment attributes.
Incorrect Answers
B:Define the intended data population before interpreting quality percentages. An undisclosed denominator can make strong scores misleading. The case-specific response is: Model an associative enrollment entity with both relationships and enrollment attributes.
C:Escalate material unresolved issues to an accountable business decision owner. Accountability prevents silent acceptance of consequential risk. The case-specific response is: Model an associative enrollment entity with both relationships and enrollment attributes.
D:Check relevant business definitions before joining independently sourced data. Semantic agreements prevent incorrect cross-system correlations. The case-specific response is: Model an associative enrollment entity with both relationships and enrollment attributes.
Question 696
A data steward examines this condition: Users search for a customer dataset but see dozens of unlabeled backups ahead of certified sources. What concept best justifies the corrective approach?
- Operational metadata describes execution, frequency, health and processing events.
- Metadata catalogs should support discovery and trust, not merely list files.
- Metadata dependency mapping enables informed change management.
- Lineage includes reference transformations, not just source-to-target copying.
Explanation
Correct Answer
B:This concept explains the reason for the proposed control. Appropriate intervention: Improve catalog classification, search relevance and certified-asset indicators.
Incorrect Answers
A: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: Metadata catalogs should support discovery and trust, not merely list files.
C:This is a defensible principle in another context (A team plans to remove a source column that feeds several dashboards and fraud rules.), not the most relevant rationale here.
D:This is a defensible principle in another context (A risk report uses an old industry code mapping but its catalog does not record which version.), not the most relevant rationale here. For the stated issue: Metadata catalogs should support discovery and trust, not merely list files.
Question 697
A proposed shortcut is offered for this situation: Two executive dashboards both show profit margin but use different numerator adjustments. Which choice is the CLEAREST mistake?
- Call differently defined ratios the same metric and ignore discrepancies.
- Verify a new interface using a controlled sample and reconciliation.
- Define the intended data population before interpreting quality percentages.
- Protect relevant audit records while investigating data problems.
Explanation
Correct Answer
A:Call differently defined ratios the same metric and ignore discrepancies. BI comparability depends on consistent business metric semantics, not chart style. A sound response instead: Govern KPI definitions, filters, denominator and time rules across reporting tools.
Incorrect Answers
B:Verify a new interface using a controlled sample and reconciliation. Testing reveals mismatches before broad deployment. The case-specific response is: Govern KPI definitions, filters, denominator and time rules across reporting tools.
C:Define the intended data population before interpreting quality percentages. An undisclosed denominator can make strong scores misleading. The case-specific response is: Govern KPI definitions, filters, denominator and time rules across reporting tools.
D:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Govern KPI definitions, filters, denominator and time rules across reporting tools.
Question 698
A data analyst must confirm the cause of this issue: Customer identifiers differ across sales, billing and support, preventing consistent reporting. Which check provides the strongest diagnostic evidence?
- Test representative queries, change ownership, consistency and operating costs.
- Review current-state flows, target-state interfaces, interim controls and transition gates.
- Trace a customer identity across reference models, interface contracts and target standards.
- Review project decision history, principle conformance and remediation evidence.
Explanation
Correct Answer
C:Trace a customer identity across reference models, interface contracts and target standards. This test checks the relevant business and technical failure rather than assuming its cause. Data architecture provides enterprise-wide direction for how data is structured and flows. Expected control result: Architecture decisions document common identifiers and approved exchange patterns across systems.
Incorrect Answers
A:Test representative queries, change ownership, consistency and operating costs. This check would investigate another issue (An organization compares central warehouse, decentralized data products and a virtualization layer for analytics.), not the immediate case. The direct diagnostic is: Trace a customer identity across reference models, interface contracts and target standards.
B:This check would investigate another issue (A bank intends to retire a reporting platform but has no inventory of upstream sources or dependencies.), not the immediate case. The direct diagnostic is: Trace a customer identity across reference models, interface contracts and target standards.
D:Review project decision history, principle conformance and remediation evidence. This check would investigate another issue (A transformation program has diagrams but no one decides whether new platforms meet enterprise principles.), not the immediate case. The direct diagnostic is: Trace a customer identity across reference models, interface contracts and target standards.
Question 699
A business owner identifies this issue: A CRM has duplicate contact records with different punctuation in their names. What is the MOST appropriate data management response?
- Enforce governed domain rules at ingestion and monitor invalid values.
- Identify the upstream source-process failure and implement a preventive correction.
- Define business uniqueness and controlled entity matching rather than exact-row equality.
- Assess completeness and timeliness separately, then choose remediation based on use.
Explanation
Correct Answer
C:Define business uniqueness and controlled entity matching rather than exact-row equality. Uniqueness depends on the real-world entity being represented, not only string equality. Evidence to obtain: Confirmed duplicate rates fall without inappropriate merges of distinct customers.
Incorrect Answers
A:Enforce governed domain rules at ingestion and monitor invalid values. This response fits a separate situation (A product status field contains values archived and disabled although only active and retired are approved.), but does not resolve the stated case. The targeted response is: Define business uniqueness and controlled entity matching rather than exact-row equality.
B:Identify the upstream source-process failure and implement a preventive correction. This response fits a separate situation (An analyst manually fixes the same missing supplier IDs every week.), but does not resolve the stated case. The targeted response is: Define business uniqueness and controlled entity matching rather than exact-row equality.
D:Assess completeness and timeliness separately, then choose remediation based on use. This response fits a separate situation (A postal address field is 100 percent complete but several entries are no longer current.), but does not resolve the stated case. The targeted response is: Define business uniqueness and controlled entity matching rather than exact-row equality.
Question 700
A data management auditor evaluates this situation: A team plans to remove a source column that feeds several dashboards and fraud rules. Which observable finding supports successful remediation?
- Affected consumers are notified and changed logic passes compatibility tests.
- Consumers see retirement dates, replacements and appropriate access warnings.
- Risk report runs identify applicable mapping versions and affected records.
- Ingestion validation matches recorded technical structures and flags incompatible changes.
Explanation
Correct Answer
A:It tests the action: Use dependency lineage to assess downstream impact and coordinate migration.
Incorrect Answers
B:Consumers see retirement dates, replacements and appropriate access warnings. This would verify a different control (A retired system's catalog entries remain marked active, misleading new project teams.), not the one in the question. The required evidence is: Affected consumers are notified and changed logic passes compatibility tests.
C:Risk report runs identify applicable mapping versions and affected records. This would verify a different control (A risk report uses an old industry code mapping but its catalog does not record which version.), not the one in the question. The required evidence is: Affected consumers are notified and changed logic passes compatibility tests.
D: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: Affected consumers are notified and changed logic passes compatibility tests.