Microsoft Exam DP-420 Topic 1 Question 42 Discussion

Actual exam question for Microsoft's DP-420 exam

Question #: 42
Topic #: 1

You have a container m an Azure Cosmos DB for NoSQL account. The container stores data about families. Data about parents, children, and pets are stored as separate documents.

Each document contains the address of each family. Members of the same family share the same partition key named family Id

You need to update the address for each member of the same family that share the same address. The solution must meet the following requirements:

* Be atomic consistent isolated, and durable (ACID).

* Provide the lowest latency.

What should you do?

AUpdate the document of each family member by using a transactional batch operation.

BUpdate the document of each family member separately by using a patch operation.

CUpdate the document of each family member separately and set the consistency level to strong.

Show Suggested Answer

Suggested Answer: A

by Abraham at Jul 02, 2024, 12:23 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Stacey

3 months ago

I love how they sneak in that 'lowest latency' requirement. Very sneaky, Azure Cosmos DB. Option A gets my vote.

upvoted 0 times

...

Sherrell

3 months ago

Option C seems like overkill. Strong consistency is great, but do we really need it for a simple address update? A is the clear winner here.

upvoted 0 times

Miesha

2 months ago

B) Definitely, it's the most efficient way to update the address for each family member.

upvoted 0 times

...

Janessa

2 months ago

A) It's the best option for updating multiple documents with the same partition key.

upvoted 0 times

...

Kate

2 months ago

B) I agree, using a transactional batch operation ensures atomicity and consistency.

upvoted 0 times

...

Lewis

2 months ago

A) Update the document of each family member by using a transactional batch operation.

upvoted 0 times

...

Cordelia

3 months ago

That's a good point, Elizabeth. However, using a transactional batch operation would provide the lowest latency as well.

upvoted 0 times

...

Elizabeth

3 months ago

But wouldn't updating the document of each family member separately with strong consistency also meet the requirements?

upvoted 0 times

...

Karan

3 months ago

I agree with Cordelia. Using a transactional batch operation ensures atomicity and consistency.

upvoted 0 times

...

Annmarie

4 months ago

I was leaning towards option B, but the requirement for low latency makes me think A might be the better choice. Batched operations should be faster.

upvoted 0 times

Kiley

3 months ago

C) Setting the consistency level to strong might also help ensure data integrity.

upvoted 0 times

...

Iluminada

3 months ago

A) Definitely, using a transactional batch operation ensures atomicity and consistency.

upvoted 0 times

...

Xochitl

3 months ago

B) I agree, batch operations are usually faster and would meet the low latency requirement.

upvoted 0 times

...

Katheryn

3 months ago

A) Update the document of each family member by using a transactional batch operation.

upvoted 0 times

...

Cordelia

4 months ago

I think we should update the document of each family member by using a transactional batch operation.

upvoted 0 times

...

Lucy

4 months ago

Hmm, I think option A is the way to go. Updating all family members in a single transaction seems like the best way to ensure ACID compliance.

upvoted 0 times

Caprice

3 months ago

Updating all family members in a single transaction does seem like the most efficient way to go.

upvoted 0 times

...

Thomasena

3 months ago

I agree, option A is the best choice for ACID compliance.

upvoted 0 times

...

Darnell

4 months ago

Updating all family members in a single transaction does seem like the most efficient way to go.

upvoted 0 times

...

Lavina

4 months ago

I agree, option A is the best choice for ACID compliance.

upvoted 0 times

...