Adjusting Database Indexes Quiz

5 questions Pass: 70% +25 pts

Quiz covering Query Performance Optimization

Adjusting Database Indexes Quiz

5 questions | Pass: 70% | Earn 25 points

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

  1. 1

    Which of the following is the default indexing policy for all items in an Azure Cosmos DB container?

  2. 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. 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. 4

    You need to optimize a query that filters by 'Category' and sorts by 'Timestamp'. Which index configuration provides the best performance?

  5. 5

    When modifying an indexing policy on a container with millions of items, what is the primary operational risk to consider?