Exam AI-100 topic 1 question 31 discussion

Actual exam question from Microsoft's AI-100

Question #: 31
Topic #: 1

You deploy an application that performs sentiment analysis on the data stored in Azure Cosmos DB.
Recently, you loaded a large amount of data to the database. The data was for a customer named Contoso, Ltd.
You discover that queries for the Contoso data are slow to complete, and the queries slow the entire application.
You need to reduce the amount of time it takes for the queries to complete. The solution must minimize costs.
What should you do? More than one answer choice may achieve the goal. (Choose two.)

A. Change the request units.
B. Change the partitioning strategy.
C. Change the transaction isolation level.
D. Migrate the data to the Cosmos DB database.

Show Suggested Answer

Suggested Answer: AB 🗳️
Increasing request units would improve throughput, but at a cost.
Throughput provisioned for a container is divided evenly among physical partitions.
References:
https://docs.microsoft.com/en-us/azure/architecture/best-practices/data-partitioning

by tatsutatsugo at April 22, 2021, 9:55 a.m.

Comments

Submit Cancel

rveney

2 years ago

recommended options to improve query performance on the Contoso data in Azure Cosmos DB while minimizing costs are: B. Change the partitioning strategy. D. Migrate the data to the Cosmos DB database.

upvoted 1 times

rveney

2 years ago

The most effective options to address slow query performance and minimize costs are A (changing the request units) and B (changing the partitioning strategy). These options focus on optimizing the resource allocation and distribution of data to improve query performance within the existing Cosmos DB database.

upvoted 1 times

...

BillChan

4 years, 2 months ago

To minimize the cost, B seems the best choice

upvoted 2 times

...

tatsutatsugo

4 years, 2 months ago

Correct

upvoted 1 times

...