CDMP DMF Practice Test 21
Question 200
The data program reviews the following failure: An analyst manually fixes the same missing supplier IDs every week. Which change should be prioritized?
- Identify the upstream source-process failure and implement a preventive correction.
- Reconcile tier definitions and synchronization logic using a defined authoritative source.
- Add input validation with clear user feedback and exception override governance.
- Run repeatable data profiling with representative population and documented limitations.
Explanation
Correct Answer
A:Identify the upstream source-process failure and implement a preventive correction. Sustainable data quality improvement addresses causes rather than repeated symptoms. Evidence to obtain: New records arrive with supplier IDs and recurrence drops after monitoring.
Incorrect Answers
B:This response fits a separate situation (The customer's tier is gold in billing but silver in the loyalty platform on the same date.), but does not resolve the stated case. Reconcile tier definitions and synchronization logic using a defined authoritative source.
C:Add input validation with clear user feedback and exception override governance. This response fits a separate situation (Bad dates are entered during onboarding and corrected only after monthly reporting failures.), but does not resolve the stated case. The targeted response is: Identify the upstream source-process failure and implement a preventive correction.
D: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. Run repeatable data profiling with representative population and documented limitations.
Question 201
An accountable data owner wants both a response and a measurable check: Reports join unrelated entities because business dimensions lack a mapped semantic model. Which action-and-evidence pair is BEST?
- Action: Define approved semantic relationships, metric calculations and valid join paths. Verification: Users get consistent results and invalid joins are rejected or flagged.
- 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: Introduce active, deprecated and archived lifecycle states with accountable approval. Verification: Consumers see retirement dates, replacements and appropriate access warnings.
- 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
A:Action: Define approved semantic relationships, metric calculations and valid join paths. Verification: Users get consistent results and invalid joins are rejected or flagged. Both the intervention and measurable outcome are directly relevant. Semantic metadata bridges technical schemas and business interpretation.
Incorrect Answers
B:This plan addresses a different situation (A pipeline silently stopped after a weekend but no one tracks run status or freshness.), not the targeted problem. Here, action and evidence must match: Action: Define approved semantic relationships, metric calculations and valid join paths.
C:This plan addresses a different situation (A retired system's catalog entries remain marked active, misleading new project teams.), not the targeted problem.
D:This plan addresses a different situation (A catalog lists every dataset but half of its owners and descriptions are outdated.), not the targeted problem.
Question 202
A business owner identifies this issue: Loan applications often omit annual income even though policy requires it for underwriting. What is the MOST appropriate data management response?
- Measure required-field completeness and introduce appropriate collection checkpoints.
- Risk-rank defects by business impact, assign owners and track remediation.
- Evaluate quality against the specific consumer's required provenance and interpretability.
- Identify the upstream source-process failure and implement a preventive correction.
Explanation
Correct Answer
A:Measure required-field completeness and introduce appropriate collection checkpoints. Completeness measures presence of required information for a defined purpose. Evidence to obtain: The proportion of applications with credible required income rises under a defined rule.
Incorrect Answers
B:Risk-rank defects by business impact, assign owners and track remediation. This response fits a separate situation (High-impact reconciliation defects are buried among hundreds of cosmetic warnings.), but does not resolve the stated case. The targeted response is: Measure required-field completeness and introduce appropriate collection checkpoints.
C:Evaluate quality against the specific consumer's required provenance and interpretability. This response fits a separate situation (A scientific dataset has fine precision but lacks metadata required for the regulator's audit.), but does not resolve the stated case. The targeted response is: Measure required-field completeness and introduce appropriate collection checkpoints.
D:Identify the upstream source-process failure and implement a preventive correction. This response fits a separate situation (An analyst manually fixes the same missing supplier IDs every week.), but does not resolve the stated case. The targeted response is: Measure required-field completeness and introduce appropriate collection checkpoints.
Question 203
The data program reviews the following failure: Contract PDFs are retained indefinitely after business use with no destruction rules. Which change should be prioritized?
- Improve indexing, controlled metadata, search relevance and authoritative-source labeling.
- Capture records with reliable context, immutable audit metadata and preservation controls.
- Suspend disposition for in-scope content until an authorized hold release is recorded.
- Classify documents and apply approved creation, review, retention, archive and disposal procedures.
Explanation
Correct Answer
D:Classify documents and apply approved creation, review, retention, archive and disposal procedures. Document and content management governs unstructured information across its lifecycle. Evidence to obtain: Records have retention schedules and disposal evidence while active holds are respected.
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: Classify documents and apply approved creation, review, retention, archive and disposal procedures.
B:This response fits a separate situation (An archived approval email is needed as evidence in a dispute but its author and date are missing.), but does not resolve the stated case. Capture records with reliable context, immutable audit metadata and preservation controls.
C:Suspend disposition for in-scope content until an authorized hold release is recorded.
Question 204
A reviewer asks for proof of improvement: One interface calls a field supplier_id while another calls it vendor_code with different identifier rules. Which result MOST convincingly demonstrates that the control works?
- Queries return authorized current results within documented latency and availability bounds.
- Translated identifiers reconcile across both systems and erroneous mappings are detected.
- The fraud service receives timely events while tax reporting reconciles its complete batch.
- Source-to-target counts and financial totals reconcile after late batches are processed.
Explanation
Correct Answer
B:It tests the action: Define an agreed canonical mapping with meaning, transform ownership and validation.
Incorrect Answers
A:Queries return authorized current results within documented latency and availability bounds. This would verify a different control (An organization wants live access to distributed records without copying every source table.), not the one in the question. The required evidence is: Translated identifiers reconcile across both systems and erroneous mappings are detected.
C:The fraud service receives timely events while tax reporting reconciles its complete batch. This would verify a different control (A daily tax report and a live fraud decision service share one nightly transfer mechanism.), not the one in the question. The required evidence is: Translated identifiers reconcile across both systems and erroneous mappings are detected.
D:Source-to-target counts and financial totals reconcile after late batches are processed. This would verify a different control (Finance reports omit transactions because an extraction job silently skips late-arriving records.), not the one in the question. The required evidence is: Translated identifiers reconcile across both systems and erroneous mappings are detected.
Question 205
Before changing procedures, the team investigates: A company has a general policy promising accurate data but no operational validation thresholds. Which review or test MOST directly locates the relevant failure?
- Review council charter, quorum, action log and overdue escalations.
- Inspect exception approval dates, scope, mitigation and renewal decisions.
- Review governance charter, ownership map and approved definition changes.
- Trace a policy requirement to a standard, test procedure and evidence artifact.
Explanation
Correct Answer
D:Trace a policy requirement to a standard, test procedure and evidence artifact. This test checks the relevant business and technical failure rather than assuming its cause. Policies express intent; standards set rules and procedures define execution. Expected control result: Teams implement specified checks and exception workflows tied to an approved policy.
Incorrect Answers
A:Review council charter, quorum, action log and overdue escalations. This check would investigate another issue (Customer and finance functions cannot agree on shared priority data rules.), not the immediate case. The direct diagnostic is: Trace a policy requirement to a standard, test procedure and evidence artifact.
B:Inspect exception approval dates, scope, mitigation and renewal decisions. This check would investigate another issue (A business requests a temporary deviation from a sensitive data retention standard.), not the immediate case. The direct diagnostic is: Trace a policy requirement to a standard, test procedure and evidence artifact.
C:Review governance charter, ownership map and approved definition changes. This check would investigate another issue (Two departments disagree about the authoritative definition of an active customer and neither can decide.), not the immediate case. The direct diagnostic is: Trace a policy requirement to a standard, test procedure and evidence artifact.
Question 206
Consider this organizational data problem: Business users need to analyze order revenue by date, product and geography. What action is most defensible?
- Apply consistent currency conversion rules with effective rates and labeled units.
- Govern mart sourcing and shared dimensions while allowing fit-for-purpose views.
- Build governed analytical integration and conformed business measures for reporting.
- Create a fact table with appropriate dimension foreign keys for a star schema.
Explanation
Correct Answer
D:Create a fact table with appropriate dimension foreign keys for a star schema. Star schemas place numeric events in facts and descriptive context in dimensions. Evidence to obtain: Reports slice measures consistently by conformed dimension attributes.
Incorrect Answers
A:Apply consistent currency conversion rules with effective rates and labeled units. This response fits a separate situation (A dashboard shows revenue increasing sharply because source currency values are mixed without conversion.), but does not resolve the stated case. The targeted response is: Create a fact table with appropriate dimension foreign keys for a star schema.
B:This response fits a separate situation (Business units create separate departmental marts from inconsistent extracts of customer master data.), but does not resolve the stated case. Govern mart sourcing and shared dimensions while allowing fit-for-purpose views.
C:Build governed analytical integration and conformed business measures for reporting. This response fits a separate situation (Executives need consistent historical revenue despite frequent transactional schema changes.), but does not resolve the stated case. The targeted response is: Create a fact table with appropriate dimension foreign keys for a star schema.
Question 207
A data steward challenges an assumption in this case: Customer and finance functions cannot agree on shared priority data rules. Which verification should be performed first?
- Inspect CDE selection criteria, downstream use and impact assessment.
- Inspect roadmap dependencies, funding, adoption measures and change readiness.
- Inspect RACI assignments, policy approvals and steward issue logs.
- Review council charter, quorum, action log and overdue escalations.
Explanation
Correct Answer
D:Review council charter, quorum, action log and overdue escalations. This test checks the relevant business and technical failure rather than assuming its cause. Enterprise governance needs a forum for conflicting priorities with explicit authority. Expected control result: Council minutes record decisions, dissent, accountable actions and resolution dates.
Incorrect Answers
A:Inspect CDE selection criteria, downstream use and impact assessment. This check would investigate another issue (A governance team treats every data field as equally critical, overwhelming its controls program.), not the immediate case. The direct diagnostic is: Review council charter, quorum, action log and overdue escalations.
B:Inspect roadmap dependencies, funding, adoption measures and change readiness. This check would investigate another issue (A new governance office attempts simultaneous enterprise rollout with no prioritization or adoption plan.), not the immediate case. The direct diagnostic is: Review council charter, quorum, action log and overdue escalations.
C:Inspect RACI assignments, policy approvals and steward issue logs. This check would investigate another issue (A product data owner expects the data steward to set commercial policy unilaterally.), not the immediate case. The direct diagnostic is: Review council charter, quorum, action log and overdue escalations.
Question 208
After addressing this problem, what evidence would justify closure? A nightly billion-event aggregation exceeds single-machine memory and now misses its SLA.
- Translated identifiers reconcile across both systems and erroneous mappings are detected.
- The distributed job completes correctly within the required window and reconciles counts.
- Consumers can discover trustworthy datasets and distinguish approved from abandoned assets.
- Staging access is restricted, audit logged and temporary files expire as approved.
Explanation
Correct Answer
B:It tests the action: Choose partitioned distributed processing with measured shuffle and skew behavior.
Incorrect Answers
A:Translated identifiers reconcile across both systems and erroneous mappings are detected. This would verify a different control (One interface calls a field supplier_id while another calls it vendor_code with different identifier rules.), not the one in the question. The required evidence is: The distributed job completes correctly within the required window and reconciles counts.
C:Consumers can discover trustworthy datasets and distinguish approved from abandoned assets. This would verify a different control (Raw clickstream files are dumped into an object store without ownership, schema or discovery metadata.), not the one in the question. The required evidence is: The distributed job completes correctly within the required window and reconciles counts.
D:Staging access is restricted, audit logged and temporary files expire as approved. This would verify a different control (A file-transfer integration includes confidential customer attributes in an unsecured staging bucket.), not the one in the question. The required evidence is: The distributed job completes correctly within the required window and reconciles counts.
Question 209
After addressing this problem, what evidence would justify closure? A party table mixes person birthdate with organization registration number, leaving ambiguous rules.
- Shared identity fields are unified and subtype-specific validation is enforced.
- Stakeholders approve shared concepts and relationship definitions.
- Database DDL enforces approved integrity and meets representative performance tests.
- Enrolments are uniquely recorded without duplicate student or course entities.
Explanation
Correct Answer
A:It tests the action: Use a common party supertype with justified person and organization subtypes.
Incorrect Answers
B:Stakeholders approve shared concepts and relationship definitions. This would verify a different control (Business stakeholders cannot agree which things should be treated as customers, accounts or products.), not the one in the question. The required evidence is: Shared identity fields are unified and subtype-specific validation is enforced.
C:Database DDL enforces approved integrity and meets representative performance tests. This would verify a different control (A logical model is approved but a PostgreSQL implementation needs columns and access paths.), not the one in the question. The required evidence is: Shared identity fields are unified and subtype-specific validation is enforced.
D:Enrolments are uniquely recorded without duplicate student or course entities. This would verify a different control (A student can enroll in many courses and a course can enroll many students.), not the one in the question. The required evidence is: Shared identity fields are unified and subtype-specific validation is enforced.
Question 210
In reviewing this data risk, select the LEAST defensible practice: A service transfers customer attributes over unencrypted HTTP between data centers.
- Validate critical changes against representative positive and negative examples.
- Accept plaintext transfer because both data centers are owned by the same firm.
- Protect relevant audit records while investigating data problems.
- Respect active legal holds before scheduling record disposition.
Explanation
Correct Answer
B:Accept plaintext transfer because both data centers are owned by the same firm. Secure data movement must protect confidentiality and integrity in transit. A sound response instead: Require authenticated encrypted transport using supported TLS configuration.
Incorrect Answers
A:Validate critical changes against representative positive and negative examples. Controlled tests provide more reliable proof than untested assumptions. The case-specific response is: Require authenticated encrypted transport using supported TLS configuration.
C:Protect relevant audit records while investigating data problems. Evidence handling supports retrospective control testing. The case-specific response is: Require authenticated encrypted transport using supported TLS configuration.
D:Respect active legal holds before scheduling record disposition. Preservation duties may override scheduled destruction. The case-specific response is: Require authenticated encrypted transport using supported TLS configuration.