Microsoft Exam DP-900 Topic 5 Question 93 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 93
Topic #: 5

What ate three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

Anormalized data

Bschema defined in a database

Cschema defined when reading unstructured data from a database

Dnormalized data

Elight writes and heavy reads

Fheavy writes and moderate reads

Show Suggested Answer

Suggested Answer: A, C, F

by Ligia at Sep 14, 2024, 11:20 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Gary

4 months ago

I believe E) light writes and heavy reads are also key characteristics of OLTP workloads.

upvoted 0 times

...

Lashaun

4 months ago

Ha! 'Heavy writes and moderate reads' - that's like a night at the casino for me. Gotta be A, B, and E.

upvoted 0 times

Kindra

3 months ago

Giovanna: So, A, B, and E it is!

upvoted 0 times

...

Rosio

3 months ago

And don't forget E) light writes and heavy reads.

upvoted 0 times

...

Vincent

3 months ago

Definitely E) light writes and heavy reads.

upvoted 0 times

...

Rory

3 months ago

Rory is correct. It's also B) schema defined in a database.

upvoted 0 times

...

Giovanna

3 months ago

I agree, and also B) schema defined in a database.

upvoted 0 times

...

Tom

3 months ago

I think it's A) normalized data.

upvoted 0 times

...

Leslie

4 months ago

I think it's A) normalized data.

upvoted 0 times

...

Skye

4 months ago

I agree with Magnolia, normalized data helps with efficient data storage and retrieval.

upvoted 0 times

...

Suzan

4 months ago

I'm not sure about C. Isn't that more for data warehousing and analytics? I'd go with A, B, and F.

upvoted 0 times

Ettie

3 months ago

Heavy writes and moderate reads also sound like characteristics of OLTP workloads.

upvoted 0 times

...

Olen

3 months ago

Normalized data and schema defined in a database make sense.

upvoted 0 times

...

Laticia

3 months ago

I agree, A, B, and F seem like the right choices.

upvoted 0 times

...

Tyra

4 months ago

I think C is more for data warehousing and analytics.

upvoted 0 times

...

Peggy

4 months ago

A, B, and E seem like the right choices to me. OLTP is all about fast, frequent transactions with minimal data processing.

upvoted 0 times

Carissa

4 months ago

Yes, OLTP is focused on quick, frequent transactions. A, B, and E cover the key characteristics needed for this type of workload.

upvoted 0 times

...

Annice

4 months ago

A, B, and E are indeed the correct choices. OLTP requires normalized data, a defined schema in a database, and light writes with heavy reads.

upvoted 0 times

...

Magnolia

4 months ago

I think A) normalized data is important for OLTP workloads.

upvoted 0 times

...