exam questions

Exam DP-420 All Questions

View all questions & answers for the DP-420 exam

Exam DP-420 topic 1 question 26 discussion

Actual exam question from Microsoft's DP-420
Question #: 26
Topic #: 1
[All DP-420 Questions]

You plan to store order data in an Azure Cosmos DB Core (SQL) API account. The data contains information about orders and their associated items.
You need to develop a model that supports order read operations. The solution must minimize the number of requests.
What should you do?

  • A. Create a database for orders and a database for order items.
  • B. Create a single database that contains a container for orders and a container for order items.
  • C. Create a single database that contains one container. Store orders and order items in separate documents in the container.
  • D. Create a single database that contains one container. Create a separate document for each order and embed the order items into the order documents.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

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
azuredemo2022three
Highly Voted 1 year, 5 months ago
Selected Answer: D
Selected Answer: D
upvoted 7 times
...
rakun
Most Recent 7 months ago
See, in this kind of questions i think we must assume that the number of items per order can go to infinity. Thus, it would be C. As answer description says: Note: In general, use embedded data models when: There's embedded data that will not grow without bound. We do not see any bound information in this example and we do not know how much data goes with each item - is it 10 key-value pairs? is it 100? 1000? So this can cause our app to hit limits and requires complete re-design and migration.
upvoted 1 times
...
D3D1997
1 year, 5 months ago
Selected Answer: D
The solution must minimize the number of requests
upvoted 2 times
...
azuredemo2022three
1 year, 5 months ago
Selected Answer: B
upvoted 2 times
...
imando
1 year, 6 months ago
Selected Answer: D
D is answer
upvoted 2 times
...
arnabdt
1 year, 8 months ago
Selected Answer: B
B. Create a single database that contains a container for orders and a container for order items. Creating a single database with two containers, one for orders and another for order items, is the best approach to support order read operations while minimizing the number of requests. This approach provides a clear separation of concerns between orders and order items, making it easier to manage the data and perform read operations. With this approach, queries that require only order data can be directed to the orders container, while queries that require order item data can be directed to the order items container. This reduces the number of requests required to retrieve the data needed for each query.
upvoted 1 times
xRiot007
11 months, 3 weeks ago
You have order reads, not order item reads, so no need for 2 containers. To reduce number of requests you denormalize data by providing a document for each order and its items.
upvoted 1 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 ...