Exam DP-900 topic 1 question 146 discussion

B: Transactional data tends to be heavy writes, moderate reads. D: Typical traits of transactional data include: schema on write, strongly enforced What is Schema On Write Schema on write is defined as creating a schema for data before writing into the database. If you have done any kind of development with a database you understand the structured nature of Relational Database(RDBMS) because you have used Structured Query Language (SQL) to read data from the database. F: Transactional data tends to be highly normalized. Reference Online transaction processing (OLTP) https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing

B,D,F are correct

Almost duplicate of #159 Anyway B,D,F are correct

Reading resource from below link, there is a table for the characteristics https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing Normalization--Highly normalized Schema--Schema on write, strongly enforced Workload--Heavy writes, moderate reads

To all of us who voted D-E-F: E is completely wrong. Schema of read is feature of no-sql databases

moderate reads - not necessarily and not relevant; but schema is there and is used

D, E, F; moderate reads - not necessarily and not relevant; but schema is there and is used

Correct: Explanation: B: Transactional data tends to be heavy writes, moderate reads. D: Typical traits of transactional data include: schema on write, strongly enforced F: Transactional data tends to be highly normalized. Reference: https://examposter.com/what-are-three-characteristics-of-an-online-transaction-processing-oltp-workload-each-correct-answer-presents-a-complete-solution-choose-three/

BDF is right

BDF is correct