Q3
Hotspot
HOTSPOT
You have a table named Person.Address that includes the following columns:
AddressID
AddressLine1
AddressLine2
City
StateProvinceID
PostakCode
RowGuid
ModifiedDate
You need to create a nonclustered index on PostalCode named IX_Address_PostalCode that uses the following included columns:
AddressLine1
AddressLine2
City
StateProvinceID
How should you complete the Transact-SQL statement? To answer, select the appropriate Transact_SQL segments in the answer are.
Select the correct area(s) on the image.
