exam questions

Exam AI-100 All Questions

View all questions & answers for the AI-100 exam

Exam AI-100 topic 1 question 17 discussion

Actual exam question from Microsoft's AI-100
Question #: 17
Topic #: 1
[All AI-100 Questions]

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 is the best way to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.

  • 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 Hide Answer
Suggested Answer: B 🗳️
Throughput provisioned for a container is divided evenly among physical partitions.
Incorrect:
Not A: Increasing request units would also improve throughput, but at a cost.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/best-practices/data-partitioning

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
cloudpandit
Highly Voted 4 years, 6 months ago
More than one answer choice may achieve the goal. A. Change the request units. Request unit is a performance currency abstracting the system resources such as CPU, IOPS, and memory that are required to perform the database operations supported by Azure Cosmos DB. https://docs.microsoft.com/en-us/azure/cosmos-db/request-units B. Change the partitioning strategy. Improve performance. Data access operations on each partition take place over a smaller volume of data. Correctly done, partitioning can make your system more efficient. Operations that affect more than one partition can run in parallel. https://docs.microsoft.com/en-us/azure/architecture/best-practices/data-partitioning
upvoted 6 times
...
ammarkareem
Highly Voted 4 years, 10 months ago
Seems to be correct
upvoted 5 times
...
rveney
Most Recent 1 year, 10 months ago
To reduce the amount of time it takes for queries to complete on the Contoso data in Azure Cosmos DB, while minimizing costs, the BEST way to achieve the goal is B. Change the partitioning strategy.
upvoted 1 times
...
ayush_singh
4 years, 2 months ago
Question Say More than one answer choice may achieve the goal but Choose the Best Answer, it would be B and if it says to choose two then we can go with A & B.
upvoted 2 times
allanm
3 years, 11 months ago
It's a trick question - The question does have provision to give multiple answers but it also says to choose the BEST answer. So B is indeed the right answer for this question.
upvoted 1 times
...
...
Cornholioz
4 years, 2 months ago
This is about provisioning throughput in Azure Cosmos DB. https://docs.microsoft.com/en-us/azure/cosmos-db/set-throughput Both A and B serve the purpose. RU's impact the cost directly, so it makes Partitioning Strategy (B) a lower cost option. Since the question asks for more than one answer, both A and B are correct... if this is a multichoice question.
upvoted 1 times
...
awron_durat
4 years, 5 months ago
A and B both work but as you want to minimize cost, B becomes the better choice.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago