Microsoft Exam Questions

Which database object should you add to the Sales table?

You have two tables named Salesperson and Sales.
You need to ensure that each record in the Sales table has a valid associated salesperson record in
the Salesperson table.
Which database object should you add to the Sales table?

A.
Nonclustered index

B.
Primary key

C.
Foreign key

D.
Clustered index