FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

DATA WAREHOUSING AND DATA MINING

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

The @active data warehouse architecture includes which of the following?

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: -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-3: -Three-tier architecture: The bottom tier, the database of the data warehouse servers. The middle tier, an online analytical processing (OLAP) server providing an abstracted view of the database for the end-user. The top tier, a front-end client layer consisting of the tools and APis used to extract data.

Detailed explanation-4: -A typical data warehouse often includes the following elements: A relational database to store and manage data. An extraction, loading, and transformation (ELT) solution for preparing the data for analysis. Statistical analysis, reporting, and data mining capabilities.

Detailed explanation-5: -The four characteristics of a data warehouse, also called features of a data warehouse, include SUBJECT ORIENTED, TIME VARIANT, INTEGRATED and NON-VOLATILE.

There is 1 question to complete.