Microsoft Exam DP-420 Topic 5 Question 55 Discussion

Actual exam question for Microsoft's DP-420 exam

Question #: 55
Topic #: 5

You have an Azure subscription.

You plan to create an Azure Cosmos DB for NoSQL database named DB1 that will store author and book data for authors that have each published up to ten books. Typical and frequent queries of the data will include:

* All books written by an individual author

* The synopsis of individual books

You need to recommend a data model for DB1. The solution must meet the following requirements:

* Support transactional updates of the author and book data.

* Minimize read operation costs.

What should you recommend?

ACreate a single container that stores author items and book items, and then items that represent the relationship between the authors and their books.

BCreate three containers, one that stores author items, a second that stores book items, and a third that stores items that represent the relationship between the authors and their books.

CCreate two containers, one that stores author items and another that stores book items. Embed a list of each author's books in the corresponding author item.

DCreate a single container that stores author items and book items. Embed a list of each author's books in the

Show Suggested Answer

Suggested Answer: D

by Alison at Dec 10, 2024, 01:49 PM

Limited Time Offer

25%

Off

Get Premium DP-420 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Rosendo

18 days ago

That's a good point, Lenita. Option C could definitely help minimize read operation costs.

upvoted 0 times

...

Lenita

22 days ago

I see your point, Gerry, but I think option C is the most efficient as it embeds the list of books directly in the author item.

upvoted 0 times

...

Velda

25 days ago

Definitely going with option C. It's a simple and efficient data model that meets all the requirements. Plus, it keeps the author and book data nicely organized.

upvoted 0 times

Kerry

7 days ago

Embedding the list of books in the author item does sound like a clean solution.

upvoted 0 times

...

Skye

9 days ago

I agree, option C seems like the best choice for this scenario.

upvoted 0 times

...

Gerry

25 days ago

I disagree, I believe option B is better as it separates the data into different containers for better organization.

upvoted 0 times

...

Altha

26 days ago

Option B seems overcomplicated for this use case. The extra container for the author-book relationship is unnecessary if we can just embed the book list in the author item.

upvoted 0 times

...

Rosendo

1 months ago

I think option A is the best choice because it keeps all the data in one container.

upvoted 0 times

...

Eric

1 months ago

I'd recommend option C. Embedding the book list in the author item makes sense for the given query patterns, and it also supports transactional updates.

upvoted 0 times