Question 310
A data professional makes this decision: Create an appropriate index on the account-number lookup column. Which outcome is the most direct expected result?
Explanation
Correct Answer
This is the expected outcome for Index search: The database can locate matching values more efficiently at a storage and write cost.
Incorrect Answers
This result would follow the different One-to-one relation decision (Relate the benefits row to the employee through a unique foreign key.) rather than the specified design.
This result would follow the different HAVING filter decision (Use HAVING to filter groups by the aggregate expense.) rather than the specified design.
This result would follow the different Unique constraint decision (Add a unique constraint on the login email column.) rather than the specified design.