Question 260
A data architect recommends this approach: Relate the benefits row to the employee through a unique foreign key. Which situation most clearly calls for that approach?
Explanation
Correct Answer
This situation calls for One-to-one relation. The optional profile can remain separate while retaining a one-to-one association.
Incorrect Answers
The other situation is better matched to Create a database view for the approved SELECT projection. Consumers can query a named logical representation of the data.
The other situation is better matched to Use GROUP BY department with SUM(amount). Input rows are aggregated into departmental totals.
The other situation is better matched to Add a unique constraint on the login email column. Duplicate email values are prevented while the primary key remains independent.