What should you recommend creating?

You have a Microsoft SQL Azure database named DBAzure1.
You create a table in DBAzure1 by using the following script:

You need to recommend a solution to ensure that each combination of CustomerContact
and CustomerDetails is not duplicated.
What should you recommend creating?

You have a Microsoft SQL Azure database named DBAzure1.
You create a table in DBAzure1 by using the following script:

You need to recommend a solution to ensure that each combination of CustomerContact
and CustomerDetails is not duplicated.
What should you recommend creating?

A.
A CHECK constraint

B.
A filtered index

C.
A columnstore index

D.
A UNIQUE constraint



Leave a Reply 1

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


Kevin

Kevin

ALTER TABLE dbo.Customers
ADD CONSTRAINT UC_Customer UNIQUE (CustomerContact, CustomerDetails);