CDMP DMF Practice Test 33
Question 320
The data management team encounters this situation: A new governance office attempts simultaneous enterprise rollout with no prioritization or adoption plan. Which intervention BEST addresses the actual problem?
- Convene an authorized cross-functional council to make and escalate policy decisions.
- Integrate governance decisions and stewardship workflows with technology support.
- Separate accountable owner decisions from stewardship coordination and operational execution.
- Stage the roadmap around high-risk data domains, sponsors, capabilities and measurable wins.
Explanation
Correct Answer
D:Stage the roadmap around high-risk data domains, sponsors, capabilities and measurable wins. A governance program needs achievable adoption and sustainable operating capacity. Evidence to obtain: Milestones show ownership uptake and validated quality/control improvements.
Incorrect Answers
A:Convene an authorized cross-functional council to make and escalate policy decisions. This response fits a separate situation (Customer and finance functions cannot agree on shared priority data rules.), but does not resolve the stated case. The targeted response is: Stage the roadmap around high-risk data domains, sponsors, capabilities and measurable wins.
B:This response fits a separate situation (A catalog tool identifies data owners but cannot force them to decide disputed definitions.), but does not resolve the stated case.
C: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. Separate accountable owner decisions from stewardship coordination and operational execution.
Question 321
A governance review considers the following: A fraud-alert service must evaluate new events within seconds while a monthly financial summary tolerates delay. Which proposal would create an avoidable risk?
- Check that the proposed procedure has an identified operator and approval path.
- Apply a monthly batch cycle to urgent fraud alerts because it is cheaper.
- Keep approved reference mappings versioned and traceable.
- Verify a new interface using a controlled sample and reconciliation.
Explanation
Correct Answer
B:A sound response instead: Use a governed low-latency event stream for alerts and a scheduled batch path for the summary.
Incorrect Answers
A:Check that the proposed procedure has an identified operator and approval path. Operational responsibility prevents undocumented workarounds. The case-specific response is: Use a governed low-latency event stream for alerts and a scheduled batch path for the summary.
C:Keep approved reference mappings versioned and traceable. Value meaning can change across time and applications. The case-specific response is: Use a governed low-latency event stream for alerts and a scheduled batch path for the summary.
D:Verify a new interface using a controlled sample and reconciliation. Testing reveals mismatches before broad deployment. The case-specific response is: Use a governed low-latency event stream for alerts and a scheduled batch path for the summary.
Question 322
A business owner identifies this issue: A daily tax report and a live fraud decision service share one nightly transfer mechanism. What is the MOST appropriate data management response?
- Add completeness reconciliation, lateness handling and replay controls to the ETL pipeline.
- Apply data minimization, encryption, scoped access and deletion controls across the transfer path.
- Govern landing, transformation logic, lineage and compute costs in a controlled ELT workflow.
- Choose integration methods based on latency, consistency, volume and operational risk.
Explanation
Correct Answer
D:Choose integration methods based on latency, consistency, volume and operational risk. Batch, messaging and service APIs meet different business service levels. Evidence to obtain: The fraud service receives timely events while tax reporting reconciles its complete batch.
Incorrect Answers
A:Add completeness reconciliation, lateness handling and replay controls to the ETL pipeline.
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: Choose integration methods based on latency, consistency, volume and operational risk.
C: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. Govern landing, transformation logic, lineage and compute costs in a controlled ELT workflow.
Question 323
Consider this organizational data problem: Executives need consistent historical revenue despite frequent transactional schema changes. What action is most defensible?
- Provide certified datasets, semantic layer guidance and role-based BI access.
- Create a fact table with appropriate dimension foreign keys for a star schema.
- Build governed analytical integration and conformed business measures for reporting.
- Use a Type 1 overwrite for the corrected descriptive attribute under change control.
Explanation
Correct Answer
C:Build governed analytical integration and conformed business measures for reporting. A warehouse supports integrated historical analysis distinct from operational transactions. Evidence to obtain: Historical reports reconcile and are insulated from irrelevant transactional changes.
Incorrect Answers
A:Provide certified datasets, semantic layer guidance and role-based BI access. This response fits a separate situation (Citizen analysts build dashboards using tables with unknown sensitivity and ambiguous joins.), but does not resolve the stated case. The targeted response is: Build governed analytical integration and conformed business measures for reporting.
B:This response fits a separate situation (Business users need to analyze order revenue by date, product and geography.), but does not resolve the stated case. Create a fact table with appropriate dimension foreign keys for a star schema.
D:This response fits a separate situation (A product description contains a typo and historic analytics do not need the old spelling.), but does not resolve the stated case.
Question 324
For this situation, which combined intervention and validation MOST directly addresses the issue? A catalog lists every dataset but half of its owners and descriptions are outdated.
- Action: Define common timestamp semantics and metadata exchange conventions. Verification: Catalog times convert consistently with time zone and source provenance retained.
- Action: Define and approve a glossary term with qualified variants and linked calculations. Verification: Reports cite approved term versions and consumers can identify differences.
- Action: Establish end-to-end field-level lineage covering sources, transforms and reports. Verification: An analyst traces a suspect field back to its origin and responsible transformation.
- Action: Measure metadata completeness, freshness and accuracy for high-value entries. Verification: Quality metrics identify stale records and verified repairs improve trust.
Explanation
Correct Answer
D:Action: Measure metadata completeness, freshness and accuracy for high-value entries. Verification: Quality metrics identify stale records and verified repairs improve trust. Both the intervention and measurable outcome are directly relevant. Metadata quality is a governable data-quality problem with measurable dimensions.
Incorrect Answers
A:This plan addresses a different situation (Three systems record table creation dates in incompatible time zones and formats.), not the targeted problem. Here, action and evidence must match: Action: Measure metadata completeness, freshness and accuracy for high-value entries.
B:This plan addresses a different situation (A term called revenue means gross receipts in one team and net receipts in another.), not the targeted problem. Here, action and evidence must match: Action: Measure metadata completeness, freshness and accuracy for high-value entries.
C:This plan addresses a different situation (A compliance report is wrong but no one knows which source change introduced the value.), not the targeted problem. Here, action and evidence must match: Action: Measure metadata completeness, freshness and accuracy for high-value entries.
Question 325
Consider this organizational data problem: A dashboard shows revenue increasing sharply because source currency values are mixed without conversion. What action is most defensible?
- Apply consistent currency conversion rules with effective rates and labeled units.
- Use Type 2 dimension rows with effective dates, surrogate keys and validity checks.
- Create a fact table with appropriate dimension foreign keys for a star schema.
- Implement incremental extraction with reliable change checkpoints and periodic full reconciliation.
Explanation
Correct Answer
A:Apply consistent currency conversion rules with effective rates and labeled units. Analytical measures must use consistent units and time context. Evidence to obtain: Comparisons reconcile to source currency and approved FX conversion methods.
Incorrect Answers
B:Use Type 2 dimension rows with effective dates, surrogate keys and validity checks. This response fits a separate situation (A salesperson moves territories and historical sales must remain attributed to prior territory.), but does not resolve the stated case. The targeted response is: Apply consistent currency conversion rules with effective rates and labeled units.
C:Create a fact table with appropriate dimension foreign keys for a star schema.
D:Implement incremental extraction with reliable change checkpoints and periodic full reconciliation. This response fits a separate situation (A nightly warehouse load rereads the entire history and repeatedly misses its completion window.), but does not resolve the stated case. The targeted response is: Apply consistent currency conversion rules with effective rates and labeled units.
Question 326
A governance review considers the following: A nightly warehouse load rereads the entire history and repeatedly misses its completion window. Which proposal would create an avoidable risk?
- Monitor control outcomes after deployment rather than relying only on design intent.
- Check relevant business definitions before joining independently sourced data.
- Advance the watermark even when the target write fails.
- Inspect lineage and source context before changing a derived report.
Explanation
Correct Answer
C:Advance the watermark even when the target write fails. Incremental loads reduce cost but depend on correct change tracking and recovery. A sound response instead: Implement incremental extraction with reliable change checkpoints and periodic full reconciliation.
Incorrect Answers
A: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: Implement incremental extraction with reliable change checkpoints and periodic full reconciliation.
B:Check relevant business definitions before joining independently sourced data. Semantic agreements prevent incorrect cross-system correlations. The case-specific response is: Implement incremental extraction with reliable change checkpoints and periodic full reconciliation.
D:Inspect lineage and source context before changing a derived report. Provenance analysis distinguishes source errors from transformations. The case-specific response is: Implement incremental extraction with reliable change checkpoints and periodic full reconciliation.
Question 327
A governance review considers the following: A vendor invoice from last month arrives after the monthly warehouse close. Which proposal would create an avoidable risk?
- Assign every late invoice to the current month without business review.
- Check relevant business definitions before joining independently sourced data.
- Apply access controls proportional to the sensitivity of business information.
- Respect active legal holds before scheduling record disposition.
Explanation
Correct Answer
A:Assign every late invoice to the current month without business review. Warehouse pipelines must distinguish event/business time from loading time. A sound response instead: Apply late-arrival processing with date-correct attribution and controlled restatement if needed.
Incorrect Answers
B:Check relevant business definitions before joining independently sourced data. Semantic agreements prevent incorrect cross-system correlations. The case-specific response is: Apply late-arrival processing with date-correct attribution and controlled restatement if needed.
C:Apply access controls proportional to the sensitivity of business information. Confidentiality obligations still apply during quality improvements. The case-specific response is: Apply late-arrival processing with date-correct attribution and controlled restatement if needed.
D:Respect active legal holds before scheduling record disposition. Preservation duties may override scheduled destruction. The case-specific response is: Apply late-arrival processing with date-correct attribution and controlled restatement if needed.
Question 328
An accountable team must correct this problem and prove results. Select TWO sound statements: A compliance report is wrong but no one knows which source change introduced the value.
- Action: Assign accountable metadata stewards and automated review reminders for priority assets.
- Verification: An analyst traces a suspect field back to its origin and responsible transformation.
- Shortcut: Record only the final report filename and call it complete lineage.
- Action: Establish end-to-end field-level lineage covering sources, transforms and reports.
- Verification: Ingestion validation matches recorded technical structures and flags incompatible changes.
Explanation
Correct Answers
B:Verification: An analyst traces a suspect field back to its origin and responsible transformation. The observed result demonstrates whether the correction operates as intended. Lineage explains data origin and movement through transformation dependencies.
D:Action: Establish end-to-end field-level lineage covering sources, transforms and reports. The proposed intervention targets the reported issue. Lineage explains data origin and movement through transformation dependencies.
Incorrect Answers
A:Action: Assign accountable metadata stewards and automated review reminders for priority assets. This intervention is for a different scenario (Catalog entries become stale because their data owners were never assigned responsibility.), not the one stated. Appropriate action here: Establish end-to-end field-level lineage covering sources, transforms and reports.
C:Shortcut: Record only the final report filename and call it complete lineage. This shortcut is not a sound remediation. Lineage explains data origin and movement through transformation dependencies. The appropriate action is: Establish end-to-end field-level lineage covering sources, transforms and reports.
E:This evidence is for a separate context (A data engineering team cannot determine the format and schema of a nightly inbound file.), not this case.
Question 329
A data steward challenges an assumption in this case: A term called revenue means gross receipts in one team and net receipts in another. Which verification should be performed first?
- Test semantic queries, metric totals and join validity against sample facts.
- Audit current systems against catalog lifecycle labels and successor links.
- Trace a report row to mapping versions, key lookups and source codes.
- Inspect glossary approval, term hierarchy and linked metric definitions.
Explanation
Correct Answer
D:Inspect glossary approval, term hierarchy and linked metric definitions. This test checks the relevant business and technical failure rather than assuming its cause. A business glossary aligns organizational terminology and semantic context. Expected control result: Reports cite approved term versions and consumers can identify differences.
Incorrect Answers
A: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: Inspect glossary approval, term hierarchy and linked metric definitions.
B: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: Inspect glossary approval, term hierarchy and linked metric definitions.
C:This check would investigate another issue (A risk report uses an old industry code mapping but its catalog does not record which version.), not the immediate case. The direct diagnostic is: Inspect glossary approval, term hierarchy and linked metric definitions.
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.