Question

Which of the following statements about data warehousing is FALSE?

Select one:

a.

Investing in building a data warehouse allows managers access to integrated data while planning to re-write legacy applications

b.

A data warehouse is read-only data to support trends analysis and discovery, forecasting and decision making

c.

Data in a data warehouse is periodically (perhaps nightly) updated from legacy production systems/applications

d.

Real-time transaction data is updated in legacy production systems

e.

All of the above statements are true

Answer 1

Ans e

All the statements are true. The real time transaction data gets uploaded in the legacy production system. Usually once a day, data from the legacy production system gets transferred to data warehouse. The data warehouse is the read only data for managers which help to support the decision making, understand forecast and carry out trend analysis. The main advantage of data warehouse is that it allows managers to collaborate and integrate data from different sources and take decisions for business.