100% Latest & Updated CDMP DMF Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 280
An information-management assessment identifies: An order table repeats the customer's phone number on every line and updates leave conflicting values. What is the most defensible diagnosis? Choose ONE answer.
- Repeated non-key attributes create update anomalies.
- Binary floating point is unsuitable for exact fixed-precision financial totals.
- Cardinality and optionality rules have not been validated against real examples.
- Current-state price alone cannot reproduce historical transactions.
Explanation
Correct Answer
A:The evidence shows that repeated non-key attributes create update anomalies.
Incorrect Answers
B:This alternative describes data type selection, but the evidence establishes the following problem: Repeated non-key attributes create update anomalies.
C:This alternative describes model validation, but the evidence establishes the following problem: Repeated non-key attributes create update anomalies.
D:This alternative describes temporal data, but the evidence establishes the following problem: Repeated non-key attributes create update anomalies.
Question 281
The organization wants to repair the cause of this problem: An order table repeats the customer's phone number on every line and updates leave conflicting values. Which TWO steps together correct the issue and reduce recurrence? Choose TWO answers.
- Model effective-dated price history or snapshot applied price on invoice.
- Choose decimal precision and scale matching business requirements.
- Document justified denormalizations for proven performance needs.
- Run representative business scenarios and boundary cases against the design.
- Separate customer contact details into a related customer entity.
Explanation
Correct Answers
C:To prevent a repeat, document justified denormalizations for proven performance needs.
E:The correction addresses this failure: Repeated non-key attributes create update anomalies. Evidence of improvement is that changing a number requires one authoritative update without inconsistent copies.
Incorrect Answers
A:This response concerns temporal data, while the current issue is that repeated non-key attributes create update anomalies.
B:This response concerns data type selection, while the current issue is that repeated non-key attributes create update anomalies.
D:This response concerns model validation, while the current issue is that repeated non-key attributes create update anomalies.
Question 282
The control owner evaluates the result of the intervention in this case: An order table repeats the customer's phone number on every line and updates leave conflicting values. Which observable result most directly verifies the correction? Choose ONE answer.
- Reprinting a past invoice reproduces its original amount.
- Changing a number requires one authoritative update without inconsistent copies.
- Sample cases for one-to-many, missing, and changing relationships behave as intended.
- Summing controlled test amounts produces stable expected totals.
Explanation
Correct Answer
B:The evidence is that changing a number requires one authoritative update without inconsistent copies. This verifies changed behavior, not just task closure.
Incorrect Answers
A:That test concerns temporal data. Here the required evidence is that changing a number requires one authoritative update without inconsistent copies.
C:That test concerns model validation. Here the required evidence is that changing a number requires one authoritative update without inconsistent copies.
D:That test concerns data type selection. Here the required evidence is that changing a number requires one authoritative update without inconsistent copies.
Question 283
The organization discovers a problem: A student table allows only one course code per student even though learners enroll in several courses. Which underlying gap explains the problem? Choose ONE answer.
- Binary floating point is unsuitable for exact fixed-precision financial totals.
- A single-valued field cannot represent a many-to-many enrollment relationship.
- The data model's grain is too coarse for the required questions.
- Logical design has been confused with physical deployment concerns.
Explanation
Correct Answer
B:The evidence shows that a single-valued field cannot represent a many-to-many enrollment relationship.
Incorrect Answers
A:This alternative describes data type selection, but the evidence establishes the following problem: A single-valued field cannot represent a many-to-many enrollment relationship.
C:This alternative describes granularity, but the evidence establishes the following problem: A single-valued field cannot represent a many-to-many enrollment relationship.
D:This alternative describes logical versus physical, but the evidence establishes the following problem: A single-valued field cannot represent a many-to-many enrollment relationship.
Question 284
The responsible team has confirmed this situation: A student table allows only one course code per student even though learners enroll in several courses. What is the most directly applicable response? Choose ONE answer.
- Review normalized entities, attributes, and constraints at logical level first.
- Choose decimal precision and scale matching business requirements.
- Introduce an enrollment associative entity referencing student and course.
- Define and retain appropriate transaction-level grain before building summaries.
Explanation
Correct Answer
C:The correction addresses this failure: A single-valued field cannot represent a many-to-many enrollment relationship. Evidence of improvement is that each student can enroll in several courses without duplicating the course definition.
Incorrect Answers
A:This response concerns logical versus physical, while the current issue is that a single-valued field cannot represent a many-to-many enrollment relationship.
B:This response concerns data type selection, while the current issue is that a single-valued field cannot represent a many-to-many enrollment relationship.
D:This response concerns granularity, while the current issue is that a single-valued field cannot represent a many-to-many enrollment relationship.
Question 285
The team must distinguish an effective correction from a closed ticket for: A student table allows only one course code per student even though learners enroll in several courses. Which THREE statements correctly link the root cause, a suitable remedy, and outcome evidence? Choose THREE answers.
- A single-valued field cannot represent a many-to-many enrollment relationship.
- Improvement in granularity suffices even if the original many-to-many defect is still present.
- A successful logical versus physical check alone proves this problem has been corrected.
- Introduce an enrollment associative entity referencing student and course.
- The data type selection control has passed, so testing this affected outcome is unnecessary.
- Each student can enroll in several courses without duplicating the course definition.
Explanation
Correct Answers
A:The underlying cause is that a single-valued field cannot represent a many-to-many enrollment relationship.
D:This response directly addresses the condition: A student table allows only one course code per student even though learners enroll in several courses.
F:The expected evidence is that each student can enroll in several courses without duplicating the course definition. This checks the actual result.
Incorrect Answers
B:For many-to-many, the stated defect must be addressed and the actual outcome checked; a granularity change alone does not establish recovery.
C:That check concerns a different logical versus physical control. The required case outcome is: Each student can enroll in several courses without duplicating the course definition.
E:Passing an unrelated data type selection control cannot replace outcome evidence for many-to-many in this case.
Question 286
Reviewers investigate this case: An insurance model gives every policy type dozens of irrelevant nullable fields. What failure is indicated by this evidence? Choose ONE answer.
- Physical access paths have not been aligned to actual query patterns.
- Distinct policy subtypes are being forced into one undifferentiated structure.
- The supplier code is not a permanent enterprise identity.
- Referential integrity has not been enforced at the relationship boundary.
Explanation
Correct Answer
B:The evidence shows that distinct policy subtypes are being forced into one undifferentiated structure.
Incorrect Answers
A:This alternative describes index design, but the evidence establishes the following problem: Distinct policy subtypes are being forced into one undifferentiated structure.
C:This alternative describes business key versus surrogate, but the evidence establishes the following problem: Distinct policy subtypes are being forced into one undifferentiated structure.
D:This alternative describes foreign key integrity, but the evidence establishes the following problem: Distinct policy subtypes are being forced into one undifferentiated structure.
Question 287
A correction is now being planned for this verified issue: An insurance model gives every policy type dozens of irrelevant nullable fields. What is the most directly applicable response? Choose ONE answer.
- Define and enforce a foreign key to the parent invoice.
- Use a stable surrogate key and store supplier code as a governed alternate key.
- Evaluate appropriate indexes using query plans and data distribution.
- Model common policy attributes and justified subtype-specific attributes.
Explanation
Correct Answer
D:The correction addresses this failure: Distinct policy subtypes are being forced into one undifferentiated structure. Evidence of improvement is that each subtype validates only its applicable required attributes.
Incorrect Answers
A:This response concerns foreign key integrity, while the current issue is that distinct policy subtypes are being forced into one undifferentiated structure.
B:This response concerns business key versus surrogate, while the current issue is that distinct policy subtypes are being forced into one undifferentiated structure.
C:This response concerns index design, while the current issue is that distinct policy subtypes are being forced into one undifferentiated structure.
Question 288
Following corrective work, a reviewer returns to this case: An insurance model gives every policy type dozens of irrelevant nullable fields. Which observable result most directly verifies the correction? Choose ONE answer.
- Execution plans show lower scan costs without excessive write penalties.
- Historical product references survive supplier recoding.
- Invalid orphan inserts are rejected while valid lines persist.
- Each subtype validates only its applicable required attributes.
Explanation
Correct Answer
D:The evidence is that each subtype validates only its applicable required attributes. This verifies changed behavior, not just task closure.
Incorrect Answers
A:That test concerns index design. Here the required evidence is that each subtype validates only its applicable required attributes.
B:That test concerns business key versus surrogate. Here the required evidence is that each subtype validates only its applicable required attributes.
C:That test concerns foreign key integrity. Here the required evidence is that each subtype validates only its applicable required attributes.
Question 289
A data control has become unreliable: Some accounts have no assigned sales representative, but the model requires one for every account. Which root cause best fits the evidence? Choose ONE answer.
- Physical access paths have not been aligned to actual query patterns.
- Physical partition design conflicts with dominant lifecycle and query boundaries.
- An identifier without descriptive attributes was placed in an unnecessary standalone dimension.
- The relationship cardinality is incorrectly mandatory.
Explanation
Correct Answer
D:The evidence shows that the relationship cardinality is incorrectly mandatory.
Incorrect Answers
A:This alternative describes index design, but the evidence establishes the following problem: The relationship cardinality is incorrectly mandatory.
B:This alternative describes partitioning, but the evidence establishes the following problem: The relationship cardinality is incorrectly mandatory.
C:This alternative describes degenerate dimension, but the evidence establishes the following problem: The relationship cardinality is incorrectly mandatory.
Question 290
The team needs an accountable response to the following case: Some accounts have no assigned sales representative, but the model requires one for every account. 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.
- Assess time-based partitioning where it improves pruning and retention work.
- Monitor when assignment becomes required by process status.
- Evaluate appropriate indexes using query plans and data distribution.
- Represent representative assignment as optional where business rules permit it.
Explanation
Correct Answers
C:To prevent a repeat, monitor when assignment becomes required by process status.
E:The correction addresses this failure: The relationship cardinality is incorrectly mandatory. Evidence of improvement is that accounts without representatives can exist without fake placeholder users.
Incorrect Answers
A:This response concerns degenerate dimension, while the current issue is that the relationship cardinality is incorrectly mandatory.
B:This response concerns partitioning, while the current issue is that the relationship cardinality is incorrectly mandatory.
D:This response concerns index design, while the current issue is that the relationship cardinality is incorrectly mandatory.
Data Management Fundamentals (DMF) Practice Tests