CDMP DMF Practice Test 22
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.
Question 211
An accountable team must correct this problem and prove results. Select TWO sound statements: A regulatory metric cannot be reconciled to the systems that initially captured its values.
- Shortcut: Draw only a final dashboard picture and claim that explains provenance.
- Action: Define canonical field semantics and versioned interface contracts with consumers.
- Verification: Architecture artifacts identify dependencies, gap owners and a credible migration path.
- Action: Create an end-to-end logical data flow mapping origin, processing, stores and consumers.
- Verification: Auditors can trace the metric through transformations and responsible systems.
Explanation
Correct Answers
D:Action: Create an end-to-end logical data flow mapping origin, processing, stores and consumers. The proposed intervention targets the reported issue. Architecture flow maps make hidden dependencies and control points observable.
E:Verification: Auditors can trace the metric through transformations and responsible systems. The observed result demonstrates whether the correction operates as intended. Architecture flow maps make hidden dependencies and control points observable.
Incorrect Answers
A:Shortcut: Draw only a final dashboard picture and claim that explains provenance. This shortcut is not a sound remediation. Architecture flow maps make hidden dependencies and control points observable. The appropriate action is: Create an end-to-end logical data flow mapping origin, processing, stores and consumers.
B:Action: Define canonical field semantics and versioned interface contracts with consumers. This intervention is for a different scenario (A team proposes proprietary event fields that cannot be interpreted by other platforms.), not the one stated. Appropriate action here: Create an end-to-end logical data flow mapping origin, processing, stores and consumers.
C:This evidence is for a separate context (A bank intends to retire a reporting platform but has no inventory of upstream sources or dependencies.), not this case.
Question 212
Consider this organizational data problem: A repository mixes invoices, procedures and complaints under inconsistent free-text tags. What action is most defensible?
- Define a managed content taxonomy and classify documents using validated metadata.
- Improve indexing, controlled metadata, search relevance and authoritative-source labeling.
- Implement disposition approval, hold checking and tamper-resistant destruction logs.
- Apply need-to-know roles, link governance and monitored content permissions.
Explanation
Correct Answer
A:Define a managed content taxonomy and classify documents using validated metadata. Controlled classification improves discovery and consistent handling of unstructured assets. Evidence to obtain: Search and lifecycle workflows retrieve the expected classes with measurable precision.
Incorrect Answers
B: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: Define a managed content taxonomy and classify documents using validated metadata.
C:Implement disposition approval, hold checking and tamper-resistant destruction logs. This response fits a separate situation (A records team says old files were deleted but cannot show what was destroyed or who authorized it.), but does not resolve the stated case. The targeted response is: Define a managed content taxonomy and classify documents using validated metadata.
D:Apply need-to-know roles, link governance and monitored content permissions. This response fits a separate situation (A public sharing link exposes sensitive human resources documents to contractors.), but does not resolve the stated case. The targeted response is: Define a managed content taxonomy and classify documents using validated metadata.
Question 213
Before changing procedures, the team investigates: Executives need consistent historical revenue despite frequent transactional schema changes. Which review or test MOST directly locates the relevant failure?
- Inspect dimension record count and description after controlled correction.
- Review historical fact loads, source reconciliation and business metric conformance.
- Recompute representative totals using source currency, rates and period.
- Replay a prior reporting run using captured source and code versions.
Explanation
Correct Answer
B:Review historical fact loads, source reconciliation and business metric conformance. This test checks the relevant business and technical failure rather than assuming its cause. A warehouse supports integrated historical analysis distinct from operational transactions. Expected control result: Historical reports reconcile and are insulated from irrelevant transactional changes.
Incorrect Answers
A:Inspect dimension record count and description after controlled correction. This check would investigate another issue (A product description contains a typo and historic analytics do not need the old spelling.), not the immediate case. The direct diagnostic is: Review historical fact loads, source reconciliation and business metric conformance.
C:Recompute representative totals using source currency, rates and period. This check would investigate another issue (A dashboard shows revenue increasing sharply because source currency values are mixed without conversion.), not the immediate case. The direct diagnostic is: Review historical fact loads, source reconciliation and business metric conformance.
D:Replay a prior reporting run using captured source and code versions. This check would investigate another issue (A published regulatory dashboard cannot explain why last month's total changed after a source correction.), not the immediate case. The direct diagnostic is: Review historical fact loads, source reconciliation and business metric conformance.
Question 214
A governance review considers the following: A data engineering team cannot determine the format and schema of a nightly inbound file. Which proposal would create an avoidable risk?
- Apply access controls proportional to the sensitivity of business information.
- Document which dataset version was used in a material decision.
- Use business descriptions as a replacement for schema and datatype metadata.
- Verify a new interface using a controlled sample and reconciliation.
Explanation
Correct Answer
C:Use business descriptions as a replacement for schema and datatype metadata. Technical metadata records how data is structurally represented and processed. A sound response instead: Capture technical metadata describing schemas, types, partitions and interfaces.
Incorrect Answers
A:Apply access controls proportional to the sensitivity of business information. Confidentiality obligations still apply during quality improvements. The case-specific response is: Capture technical metadata describing schemas, types, partitions and interfaces.
B:Document which dataset version was used in a material decision. Version records support reproducible decisions. The case-specific response is: Capture technical metadata describing schemas, types, partitions and interfaces.
D:Verify a new interface using a controlled sample and reconciliation. Testing reveals mismatches before broad deployment. The case-specific response is: Capture technical metadata describing schemas, types, partitions and interfaces.
Question 215
Which statement best describes the governing idea behind the response to this case: Two executive dashboards both show profit margin but use different numerator adjustments.
- A warehouse supports integrated historical analysis distinct from operational transactions.
- BI comparability depends on consistent business metric semantics, not chart style.
- Preaggregation trades computation cost for maintenance and freshness requirements.
- Type 2 dimensions preserve attribute history by versioning rows.
Explanation
Correct Answer
B:BI comparability depends on consistent business metric semantics, not chart style. This concept explains the reason for the proposed control. Appropriate intervention: Govern KPI definitions, filters, denominator and time rules across reporting tools.
Incorrect Answers
A:A warehouse supports integrated historical analysis distinct from operational transactions. This is a defensible principle in another context (Executives need consistent historical revenue despite frequent transactional schema changes.), not the most relevant rationale here. For the stated issue: BI comparability depends on consistent business metric semantics, not chart style.
C:Preaggregation trades computation cost for maintenance and freshness requirements. This is a defensible principle in another context (A star-schema dashboard query repeatedly scans granular facts for the same monthly totals.), not the most relevant rationale here. For the stated issue: BI comparability depends on consistent business metric semantics, not chart style.
D:Type 2 dimensions preserve attribute history by versioning rows. This is a defensible principle in another context (A salesperson moves territories and historical sales must remain attributed to prior territory.), not the most relevant rationale here. For the stated issue: BI comparability depends on consistent business metric semantics, not chart style.
Question 216
Which statement best describes the governing idea behind the response to this case: A nightly billion-event aggregation exceeds single-machine memory and now misses its SLA.
- Big-data computation relies on parallelism and careful data partitioning rather than unlimited node memory.
- Batch, messaging and service APIs meet different business service levels.
- At-least-once delivery requires consumers to tolerate duplicate messages.
- Virtualization reduces duplication but retains source dependence and governance costs.
Explanation
Correct Answer
A:Big-data computation relies on parallelism and careful data partitioning rather than unlimited node memory. This concept explains the reason for the proposed control. Appropriate intervention: Choose partitioned distributed processing with measured shuffle and skew behavior.
Incorrect Answers
B:This is a defensible principle in another context (A daily tax report and a live fraud decision service share one nightly transfer mechanism.), not the most relevant rationale here. For the stated issue: Big-data computation relies on parallelism and careful data partitioning rather than unlimited node memory.
C:This is a defensible principle in another context (An event consumer processes a payment notification twice after retry and creates duplicate ledger postings.), not the most relevant rationale here. For the stated issue: Big-data computation relies on parallelism and careful data partitioning rather than unlimited node memory.
D:This is a defensible principle in another context (An organization wants live access to distributed records without copying every source table.), not the most relevant rationale here. For the stated issue: Big-data computation relies on parallelism and careful data partitioning rather than unlimited node memory.
Question 217
A data steward examines this condition: An automated seven-year purge is about to remove correspondence covered by an active litigation hold. What concept best justifies the corrective approach?
- Legal holds can override routine retention disposition for specified records.
- Controlled classification improves discovery and consistent handling of unstructured assets.
- Content version management prevents superseded drafts from being mistaken for authoritative records.
- Document and content management governs unstructured information across its lifecycle.
Explanation
Correct Answer
A:Legal holds can override routine retention disposition for specified records. This concept explains the reason for the proposed control. Appropriate intervention: Suspend disposition for in-scope content until an authorized hold release is recorded.
Incorrect Answers
B:Controlled classification improves discovery and consistent handling of unstructured assets. This is a defensible principle in another context (A repository mixes invoices, procedures and complaints under inconsistent free-text tags.), not the most relevant rationale here. For the stated issue: Legal holds can override routine retention disposition for specified records.
C:This is a defensible principle in another context (Staff collaborate on a policy but several copied files are called final and no approved version is clear.), not the most relevant rationale here. For the stated issue: Legal holds can override routine retention disposition for specified records.
D:Document and content management governs unstructured information across its lifecycle. This is a defensible principle in another context (Contract PDFs are retained indefinitely after business use with no destruction rules.), not the most relevant rationale here. For the stated issue: Legal holds can override routine retention disposition for specified records.
Question 218
A data analyst must confirm the cause of this issue: A new organizational hierarchy update accidentally makes Division A the parent of itself through B. Which check provides the strongest diagnostic evidence?
- Simulate conflicting source updates and inspect synchronization audit records.
- Compare reports across the change boundary with reference effective dates.
- Run cycle-detection tests and inspect affected rollups after a change.
- Sample cross-system customer matches and evaluate false merges and misses.
Explanation
Correct Answer
C:Run cycle-detection tests and inspect affected rollups after a change. This test checks the relevant business and technical failure rather than assuming its cause. Master relationship governance must enforce structural integrity constraints. Expected control result: Prohibited cycles are rejected and rollup traversal terminates with correct totals.
Incorrect Answers
A:Simulate conflicting source updates and inspect synchronization audit records. This check would investigate another issue (Business units need local writes but also expect synchronized approved enterprise attributes.), not the immediate case. The direct diagnostic is: Run cycle-detection tests and inspect affected rollups after a change.
B:Compare reports across the change boundary with reference effective dates. This check would investigate another issue (A product taxonomy changes in January but last year's reports must preserve prior category assignments.), not the immediate case. The direct diagnostic is: Run cycle-detection tests and inspect affected rollups after a change.
D:Sample cross-system customer matches and evaluate false merges and misses. This check would investigate another issue (Retail and service systems each assign different IDs to the same real-world customer.), not the immediate case. The direct diagnostic is: Run cycle-detection tests and inspect affected rollups after a change.
Question 219
Before changing procedures, the team investigates: High-impact reconciliation defects are buried among hundreds of cosmetic warnings. Which review or test MOST directly locates the relevant failure?
- Join same-customer records at a common as-of time and compare tier values.
- Inspect severity criteria, aging queues, owners and post-fix validation.
- Compare rule IDs, accepted domains and exception handling across pipelines.
- Sample records for presence, recency and accurate destination independently.
Explanation
Correct Answer
B:Inspect severity criteria, aging queues, owners and post-fix validation. This test checks the relevant business and technical failure rather than assuming its cause. Data-quality issue processes should prioritize consequential defects and accountable response. Expected control result: Critical defects receive timely escalation, correction and verifiable closure.
Incorrect Answers
A:This check would investigate another issue (The customer's tier is gold in billing but silver in the loyalty platform on the same date.), not the immediate case. The direct diagnostic is: Inspect severity criteria, aging queues, owners and post-fix validation.
C:Compare rule IDs, accepted domains and exception handling across pipelines. This check would investigate another issue (Different pipelines enforce different allowable values for the same governed country field.), not the immediate case. The direct diagnostic is: Inspect severity criteria, aging queues, owners and post-fix validation.
D:Sample records for presence, recency and accurate destination independently. This check would investigate another issue (A postal address field is 100 percent complete but several entries are no longer current.), not the immediate case. The direct diagnostic is: Inspect severity criteria, aging queues, owners and post-fix validation.
Question 220
In reviewing this data risk, select the LEAST defensible practice: An unauthorized service account downloads a large restricted dataset overnight.
- Check that the proposed procedure has an identified operator and approval path.
- Monitor control outcomes after deployment rather than relying only on design intent.
- Validate critical changes against representative positive and negative examples.
- Delete the access logs immediately to avoid reputational concern.
Explanation
Correct Answer
D:Delete the access logs immediately to avoid reputational concern. Data security incidents require containment, evidence and accountable escalation. A sound response instead: Revoke relevant access, preserve evidence, assess scope and follow incident notification policy.
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: Revoke relevant access, preserve evidence, assess scope and follow incident notification policy.
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: Revoke relevant access, preserve evidence, assess scope and follow incident notification policy.
C:Validate critical changes against representative positive and negative examples. Controlled tests provide more reliable proof than untested assumptions. The case-specific response is: Revoke relevant access, preserve evidence, assess scope and follow incident notification policy.