Microsoft Exam DP-420 Topic 10 Question 45 Discussion

Actual exam question for Microsoft's DP-420 exam

Question #: 45
Topic #: 10

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 Marguerita at Aug 04, 2024, 05:55 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Sue

3 months ago

I agree with Titus, option A seems to be the most scalable and efficient solution for this scenario.

upvoted 0 times

...

Titus

3 months ago

But embedding a list of books in the author item might lead to performance issues when querying for individual books.

upvoted 0 times

...

Nadine

4 months ago

I disagree, I believe option C is better as it reduces the number of containers and simplifies the data model.

upvoted 0 times

...

Titus

4 months ago

I think option A is the best choice because it allows for a more efficient way to query the data.

upvoted 0 times

...

Martina

4 months ago

I don't know, man. What if the author publishes way more than 10 books? Wouldn't that make the embedded book list a performance nightmare? Maybe Option B is the way to go, even if it's a bit more work.

upvoted 0 times

Sherell

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

...

Marylyn

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

...

Delsie

4 months ago

I agree with Denny, option A seems like the most scalable and cost-effective solution for this scenario.

upvoted 0 times

...

Denny

4 months ago

But embedding the list of books in the author item could lead to performance issues with large datasets.

upvoted 0 times

...

Sabra

4 months ago

Ha! Reminds me of that classic exam question - 'Which data model gives me the least amount of work?' Classic Cosmos DB stuff. I'd have to go with Option C as well.

upvoted 0 times

...

Lashunda

4 months ago

Good point. Cosmos DB is all about optimizing for your access patterns. If you're really only dealing with up to 10 books per author, then Option C does seem like the winner here.

upvoted 0 times

Lonny

3 months ago

Good point. Cosmos DB is all about optimizing for your access patterns. If you're really only dealing with up to 10 books per author, then Option C does seem like the winner here.

upvoted 0 times

...

Kaycee

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

...

Joaquin

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

...

Yasuko

4 months ago

I disagree, I believe option C is better as it reduces the number of containers and simplifies the data model.

upvoted 0 times

...

Belen

4 months ago

Option C sounds like the way to go. Embedding the book list in the author item makes sense for the frequent queries and minimizes read costs.

upvoted 0 times

Jeniffer

3 months ago

That's true, having a single container with embedded lists could simplify the data model and make updates easier.

upvoted 0 times

...

Olive

3 months ago

But wouldn't it be easier to manage if everything is in one container with embedded lists?

upvoted 0 times

...

Lashawna

4 months ago

I agree, having two separate containers for authors and books could make queries more efficient.

upvoted 0 times

...

Otis

4 months ago

Option C sounds like the way to go. Embedding the book list in the author item makes sense for the frequent queries and minimizes read costs.

upvoted 0 times

...

Denny

4 months ago

I think option A is the best choice because it allows for efficient queries on both authors and books.

upvoted 0 times

...