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

Jennifer

29 days ago

Option C is the way to go! Embedding the book list in the author item is like putting all your books on the same shelf - easy to find what you need.

upvoted 0 times

Ricarda

5 days ago

I think I'll go with option C for my Azure Cosmos DB data model. Thanks for the recommendation!

upvoted 0 times

...

Dino

8 days ago

It definitely simplifies the data structure and makes querying for author and book data more straightforward.

upvoted 0 times

...

Rachael

16 days ago

I agree, having two containers and embedding the book list in the author item makes sense for efficient queries.

upvoted 0 times

...

Hayley

18 days ago

Option C is the way to go! Embedding the book list in the author item is like putting all your books on the same shelf - easy to find what you need.

upvoted 0 times

...

Carin

1 months ago

I don't know, man. Option D sounds like a recipe for a hot mess. Why would you want to cram both author and book data into a single container? That's just asking for trouble.

upvoted 0 times

Danica

3 days ago

C) Create 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.

upvoted 0 times

...

Ryan

6 days ago

B) Create 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.

upvoted 0 times

...

Maryln

21 days ago

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

upvoted 0 times

...

Rosendo

2 months ago

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

upvoted 0 times

...

Lenita

2 months 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

2 months 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

1 months ago

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

upvoted 0 times

...

Skye

1 months ago

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

upvoted 0 times

...

Gerry

2 months ago

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

upvoted 0 times

...

Altha

2 months 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

2 months ago

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

upvoted 0 times

...

Eric

2 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