DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
At least one data mart
|
|
|
Data that can extracted from numerous internal and external sources
|
|
|
Near real-time updates
|
|
|
All of the above.
|
Detailed explanation-1: -24. The generic two-level data warehouse architecture includes which of the following? Explanation: The generic two-level data warehouse architecture includes data that can extracted from numerous internal and external sources.
Detailed explanation-2: -Two-tier Data Warehouse Architecture A two-tier architecture includes a staging area for all data sources, before the data warehouse layer. By adding a staging area between the sources and the storage repository, you ensure all data loaded into the warehouse is cleansed and in the appropriate format.
Detailed explanation-3: -6 Extraction, Transformation, and Loading. Data warehouse systems use back-end tools and utilities to populate and refresh their data (Figure 4.1). These tools and utilities include the following functions: Data extraction, which typically gathers data from multiple, heterogeneous, and external sources.
Detailed explanation-4: -Data Extraction − Involves gathering data from multiple heterogeneous sources.
Detailed explanation-5: -Three tier architecture, the most popular type of data warehouse architecture, creates a more structured flow for data from raw sets to actionable insights.