Microsoft Exam DP-900 Topic 4 Question 84 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 84
Topic #: 4

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.)

NOTE: Each correct selection is worth one point.

Adenormalized data

Bheavy writes and moderate reads

Clight writes and heavy reads

Dschema on write

Eschema on read

Fnormalized data

Show Suggested Answer

Suggested Answer: C

by Galen at Jun 23, 2024, 07:54 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

2 days ago

Ah, finally a question I can ace! B, D, and F are the keys to OLTP success. Time to show off my database expertise.

upvoted 0 times

...

9 days ago

B, D, and F seem like the correct choices here. I need to review my notes on OLTP characteristics.

upvoted 0 times

...

23 days ago

I think normalized data is not a characteristic of OLTP workload, so F is not correct.

upvoted 0 times

...

23 days ago

I agree with Keva, but I also believe denormalized data is another characteristic.

upvoted 0 times

...

25 days ago

I think characteristics of OLTP workload include heavy writes and moderate reads.

upvoted 0 times

...