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.
Suggested Answer: C
Get Premium DP-900 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
37 comments · newest first
CH
Chantay
12 months ago
Light writes and heavy reads? Nah, that's more like OLAP.
CA
Cassi
12 months ago
Denormalized data? That's a bit surprising for OLTP workloads!
MA
Matthew
12 months ago
Wait, isn't it usually normalized data for OLTP?
AS
Asha
1 year ago
Totally agree, schema on write is key for OLTP.
DE
Deandrea
1 year ago
OLTP is all about heavy writes and moderate reads!
SO
Sommer
1 year ago
I’m a bit confused about the reads and writes balance. I thought OLTP had more reads, but maybe I’m mixing it up with OLAP?
GR
Gregoria
1 year ago
I practiced a question similar to this, and I think schema on write is definitely a characteristic, so I’d go with option D.
GW
Gwenn
1 year ago
I’m not entirely sure, but I feel like denormalized data could be relevant for OLTP. Maybe option A?
JA
Janae
1 year ago
I remember OLTP workloads typically involve heavy writes, so I think option B might be one of the answers.
JO
Jose
1 year ago
Let me think this through step-by-step. OLTP is about real-time, low-latency transactions, so the data model needs to support that. Denormalized data, heavy writes, and moderate reads - got it!
DO
Dong
1 year ago
I'm confident I can nail this. OLTP is the bread and butter of most business applications, so I know these characteristics well. Time to put that knowledge to use.
VI
Vinnie
1 year ago
Okay, I've got this. OLTP is all about fast, frequent transactions, so the focus should be on write-heavy operations and denormalized data for quick access.
JU
Justine
1 year ago
Hmm, I'm a bit unsure about the difference between schema on write and schema on read. I'll need to review those concepts quickly before answering.
SE
Serita
1 year ago
This looks like a straightforward question on OLTP workload characteristics. I'll focus on the key aspects like heavy writes, moderate reads, and denormalized data.
LA
Lasandra
1 year ago
I feel like there was a question similar to this, but I can't recall if we used getElementById or getElementsByTagName.
GW
Gwen
1 year ago
Hmm, I'm a bit unsure about how to approach this. I know earned value is involved, but I'm not confident I can calculate the schedule variance correctly.
BA
Basilia
2 years ago
What's an OLTP workload? Is that like a fitness routine for my database?
JA
Janella
2 years ago
Hold up, is this a trick question? I'm just going to guess B, D, and F and hope for the best.
RA
Raylene
1 year ago
User 3: I agree with Raylene, it's A, B, and F.
TA
Tawny
1 year ago
User 2: No, it's actually A, B, and F.
HY
Hyman
1 year ago
User 1: I think it's B, D, and F.
QU
Quentin
2 years ago
Hmm, I was sure C, E, and F were the right answers. But I guess I need to double-check my understanding of OLTP.
JO
Johana
1 year ago
Hildred: Sure, let's go over the characteristics of an OLTP workload.
HI
Hildred
1 year ago
User 2: Really? I thought it was C, E, and F. Let's review together.
MI
Mitsue
1 year ago
User 1: I think the correct answers are A, B, and D.
TI
Tijuana
2 years 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.
ME
Melvin
1 year ago
User 3: Absolutely, those are the key components for successful online transaction processing.
WA
Wade
2 years ago
User 2: I agree, heavy writes, schema on write, and normalized data are essential for OLTP.
JI
Jina
2 years ago
User 1: I think B, D, and F are the correct characteristics for OLTP workloads.
LI
Lizette
2 years ago
B, D, and F seem like the correct choices here. I need to review my notes on OLTP characteristics.
AR
Arlen
1 year ago
User 4: It's important to understand the characteristics to optimize performance.
BO
Bobbye
1 year ago
User 3: Denormalized data, schema on write, and normalized data are key for OLTP.
SU
Sunny
1 year ago
User 2: I agree, those characteristics make sense for OLTP workloads.
FR
France
2 years ago
User 1: I think B, D, and F are the correct choices.
TR
Tresa
2 years ago
I think normalized data is not a characteristic of OLTP workload, so F is not correct.
KA
Kami
2 years ago
I agree with Keva, but I also believe denormalized data is another characteristic.
KE
Keva
2 years ago
I think characteristics of OLTP workload include heavy writes and moderate reads.