The advantage of three-tier architecture for data warehousing is its separation of the functions of the data warehouse,which eliminates resource constraints and makes it possible to easily create data ________.
A) banks
B) cubes
C) bases
D) marts

Question

Quizplus · Accepted Answer

The best choice is D) marts. Three-tier architecture for data warehousing separates the functions of the data warehouse into three layers: the bottom layer is the data source layer, the middle layer is the data warehouse layer, and the top layer is the data access layer. By separating these functions, it becomes easier to create data marts, which are subsets of the data warehouse optimized for specific business functions, departments or users. This allows for easier access to the data and eliminates resource constraints.

The Advantage of Three-Tier Architecture for Data Warehousing Is Its