Which one of the following applications/activities is typical of a data warehouse?
A) Updating of the inventory data as the sales occur in the supermarket
B) Comparing last year sales with this year sales to identify the most promising product
C) Looking at sales this month to identify the most valuable salesperson of the month
D) Reviewing last month customer accounts to prepare overdue notices

Question

Quizplus · Accepted Answer

Comparing last year sales with this year sales to identify the most promising product is typical of a data warehouse because it involves analyzing historical data to make business decisions. Data warehouses are designed to store and analyze large amounts of historical data for decision making purposes.

The other options are not typical of a data warehouse. A is an example of real-time updating of transactional data in an operational database. C is an example of analyzing current data to make decisions and does not require historical data analysis. D is an example of a business process related to accounts receivable and does not involve data analysis.

Which One of the Following Applications/activities Is Typical of a Data