CDMP DMF Practice Test 34
Question 330
A business owner identifies this issue: A contact table stores three comma-separated telephone numbers in one column. What is the MOST appropriate data management response?
- Define entities, attributes, relationships, optionality and business keys in a logical model.
- Define correct one-to-many customer-to-order cardinality and mandatory participation.
- Model phone numbers as atomic repeating child records with appropriate identifiers.
- Consider controlled denormalization with refresh ownership and reconciliation.
Explanation
Correct Answer
C:Model phone numbers as atomic repeating child records with appropriate identifiers. First normal form discourages repeating groups and multi-valued atomic fields. Evidence to obtain: Each number is independently searchable and maintained without string parsing.
Incorrect Answers
A:Define entities, attributes, relationships, optionality and business keys in a logical model. This response fits a separate situation (An enterprise needs rules for customer-to-contract cardinality without choosing a database product.), but does not resolve the stated case. The targeted response is: Model phone numbers as atomic repeating child records with appropriate identifiers.
B:Define correct one-to-many customer-to-order cardinality and mandatory participation. This response fits a separate situation (A model incorrectly allows each order to have many unrelated customer owners.), but does not resolve the stated case. The targeted response is: Model phone numbers as atomic repeating child records with appropriate identifiers.
D:Consider controlled denormalization with refresh ownership and reconciliation. This response fits a separate situation (A read-heavy dashboard suffers repeated expensive joins but operational source integrity is sound.), but does not resolve the stated case. The targeted response is: Model phone numbers as atomic repeating child records with appropriate identifiers.
Question 331
Consider this data-management scenario: Business users need to analyze order revenue by date, product and geography. Which underlying principle MOST directly explains the preferred response?
- Star schemas place numeric events in facts and descriptive context in dimensions.
- Data marts should not undermine enterprise definitions or trusted master sources.
- Warehouse pipelines must distinguish event/business time from loading time.
- Trusted BI requires reproducible metrics and transparent revision histories.
Explanation
Correct Answer
A:Star schemas place numeric events in facts and descriptive context in dimensions. This concept explains the reason for the proposed control. Appropriate intervention: Create a fact table with appropriate dimension foreign keys for a star schema.
Incorrect Answers
B:This is a defensible principle in another context (Business units create separate departmental marts from inconsistent extracts of customer master data.), not the most relevant rationale here.
C:Warehouse pipelines must distinguish event/business time from loading time. This is a defensible principle in another context (A vendor invoice from last month arrives after the monthly warehouse close.), not the most relevant rationale here. For the stated issue: Star schemas place numeric events in facts and descriptive context in dimensions.
D:This is a defensible principle in another context (A published regulatory dashboard cannot explain why last month's total changed after a source correction.), not the most relevant rationale here. For the stated issue: Star schemas place numeric events in facts and descriptive context in dimensions.
Question 332
A governance review considers the following: A daily tax report and a live fraud decision service share one nightly transfer mechanism. Which proposal would create an avoidable risk?
- Respect active legal holds before scheduling record disposition.
- Force every process through the same nightly file because it already exists.
- Protect relevant audit records while investigating data problems.
- Validate critical changes against representative positive and negative examples.
Explanation
Correct Answer
B:Force every process through the same nightly file because it already exists. Batch, messaging and service APIs meet different business service levels. A sound response instead: Choose integration methods based on latency, consistency, volume and operational risk.
Incorrect Answers
A:Respect active legal holds before scheduling record disposition. Preservation duties may override scheduled destruction. The case-specific response is: Choose integration methods based on latency, consistency, volume and operational risk.
C:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Choose integration methods based on latency, consistency, volume and operational risk.
D:Validate critical changes against representative positive and negative examples. Controlled tests provide more reliable proof than untested assumptions. The case-specific response is: Choose integration methods based on latency, consistency, volume and operational risk.
Question 333
The data program reviews the following failure: A compliance report is wrong but no one knows which source change introduced the value. Which change should be prioritized?
- Use a governed repository or catalog with stewardship workflows and controlled synchronization.
- Collect operational metadata such as run timestamps, row counts and failure states.
- Establish end-to-end field-level lineage covering sources, transforms and reports.
- Classify metadata and restrict previews, samples and access to sensitive catalog fields.
Explanation
Correct Answer
C:Establish end-to-end field-level lineage covering sources, transforms and reports. Lineage explains data origin and movement through transformation dependencies. Evidence to obtain: An analyst traces a suspect field back to its origin and responsible transformation.
Incorrect Answers
A:Use a governed repository or catalog with stewardship workflows and controlled synchronization. This response fits a separate situation (Metadata lives in individual spreadsheets that differ on owners and field meanings.), but does not resolve the stated case. The targeted response is: Establish end-to-end field-level lineage covering sources, transforms and reports.
B:Collect operational metadata such as run timestamps, row counts and failure states.
D: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: Establish end-to-end field-level lineage covering sources, transforms and reports.
Question 334
The data program reviews the following failure: Several applications retain their own customer stores but need a shared identity index. Which change should be prioritized?
- Adopt a registry-style MDM where appropriate, linking identifiers without assuming data centralization.
- Create a governed master-customer identity strategy with matching and cross-reference rules.
- Distribute reference versions through a governed publish/subscribe or release process.
- Model party identity separately from business roles and maintain role-specific attributes.
Explanation
Correct Answer
A:Adopt a registry-style MDM where appropriate, linking identifiers without assuming data centralization. Registry MDM can manage identity linkage without necessarily storing all mastered attributes. Evidence to obtain: A lookup resolves cross-system references while authoritative attributes remain in sources.
Incorrect Answers
B:This response fits a separate situation (Retail and service systems each assign different IDs to the same real-world customer.), but does not resolve the stated case.
C:This response fits a separate situation (A mobile app uses a currency-code list six months older than the payments platform.), but does not resolve the stated case. Distribute reference versions through a governed publish/subscribe or release process.
D:Model party identity separately from business roles and maintain role-specific attributes. This response fits a separate situation (One organization can be both a supplier and customer, but systems duplicate its legal entity per role.), but does not resolve the stated case. The targeted response is: Adopt a registry-style MDM where appropriate, linking identifiers without assuming data centralization.
Question 335
A data analyst must confirm the cause of this issue: A source database gains fields but the catalog schema remains unchanged for months. Which check provides the strongest diagnostic evidence?
- Compare live database schema with harvested metadata and review tasks.
- Test semantic queries, metric totals and join validity against sample facts.
- Compare catalog schemas with actual source files and pipeline expectations.
- Audit current systems against catalog lifecycle labels and successor links.
Explanation
Correct Answer
A:Compare live database schema with harvested metadata and review tasks. This test checks the relevant business and technical failure rather than assuming its cause. Automated harvesting can reduce catalog staleness but still needs semantic stewardship. Expected control result: New schema fields appear promptly with change events and review status.
Incorrect Answers
B:Test semantic queries, metric totals and join validity against sample facts. This check would investigate another issue (Reports join unrelated entities because business dimensions lack a mapped semantic model.), not the immediate case. The direct diagnostic is: Compare live database schema with harvested metadata and review tasks.
C:Compare catalog schemas with actual source files and pipeline expectations. This check would investigate another issue (A data engineering team cannot determine the format and schema of a nightly inbound file.), not the immediate case. The direct diagnostic is: Compare live database schema with harvested metadata and review tasks.
D:Audit current systems against catalog lifecycle labels and successor links. This check would investigate another issue (A retired system's catalog entries remain marked active, misleading new project teams.), not the immediate case. The direct diagnostic is: Compare live database schema with harvested metadata and review tasks.
Question 336
The data program reviews the following failure: Two departments use the term account for unrelated concepts and merge records incorrectly. Which change should be prioritized?
- Define canonical field semantics and versioned interface contracts with consumers.
- Use a federated architecture with governed metadata and lawful cross-border access patterns.
- Agree enterprise-level business concepts and relationships before mapping physical application schemas.
- Publish target enterprise data architecture with shared identity principles and integration boundaries.
Explanation
Correct Answer
C:Agree enterprise-level business concepts and relationships before mapping physical application schemas. Logical enterprise architecture clarifies shared meaning independently of vendor databases. Evidence to obtain: An approved logical model distinguishes party, agreement and financial account semantics.
Incorrect Answers
A:Define canonical field semantics and versioned interface contracts with consumers. This response fits a separate situation (A team proposes proprietary event fields that cannot be interpreted by other platforms.), but does not resolve the stated case. The targeted response is: Agree enterprise-level business concepts and relationships before mapping physical application schemas.
B:Use a federated architecture with governed metadata and lawful cross-border access patterns. This response fits a separate situation (A multinational has legal requirements to keep certain data local while enabling group analytics.), but does not resolve the stated case. The targeted response is: Agree enterprise-level business concepts and relationships before mapping physical application schemas.
D: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: Agree enterprise-level business concepts and relationships before mapping physical application schemas.
Question 337
For this situation, which combined intervention and validation MOST directly addresses the issue? A dashboard shows revenue increasing sharply because source currency values are mixed without conversion.
- Action: Create a fact table with appropriate dimension foreign keys for a star schema. Verification: Reports slice measures consistently by conformed dimension attributes.
- Action: Preserve run versions, source snapshots and transformation lineage with approved restatement rules. Verification: Auditors reproduce the original total and explain the changed figure from documented inputs.
- Action: Apply consistent currency conversion rules with effective rates and labeled units. Verification: Comparisons reconcile to source currency and approved FX conversion methods.
- Action: Use analytical aggregations and dimensional hierarchies rather than transactional updates. Verification: Slice-and-dice queries reconcile across dimensions and preserve base transaction state.
Explanation
Correct Answer
C:Action: Apply consistent currency conversion rules with effective rates and labeled units. Verification: Comparisons reconcile to source currency and approved FX conversion methods. Both the intervention and measurable outcome are directly relevant. Analytical measures must use consistent units and time context.
Incorrect Answers
A:This plan addresses a different situation (Business users need to analyze order revenue by date, product and geography.), not the targeted problem.
B:This plan addresses a different situation (A published regulatory dashboard cannot explain why last month's total changed after a source correction.), not the targeted problem.
D:This plan addresses a different situation (A financial analyst needs totals by region and quarter without modifying source orders.), not the targeted problem. Here, action and evidence must match: Action: Apply consistent currency conversion rules with effective rates and labeled units.
Question 338
The data program reviews the following failure: A consultant rates governance mature from interview opinions without supporting operational evidence. Which change should be prioritized?
- Assess maturity against defined capabilities with artifacts, repeatable evidence and gaps.
- Stage the roadmap around high-risk data domains, sponsors, capabilities and measurable wins.
- Separate accountable owner decisions from stewardship coordination and operational execution.
- Define federated decision boundaries, central standards and locally accountable execution.
Explanation
Correct Answer
A:Assess maturity against defined capabilities with artifacts, repeatable evidence and gaps. Maturity is an evidence-based view of institutionalized practices, not aspirational claims. Evidence to obtain: A reproducible score references controls, owners and improvement actions.
Incorrect Answers
B:This response fits a separate situation (A new governance office attempts simultaneous enterprise rollout with no prioritization or adoption plan.), but does not resolve the stated case. Stage the roadmap around high-risk data domains, sponsors, capabilities and measurable wins.
C:Separate accountable owner decisions from stewardship coordination and operational execution. This response fits a separate situation (A product data owner expects the data steward to set commercial policy unilaterally.), but does not resolve the stated case. The targeted response is: Assess maturity against defined capabilities with artifacts, repeatable evidence and gaps.
D:Define federated decision boundaries, central standards and locally accountable execution. This response fits a separate situation (A federated enterprise wants local stewards but must preserve consistent enterprise rules.), but does not resolve the stated case. The targeted response is: Assess maturity against defined capabilities with artifacts, repeatable evidence and gaps.
Question 339
A reviewer asks for proof of improvement: Analysts cannot tell whether customer_age means current age or age at first purchase. Which result MOST convincingly demonstrates that the control works?
- Owner, definition and quality metadata stay current after system changes.
- Quality metrics identify stale records and verified repairs improve trust.
- Users understand the term and can link it to approved datasets and business rules.
- Unauthorized users see discovery descriptions but no confidential samples.
Explanation
Correct Answer
C:It tests the action: Publish business metadata with precise glossary definitions and stewardship approval.
Incorrect Answers
A: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: Users understand the term and can link it to approved datasets and business rules.
B:Quality metrics identify stale records and verified repairs improve trust. This would verify a different control (A catalog lists every dataset but half of its owners and descriptions are outdated.), not the one in the question. The required evidence is: Users understand the term and can link it to approved datasets and business rules.
D: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: Users understand the term and can link it to approved datasets and business rules.
Question 340
Before changing procedures, the team investigates: Business users need to analyze order revenue by date, product and geography. Which review or test MOST directly locates the relevant failure?
- Inspect fact grain, dimension keys and slicing query correctness.
- Inspect invoice event date, load watermark and restated monthly totals.
- Check nonoverlapping effective windows and historical fact joins.
- Recalculate sample margins from agreed source measures and compare dashboards.
Explanation
Correct Answer
A:Inspect fact grain, dimension keys and slicing query correctness. This test checks the relevant business and technical failure rather than assuming its cause. Star schemas place numeric events in facts and descriptive context in dimensions. Expected control result: Reports slice measures consistently by conformed dimension attributes.
Incorrect Answers
B:Inspect invoice event date, load watermark and restated monthly totals. This check would investigate another issue (A vendor invoice from last month arrives after the monthly warehouse close.), not the immediate case. The direct diagnostic is: Inspect fact grain, dimension keys and slicing query correctness.
C: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: Inspect fact grain, dimension keys and slicing query correctness.
D:Recalculate sample margins from agreed source measures and compare dashboards. This check would investigate another issue (Two executive dashboards both show profit margin but use different numerator adjustments.), not the immediate case. The direct diagnostic is: Inspect fact grain, dimension keys and slicing query correctness.