Question 2
UnclassifiedA container has heavy writes and only a few query paths. What might improve performance and cost?
Correct answer: A
Explanation
If a container has "heavy writes" and only a few query paths, indexing every field adds unnecessary write overhead and storage cost. Reviewing the indexing policy so only useful paths are indexed reduces index maintenance while still supporting the needed queries, improving performance and cost.
Why each option is right or wrong
A. Reviewing the indexing policy so only useful paths are indexed.
Azure Cosmos DB automatically indexes all properties by default, and each write must update those indexes, which increases RU consumption and storage when the workload is write-heavy. Under the indexing policy settings, you can exclude unused paths or switch to a more selective policy so only the queried paths are maintained, reducing write latency and cost while preserving the few required query patterns.
B. Indexing every unused field forever.
C. Disabling all security.
D. Moving the data to a presentation file.