The following is typical of many three-tier data warehouses:
A) Data marts are under the control of user departments
B) The data warehouse is under corporate control
C) The data marts and the data warehouse reside on different servers
D) All of the above

Question

Quizplus · Accepted Answer

A three-tier data warehouse typically includes a central data warehouse that is under corporate control and data marts that are created and managed by user departments. This allows for greater flexibility and autonomy for individual departments while still maintaining a central source of truth for the organization's data. Additionally, it is common for the data warehouse and the data marts to reside on different servers to optimize performance and manageability. Therefore, all of the options (A, B, and C) are correct.

The Following Is Typical of Many Three-Tier Data Warehouses