CDMP DMF Practice Test 57
Question 560
A data steward examines this condition: Loan applications often omit annual income even though policy requires it for underwriting. What concept best justifies the corrective approach?
- Data-quality issue processes should prioritize consequential defects and accountable response.
- Timeliness is fitness of information at the required decision moment.
- Completeness measures presence of required information for a defined purpose.
- A quality score can be misleading when its monitored population is incomplete.
Explanation
Correct Answer
C:Completeness measures presence of required information for a defined purpose. This concept explains the reason for the proposed control. Appropriate intervention: Measure required-field completeness and introduce appropriate collection checkpoints.
Incorrect Answers
A:Data-quality issue processes should prioritize consequential defects and accountable response. This is a defensible principle in another context (High-impact reconciliation defects are buried among hundreds of cosmetic warnings.), not the most relevant rationale here. For the stated issue: Completeness measures presence of required information for a defined purpose.
B:Timeliness is fitness of information at the required decision moment. This is a defensible principle in another context (A fraud team receives transaction events forty minutes after its five-minute alert deadline.), not the most relevant rationale here. For the stated issue: Completeness measures presence of required information for a defined purpose.
D:This is a defensible principle in another context (A scorecard reports 99 percent valid rows but excludes an entire failed daily feed.), not the most relevant rationale here. For the stated issue: Completeness measures presence of required information for a defined purpose.
Question 561
A data management auditor evaluates this situation: A product taxonomy changes in January but last year's reports must preserve prior category assignments. Which observable finding supports successful remediation?
- The consolidated view is refreshed and lineage shows each source-system contribution.
- Historical reports use previous mappings while current queries use approved new categories.
- Known duplicate test cases are flagged while legitimate similar companies remain distinct.
- A lookup resolves cross-system references while authoritative attributes remain in sources.
Explanation
Correct Answer
B:It tests the action: Manage reference data as effective-dated versions with historical mapping support.
Incorrect Answers
A:The consolidated view is refreshed and lineage shows each source-system contribution. This would verify a different control (A company wants a central analytical customer view while operational systems continue owning updates.), not the one in the question. The required evidence is: Historical reports use previous mappings while current queries use approved new categories.
C:Known duplicate test cases are flagged while legitimate similar companies remain distinct. This would verify a different control (New customer onboarding creates a second record when spacing differs in a business name.), not the one in the question. The required evidence is: Historical reports use previous mappings while current queries use approved new categories.
D: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: Historical reports use previous mappings while current queries use approved new categories.
Question 562
Which statement best describes the governing idea behind the response to this case: A team plans to remove a source column that feeds several dashboards and fraud rules.
- Interoperable metadata requires shared representations and semantics.
- A business glossary aligns organizational terminology and semantic context.
- Metadata dependency mapping enables informed change management.
- Operational metadata describes execution, frequency, health and processing events.
Explanation
Correct Answer
C:Metadata dependency mapping enables informed change management. This concept explains the reason for the proposed control. Appropriate intervention: Use dependency lineage to assess downstream impact and coordinate migration.
Incorrect Answers
A:Interoperable metadata requires shared representations and semantics. This is a defensible principle in another context (Three systems record table creation dates in incompatible time zones and formats.), not the most relevant rationale here. For the stated issue: Metadata dependency mapping enables informed change management.
B:A business glossary aligns organizational terminology and semantic context. This is a defensible principle in another context (A term called revenue means gross receipts in one team and net receipts in another.), not the most relevant rationale here. For the stated issue: Metadata dependency mapping enables informed change management.
D:Operational metadata describes execution, frequency, health and processing events. This is a defensible principle in another context (A pipeline silently stopped after a weekend but no one tracks run status or freshness.), not the most relevant rationale here. For the stated issue: Metadata dependency mapping enables informed change management.
Question 563
A proposed shortcut is offered for this situation: A nightly billion-event aggregation exceeds single-machine memory and now misses its SLA. Which choice is the CLEAREST mistake?
- Preserve source evidence and document why any exception was approved.
- Move the workload to a slightly larger laptop and stop monitoring skew.
- Monitor control outcomes after deployment rather than relying only on design intent.
- Apply access controls proportional to the sensitivity of business information.
Explanation
Correct Answer
B:Move the workload to a slightly larger laptop and stop monitoring skew. Big-data computation relies on parallelism and careful data partitioning rather than unlimited node memory. A sound response instead: Choose partitioned distributed processing with measured shuffle and skew behavior.
Incorrect Answers
A:Preserve source evidence and document why any exception was approved. Traceability enables independent review of exceptions. The case-specific response is: Choose partitioned distributed processing with measured shuffle and skew behavior.
C: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: Choose partitioned distributed processing with measured shuffle and skew behavior.
D:Apply access controls proportional to the sensitivity of business information. Confidentiality obligations still apply during quality improvements. The case-specific response is: Choose partitioned distributed processing with measured shuffle and skew behavior.
Question 564
An accountable data owner wants both a response and a measurable check: A pipeline silently stopped after a weekend but no one tracks run status or freshness. Which action-and-evidence pair is BEST?
- Action: Define common timestamp semantics and metadata exchange conventions. Verification: Catalog times convert consistently with time zone and source provenance retained.
- 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: Collect operational metadata such as run timestamps, row counts and failure states. Verification: Owners detect late or failed loads using observable pipeline execution history.
- Action: Define and approve a glossary term with qualified variants and linked calculations. Verification: Reports cite approved term versions and consumers can identify differences.
Explanation
Correct Answer
C:Recommended action: Collect operational metadata such as run timestamps, row counts and failure states. How to verify: Owners detect late or failed loads using observable pipeline execution history. Both the intervention and measurable outcome are directly relevant. Operational metadata describes execution, frequency, health and processing events.
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: Collect operational metadata such as run timestamps, row counts and failure states.
B: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: Collect operational metadata such as run timestamps, row counts and failure states.
D: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: Collect operational metadata such as run timestamps, row counts and failure states.
Question 565
A data steward examines this condition: A fraud-alert service must evaluate new events within seconds while a monthly financial summary tolerates delay. What concept best justifies the corrective approach?
- Processing architecture should match latency, correctness and replay requirements of each use case.
- Data integration reliability requires observable completeness and repeatable recovery.
- CDC depends on correct change ordering and consumption state across failures.
- Data interoperability requires shared semantics even when field names differ.
Explanation
Correct Answer
A:Processing architecture should match latency, correctness and replay requirements of each use case. This concept explains the reason for the proposed control. Appropriate intervention: Use a governed low-latency event stream for alerts and a scheduled batch path for the summary.
Incorrect Answers
B: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: Processing architecture should match latency, correctness and replay requirements of each use case.
C:This is a defensible principle in another context (A customer platform needs low-latency updates without repeatedly scanning entire operational tables.), not the most relevant rationale here. For the stated issue: Processing architecture should match latency, correctness and replay requirements of each use case.
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: Processing architecture should match latency, correctness and replay requirements of each use case.
Question 566
A business owner identifies this issue: A developer stores payment account numbers in a general-purpose dataset tagged public. What is the MOST appropriate data management response?
- Enforce row-level security using authoritative user-to-region mapping.
- Classify sensitive fields and apply controls aligned to business and regulatory risk.
- Require authenticated encrypted transport using supported TLS configuration.
- Enable protected access and export audit logs with appropriate retention and review.
Explanation
Correct Answer
B:Classify sensitive fields and apply controls aligned to business and regulatory risk. Security controls should reflect classification and sensitivity, not storage location alone. Evidence to obtain: The dataset is correctly labeled and unauthorized roles cannot read restricted attributes.
Incorrect Answers
A:Enforce row-level security using authoritative user-to-region mapping. This response fits a separate situation (Regional sales managers can query all customer records despite regional authorization rules.), but does not resolve the stated case. The targeted response is: Classify sensitive fields and apply controls aligned to business and regulatory risk.
C:Require authenticated encrypted transport using supported TLS configuration. This response fits a separate situation (A service transfers customer attributes over unencrypted HTTP between data centers.), but does not resolve the stated case. The targeted response is: Classify sensitive fields and apply controls aligned to business and regulatory risk.
D:Enable protected access and export audit logs with appropriate retention and review.
Question 567
A governance review considers the following: A backup contains confidential employee salaries and is stored without encryption controls. Which proposal would create an avoidable risk?
- Protect relevant audit records while investigating data problems.
- Assume encryption without managed keys automatically solves all backup security issues.
- Validate critical changes against representative positive and negative examples.
- Keep approved reference mappings versioned and traceable.
Explanation
Correct Answer
B:Assume encryption without managed keys automatically solves all backup security issues. Encryption at rest reduces exposure of stored sensitive information but requires key governance. A sound response instead: Encrypt backup data using approved keys with controlled key access and recovery procedures.
Incorrect Answers
A:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Encrypt backup data using approved keys with controlled key access and recovery procedures.
C:Validate critical changes against representative positive and negative examples. Controlled tests provide more reliable proof than untested assumptions. The case-specific response is: Encrypt backup data using approved keys with controlled key access and recovery procedures.
D:Keep approved reference mappings versioned and traceable. Value meaning can change across time and applications. The case-specific response is: Encrypt backup data using approved keys with controlled key access and recovery procedures.
Question 568
A reviewer asks for proof of improvement: A database service is slow but monitoring records only whether its process is up. Which result MOST convincingly demonstrates that the control works?
- Representative query time improves without unacceptable ingestion regression.
- A pre-incident restore point survives attack and recovers clean data.
- Alerts identify bottlenecks and response resolves tested workload degradation.
- Patched instances pass regression checks without violating availability constraints.
Explanation
Correct Answer
C:It tests the action: Add performance monitoring for query latency, locks, throughput and resource saturation.
Incorrect Answers
A:Representative query time improves without unacceptable ingestion regression. This would verify a different control (A report scans millions of rows although its date filter is selective and frequent.), not the one in the question. The required evidence is: Alerts identify bottlenecks and response resolves tested workload degradation.
B:A pre-incident restore point survives attack and recovers clean data. This would verify a different control (A company keeps only the latest backup copy, leaving no way to recover before ransomware encryption.), not the one in the question. The required evidence is: Alerts identify bottlenecks and response resolves tested workload degradation.
D:Patched instances pass regression checks without violating availability constraints. This would verify a different control (A security patch must be applied to a data store with a strict availability commitment.), not the one in the question. The required evidence is: Alerts identify bottlenecks and response resolves tested workload degradation.
Question 569
A governance review considers the following: Different pipelines enforce different allowable values for the same governed country field. Which proposal would create an avoidable risk?
- Escalate material unresolved issues to an accountable business decision owner.
- Respect active legal holds before scheduling record disposition.
- Let each pipeline silently select a different valid-value list.
- Document which dataset version was used in a material decision.
Explanation
Correct Answer
C:Let each pipeline silently select a different valid-value list. Quality rules need documented semantics and controlled reuse across systems. A sound response instead: Publish reusable data-quality rules with owners, thresholds and exceptions.
Incorrect Answers
A:Escalate material unresolved issues to an accountable business decision owner. Accountability prevents silent acceptance of consequential risk. The case-specific response is: Publish reusable data-quality rules with owners, thresholds and exceptions.
B:Respect active legal holds before scheduling record disposition. Preservation duties may override scheduled destruction. The case-specific response is: Publish reusable data-quality rules with owners, thresholds and exceptions.
D:Document which dataset version was used in a material decision. Version records support reproducible decisions. The case-specific response is: Publish reusable data-quality rules with owners, thresholds and exceptions.
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.