Exam DP-420 topic 8 question 3 discussion

HOTSPOT -
You need to recommend indexes for con-product and con-productVendor. The solution must meet the product catalog requirements and the business requirements.
Which type of index should you recommend for each container? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Suggested Answer:
Box 1: Range on con-productVendor
Range index is based on an ordered tree-like structure. The range index type is used for:
Equality queries:
SELECT * FROM container c WHERE c.property = 'value'
SELECT * FROM c WHERE c.property IN ("value1", "value2", "value3")
Note:
The con-product container stores the company's product catalog data. Each document in con-product includes a con-productvendor value. Most queries targeting the data in con-product are in the following format.
SELECT * FROM con-product p WHERE p.con-productVendor - 'name'
Box 2: Composite in creditRating and yearFounded
Composite indexes increase the efficiency when you are performing operations on multiple fields. The composite index type is used for:
ORDER BY queries on multiple properties:
SELECT * FROM container c ORDER BY c.property1, c.property2
Note: Most queries targeting the data in the con-productVendor container are in the following format
SELECT * FROM con-productVendor pv
ORDER BY pv.creditRating, pv.yearFounded
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/index-overview