You’re designing a new SQL Server 2012 table that will hold millions of records. The table will be
used by a finance application to show historical transactions. The table only has 10 columns but
it’s vital that the table performs well. How many primary keys should you create for the table for
best performance?
A.
2
B.
10
C.
3
D.
1
Explanation:
You can only have 1 primary key per table.