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?

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

Show Hint

Leave a Reply 1

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

MickBig

MickBig

UNIQUE Constraint. You could do this:

ALTER TABLE dbo.Products ADD CONSTRAINT UC_ProductName_ProductManufacturer UNIQUE (ProductName, ProductManufacturer)

Reply