CS Professional · Artificial Intelligence, Data Analytics and Cyber Security - Laws and Practice · Database Management
A retail company copies sales, inventory and customer data from its separate operational systems into one central repository. The data is cleaned, integrated and stored by subject and over time so that management can run trend analysis without slowing day-to-day transaction systems. What is this repository called?
The repository is a data warehouse. It integrates cleaned data from several operational systems, organises it by subject and keeps history over time, so management can analyse trends and support decisions without burdening the day-to-day transaction systems.
- AData warehouseCorrect
- BTransaction processing database
- CData dictionary
- DBackup server
Explanation
A data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data meant for analysis and decision support. A transaction processing database serves daily operations, not historical analysis. A data dictionary only holds metadata, and a backup server is for recovery.
Did you get it right without looking?
One question tells you little. A timed set on Database Management shows your real accuracy, how long you take and where you lose marks.
More Database Management questions
- A retail company stores customer data in separate flat files maintained by the sales, billing and delivery teams. The same customer's addres…
- In the three-schema architecture of a DBMS, which level describes how data is physically stored on disk, including file organisation and ind…
- A bank's database has entities Customer and Account. One customer may hold many accounts, but each account belongs to exactly one customer. …
- In a relational database table, a column (or set of columns) chosen to uniquely identify each row, which cannot hold NULL values and cannot …
- A telecom company handles huge call-record streams arriving at high speed, in text, audio and log formats, from many sources. Which set of c…
- A firm's database administrator runs a DELETE statement without a WHERE clause inside a transaction that has not been committed, then realis…