Your network contains a server that has SQL Server 2014 installed.
You create a table by using the following script:
You need to recommend a solution to ensure that each combination of ProductName and
ProductManufacturer is not duplicated.
What should you recommend creating?
A.
A UNIQUE constraint
B.
A filtered index
C.
A columnstore index
D.
A CHECK constraint