DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -A data warehouse, meanwhile, is a centralized repository and information system that is used to develop insights and guide decision-making through business intelligence. A data warehouse stores summarized data from multiple sources, such as databases, and employs online analytical processing (OLAP) to analyze data.
Detailed explanation-2: -A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources.
Detailed explanation-3: -Answer-C) Reconcile data is the current data intended to be the single source for all decision support systems.
Detailed explanation-4: -Answer) c. The data warehouse does not replace the need for all other reporting systems within an organization. Rest all the statements are true as per the book => Decision Support and Business Intelligence Systems.