What are 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
B.
heavy writes and moderate reads
C.
light writes and heavy reads
D.
schema defined in a database
E.
schema defined when reading unstructured data from a database
OK, first, a terrible question with no real right answers. Transactions (updates) tend to be lots of writes and fewer reads and writes are more expensive because of ACID: so B with "heavy writes and light reads" (whatever "heavy" and "light" mean here and it's terminology that isn't used in the current DP-900). But, in fact, overall OLTP systems tend to have more reads than writes -- we look up more data than we change. Most of the other aswers relate to structured data, not to OLTP system -- semi-structured data is also used for OLTP (in fact, for online applications processing lots of transactions per seconds). Transactions/ACID still matters even in semi-structured database: You don't want to write out half a JSON document, for example...I suppose we could call what happens with semi-structured data, OLP. But the question confuses structured data with OLTP which are two different things and, I bet, this question is no longer in the exam pool.
This section is not available anymore. Please use the main Exam Page.DP-900 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
JA2018
Highly Voted 2 years agobfan95
Highly Voted 2 years, 6 months agoAGTraining
Most Recent 7 months, 4 weeks agophvogel
1 year, 3 months agoRajivjain
1 year, 4 months agoravick4u
1 year, 8 months agoBreeze21
2 years, 3 months agoMern
2 years, 4 months ago