CDMP DMF Practice Test 68
Question 670
An accountable team must correct this problem and prove results. Select TWO sound statements: Different pipelines enforce different allowable values for the same governed country field.
- Verification: Equivalent datasets are evaluated against the same approved country-code version.
- Verification: SLA measures and exceptions trigger response when thresholds are missed.
- Action: Publish reusable data-quality rules with owners, thresholds and exceptions.
- Shortcut: Let each pipeline silently select a different valid-value list.
- Action: Verify the address against a trusted recent source and update the authoritative record.
Explanation
Correct Answers
A:Verification: Equivalent datasets are evaluated against the same approved country-code version. The observed result demonstrates whether the correction operates as intended. Quality rules need documented semantics and controlled reuse across systems.
C:Action: Publish reusable data-quality rules with owners, thresholds and exceptions. The proposed intervention targets the reported issue. Quality rules need documented semantics and controlled reuse across systems.
Incorrect Answers
B:Verification: SLA measures and exceptions trigger response when thresholds are missed. This evidence is for a separate context (A shared customer dataset has no agreed defect response or availability expectations.), not this case. The valid outcome is: Equivalent datasets are evaluated against the same approved country-code version.
D:Shortcut: Let each pipeline silently select a different valid-value list. This shortcut is not a sound remediation. Quality rules need documented semantics and controlled reuse across systems. The appropriate action is: Publish reusable data-quality rules with owners, thresholds and exceptions.
E:Action: Verify the address against a trusted recent source and update the authoritative record. This intervention is for a different scenario (A customer's billing address is validly formatted but refers to a previous residence.), not the one stated. Appropriate action here: Publish reusable data-quality rules with owners, thresholds and exceptions.
Question 671
Consider this organizational data problem: A backup contains confidential employee salaries and is stored without encryption controls. What action is most defensible?
- Encrypt backup data using approved keys with controlled key access and recovery procedures.
- Enable protected access and export audit logs with appropriate retention and review.
- Require authenticated encrypted transport using supported TLS configuration.
- Enforce row-level security using authoritative user-to-region mapping.
Explanation
Correct Answer
A:Encrypt backup data using approved keys with controlled key access and recovery procedures. Encryption at rest reduces exposure of stored sensitive information but requires key governance. Evidence to obtain: Stored backups are unreadable without authorized key access and restores succeed.
Incorrect Answers
B:Enable protected access and export audit logs with appropriate retention and review. This response fits a separate situation (Privileged database exports are possible but no one records who initiated them.), but does not resolve the stated case. The targeted response is: Encrypt backup data using approved keys with controlled key access and recovery procedures.
C:Require authenticated encrypted transport using supported TLS configuration. This response fits a separate situation (A service transfers customer attributes over unencrypted HTTP between data centers.), but does not resolve the stated case. The targeted response is: Encrypt backup data using approved keys with controlled key access and recovery procedures.
D:Enforce row-level security using authoritative user-to-region mapping. This response fits a separate situation (Regional sales managers can query all customer records despite regional authorization rules.), but does not resolve the stated case. The targeted response is: Encrypt backup data using approved keys with controlled key access and recovery procedures.
Question 672
A data steward examines this condition: A records team says old files were deleted but cannot show what was destroyed or who authorized it. What concept best justifies the corrective approach?
- Content version management prevents superseded drafts from being mistaken for authoritative records.
- Content repositories require classification-based access and sharing restrictions.
- Defensible disposal requires provable compliance with retention and preservation rules.
- Extracted content is derived data whose accuracy and provenance require verification.
Explanation
Correct Answer
C:Defensible disposal requires provable compliance with retention and preservation rules. This concept explains the reason for the proposed control. Appropriate intervention: Implement disposition approval, hold checking and tamper-resistant destruction logs.
Incorrect Answers
A:This is a defensible principle in another context (Staff collaborate on a policy but several copied files are called final and no approved version is clear.), not the most relevant rationale here. For the stated issue: Defensible disposal requires provable compliance with retention and preservation rules.
B:Content repositories require classification-based access and sharing restrictions. This is a defensible principle in another context (A public sharing link exposes sensitive human resources documents to contractors.), not the most relevant rationale here. For the stated issue: Defensible disposal requires provable compliance with retention and preservation rules.
D:This is a defensible principle in another context (A team runs OCR on handwritten forms and loads extracted values directly into an account ledger.), not the most relevant rationale here. For the stated issue: Defensible disposal requires provable compliance with retention and preservation rules.
Question 673
An accountable team must correct this problem and prove results. Select TWO sound statements: A new platform requires all customer master updates to occur through one governed service.
- Action: Model party identity separately from business roles and maintain role-specific attributes.
- Shortcut: Permit untracked direct writes to satellite copies of authoritative master attributes.
- Verification: Each approved update follows the master service and downstream consumers receive consistent versions.
- Action: Consider centralized transaction-style MDM with authoritative write APIs and availability controls.
- Verification: Known duplicate test cases are flagged while legitimate similar companies remain distinct.
Explanation
Correct Answers
C:Verification: Each approved update follows the master service and downstream consumers receive consistent versions. The observed result demonstrates whether the correction operates as intended. Centralized mastering makes the hub the system of entry for core entity changes.
D:Action: Consider centralized transaction-style MDM with authoritative write APIs and availability controls. The proposed intervention targets the reported issue. Centralized mastering makes the hub the system of entry for core entity changes.
Incorrect Answers
A:This intervention is for a different scenario (One organization can be both a supplier and customer, but systems duplicate its legal entity per role.), not the one stated. Appropriate action here: Consider centralized transaction-style MDM with authoritative write APIs and availability controls.
B:Shortcut: Permit untracked direct writes to satellite copies of authoritative master attributes. This shortcut is not a sound remediation. Centralized mastering makes the hub the system of entry for core entity changes. The appropriate action is: Consider centralized transaction-style MDM with authoritative write APIs and availability controls.
E:This evidence is for a separate context (New customer onboarding creates a second record when spacing differs in a business name.), not this case.
Question 674
A governance committee needs a defensible plan and proof: Privileged database exports are possible but no one records who initiated them. Which paired proposal is appropriate?
- Action: Enforce row-level security using authoritative user-to-region mapping. Verification: An authorized manager sees own-region rows and cannot access other regions.
- Action: Grant narrow read access to approved views instead of broad administrative rights. Verification: The analyst can perform the report but cannot alter or see unrelated sensitive records.
- Action: Revoke relevant access, preserve evidence, assess scope and follow incident notification policy. Verification: Investigation records affected datasets, containment, timeline and obligations.
- Action: Enable protected access and export audit logs with appropriate retention and review. Verification: A test export captures actor, dataset, time and authorized action in immutable evidence.
Explanation
Correct Answer
D:Action: Enable protected access and export audit logs with appropriate retention and review. Verification: A test export captures actor, dataset, time and authorized action in immutable evidence. Both the intervention and measurable outcome are directly relevant. Auditability complements prevention by making sensitive operations attributable.
Incorrect Answers
A:This plan addresses a different situation (Regional sales managers can query all customer records despite regional authorization rules.), not the targeted problem. Here, action and evidence must match: Action: Enable protected access and export audit logs with appropriate retention and review.
B:This plan addresses a different situation (A BI analyst receives administrator access to production customer tables for simple reporting.), not the targeted problem.
C:This plan addresses a different situation (An unauthorized service account downloads a large restricted dataset overnight.), not the targeted problem. Here, action and evidence must match: Action: Enable protected access and export audit logs with appropriate retention and review.
Question 675
A data management auditor evaluates this situation: A catalog tool identifies data owners but cannot force them to decide disputed definitions. Which observable finding supports successful remediation?
- The ownership matrix identifies decision rights and contractual handoffs for each critical field.
- Tool records link approved decisions to datasets, issues and accountable people.
- All regions use a versioned approved term or documented qualified exception.
- Local issues are resolved within authority and enterprise conflicts have a clear escalation route.
Explanation
Correct Answer
B:It tests the action: Integrate governance decisions and stewardship workflows with technology support.
Incorrect Answers
A:The ownership matrix identifies decision rights and contractual handoffs for each critical field. This would verify a different control (A dataset is copied into three systems and each team claims another group owns quality.), not the one in the question. The required evidence is: Tool records link approved decisions to datasets, issues and accountable people.
C:All regions use a versioned approved term or documented qualified exception. This would verify a different control (Different regions change the meaning of a sales metric without notifying downstream consumers.), not the one in the question. The required evidence is: Tool records link approved decisions to datasets, issues and accountable people.
D:Local issues are resolved within authority and enterprise conflicts have a clear escalation route. This would verify a different control (A federated enterprise wants local stewards but must preserve consistent enterprise rules.), not the one in the question. The required evidence is: Tool records link approved decisions to datasets, issues and accountable people.
Question 676
The data management team encounters this situation: A records team says old files were deleted but cannot show what was destroyed or who authorized it. Which intervention BEST addresses the actual problem?
- Suspend disposition for in-scope content until an authorized hold release is recorded.
- Define a managed content taxonomy and classify documents using validated metadata.
- Validate extraction confidence and route uncertain fields to authorized human review.
- Implement disposition approval, hold checking and tamper-resistant destruction logs.
Explanation
Correct Answer
D:Implement disposition approval, hold checking and tamper-resistant destruction logs. Defensible disposal requires provable compliance with retention and preservation rules. Evidence to obtain: Evidence lists eligible records, authorization, method, time and any exception.
Incorrect Answers
A:Suspend disposition for in-scope content until an authorized hold release is recorded. This response fits a separate situation (An automated seven-year purge is about to remove correspondence covered by an active litigation hold.), but does not resolve the stated case. The targeted response is: Implement disposition approval, hold checking and tamper-resistant destruction logs.
B:Define a managed content taxonomy and classify documents using validated metadata. This response fits a separate situation (A repository mixes invoices, procedures and complaints under inconsistent free-text tags.), but does not resolve the stated case. The targeted response is: Implement disposition approval, hold checking and tamper-resistant destruction logs.
C:Validate extraction confidence and route uncertain fields to authorized human review. This response fits a separate situation (A team runs OCR on handwritten forms and loads extracted values directly into an account ledger.), but does not resolve the stated case. The targeted response is: Implement disposition approval, hold checking and tamper-resistant destruction logs.
Question 677
The data program reviews the following failure: An organization wants live access to distributed records without copying every source table. Which change should be prioritized?
- Evaluate governed federation or virtualization with source access, query pushdown and performance limits.
- Apply data minimization, encryption, scoped access and deletion controls across the transfer path.
- Establish a versioned API contract and compatibility tests before deploying breaking changes.
- Govern landing, transformation logic, lineage and compute costs in a controlled ELT workflow.
Explanation
Correct Answer
A:Evaluate governed federation or virtualization with source access, query pushdown and performance limits. Virtualization reduces duplication but retains source dependence and governance costs. Evidence to obtain: Queries return authorized current results within documented latency and availability bounds.
Incorrect Answers
B:Apply data minimization, encryption, scoped access and deletion controls across the transfer path. This response fits a separate situation (A file-transfer integration includes confidential customer attributes in an unsecured staging bucket.), but does not resolve the stated case. The targeted response is: Evaluate governed federation or virtualization with source access, query pushdown and performance limits.
C:Establish a versioned API contract and compatibility tests before deploying breaking changes. This response fits a separate situation (An upstream API changes a numeric customer status code into a text value and breaks consumers.), but does not resolve the stated case. The targeted response is: Evaluate governed federation or virtualization with source access, query pushdown and performance limits.
D:Govern landing, transformation logic, lineage and compute costs in a controlled ELT workflow. This response fits a separate situation (An analytics platform loads source extracts into a warehouse then performs transformations there.), but does not resolve the stated case. The targeted response is: Evaluate governed federation or virtualization with source access, query pushdown and performance limits.
Question 678
After addressing this problem, what evidence would justify closure? Users search for a customer dataset but see dozens of unlabeled backups ahead of certified sources.
- Representative searches surface approved datasets and disclose archival alternatives.
- Risk report runs identify applicable mapping versions and affected records.
- Reports cite approved term versions and consumers can identify differences.
- Ingestion validation matches recorded technical structures and flags incompatible changes.
Explanation
Correct Answer
A:It tests the action: Improve catalog classification, search relevance and certified-asset indicators.
Incorrect Answers
B: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: Representative searches surface approved datasets and disclose archival alternatives.
C:Reports cite approved term versions and consumers can identify differences. This would verify a different control (A term called revenue means gross receipts in one team and net receipts in another.), not the one in the question. The required evidence is: Representative searches surface approved datasets and disclose archival alternatives.
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: Representative searches surface approved datasets and disclose archival alternatives.
Question 679
Which statement best describes the governing idea behind the response to this case: A daily tax report and a live fraud decision service share one nightly transfer mechanism.
- Data interoperability requires shared semantics even when field names differ.
- Interfaces require semantic and schema compatibility, not merely network availability.
- Batch, messaging and service APIs meet different business service levels.
- CDC depends on correct change ordering and consumption state across failures.
Explanation
Correct Answer
C:Batch, messaging and service APIs meet different business service levels. This concept explains the reason for the proposed control. Appropriate intervention: Choose integration methods based on latency, consistency, volume and operational risk.
Incorrect Answers
A:This is a defensible principle in another context (One interface calls a field supplier_id while another calls it vendor_code with different identifier rules.), not the most relevant rationale here. For the stated issue: Batch, messaging and service APIs meet different business service levels.
B:This is a defensible principle in another context (An upstream API changes a numeric customer status code into a text value and breaks consumers.), not the most relevant rationale here. For the stated issue: Batch, messaging and service APIs meet different business service levels.
D:CDC depends on correct change ordering and consumption state across failures. This is a defensible principle in another context (A customer platform needs low-latency updates without repeatedly scanning entire operational tables.), not the most relevant rationale here. For the stated issue: Batch, messaging and service APIs meet different business service levels.
Question 680
A proposed shortcut is offered for this situation: A customer changes region but analysts need sales under the region valid at each transaction date. Which choice is the CLEAREST mistake?
- Overwrite past region values and silently restate historical metrics.
- Monitor control outcomes after deployment rather than relying only on design intent.
- Keep approved reference mappings versioned and traceable.
- Verify a new interface using a controlled sample and reconciliation.
Explanation
Correct Answer
A:Overwrite past region values and silently restate historical metrics. Temporal modeling preserves time-dependent truth needed for historical analysis. A sound response instead: Model history with effective-dated dimension versions when historical attribution matters.
Incorrect Answers
B:Monitor control outcomes after deployment rather than relying only on design intent. Operations need evidence that a planned control actually works. The case-specific response is: Model history with effective-dated dimension versions when historical attribution matters.
C:Keep approved reference mappings versioned and traceable. Value meaning can change across time and applications. The case-specific response is: Model history with effective-dated dimension versions when historical attribution matters.
D:Verify a new interface using a controlled sample and reconciliation. Testing reveals mismatches before broad deployment. The case-specific response is: Model history with effective-dated dimension versions when historical attribution matters.