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.
|
|
|
far real-time updates.
|
Detailed explanation-1: -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: -Real-time data warehousing enables organizations to consolidate data from different sources, extract insights from them and leverage them to make strategic business decisions faster. Organizations can refresh data from all business systems in the data warehouse in real-time and set reports to run on an as-needed basis.
Detailed explanation-4: -Operational Data Store (ODS) An ODS is refreshed in real-time, making it preferable for routine activities such as storing employee records.
Detailed explanation-5: -The Top-down approach stores the data first in the data warehouse, followed by the data marts. On the other hand, The Bottom-Up approach stores the data first in data marts followed by the data warehouse.