CS Professional · Artificial Intelligence, Data Analytics and Cyber Security - Laws and Practice · Database Management
A retail company in Pune copies sales, inventory and customer data from several operational systems into one central repository. The data is cleaned, integrated and stored by subject so that managers can run historical trend analysis. Which term best describes this repository?
The repository is a data warehouse. It integrates cleaned data from several operational systems, organises it by subject and keeps history, so managers can analyse trends. An operational transaction database instead supports routine day-to-day processing of current data.
- AData warehouseCorrect
- BTransaction processing database
- CCache memory
- DFirewall log
Explanation
A data warehouse is a subject-oriented, integrated, time-variant and non-volatile store built for analysis and decision support. A transaction processing database serves day-to-day operations and holds current data, not integrated history for analysis.
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 bank's employee, while a transaction updating a customer's balance is still uncommitted, is shown by another session a balance value that …
- In the ETL process used to populate a data warehouse, which activity is performed in the 'Transform' step?
- An e-commerce firm stores personal data of buyers. Its database designer finds that a Buyer table holds buyer name, city and also the city's…
- A bank encrypts the customer table in its database so that data files stolen from the server cannot be read without a key. This control main…
- A table EMP has 6 rows with salaries 20000, 30000, 30000, 40000, 50000 and NULL. Which of the following statements about the results is corr…
- An insurer's DBA wants staff in the claims department to see only the claim number, claimant name and claim status from a table that also ho…