DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The following are layers in the data warehouse architecture, except
|
|
Data Directory Layer
|
|
|
Presentation Layer
|
|
|
Data Staging Layer
|
|
|
Answers A and C are wrong
|
Explanation:
Detailed explanation-1: -The three-tier architecture consists of the source layer (containing multiple source system), the reconciled layer and the data warehouse layer (containing both data warehouses and data marts). The reconciled layer sits between the source data and data warehouse.
Detailed explanation-2: -ETL stands for Extract, Transform, and Load.
Detailed explanation-3: -A typical data warehouse has four main components: a central database, ETL (extract, transform, load) tools, metadata, and access tools.
There is 1 question to complete.