Exam 70-762 topic 1 question 102 discussion

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.
Hot Area:

Suggested Answer:
Box 1: INDEX -

Box 2: ON -

Box 3: INCLUDE -
INCLUDE (column [ ,... n ] ) specifies the non-key columns to be added to the leaf level of the nonclustered index. The nonclustered index can be unique or non- unique.
References:
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-index-transact-sql?view=sql-server-2017