Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

What is the key difference between OLTP and OLAP workloads?

  1. A OLTP handles many small transactions; OLAP handles fewer large analytical queries
  2. B OLTP is used for reporting
  3. C OLAP is normalised for writes
  4. 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.

All Data Warehousing MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as