A Cosmos DB NoSQL container needs to efficiently run queries filtering on a property that is not the partition key. What indexing feature should be verified?
- A Composite index on the property
- B Spatial index
- C The property must be included in the indexing policy (included paths) (correct answer)
- D TTL index
Shortcut: By default, all properties are indexed (Consistent mode). If indexing policy has been customized to exclude paths, properties not indexed will cause full scans. Verify the property is in included paths.