Data Warehousing - Technical MCQs

Q1:

An operational system is which of the following?

A A system that is used to run the business in real time and is based on historical data.

B A system that is used to run the business in real time and is based on current data.

C A system that is used to support decision making and is based on current data.

D A system that is used to support decision making and is based on historical data.

ANS:B - A system that is used to run the business in real time and is based on current data.

An Operational System is a system that is used daily (perhaps constantly) to perform routine operations - part of the normal business processes.

An operational system is a term used in data warehousing to refer to a system that is used to process the day-to-day transactions of an organization. These systems are designed so processing of day-to-day transactions is performed efficiently and the integrity of the transactional data is preserved.