FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

DATA WAREHOUSING AND DATA MINING

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The active data warehouse architecture includes ____
A
at least one data mart.
B
data that can extracted from numerous internal and external sources.
C
near real-time updates.
D
all of the above.
Explanation: 

Detailed explanation-1: -It contains at least one data mart. In an active data warehouse, data that can extracted from numerous internal and external sources. The data warehouse always gets near real-time updates i.e. the data is being updated constantly as and when it happens.

Detailed explanation-2: -There are mainly 5 components of Data Warehouse Architecture: 1) Database 2) ETL Tools 3) Meta Data 4) Query Tools 5) DataMarts.

Detailed explanation-3: -Data Warehouses usually have a three-level (tier) architecture that includes: Bottom Tier (Data Warehouse Server) Middle Tier (OLAP Server) Top Tier (Front end Tools).

Detailed explanation-4: -data that can extracted from numerous internal and external sources.

Detailed explanation-5: -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.
Previous
Next