Query Optimization Quiz

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

Quiz covering Azure Cosmos DB for NoSQL

What you'll be asked

  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. When designing a query in Azure Cosmos DB, why is it recommended to include the partition key in the WHERE clause whenever possible?
  3. Which of the following query patterns is considered an anti-pattern that can lead to high Request Unit (RU) consumption?
  4. What is the primary purpose of the Request Charge (measured in RUs) returned in the query response header?
  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?

Answers and explanations come after you submit.