Question 250
A data professional makes this decision: Store customer contact data once and reference its key from order records. Which outcome is the most direct expected result?
Explanation
Correct Answer
This is the expected outcome for Normalize duplicate contacts: The same contact detail no longer needs editing in every purchased item row.
Incorrect Answers
This result would follow the different DELETE selected decision (Use DELETE with a WHERE predicate matching expired sessions.) rather than the specified design.
This result would follow the different WHERE predicate decision (Add a WHERE condition on invoice due date.) rather than the specified design.
This result would follow the different Primary key decision (Define a primary key on the employee identifier column.) rather than the specified design.