Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-900 Exam - Topic 11 Question 50 Discussion

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.
A) denormalized data and B) schema defined in a database and F) heavy writes and moderate reads
C) schema defined when reading unstructured data from a database
D) normalized data
E) light writes and heavy reads

Microsoft DP-900 Exam - Topic 11 Question 50 Discussion

Actual exam question for Microsoft's DP-900 exam
Question #: 50
Topic #: 11
[All DP-900 Questions]

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.

Show Suggested Answer Hide Answer
Suggested Answer: A, B, F

by Willard at Aug 02, 2022, 07:07 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Belen
10 months ago
Denormalized data? Really? That seems off for OLTP.
upvoted 0 times
...
Josphine
10 months ago
Light writes and heavy reads are definitely a characteristic.
upvoted 0 times
...
Josefa
10 months ago
Wait, I thought OLTP was all about heavy writes?
upvoted 0 times
...
Lou
10 months ago
Totally agree, normalized data is key for OLTP!
upvoted 0 times
...
Wilda
10 months ago
OLTP usually has a schema defined in a database.
upvoted 0 times
...
Barrett
11 months ago
I'm pretty certain that OLTP has a defined schema in the database, but I’m confused about the difference between that and unstructured data.
upvoted 0 times
...
Roselle
11 months ago
I feel like denormalized data could be a characteristic, but I can't recall if it applies specifically to OLTP or not.
upvoted 0 times
...
Peggy
11 months ago
I remember practicing a question about OLTP that mentioned heavy writes and moderate reads. That might be relevant here.
upvoted 0 times
...
Nakita
11 months ago
I think OLTP workloads usually involve normalized data, but I'm not completely sure if that's always the case.
upvoted 0 times
...
Bernadine
11 months ago
Hmm, the order of the steps is tricky. I'll need to carefully review each option to make sure I don't miss anything.
upvoted 0 times
...
Whitney
11 months ago
I'm a little confused by the wording of this question. It's asking about "the correct security roles," but there could be multiple valid sets of roles. I'll have to carefully consider each option to determine the best answer.
upvoted 0 times
...
Jiviify
4 years ago
BDF. OLTP data is Normalized, In Data Warehousing its De-Normalized
upvoted 1 times
...
Jiviify
4 years ago
BDF
upvoted 1 times
...

Save Cancel