Query Optimization Quiz

5 questions Pass: 70% +25 pts

Quiz covering Azure Cosmos DB for NoSQL

Query Optimization 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 tool in the Azure portal is most commonly used to execute and test SQL queries against an Azure Cosmos DB for NoSQL container?

  2. 2

    When designing a query in Azure Cosmos DB, why is it recommended to include the partition key in the WHERE clause whenever possible?

  3. 3

    Which of the following query patterns is considered an anti-pattern that can lead to high Request Unit (RU) consumption?

  4. 4

    What is the primary purpose of the Request Charge (measured in RUs) returned in the query response header?

  5. 5

    You have a query that performs a cross-partition scan and returns a high RU cost. You notice the query uses an 'ORDER BY' clause on a property that is not indexed. What is the most effective way to optimize this?