CDMP DMF Practice Test 62
Question 610
In reviewing this data risk, select the LEAST defensible practice: A multinational has legal requirements to keep certain data local while enabling group analytics.
- Respect active legal holds before scheduling record disposition.
- Escalate material unresolved issues to an accountable business decision owner.
- Replicate all raw personal data centrally without examining location restrictions.
- Retain a rollback or recovery plan before making destructive data changes.
Explanation
Correct Answer
C:Replicate all raw personal data centrally without examining location restrictions. Architecture must balance enterprise interoperability with local legal and operational constraints. A sound response instead: Use a federated architecture with governed metadata and lawful cross-border access patterns.
Incorrect Answers
A:Respect active legal holds before scheduling record disposition. Preservation duties may override scheduled destruction. The case-specific response is: Use a federated architecture with governed metadata and lawful cross-border access patterns.
B:Escalate material unresolved issues to an accountable business decision owner. Accountability prevents silent acceptance of consequential risk. The case-specific response is: Use a federated architecture with governed metadata and lawful cross-border access patterns.
D:Retain a rollback or recovery plan before making destructive data changes. Recoverability reduces the consequences of incorrect remediation. The case-specific response is: Use a federated architecture with governed metadata and lawful cross-border access patterns.
Question 611
A reviewer asks for proof of improvement: A postal address field is 100 percent complete but several entries are no longer current. Which result MOST convincingly demonstrates that the control works?
- The scorecard shows distinct dimension measures and decision-relevant targets.
- Every accepted line references a valid invoice or has an owned exception.
- Regulatory users can reproduce lineage and assess permitted use of each observation.
- Equivalent datasets are evaluated against the same approved country-code version.
Explanation
Correct Answer
A:It tests the action: Assess completeness and timeliness separately, then choose remediation based on use.
Incorrect Answers
B:Every accepted line references a valid invoice or has an owned exception. This would verify a different control (An invoice line appears without an invoice header after a partial load.), not the one in the question. The required evidence is: The scorecard shows distinct dimension measures and decision-relevant targets.
C:Regulatory users can reproduce lineage and assess permitted use of each observation. This would verify a different control (A scientific dataset has fine precision but lacks metadata required for the regulator's audit.), not the one in the question. The required evidence is: The scorecard shows distinct dimension measures and decision-relevant targets.
D:Equivalent datasets are evaluated against the same approved country-code version. This would verify a different control (Different pipelines enforce different allowable values for the same governed country field.), not the one in the question. The required evidence is: The scorecard shows distinct dimension measures and decision-relevant targets.
Question 612
For this situation, which combined intervention and validation MOST directly addresses the issue? Customer identifiers differ across sales, billing and support, preventing consistent reporting.
- Action: Use a federated architecture with governed metadata and lawful cross-border access patterns. Verification: Queries respect localization constraints and approved shared views expose necessary aggregates.
- Action: Create an end-to-end logical data flow mapping origin, processing, stores and consumers. Verification: Auditors can trace the metric through transformations and responsible systems.
- Action: Publish target enterprise data architecture with shared identity principles and integration boundaries. Verification: Architecture decisions document common identifiers and approved exchange patterns across systems.
- Action: Model the current and target data states and a sequenced transition roadmap. Verification: Architecture artifacts identify dependencies, gap owners and a credible migration path.
Explanation
Correct Answer
C:Action: Publish target enterprise data architecture with shared identity principles and integration boundaries. Verification: Architecture decisions document common identifiers and approved exchange patterns across systems. Both the intervention and measurable outcome are directly relevant. Data architecture provides enterprise-wide direction for how data is structured and flows.
Incorrect Answers
A:This plan addresses a different situation (A multinational has legal requirements to keep certain data local while enabling group analytics.), not the targeted problem. Here, action and evidence must match: Action: Publish target enterprise data architecture with shared identity principles and integration boundaries.
B:This plan addresses a different situation (A regulatory metric cannot be reconciled to the systems that initially captured its values.), not the targeted problem.
D:This plan addresses a different situation (A bank intends to retire a reporting platform but has no inventory of upstream sources or dependencies.), not the targeted problem.
Question 613
A data management auditor evaluates this situation: Three regions encode country using names, ISO codes and private numeric lists. Which observable finding supports successful remediation?
- Country values map consistently and invalid codes fail controlled validation.
- Applications resolve one trusted customer identity while retaining source identifiers.
- A lookup resolves cross-system references while authoritative attributes remain in sources.
- Verified false merges decrease without unacceptable missed true matches.
Explanation
Correct Answer
A:It tests the action: Govern a shared country reference set with mappings, definitions and permitted changes.
Incorrect Answers
B:Applications resolve one trusted customer identity while retaining source identifiers. This would verify a different control (Retail and service systems each assign different IDs to the same real-world customer.), not the one in the question. The required evidence is: Country values map consistently and invalid codes fail controlled validation.
C:A lookup resolves cross-system references while authoritative attributes remain in sources. This would verify a different control (Several applications retain their own customer stores but need a shared identity index.), not the one in the question. The required evidence is: Country values map consistently and invalid codes fail controlled validation.
D:Verified false merges decrease without unacceptable missed true matches. This would verify a different control (A matching algorithm merges a parent and child solely because they share surname and address.), not the one in the question. The required evidence is: Country values map consistently and invalid codes fail controlled validation.
Question 614
Consider this data-management scenario: An organization wants live access to distributed records without copying every source table. Which underlying principle MOST directly explains the preferred response?
- Virtualization reduces duplication but retains source dependence and governance costs.
- Data integration reliability requires observable completeness and repeatable recovery.
- ELT moves transformation into the target platform but does not remove data quality obligations.
- Data interoperability requires shared semantics even when field names differ.
Explanation
Correct Answer
A:Virtualization reduces duplication but retains source dependence and governance costs. This concept explains the reason for the proposed control. Appropriate intervention: Evaluate governed federation or virtualization with source access, query pushdown and performance limits.
Incorrect Answers
B:Data integration reliability requires observable completeness and repeatable recovery. This is a defensible principle in another context (Finance reports omit transactions because an extraction job silently skips late-arriving records.), not the most relevant rationale here. For the stated issue: Virtualization reduces duplication but retains source dependence and governance costs.
C:This is a defensible principle in another context (An analytics platform loads source extracts into a warehouse then performs transformations there.), not the most relevant rationale here. For the stated issue: Virtualization reduces duplication but retains source dependence and governance costs.
D: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: Virtualization reduces duplication but retains source dependence and governance costs.
Question 615
Before changing procedures, the team investigates: An analytics platform loads source extracts into a warehouse then performs transformations there. Which review or test MOST directly locates the relevant failure?
- Compare source watermarks, late-arrival counts and target reconciliation results.
- Inject retries and inspect deduplication keys and final ledger balances.
- Inspect raw landing zones, transformation versions and reconciliation checks.
- Inspect transfer encryption, bucket permissions, retention and operational logs.
Explanation
Correct Answer
C:Inspect raw landing zones, transformation versions and reconciliation checks. This test checks the relevant business and technical failure rather than assuming its cause. ELT moves transformation into the target platform but does not remove data quality obligations. Expected control result: Raw inputs and reproducible transformation outputs are traceable and validated.
Incorrect Answers
A:Compare source watermarks, late-arrival counts and target reconciliation results. This check would investigate another issue (Finance reports omit transactions because an extraction job silently skips late-arriving records.), not the immediate case. The direct diagnostic is: Inspect raw landing zones, transformation versions and reconciliation checks.
B:Inject retries and inspect deduplication keys and final ledger balances. This check would investigate another issue (An event consumer processes a payment notification twice after retry and creates duplicate ledger postings.), not the immediate case. The direct diagnostic is: Inspect raw landing zones, transformation versions and reconciliation checks.
D:Inspect transfer encryption, bucket permissions, retention and operational logs. This check would investigate another issue (A file-transfer integration includes confidential customer attributes in an unsecured staging bucket.), not the immediate case. The direct diagnostic is: Inspect raw landing zones, transformation versions and reconciliation checks.
Question 616
The data program reviews the following failure: A new organizational hierarchy update accidentally makes Division A the parent of itself through B. Which change should be prioritized?
- Assign a data owner and stewardship process for supplier master definitions and changes.
- Validate hierarchy acyclicity, permitted parents and effective dates before publishing.
- Design coexistence MDM with controlled bidirectional synchronization and conflict handling.
- Govern effective-dated entity relationships and hierarchy ownership.
Explanation
Correct Answer
B:Validate hierarchy acyclicity, permitted parents and effective dates before publishing. Master relationship governance must enforce structural integrity constraints. Evidence to obtain: Prohibited cycles are rejected and rollup traversal terminates with correct totals.
Incorrect Answers
A:Assign a data owner and stewardship process for supplier master definitions and changes. This response fits a separate situation (Marketing and finance disagree on who approves supplier legal entity identifiers.), but does not resolve the stated case. The targeted response is: Validate hierarchy acyclicity, permitted parents and effective dates before publishing.
C:Design coexistence MDM with controlled bidirectional synchronization and conflict handling. This response fits a separate situation (Business units need local writes but also expect synchronized approved enterprise attributes.), but does not resolve the stated case. The targeted response is: Validate hierarchy acyclicity, permitted parents and effective dates before publishing.
D:Govern effective-dated entity relationships and hierarchy ownership. This response fits a separate situation (Sales cannot roll up revenue because the customer parent-child corporate hierarchy differs across reports.), but does not resolve the stated case. The targeted response is: Validate hierarchy acyclicity, permitted parents and effective dates before publishing.
Question 617
After addressing this problem, what evidence would justify closure? A salesperson moves territories and historical sales must remain attributed to prior territory.
- Sales on each date join the applicable territory history without overlap.
- Department reports reconcile common customer and product metrics.
- Comparisons reconcile to source currency and approved FX conversion methods.
- Slice-and-dice queries reconcile across dimensions and preserve base transaction state.
Explanation
Correct Answer
A:It tests the action: Use Type 2 dimension rows with effective dates, surrogate keys and validity checks.
Incorrect Answers
B:Department reports reconcile common customer and product metrics. This would verify a different control (Business units create separate departmental marts from inconsistent extracts of customer master data.), not the one in the question. The required evidence is: Sales on each date join the applicable territory history without overlap.
C:Comparisons reconcile to source currency and approved FX conversion methods. This would verify a different control (A dashboard shows revenue increasing sharply because source currency values are mixed without conversion.), not the one in the question. The required evidence is: Sales on each date join the applicable territory history without overlap.
D:Slice-and-dice queries reconcile across dimensions and preserve base transaction state. This would verify a different control (A financial analyst needs totals by region and quarter without modifying source orders.), not the one in the question. The required evidence is: Sales on each date join the applicable territory history without overlap.
Question 618
A governance review considers the following: A database service is slow but monitoring records only whether its process is up. Which proposal would create an avoidable risk?
- Restart the database repeatedly without collecting workload evidence.
- Inspect lineage and source context before changing a derived report.
- Keep approved reference mappings versioned and traceable.
- Escalate material unresolved issues to an accountable business decision owner.
Explanation
Correct Answer
A:Restart the database repeatedly without collecting workload evidence. Database availability alone does not establish acceptable operational performance. A sound response instead: Add performance monitoring for query latency, locks, throughput and resource saturation.
Incorrect Answers
B:Inspect lineage and source context before changing a derived report. Provenance analysis distinguishes source errors from transformations. The case-specific response is: Add performance monitoring for query latency, locks, throughput and resource saturation.
C:Keep approved reference mappings versioned and traceable. Value meaning can change across time and applications. The case-specific response is: Add performance monitoring for query latency, locks, throughput and resource saturation.
D:Escalate material unresolved issues to an accountable business decision owner. Accountability prevents silent acceptance of consequential risk. The case-specific response is: Add performance monitoring for query latency, locks, throughput and resource saturation.
Question 619
A business owner identifies this issue: A retired system's catalog entries remain marked active, misleading new project teams. What is the MOST appropriate data management response?
- Classify metadata and restrict previews, samples and access to sensitive catalog fields.
- Improve catalog classification, search relevance and certified-asset indicators.
- Introduce active, deprecated and archived lifecycle states with accountable approval.
- Establish end-to-end field-level lineage covering sources, transforms and reports.
Explanation
Correct Answer
C:Introduce active, deprecated and archived lifecycle states with accountable approval. Metadata must reflect the lifecycle of the assets it describes. Evidence to obtain: Consumers see retirement dates, replacements and appropriate access warnings.
Incorrect Answers
A:Classify metadata and restrict previews, samples and access to sensitive catalog fields. This response fits a separate situation (A public catalog description reveals restricted patient identities in sample values.), but does not resolve the stated case. The targeted response is: Introduce active, deprecated and archived lifecycle states with accountable approval.
B:Improve catalog classification, search relevance and certified-asset indicators. This response fits a separate situation (Users search for a customer dataset but see dozens of unlabeled backups ahead of certified sources.), but does not resolve the stated case. The targeted response is: Introduce active, deprecated and archived lifecycle states with accountable approval.
D:Establish end-to-end field-level lineage covering sources, transforms and reports. This response fits a separate situation (A compliance report is wrong but no one knows which source change introduced the value.), but does not resolve the stated case. The targeted response is: Introduce active, deprecated and archived lifecycle states with accountable approval.
Question 620
Which statement best describes the governing idea behind the response to this case: A registration field is blank, but downstream calculations treat unknown age as zero.
- Physical modeling implements logical structures under actual platform constraints.
- Subtype modeling represents common identity while preserving different business attributes.
- Null can denote absent or unknown information and is not automatically a numeric zero.
- First normal form discourages repeating groups and multi-valued atomic fields.
Explanation
Correct Answer
C:Null can denote absent or unknown information and is not automatically a numeric zero. This concept explains the reason for the proposed control. Appropriate intervention: Represent missingness according to explicit semantic rules and validate downstream behavior.
Incorrect Answers
A:This is a defensible principle in another context (A logical model is approved but a PostgreSQL implementation needs columns and access paths.), not the most relevant rationale here.
B:This is a defensible principle in another context (A party table mixes person birthdate with organization registration number, leaving ambiguous rules.), not the most relevant rationale here.
D: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.