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
D is the Answer. After creating the Composite key in both table we can remove OrderID and Line No from any one of the table to eliminate the synthetic key, According to 1st sentence of the D, they have created the Composite key in both Orders and Shipments Table.
D is the Answer. After creating the Composite key in both table we can remove OrderID and Line No from any one of the table to eliminate the synthetic key, According to 1st sentence of the D, they have created the Composite key in both Orders and Shipments Table.
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.
shaan007
1 month, 2 weeks agoshaan007
1 month, 2 weeks ago7d737d9
2 months, 2 weeks ago