CDMP DMF Practice Test 58
Question 570
Before changing procedures, the team investigates: Staff collaborate on a policy but several copied files are called final and no approved version is clear. Which review or test MOST directly locates the relevant failure?
- Review content classes, retention triggers, holds and disposal authorizations.
- Examine record metadata, authenticity checks and immutable version history.
- Test inherited permissions, external links, revocation and audit events.
- Inspect version history, effective dates, approval chain and supersession links.
Explanation
Correct Answer
D:Inspect version history, effective dates, approval chain and supersession links. This test checks the relevant business and technical failure rather than assuming its cause. Content version management prevents superseded drafts from being mistaken for authoritative records. Expected control result: Users find the currently approved policy and earlier revisions remain traceable.
Incorrect Answers
A:Review content classes, retention triggers, holds and disposal authorizations. This check would investigate another issue (Contract PDFs are retained indefinitely after business use with no destruction rules.), not the immediate case. The direct diagnostic is: Inspect version history, effective dates, approval chain and supersession links.
B:Examine record metadata, authenticity checks and immutable version history. This check would investigate another issue (An archived approval email is needed as evidence in a dispute but its author and date are missing.), not the immediate case. The direct diagnostic is: Inspect version history, effective dates, approval chain and supersession links.
C:Test inherited permissions, external links, revocation and audit events. This check would investigate another issue (A public sharing link exposes sensitive human resources documents to contractors.), not the immediate case. The direct diagnostic is: Inspect version history, effective dates, approval chain and supersession links.
Question 571
Select TWO appropriate statements, one intervention and one verification, for this data management case: A product description contains a typo and historic analytics do not need the old spelling.
- Action: Apply consistent currency conversion rules with effective rates and labeled units.
- Action: Use a Type 1 overwrite for the corrected descriptive attribute under change control.
- Shortcut: Create needless historical versions for every spelling correction by default.
- Verification: Current and historical queries show the corrected description without extra history rows.
- Verification: Revenue reconciles at order, line and shipment levels without duplicated values.
Explanation
Correct Answers
B:Action: Use a Type 1 overwrite for the corrected descriptive attribute under change control. The proposed intervention targets the reported issue. Type 1 slowly changing dimensions replace values when historical changes are unnecessary.
D:Verification: Current and historical queries show the corrected description without extra history rows. The observed result demonstrates whether the correction operates as intended. Type 1 slowly changing dimensions replace values when historical changes are unnecessary.
Incorrect Answers
A:This intervention is for a different scenario (A dashboard shows revenue increasing sharply because source currency values are mixed without conversion.), not the one stated.
C:Shortcut: Create needless historical versions for every spelling correction by default. This shortcut is not a sound remediation. Type 1 slowly changing dimensions replace values when historical changes are unnecessary. The appropriate action is: Use a Type 1 overwrite for the corrected descriptive attribute under change control.
E:Verification: Revenue reconciles at order, line and shipment levels without duplicated values. This evidence is for a separate context (A sales fact table mixes shipment-level and order-line-level amounts, doubling totals.), not this case. The valid outcome is: Current and historical queries show the corrected description without extra history rows.
Question 572
The data management team encounters this situation: Marketing and finance disagree on who approves supplier legal entity identifiers. Which intervention BEST addresses the actual problem?
- Use multiple discriminating attributes and calibrated match thresholds with review for uncertain pairs.
- Validate hierarchy acyclicity, permitted parents and effective dates before publishing.
- Normalize relevant fields and check probable duplicates before creating master identities.
- Assign a data owner and stewardship process for supplier master definitions and changes.
Explanation
Correct Answer
D:Assign a data owner and stewardship process for supplier master definitions and changes. Master-data stewardship needs business authority for accepted entity definitions. Evidence to obtain: Change requests are approved by an accountable owner and validated before distribution.
Incorrect Answers
A:Use multiple discriminating attributes and calibrated match thresholds with review for uncertain pairs. This response fits a separate situation (A matching algorithm merges a parent and child solely because they share surname and address.), but does not resolve the stated case. The targeted response is: Assign a data owner and stewardship process for supplier master definitions and changes.
B:Validate hierarchy acyclicity, permitted parents and effective dates before publishing. This response fits a separate situation (A new organizational hierarchy update accidentally makes Division A the parent of itself through B.), but does not resolve the stated case. The targeted response is: Assign a data owner and stewardship process for supplier master definitions and changes.
C:This response fits a separate situation (New customer onboarding creates a second record when spacing differs in a business name.), but does not resolve the stated case.
Question 573
After addressing this problem, what evidence would justify closure? A regulatory metric cannot be reconciled to the systems that initially captured its values.
- Auditors can trace the metric through transformations and responsible systems.
- Queries respect localization constraints and approved shared views expose necessary aggregates.
- Architecture artifacts identify dependencies, gap owners and a credible migration path.
- Design reviews record compliance, rationale, owners and remediation for deviations.
Explanation
Correct Answer
A:It tests the action: Create an end-to-end logical data flow mapping origin, processing, stores and consumers.
Incorrect Answers
B:Queries respect localization constraints and approved shared views expose necessary aggregates. This would verify a different control (A multinational has legal requirements to keep certain data local while enabling group analytics.), not the one in the question. The required evidence is: Auditors can trace the metric through transformations and responsible systems.
C:Architecture artifacts identify dependencies, gap owners and a credible migration path. This would verify a different control (A bank intends to retire a reporting platform but has no inventory of upstream sources or dependencies.), not the one in the question. The required evidence is: Auditors can trace the metric through transformations and responsible systems.
D:Design reviews record compliance, rationale, owners and remediation for deviations. This would verify a different control (A transformation program has diagrams but no one decides whether new platforms meet enterprise principles.), not the one in the question. The required evidence is: Auditors can trace the metric through transformations and responsible systems.
Question 574
Before changing procedures, the team investigates: A backup contains confidential employee salaries and is stored without encryption controls. Which review or test MOST directly locates the relevant failure?
- Test role grants with allowed reporting and prohibited update queries.
- Attempt reidentification on samples and check masking transformations and access.
- Inspect storage encryption status, key access logs and a restoration test.
- Review anomalous access logs, credential exposure, response records and retention.
Explanation
Correct Answer
C:Inspect storage encryption status, key access logs and a restoration test. This test checks the relevant business and technical failure rather than assuming its cause. Encryption at rest reduces exposure of stored sensitive information but requires key governance. Expected control result: Stored backups are unreadable without authorized key access and restores succeed.
Incorrect Answers
A:Test role grants with allowed reporting and prohibited update queries. This check would investigate another issue (A BI analyst receives administrator access to production customer tables for simple reporting.), not the immediate case. The direct diagnostic is: Inspect storage encryption status, key access logs and a restoration test.
B:Attempt reidentification on samples and check masking transformations and access. This check would investigate another issue (Test developers need representative orders but a test export includes real customer identity numbers.), not the immediate case. The direct diagnostic is: Inspect storage encryption status, key access logs and a restoration test.
D:Review anomalous access logs, credential exposure, response records and retention. This check would investigate another issue (An unauthorized service account downloads a large restricted dataset overnight.), not the immediate case. The direct diagnostic is: Inspect storage encryption status, key access logs and a restoration test.
Question 575
The data program reviews the following failure: Staff collaborate on a policy but several copied files are called final and no approved version is clear. Which change should be prioritized?
- Improve indexing, controlled metadata, search relevance and authoritative-source labeling.
- Define a managed content taxonomy and classify documents using validated metadata.
- Validate extraction confidence and route uncertain fields to authorized human review.
- Use controlled document versioning with approval, access and supersession metadata.
Explanation
Correct Answer
D:Use controlled document versioning with approval, access and supersession metadata. Content version management prevents superseded drafts from being mistaken for authoritative records. Evidence to obtain: Users find the currently approved policy and earlier revisions remain traceable.
Incorrect Answers
A:Improve indexing, controlled metadata, search relevance and authoritative-source labeling. This response fits a separate situation (Employees cannot find approved procedures because files lack titles, tags and indexed text.), but does not resolve the stated case. The targeted response is: Use controlled document versioning with approval, access and supersession metadata.
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: Use controlled document versioning with approval, access and supersession metadata.
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: Use controlled document versioning with approval, access and supersession metadata.
Question 576
A proposed shortcut is offered for this situation: Loan applications often omit annual income even though policy requires it for underwriting. Which choice is the CLEAREST mistake?
- Preserve source evidence and document why any exception was approved.
- Escalate material unresolved issues to an accountable business decision owner.
- Define the intended data population before interpreting quality percentages.
- Call the application complete when an optional comments box has any text.
Explanation
Correct Answer
D:Call the application complete when an optional comments box has any text. Completeness measures presence of required information for a defined purpose. A sound response instead: Measure required-field completeness and introduce appropriate collection checkpoints.
Incorrect Answers
A:Preserve source evidence and document why any exception was approved. Traceability enables independent review of exceptions. The case-specific response is: Measure required-field completeness and introduce appropriate collection checkpoints.
B:Escalate material unresolved issues to an accountable business decision owner. Accountability prevents silent acceptance of consequential risk. The case-specific response is: Measure required-field completeness and introduce appropriate collection checkpoints.
C:Define the intended data population before interpreting quality percentages. An undisclosed denominator can make strong scores misleading. The case-specific response is: Measure required-field completeness and introduce appropriate collection checkpoints.
Question 577
The data management team encounters this situation: High-impact reconciliation defects are buried among hundreds of cosmetic warnings. Which intervention BEST addresses the actual problem?
- Run repeatable data profiling with representative population and documented limitations.
- Define business uniqueness and controlled entity matching rather than exact-row equality.
- Risk-rank defects by business impact, assign owners and track remediation.
- Enforce governed domain rules at ingestion and monitor invalid values.
Explanation
Correct Answer
C:Risk-rank defects by business impact, assign owners and track remediation. Data-quality issue processes should prioritize consequential defects and accountable response. Evidence to obtain: Critical defects receive timely escalation, correction and verifiable closure.
Incorrect Answers
A:Run repeatable data profiling with representative population and documented limitations. This response fits a separate situation (A data team wants to set quality targets before knowing null, duplicate and value distributions.), but does not resolve the stated case. The targeted response is: Risk-rank defects by business impact, assign owners and track remediation.
B:Define business uniqueness and controlled entity matching rather than exact-row equality. This response fits a separate situation (A CRM has duplicate contact records with different punctuation in their names.), but does not resolve the stated case. The targeted response is: Risk-rank defects by business impact, assign owners and track remediation.
D: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. Enforce governed domain rules at ingestion and monitor invalid values.
Question 578
An accountable team must correct this problem and prove results. Select TWO sound statements: A term called revenue means gross receipts in one team and net receipts in another.
- Action: Capture metadata linking transformed fields to versioned reference-data mappings.
- Verification: Reports cite approved term versions and consumers can identify differences.
- Verification: An analyst traces a suspect field back to its origin and responsible transformation.
- Action: Define and approve a glossary term with qualified variants and linked calculations.
- Shortcut: Use the same name for conflicting formulas without documenting the distinction.
Explanation
Correct Answers
B:Verification: Reports cite approved term versions and consumers can identify differences. The observed result demonstrates whether the correction operates as intended. A business glossary aligns organizational terminology and semantic context.
D:Action: Define and approve a glossary term with qualified variants and linked calculations. The proposed intervention targets the reported issue. A business glossary aligns organizational terminology and semantic context.
Incorrect Answers
A:This intervention is for a different scenario (A risk report uses an old industry code mapping but its catalog does not record which version.), not the one stated.
C:This evidence is for a separate context (A compliance report is wrong but no one knows which source change introduced the value.), not this case. The valid outcome is: Reports cite approved term versions and consumers can identify differences.
E:Shortcut: Use the same name for conflicting formulas without documenting the distinction. This shortcut is not a sound remediation. A business glossary aligns organizational terminology and semantic context. The appropriate action is: Define and approve a glossary term with qualified variants and linked calculations.
Question 579
After addressing this problem, what evidence would justify closure? An archived approval email is needed as evidence in a dispute but its author and date are missing.
- Unauthorized test users cannot open sensitive documents and approved users retain access.
- The record shows origin, integrity, retention rule and auditable access history.
- Search tests surface the current approved procedure rather than obsolete drafts.
- Held content survives purge jobs and hold decisions have a traceable case reference.
Explanation
Correct Answer
B:It tests the action: Capture records with reliable context, immutable audit metadata and preservation controls.
Incorrect Answers
A:Unauthorized test users cannot open sensitive documents and approved users retain access. This would verify a different control (A public sharing link exposes sensitive human resources documents to contractors.), not the one in the question. The required evidence is: The record shows origin, integrity, retention rule and auditable access history.
C:Search tests surface the current approved procedure rather than obsolete drafts. This would verify a different control (Employees cannot find approved procedures because files lack titles, tags and indexed text.), not the one in the question. The required evidence is: The record shows origin, integrity, retention rule and auditable access history.
D:Held content survives purge jobs and hold decisions have a traceable case reference. This would verify a different control (An automated seven-year purge is about to remove correspondence covered by an active litigation hold.), not the one in the question. The required evidence is: The record shows origin, integrity, retention rule and auditable access history.
Question 580
A proposed shortcut is offered for this situation: Business users need to analyze order revenue by date, product and geography. Which choice is the CLEAREST mistake?
- Store all descriptive dimension changes as unrelated columns in the fact only.
- Respect active legal holds before scheduling record disposition.
- Check that the proposed procedure has an identified operator and approval path.
- Retain a rollback or recovery plan before making destructive data changes.
Explanation
Correct Answer
A:Store all descriptive dimension changes as unrelated columns in the fact only. This is the unsafe shortcut because it ignores the control logic. Star schemas place numeric events in facts and descriptive context in dimensions. A sound response instead: Create a fact table with appropriate dimension foreign keys for a star schema.
Incorrect Answers
B:Respect active legal holds before scheduling record disposition. Preservation duties may override scheduled destruction. The case-specific response is: Create a fact table with appropriate dimension foreign keys for a star schema.
C:Check that the proposed procedure has an identified operator and approval path. Operational responsibility prevents undocumented workarounds. The case-specific response is: Create a fact table with appropriate dimension foreign keys for a star schema.
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 a fact table with appropriate dimension foreign keys for a star schema.