You plan to add a new column named SmallKey to the Sales.Product table that will be used in a
unique constraint. You are required to ensure that the following information is applied when adding
the
new column:
‘a1’ and ‘A1’ are treated as different values
‘a’ and ‘A’ sort before ‘b’ and ‘B’ in an ORDER BY clause
You need to select the collation that meets the requirements for the new column. Which collation
should you select?

A.
Latin1_General_BIN

B.
SQL_Latin1_General_CP1_CI_AI

C.
SQL_Latin1_General_CP1_CI_AS

D.
SQL_Latin1_General_CP1_CS_AS