CDMP DMF Practice Test 2
Question 10
A data steward examines this condition: Two customer sources disagree about legal name after one verifies recent government ID. What concept best justifies the corrective approach?
- Consolidation offers a harmonized downstream master view without mandatory operational writeback.
- Registry MDM can manage identity linkage without necessarily storing all mastered attributes.
- Entity resolution must balance false positive merges against missed duplicates.
- Golden-record construction applies business rules to conflicting source attributes.
Explanation
Correct Answer
D:Golden-record construction applies business rules to conflicting source attributes. This concept explains the reason for the proposed control. Appropriate intervention: Define survivorship rules that favor verified recent evidence with traceable provenance.
Incorrect Answers
A:This is a defensible principle in another context (A company wants a central analytical customer view while operational systems continue owning updates.), not the most relevant rationale here. For the stated issue: Golden-record construction applies business rules to conflicting source attributes.
B:This is a defensible principle in another context (Several applications retain their own customer stores but need a shared identity index.), not the most relevant rationale here. For the stated issue: Golden-record construction applies business rules to conflicting source attributes.
C:This is a defensible principle in another context (A matching algorithm merges a parent and child solely because they share surname and address.), not the most relevant rationale here. For the stated issue: Golden-record construction applies business rules to conflicting source attributes.
Question 11
Select TWO appropriate statements, one intervention and one verification, for this data management case: A BI analyst receives administrator access to production customer tables for simple reporting.
- Verification: The dataset is correctly labeled and unauthorized roles cannot read restricted attributes.
- 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: Encrypt backup data using approved keys with controlled key access and recovery procedures.
- Shortcut: Use a database superuser account for every analyst because approval is easier.
Explanation
Correct Answers
B:Action: Grant narrow read access to approved views instead of broad administrative rights. The proposed intervention targets the reported issue. Least privilege provides only the access required for an authorized purpose.
C:Verification: The analyst can perform the report but cannot alter or see unrelated sensitive records. The observed result demonstrates whether the correction operates as intended. Least privilege provides only the access required for an authorized purpose.
Incorrect Answers
A:The valid outcome is: The analyst can perform the report but cannot alter or see unrelated sensitive records.
D:This intervention is for a different scenario (A backup contains confidential employee salaries and is stored without encryption controls.), not the one stated.
E:Shortcut: Use a database superuser account for every analyst because approval is easier. This shortcut is not a sound remediation. Least privilege provides only the access required for an authorized purpose. The appropriate action is: Grant narrow read access to approved views instead of broad administrative rights.
Question 12
A governance review considers the following: A CRM has duplicate contact records with different punctuation in their names. Which proposal would create an avoidable risk?
- Define the intended data population before interpreting quality percentages.
- Monitor control outcomes after deployment rather than relying only on design intent.
- Call every row unique because each has a different surrogate ID.
- Verify a new interface using a controlled sample and reconciliation.
Explanation
Correct Answer
C:Call every row unique because each has a different surrogate ID. Uniqueness depends on the real-world entity being represented, not only string equality. A sound response instead: Define business uniqueness and controlled entity matching rather than exact-row equality.
Incorrect Answers
A:Define the intended data population before interpreting quality percentages. An undisclosed denominator can make strong scores misleading. The case-specific response is: Define business uniqueness and controlled entity matching rather than exact-row equality.
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: Define business uniqueness and controlled entity matching rather than exact-row equality.
D:Verify a new interface using a controlled sample and reconciliation. Testing reveals mismatches before broad deployment. The case-specific response is: Define business uniqueness and controlled entity matching rather than exact-row equality.
Question 13
A reviewer asks for proof of improvement: A financial analyst needs totals by region and quarter without modifying source orders. Which result MOST convincingly demonstrates that the control works?
- Cross-mart comparisons reconcile categories for equivalent reporting periods.
- Auditors reproduce the original total and explain the changed figure from documented inputs.
- Department reports reconcile common customer and product metrics.
- Slice-and-dice queries reconcile across dimensions and preserve base transaction state.
Explanation
Correct Answer
D:It tests the action: Use analytical aggregations and dimensional hierarchies rather than transactional updates.
Incorrect Answers
A:Cross-mart comparisons reconcile categories for equivalent reporting periods. This would verify a different control (Finance and sales marts use different definitions of product category for the same item.), not the one in the question. The required evidence is: Slice-and-dice queries reconcile across dimensions and preserve base transaction state.
B:Auditors reproduce the original total and explain the changed figure from documented inputs. This would verify a different control (A published regulatory dashboard cannot explain why last month's total changed after a source correction.), not the one in the question. The required evidence is: Slice-and-dice queries reconcile across dimensions and preserve base transaction state.
C: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: Slice-and-dice queries reconcile across dimensions and preserve base transaction state.
Question 14
A data steward examines this condition: Project teams repeatedly pick conflicting data integration styles for identical business needs. What concept best justifies the corrective approach?
- Architecture principles make cross-project decisions consistent without prohibiting justified exceptions.
- Data architecture provides enterprise-wide direction for how data is structured and flows.
- Architecture migration should expose the gap between existing capabilities and desired future state.
- Logical enterprise architecture clarifies shared meaning independently of vendor databases.
Explanation
Correct Answer
A:Architecture principles make cross-project decisions consistent without prohibiting justified exceptions. This concept explains the reason for the proposed control. Appropriate intervention: Create agreed architecture principles and review exceptions through a decision process.
Incorrect Answers
B:Data architecture provides enterprise-wide direction for how data is structured and flows. This is a defensible principle in another context (Customer identifiers differ across sales, billing and support, preventing consistent reporting.), not the most relevant rationale here. For the stated issue: Architecture principles make cross-project decisions consistent without prohibiting justified exceptions.
C:This is a defensible principle in another context (A bank intends to retire a reporting platform but has no inventory of upstream sources or dependencies.), not the most relevant rationale here. For the stated issue: Architecture principles make cross-project decisions consistent without prohibiting justified exceptions.
D:Logical enterprise architecture clarifies shared meaning independently of vendor databases. This is a defensible principle in another context (Two departments use the term account for unrelated concepts and merge records incorrectly.), not the most relevant rationale here. For the stated issue: Architecture principles make cross-project decisions consistent without prohibiting justified exceptions.
Question 15
Which statement best describes the governing idea behind the response to this case: New customer onboarding creates a second record when spacing differs in a business name.
- Master data includes controlled relationships and hierarchies, not only flat attributes.
- Preventing duplicate creation is usually cheaper than repeated downstream reconciliation.
- Reference-data changes can alter meaning across time and require controlled versions.
- Registry MDM can manage identity linkage without necessarily storing all mastered attributes.
Explanation
Correct Answer
B:Preventing duplicate creation is usually cheaper than repeated downstream reconciliation. This concept explains the reason for the proposed control. Appropriate intervention: Normalize relevant fields and check probable duplicates before creating master identities.
Incorrect Answers
A:This is a defensible principle in another context (Sales cannot roll up revenue because the customer parent-child corporate hierarchy differs across reports.), not the most relevant rationale here. For the stated issue: Preventing duplicate creation is usually cheaper than repeated downstream reconciliation.
C:This is a defensible principle in another context (A product taxonomy changes in January but last year's reports must preserve prior category assignments.), not the most relevant rationale here. For the stated issue: Preventing duplicate creation is usually cheaper than repeated downstream reconciliation.
D:This is a defensible principle in another context (Several applications retain their own customer stores but need a shared identity index.), not the most relevant rationale here. For the stated issue: Preventing duplicate creation is usually cheaper than repeated downstream reconciliation.
Question 16
A business owner identifies this issue: Regional sales managers can query all customer records despite regional authorization rules. What is the MOST appropriate data management response?
- Enforce row-level security using authoritative user-to-region mapping.
- Revoke relevant access, preserve evidence, assess scope and follow incident notification policy.
- Apply governed masking or synthetic data that preserves testing requirements without exposing identities.
- Grant narrow read access to approved views instead of broad administrative rights.
Explanation
Correct Answer
A:Enforce row-level security using authoritative user-to-region mapping. Row-level controls enforce instance-specific access beyond coarse table grants. Evidence to obtain: An authorized manager sees own-region rows and cannot access other regions.
Incorrect Answers
B:Revoke relevant access, preserve evidence, assess scope and follow incident notification policy. This response fits a separate situation (An unauthorized service account downloads a large restricted dataset overnight.), but does not resolve the stated case. The targeted response is: Enforce row-level security using authoritative user-to-region mapping.
C:Apply governed masking or synthetic data that preserves testing requirements without exposing identities. This response fits a separate situation (Test developers need representative orders but a test export includes real customer identity numbers.), but does not resolve the stated case. The targeted response is: Enforce row-level security using authoritative user-to-region mapping.
D:Grant narrow read access to approved views instead of broad administrative rights. This response fits a separate situation (A BI analyst receives administrator access to production customer tables for simple reporting.), but does not resolve the stated case. The targeted response is: Enforce row-level security using authoritative user-to-region mapping.
Question 17
A data analyst must confirm the cause of this issue: A data engineering team cannot determine the format and schema of a nightly inbound file. Which check provides the strongest diagnostic evidence?
- Inspect run logs, watermarks, failure alerts and last-successful-load times.
- Audit current systems against catalog lifecycle labels and successor links.
- Audit catalog freshness and ownership against active application inventories.
- Compare catalog schemas with actual source files and pipeline expectations.
Explanation
Correct Answer
D:Compare catalog schemas with actual source files and pipeline expectations. This test checks the relevant business and technical failure rather than assuming its cause. Technical metadata records how data is structurally represented and processed. Expected control result: Ingestion validation matches recorded technical structures and flags incompatible changes.
Incorrect Answers
A:Inspect run logs, watermarks, failure alerts and last-successful-load times. This check would investigate another issue (A pipeline silently stopped after a weekend but no one tracks run status or freshness.), not the immediate case. The direct diagnostic is: Compare catalog schemas with actual source files and pipeline expectations.
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: Compare catalog schemas with actual source files and pipeline expectations.
C:Audit catalog freshness and ownership against active application inventories. This check would investigate another issue (Catalog entries become stale because their data owners were never assigned responsibility.), not the immediate case. The direct diagnostic is: Compare catalog schemas with actual source files and pipeline expectations.
Question 18
In reviewing this data risk, select the LEAST defensible practice: A business requests a temporary deviation from a sensitive data retention standard.
- Document which dataset version was used in a material decision.
- Grant an indefinite verbal exemption to a profitable business unit.
- Verify a new interface using a controlled sample and reconciliation.
- Monitor control outcomes after deployment rather than relying only on design intent.
Explanation
Correct Answer
B:Grant an indefinite verbal exemption to a profitable business unit. Governed exceptions prevent informal departures from becoming permanent invisible risk. A sound response instead: Require authorized risk assessment, expiry, compensating controls and documented acceptance.
Incorrect Answers
A:Document which dataset version was used in a material decision. Version records support reproducible decisions. The case-specific response is: Require authorized risk assessment, expiry, compensating controls and documented acceptance.
C:Verify a new interface using a controlled sample and reconciliation. Testing reveals mismatches before broad deployment. The case-specific response is: Require authorized risk assessment, expiry, compensating controls and documented acceptance.
D: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: Require authorized risk assessment, expiry, compensating controls and documented acceptance.
Question 19
A data steward challenges an assumption in this case: A repository mixes invoices, procedures and complaints under inconsistent free-text tags. Which verification should be performed first?
- Sample tagging accuracy and compare searches against curated representative records.
- Reconcile deletion job manifests to approved schedules and hold registries.
- Examine record metadata, authenticity checks and immutable version history.
- Inspect version history, effective dates, approval chain and supersession links.
Explanation
Correct Answer
A:Sample tagging accuracy and compare searches against curated representative records. This test checks the relevant business and technical failure rather than assuming its cause. Controlled classification improves discovery and consistent handling of unstructured assets. Expected control result: Search and lifecycle workflows retrieve the expected classes with measurable precision.
Incorrect Answers
B:This check would investigate another issue (A records team says old files were deleted but cannot show what was destroyed or who authorized it.), not the immediate case. The direct diagnostic is: Sample tagging accuracy and compare searches against curated representative records.
C: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: Sample tagging accuracy and compare searches against curated representative records.
D:This check would investigate another issue (Staff collaborate on a policy but several copied files are called final and no approved version is clear.), not the immediate case. The direct diagnostic is: Sample tagging accuracy and compare searches against curated representative records.
Question 20
An accountable team must correct this problem and prove results. Select TWO sound statements: An analytics team reuses location records collected for delivery tracking to infer employees' medical visits.
- Shortcut: Assume employment status makes every personal inference acceptable.
- Action: Evaluate the new use against purpose, notice, proportionality and potential harm before access.
- Verification: People receive intelligible information and the team records a lawful, ethical justification.
- Action: Test subgroup outcomes, data representativeness and remediations with accountable review.
- Verification: The use is rejected or redesigned with appropriate authorization, minimization and safeguards.
Explanation
Correct Answers
B:Action: Evaluate the new use against purpose, notice, proportionality and potential harm before access. The proposed intervention targets the reported issue. Ethical data handling asks whether a use is fair and justified even when technically possible.
E:Verification: The use is rejected or redesigned with appropriate authorization, minimization and safeguards. The observed result demonstrates whether the correction operates as intended. Ethical data handling asks whether a use is fair and justified even when technically possible.
Incorrect Answers
A:Shortcut: Assume employment status makes every personal inference acceptable. This shortcut is not a sound remediation. Ethical data handling asks whether a use is fair and justified even when technically possible. The appropriate action is: Evaluate the new use against purpose, notice, proportionality and potential harm before access.
C:The valid outcome is: The use is rejected or redesigned with appropriate authorization, minimization and safeguards.
D:Action: Test subgroup outcomes, data representativeness and remediations with accountable review. This intervention is for a different scenario (A credit model has similar overall accuracy but rejects an underserved population disproportionately.), not the one stated. Appropriate action here: Evaluate the new use against purpose, notice, proportionality and potential harm before access.