Which choice BEST captures the distinction between operational and non-operational databases?
Operational databases are OLTP systems built to support live business transactions, meaning they must update records (create, read, update, delete) in real time as events occur — for example, updating stock counts the instant a customer places an order. Non-operational databases, such as data warehouses, instead hold historical or aggregated data that is refreshed periodically (often through batch loads) and are optimized for analytical (OLAP) querying and reporting rather than immediate transactional updates. This makes real-time data updating the defining trait of operational databases, distinguishing them from non-operational systems.
Community Discussion