Your network contains a server that has SQL Server 2014 installed. You create a table by using the following script: Yo
Posted: Mon Oct 17, 2022 4:50 pm
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
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 Co 1 (45.44 KiB) Viewed 108 times
B. A filtered index
C. A columnstore index
D. A CHECK constraint