Refer to the exhibit. A data architect is loading the tables and a synthetic key is generated. How should the data architect resolve the synthetic key?
A.
Remove the LineNo field from Shipments and use the AutoNumber function on the OrderID field
B.
Remove the LineNo field from both tables and use the AutoNumber function on the OrderID field
C.
Create a composite key using OrderID and LineNo
D.
Create a composite key using OrderID and LineNo, and remove OrderID and LineNo from Shipments
Just creating a composite key won't fix the error, you would still need to remove/rename fields creating the synthetic joins which suggests that answer would be more complete.
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
7d737d9
5 days, 20 hours ago