MENU
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.
Suggested Answer: A, B, F
Get Premium DP-900 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
13 comments · newest first
BE
Belen
11 months ago
Denormalized data? Really? That seems off for OLTP.
JO
Josphine
11 months ago
Light writes and heavy reads are definitely a characteristic.
JO
Josefa
12 months ago
Wait, I thought OLTP was all about heavy writes?
LO
Lou
12 months ago
Totally agree, normalized data is key for OLTP!
WI
Wilda
1 year ago
OLTP usually has a schema defined in a database.
BA
Barrett
1 year 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.
RO
Roselle
1 year ago
I feel like denormalized data could be a characteristic, but I can't recall if it applies specifically to OLTP or not.
PE
Peggy
1 year ago
I remember practicing a question about OLTP that mentioned heavy writes and moderate reads. That might be relevant here.
NA
Nakita
1 year ago
I think OLTP workloads usually involve normalized data, but I'm not completely sure if that's always the case.
BE
Bernadine
1 year 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.
WH
Whitney
1 year 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.
JI
Jiviify
4 years ago
BDF.
OLTP data is Normalized, In Data Warehousing its De-Normalized
JI
Jiviify
4 years ago
BDF