100% Latest & Updated CDMP DMF Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 310
An information-management assessment identifies: Product prices change by effective date, but old invoices must show original price. What failure is indicated by this evidence? Choose ONE answer.
- A mutable descriptive attribute was used as an entity identifier.
- Current-state price alone cannot reproduce historical transactions.
- Physical partition design conflicts with dominant lifecycle and query boundaries.
- Binary floating point is unsuitable for exact fixed-precision financial totals.
Explanation
Correct Answer
B:The evidence shows that current-state price alone cannot reproduce historical transactions.
Incorrect Answers
A:This alternative describes primary key stability, but the evidence establishes the following problem: Current-state price alone cannot reproduce historical transactions.
C:This alternative describes partitioning, but the evidence establishes the following problem: Current-state price alone cannot reproduce historical transactions.
D:This alternative describes data type selection, but the evidence establishes the following problem: Current-state price alone cannot reproduce historical transactions.
Question 311
The organization wants to repair the cause of this problem: Product prices change by effective date, but old invoices must show original price. Which TWO steps together correct the issue and reduce recurrence? Choose TWO answers.
- Assess time-based partitioning where it improves pruning and retention work.
- Introduce a stable key and keep display name as changeable data.
- Model effective-dated price history or snapshot applied price on invoice.
- Define how retroactive corrections affect historical views.
- Choose decimal precision and scale matching business requirements.
Explanation
Correct Answers
C:The correction addresses this failure: Current-state price alone cannot reproduce historical transactions. Evidence of improvement is that reprinting a past invoice reproduces its original amount.
D:To prevent a repeat, define how retroactive corrections affect historical views.
Incorrect Answers
A:This response concerns partitioning, while the current issue is that current-state price alone cannot reproduce historical transactions.
B:This response concerns primary key stability, while the current issue is that current-state price alone cannot reproduce historical transactions.
E:This response concerns data type selection, while the current issue is that current-state price alone cannot reproduce historical transactions.
Question 312
The control owner evaluates the result of the intervention in this case: Product prices change by effective date, but old invoices must show original price. Which observable result most directly verifies the correction? Choose ONE answer.
- Reprinting a past invoice reproduces its original amount.
- Monthly reads prune unrelated partitions and archiving is controlled.
- Summing controlled test amounts produces stable expected totals.
- Historical references remain valid after employees change names.
Explanation
Correct Answer
A:The evidence is that reprinting a past invoice reproduces its original amount. This verifies changed behavior, not just task closure.
Incorrect Answers
B:That test concerns partitioning. Here the required evidence is that reprinting a past invoice reproduces its original amount.
C:That test concerns data type selection. Here the required evidence is that reprinting a past invoice reproduces its original amount.
D:That test concerns primary key stability. Here the required evidence is that reprinting a past invoice reproduces its original amount.
Question 313
The organization discovers a problem: A monetary amount is modeled as binary floating point and reconciliation shows rounding drift. Which root cause best fits the evidence? Choose ONE answer.
- Binary floating point is unsuitable for exact fixed-precision financial totals.
- Repeated non-key attributes create update anomalies.
- Unknown and actual zero have been conflated.
- Distinct policy subtypes are being forced into one undifferentiated structure.
Explanation
Correct Answer
A:The evidence shows that binary floating point is unsuitable for exact fixed-precision financial totals.
Incorrect Answers
B:This alternative describes normalization trade-off, but the evidence establishes the following problem: Binary floating point is unsuitable for exact fixed-precision financial totals.
C:This alternative describes null semantics, but the evidence establishes the following problem: Binary floating point is unsuitable for exact fixed-precision financial totals.
D:This alternative describes subtype modeling, but the evidence establishes the following problem: Binary floating point is unsuitable for exact fixed-precision financial totals.
Question 314
The responsible team has confirmed this situation: A monetary amount is modeled as binary floating point and reconciliation shows rounding drift. What is the most directly applicable response? Choose ONE answer.
- Model unknown values explicitly and document aggregation treatment.
- Separate customer contact details into a related customer entity.
- Choose decimal precision and scale matching business requirements.
- Model common policy attributes and justified subtype-specific attributes.
Explanation
Correct Answer
C:The correction addresses this failure: Binary floating point is unsuitable for exact fixed-precision financial totals. Evidence of improvement is that summing controlled test amounts produces stable expected totals.
Incorrect Answers
A:This response concerns null semantics, while the current issue is that binary floating point is unsuitable for exact fixed-precision financial totals.
B:This response concerns normalization trade-off, while the current issue is that binary floating point is unsuitable for exact fixed-precision financial totals.
D:This response concerns subtype modeling, while the current issue is that binary floating point is unsuitable for exact fixed-precision financial totals.
Question 315
The team must distinguish an effective correction from a closed ticket for: A monetary amount is modeled as binary floating point and reconciliation shows rounding drift. Which THREE statements correctly link the root cause, a suitable remedy, and outcome evidence? Choose THREE answers.
- Binary floating point is unsuitable for exact fixed-precision financial totals.
- A successful normalization trade-off check alone proves this problem has been corrected.
- The null semantics control has passed, so testing this affected outcome is unnecessary.
- Choose decimal precision and scale matching business requirements.
- Summing controlled test amounts produces stable expected totals.
- Improvement in subtype modeling suffices even if the original data type selection defect is still present.
Explanation
Correct Answers
A:The underlying cause is that binary floating point is unsuitable for exact fixed-precision financial totals.
D:This response directly addresses the condition: A monetary amount is modeled as binary floating point and reconciliation shows rounding drift.
E:The expected evidence is that summing controlled test amounts produces stable expected totals. This checks the actual result.
Incorrect Answers
B:That check concerns a different normalization trade-off control. The required case outcome is: Summing controlled test amounts produces stable expected totals.
C:Passing an unrelated null semantics control cannot replace outcome evidence for data type selection in this case.
F:For data type selection, the stated defect must be addressed and the actual outcome checked; a subtype modeling change alone does not establish recovery.
Question 316
Reviewers investigate this case: A fact table uses zero to represent unknown quantity and sums become misleading. What is the most defensible diagnosis? Choose ONE answer.
- Unknown and actual zero have been conflated.
- Physical partition design conflicts with dominant lifecycle and query boundaries.
- The supplier code is not a permanent enterprise identity.
- Binary floating point is unsuitable for exact fixed-precision financial totals.
Explanation
Correct Answer
A:The evidence shows that unknown and actual zero have been conflated.
Incorrect Answers
B:This alternative describes partitioning, but the evidence establishes the following problem: Unknown and actual zero have been conflated.
C:This alternative describes business key versus surrogate, but the evidence establishes the following problem: Unknown and actual zero have been conflated.
D:This alternative describes data type selection, but the evidence establishes the following problem: Unknown and actual zero have been conflated.
Question 317
A correction is now being planned for this verified issue: A fact table uses zero to represent unknown quantity and sums become misleading. What is the most directly applicable response? Choose ONE answer.
- Model unknown values explicitly and document aggregation treatment.
- Assess time-based partitioning where it improves pruning and retention work.
- Choose decimal precision and scale matching business requirements.
- Use a stable surrogate key and store supplier code as a governed alternate key.
Explanation
Correct Answer
A:The correction addresses this failure: Unknown and actual zero have been conflated. Evidence of improvement is that reports distinguish no measurement from a measured value of zero.
Incorrect Answers
B:This response concerns partitioning, while the current issue is that unknown and actual zero have been conflated.
C:This response concerns data type selection, while the current issue is that unknown and actual zero have been conflated.
D:This response concerns business key versus surrogate, while the current issue is that unknown and actual zero have been conflated.
Question 318
Following corrective work, a reviewer returns to this case: A fact table uses zero to represent unknown quantity and sums become misleading. Which observable result most directly verifies the correction? Choose ONE answer.
- Summing controlled test amounts produces stable expected totals.
- Historical product references survive supplier recoding.
- Reports distinguish no measurement from a measured value of zero.
- Monthly reads prune unrelated partitions and archiving is controlled.
Explanation
Correct Answer
C:The evidence is that reports distinguish no measurement from a measured value of zero. This verifies changed behavior, not just task closure.
Incorrect Answers
A:That test concerns data type selection. Here the required evidence is that reports distinguish no measurement from a measured value of zero.
B:That test concerns business key versus surrogate. Here the required evidence is that reports distinguish no measurement from a measured value of zero.
D:That test concerns partitioning. Here the required evidence is that reports distinguish no measurement from a measured value of zero.
Question 319
A data control has become unreliable: Two services deploy inconsistent versions of the logical customer model. Which underlying gap explains the problem? Choose ONE answer.
- An identifier without descriptive attributes was placed in an unnecessary standalone dimension.
- A single-valued field cannot represent a many-to-many enrollment relationship.
- Model changes have no managed version or impact assessment.
- The supplier code is not a permanent enterprise identity.
Explanation
Correct Answer
C:The evidence shows that model changes have no managed version or impact assessment.
Incorrect Answers
A:This alternative describes degenerate dimension, but the evidence establishes the following problem: Model changes have no managed version or impact assessment.
B:This alternative describes many-to-many, but the evidence establishes the following problem: Model changes have no managed version or impact assessment.
D:This alternative describes business key versus surrogate, but the evidence establishes the following problem: Model changes have no managed version or impact assessment.
Question 320
The team needs an accountable response to the following case: Two services deploy inconsistent versions of the logical customer model. Which TWO steps together correct the issue and reduce recurrence? Choose TWO answers.
- Keep the order number directly at transaction fact grain as a degenerate dimension.
- Record migrations tied to model versions.
- Version model artifacts and review dependency impact before release.
- Introduce an enrollment associative entity referencing student and course.
- Use a stable surrogate key and store supplier code as a governed alternate key.
Explanation
Correct Answers
B:To prevent a repeat, record migrations tied to model versions.
C:The correction addresses this failure: Model changes have no managed version or impact assessment. Evidence of improvement is that both services interpret the agreed field definitions and keys.
Incorrect Answers
A:This response concerns degenerate dimension, while the current issue is that model changes have no managed version or impact assessment.
D:This response concerns many-to-many, while the current issue is that model changes have no managed version or impact assessment.
E:This response concerns business key versus surrogate, while the current issue is that model changes have no managed version or impact assessment.
Data Management Fundamentals (DMF) Practice Tests