100% Latest & Updated CDMP DMF Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 270
The team must distinguish an effective correction from a closed ticket for: An MDM program counts loaded records but cannot demonstrate business improvement. Which observable result most directly verifies the correction? Choose ONE answer.
- Suppression tests respect the most relevant valid opt-out.
- New transactions reject retired codes unless an authorized exception applies.
- Two unrelated residents remain separate persons while sharing an address.
- Monthly samples show improved entity accuracy and consumption.
Explanation
Correct Answer
D:The evidence is that monthly samples show improved entity accuracy and consumption. This verifies changed behavior, not just task closure.
Incorrect Answers
A:That test concerns consent preference. Here the required evidence is that monthly samples show improved entity accuracy and consumption.
B:That test concerns reference code set. Here the required evidence is that monthly samples show improved entity accuracy and consumption.
C:That test concerns householding. Here the required evidence is that monthly samples show improved entity accuracy and consumption.
Question 271
A data-management review uncovers this condition: Executives reject a conceptual customer-order-payment model because it contains no database table partitions. Which underlying gap explains the problem? Choose ONE answer.
- Referential integrity has not been enforced at the relationship boundary.
- The supplier code is not a permanent enterprise identity.
- An identifier without descriptive attributes was placed in an unnecessary standalone dimension.
- Business concepts are being judged against physical implementation details instead of conceptual semantics.
Explanation
Correct Answer
D:The evidence shows that business concepts are being judged against physical implementation details instead of conceptual semantics.
Incorrect Answers
A:This alternative describes foreign key integrity, but the evidence establishes the following problem: Business concepts are being judged against physical implementation details instead of conceptual semantics.
B:This alternative describes business key versus surrogate, but the evidence establishes the following problem: Business concepts are being judged against physical implementation details instead of conceptual semantics.
C:This alternative describes degenerate dimension, but the evidence establishes the following problem: Business concepts are being judged against physical implementation details instead of conceptual semantics.
Question 272
A correction is now being planned for this verified issue: Executives reject a conceptual customer-order-payment model because it contains no database table partitions. Which TWO steps together correct the issue and reduce recurrence? Choose TWO answers.
- Keep approved business concepts traceable to later logical and physical models.
- Use a stable surrogate key and store supplier code as a governed alternate key.
- Clarify entity meaning and cardinality before choosing physical storage details.
- Define and enforce a foreign key to the parent invoice.
- Keep the order number directly at transaction fact grain as a degenerate dimension.
Explanation
Correct Answers
A:To prevent a repeat, keep approved business concepts traceable to later logical and physical models.
C:The correction addresses this failure: Business concepts are being judged against physical implementation details instead of conceptual semantics. Evidence of improvement is that business users approve the relationships without requiring engine-specific ddl.
Incorrect Answers
B:This response concerns business key versus surrogate, while the current issue is that business concepts are being judged against physical implementation details instead of conceptual semantics.
D:This response concerns foreign key integrity, while the current issue is that business concepts are being judged against physical implementation details instead of conceptual semantics.
E:This response concerns degenerate dimension, while the current issue is that business concepts are being judged against physical implementation details instead of conceptual semantics.
Question 273
Following corrective work, a reviewer returns to this case: Executives reject a conceptual customer-order-payment model because it contains no database table partitions. Which observable result most directly verifies the correction? Choose ONE answer.
- Invalid orphan inserts are rejected while valid lines persist.
- Historical product references survive supplier recoding.
- Business users approve the relationships without requiring engine-specific DDL.
- A user drills from sales totals to the original order without an empty dimension join.
Explanation
Correct Answer
C:The evidence is that business users approve the relationships without requiring engine-specific ddl. This verifies changed behavior, not just task closure.
Incorrect Answers
A:That test concerns foreign key integrity. Here the required evidence is that business users approve the relationships without requiring engine-specific ddl.
B:That test concerns business key versus surrogate. Here the required evidence is that business users approve the relationships without requiring engine-specific ddl.
D:That test concerns degenerate dimension. Here the required evidence is that business users approve the relationships without requiring engine-specific ddl.
Question 274
Consider this operating issue: An employee table uses display name as its primary key and records break after name changes. What failure is indicated by this evidence? Choose ONE answer.
- A mutable descriptive attribute was used as an entity identifier.
- Logical design has been confused with physical deployment concerns.
- Physical access paths have not been aligned to actual query patterns.
- Distinct policy subtypes are being forced into one undifferentiated structure.
Explanation
Correct Answer
A:The evidence shows that a mutable descriptive attribute was used as an entity identifier.
Incorrect Answers
B:This alternative describes logical versus physical, but the evidence establishes the following problem: A mutable descriptive attribute was used as an entity identifier.
C:This alternative describes index design, but the evidence establishes the following problem: A mutable descriptive attribute was used as an entity identifier.
D:This alternative describes subtype modeling, but the evidence establishes the following problem: A mutable descriptive attribute was used as an entity identifier.
Question 275
The team needs an accountable response to the following case: An employee table uses display name as its primary key and records break after name changes. What is the most directly applicable response? Choose ONE answer.
- Review normalized entities, attributes, and constraints at logical level first.
- Evaluate appropriate indexes using query plans and data distribution.
- Model common policy attributes and justified subtype-specific attributes.
- Introduce a stable key and keep display name as changeable data.
Explanation
Correct Answer
D:The correction addresses this failure: A mutable descriptive attribute was used as an entity identifier. Evidence of improvement is that historical references remain valid after employees change names.
Incorrect Answers
A:This response concerns logical versus physical, while the current issue is that a mutable descriptive attribute was used as an entity identifier.
B:This response concerns index design, while the current issue is that a mutable descriptive attribute was used as an entity identifier.
C:This response concerns subtype modeling, while the current issue is that a mutable descriptive attribute was used as an entity identifier.
Question 276
The organization requests independent outcome evidence for: An employee table uses display name as its primary key and records break after name changes. Which THREE statements correctly link the root cause, a suitable remedy, and outcome evidence? Choose THREE answers.
- Improvement in logical versus physical suffices even if the original primary key stability defect is still present.
- A successful subtype modeling check alone proves this problem has been corrected.
- Introduce a stable key and keep display name as changeable data.
- A mutable descriptive attribute was used as an entity identifier.
- Historical references remain valid after employees change names.
- The index design control has passed, so testing this affected outcome is unnecessary.
Explanation
Correct Answers
C:This response directly addresses the condition: An employee table uses display name as its primary key and records break after name changes.
D:The underlying cause is that a mutable descriptive attribute was used as an entity identifier.
E:The expected evidence is that historical references remain valid after employees change names. This checks the actual result.
Incorrect Answers
A:For primary key stability, the stated defect must be addressed and the actual outcome checked; a logical versus physical change alone does not establish recovery.
B:That check concerns a different subtype modeling control. The required case outcome is: Historical references remain valid after employees change names.
F:Passing an unrelated index design control cannot replace outcome evidence for primary key stability in this case.
Question 277
A business team reports the following failure: An invoice line points to a nonexistent invoice header. Which root cause best fits the evidence? Choose ONE answer.
- Analytical attributes require effective-dated history for as-of reporting.
- Referential integrity has not been enforced at the relationship boundary.
- Physical partition design conflicts with dominant lifecycle and query boundaries.
- Distinct policy subtypes are being forced into one undifferentiated structure.
Explanation
Correct Answer
B:The evidence shows that referential integrity has not been enforced at the relationship boundary.
Incorrect Answers
A:This alternative describes slowly changing dimensions, but the evidence establishes the following problem: Referential integrity has not been enforced at the relationship boundary.
C:This alternative describes partitioning, but the evidence establishes the following problem: Referential integrity has not been enforced at the relationship boundary.
D:This alternative describes subtype modeling, but the evidence establishes the following problem: Referential integrity has not been enforced at the relationship boundary.
Question 278
Operations must address the demonstrated failure: An invoice line points to a nonexistent invoice header. What is the most directly applicable response? Choose ONE answer.
- Model common policy attributes and justified subtype-specific attributes.
- Design a type-2 style historical dimension when business questions require prior states.
- Assess time-based partitioning where it improves pruning and retention work.
- Define and enforce a foreign key to the parent invoice.
Explanation
Correct Answer
D:The correction addresses this failure: Referential integrity has not been enforced at the relationship boundary. Evidence of improvement is that invalid orphan inserts are rejected while valid lines persist.
Incorrect Answers
A:This response concerns subtype modeling, while the current issue is that referential integrity has not been enforced at the relationship boundary.
B:This response concerns slowly changing dimensions, while the current issue is that referential integrity has not been enforced at the relationship boundary.
C:This response concerns partitioning, while the current issue is that referential integrity has not been enforced at the relationship boundary.
Question 279
A data steward checks whether remediation actually worked for: An invoice line points to a nonexistent invoice header. Which observable result most directly verifies the correction? Choose ONE answer.
- Invalid orphan inserts are rejected while valid lines persist.
- Each subtype validates only its applicable required attributes.
- Earlier reports resolve the segment valid at the event date.
- Monthly reads prune unrelated partitions and archiving is controlled.
Explanation
Correct Answer
A:The evidence is that invalid orphan inserts are rejected while valid lines persist. This verifies changed behavior, not just task closure.
Incorrect Answers
B:That test concerns subtype modeling. Here the required evidence is that invalid orphan inserts are rejected while valid lines persist.
C:That test concerns slowly changing dimensions. Here the required evidence is that invalid orphan inserts are rejected while valid lines persist.
D:That test concerns partitioning. Here the required evidence is that invalid orphan inserts are rejected while valid lines persist.
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.
Data Management Fundamentals (DMF) Practice Tests