Adjusting Database Indexes Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Query Performance Optimization

What you'll be asked

  1. Which of the following is the default indexing policy for all items in an Azure Cosmos DB container?
  2. You have a container with a large volume of data. You notice that your write operations are consuming too many Request Units (RUs). What is the most effective way to optimize this?
  3. A query filtering by a range condition (e.g., price > 100) is performing poorly. What index type should you ensure is configured to improve this?
  4. You need to optimize a query that filters by 'Category' and sorts by 'Timestamp'. Which index configuration provides the best performance?
  5. When modifying an indexing policy on a container with millions of items, what is the primary operational risk to consider?

Answers and explanations come after you submit.