Microsoft Exam DP-420 Topic 5 Question 25 Discussion

Actual exam question for Microsoft's DP-420 exam

Question #: 25
Topic #: 5

You need to create a data store for a directory of small and medium-sized businesses (SMBs). The data store must meet the following requirements:

* Store companies and the users employed by them. Each company will have less than 1,000 users.

* Some users have data that is greater than 2 KB.

* Associate each user to only one company.

* Provide the ability to browse by company.

* Provide the ability to browse the users by company.

* Whenever a company or user profile is selected, show a details page for the company and all the related users.

* Be optimized for reading data.

Which design should you implement to optimize the data store for reading data?

AIn a directory container, create a document for each company and a document for each user. Use company ID as the partition key.

BIn a company container, create a document for each company. Embed the users into company documents. Use the company ID as the partition key.

CCreate a user container that uses the user ID as the partition key and a company container that container that uses the company ID as the partition key. Add the company ID to each user documents.

DIn a user container, create a document for each user. Embed the company into each user document. Use the user ID as the partition key.

Show Suggested Answer

Suggested Answer: A

by Louisa at Sep 02, 2023, 01:26 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Aracelis

4 days ago

I personally prefer option C because it keeps user and company data separate but still links them together.

upvoted 0 times

...

Norah

8 days ago

I disagree, I believe option B is more efficient as it embeds users into company documents for easier browsing.

upvoted 0 times

...

Cecil

11 days ago

I think option A is the best choice because it separates companies and users into different documents.

upvoted 0 times

...