Certified Data Management Professional – Fundamentals (CDMP) — Question 153

Significant operational issues have been caused by the implementation of a data model that represents a Customer Agreement as a ternary relationship between the Enterprise, a Customer, and their Contact Person. Which of the following describes the likely operational issue?

Answer options

• A. Every time the customer changes addresses the address for the contact person must change as well
• B. In the event of a merger between enterprises, the contact person addresses need to be updated
• C. Every time the contact person changes, the customer agreement needs to be re-established
• D. Response time for retrieving the Customer Agreement degrades rapidly due to the lack of indexing
• E. Every time the Customer Agreement was renewed, a new Contact Person record was required

Correct answer: C

Explanation

The correct answer is C because a ternary relationship implies that any change in the contact person necessitates a reevaluation of the agreement, leading to operational inefficiencies. The other options describe scenarios that may cause inconvenience but do not directly relate to the need for re-establishing the customer agreement as a result of changes in contact personnel.