CS Professional · Artificial Intelligence, Data Analytics and Cyber Security - Laws and Practice · Information Systems
Which of the following best describes a data warehouse as distinct from an operational (OLTP) database?
A data warehouse is a subject-oriented, integrated store of historical data drawn from several sources and used for analysis and reporting. This differs from an OLTP database, which is built for frequent small real-time transactions.
- AA system optimised for many small real-time inserts and updates of daily transactions
- BA subject-oriented, integrated repository of historical data from several sources, used mainly for analysis and reportingCorrect
- CA temporary cache that stores only the latest transaction
- DA backup copy that cannot be queried
Explanation
A data warehouse consolidates historical data from multiple sources for analytical querying and decision support. OLTP systems handle day-to-day transactions with frequent small updates. A warehouse is queried actively and is not just a backup or cache.
Did you get it right without looking?
One question tells you little. A timed set on Information Systems shows your real accuracy, how long you take and where you lose marks.
More Information Systems questions
- In an information system, which control is classified as a preventive control?
- A Mumbai-based retail company stores customer records in a table where each row represents one customer and the column 'CustomerID' uniquely…
- A Mumbai-based payments company wants to define the maximum amount of data loss, measured in time, that it can tolerate after a system failu…
- A Bengaluru fintech suffers a ransomware attack that encrypts its servers. Its backups are stored on a network drive permanently mounted to …
- A firm's database records an employee's department name and department head in every employee row, so changing a department head means editi…
- Aarav Textiles Ltd. keeps a fully equipped duplicate data centre in Pune with live data replication, so operations can switch over within mi…