What is the key difference between OLTP and OLAP workloads?
- A OLTP handles many small transactions; OLAP handles fewer large analytical queries
- B OLTP is used for reporting
- C OLAP is normalised for writes
- D There is no difference
Answer
OLTP handles many small transactions; OLAP handles fewer large analytical queries
OLTP is normalised and write-optimised. OLAP is denormalised, often column-oriented, and optimised for scanning and aggregation.





