Question

An online retail company runs a system where customers place orders throughout the day. Each order involves inserting a row, updating inventory counts, and confirming payment—all as a single unit of work that must either fully complete or fully roll back. The system processes thousands of these small, fast operations every minute. Which characteristic BEST describes this workload?

Accepted Answer

It is a transactional (OLTP) workload optimized for many small read/write operations with high data integrity

Answer

It is an analytical (OLAP) workload optimized for aggregating large volumes of historical data

Answer

It is a batch workload that processes data only during scheduled overnight windows

Answer

It is a streaming workload that continuously ingests unbounded telemetry from IoT sensors