What should you recommend creating?

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

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.