Question

Which of the following factors drive the need for data warehousing?

A.Informational data must be kept together with operational data.
B.Reduce virus and Trojan horse threats.
C.Data warehouses generally have better security.
D.Businesses need an integrated view of company information.

Answer 1

A.Informational data must be kept together with operational data.

Step-by-step explanation:

• The data warehousing is an important system of business intelligence that is designed to integrate data into the one single place and is then uploaded from the operational systems such as marketing and sales, and has to pass through the data cleansing and depends on the use of the ETL tools to store the data that is transformed.

• It has certain benefits like the Integrate data from multiple sources, mitigate the problem of the database isolation, improved data quality, and make the decision support queries easier to handle.