Q14 Cosmos DB Domain 2 · 25–30% of exam Priority · Real Exam

Which change most reduces the RU cost of a query that currently reports a high number of retrieved documents but returns few?

  1. A Add a filter on the partition key, and index the filtered properties (correct answer)
  2. B Switch to Eventual consistency
  3. C Increase page size
  4. D Enable TTL

Shortcut: A large gap between retrieved and output document count indicates a scan. Filtering on the partition key and ensuring filter paths are indexed converts it into a targeted index seek.