Question

A retail company's engineering team maintains two database systems. The first handles thousands of concurrent customer purchases per minute, with each transaction inserting or updating small amounts of data that must remain highly consistent. The second is queried by the analytics team, who run complex aggregations across years of historical sales to identify seasonal buying trends. Which statement correctly characterizes these two systems?

Accepted Answer

The first is an OLTP system optimized for fast writes and consistency; the second is an OLAP system optimized for complex read-heavy analytical queries.

Answer

The first is an OLAP system optimized for aggregations; the second is an OLTP system optimized for transaction integrity.

Answer

Both systems are OLTP because they both store sales data and serve business users.

Answer

The first is a data lake for raw ingestion; the second is an OLTP system for reporting.