Data marts, databases, and data warehouses have distinct characteristics. Which of the following does not correctly describe a data warehouse?

A.
It could increase the risk of privacy violations.

B.
It is developed to carry out analysis.

C.
It contains data from several different sources.

D.
It is created and used for project-based tactical reasons.

Explanation:
D: A data warehouse is not commonly created and used for project-based tactical reasons. That description is characteristic of a data mart, which is a portion of a database that is
used for a short period of time mainly for projects to determine tactical approaches to a problem. A data warehouse, on the other hand, is created for the purpose of conducting data
mining and analysis for strategic reasons.
A is incorrect because data warehouses could increase the risk of privacy violations considering that data is collected from several different sources and is held in one central
location (the warehouse). Although this provides easier access and control, because the data warehouse is in one place, it also requires more stringent security. If an intruder got into
the data warehouse, she could access all of the company’s information at once.
B is incorrect because the statement is true; data warehouses are commonly created for the purpose of analysis. The analysis allows for strategic decisions to be made, for
example, those related to business trends, fraudulent activities, or marketing effectiveness. The analysis work is commonly carried out through data mining activities.
C is incorrect because a data warehouse does contain data from several different sources. Data is extracted from different databases and other data locations, transferred to a
central data storage place called a warehouse, and normalized. This enables users to query a single entity rather than accessing and querying different data sources, and allows for
more efficient information retrieval and data analysis