DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Data mining database servers.
|
|
|
Data warehouse database servers
|
|
|
Data mart database servers.
|
|
|
Relational data base servers.
|
Detailed explanation-1: -What is known as the heart of the warehouse? Answer-C) Data warehouse database servers are known as the hearth of the warehouse.
Detailed explanation-2: -Answer. B. data warehouse database servers.
Detailed explanation-3: -A data warehouse and a server farm are actually two separate things. Simply put, a data warehouse is a collection of data which is gathered from operational systems and external data sources. The main purpose of this system is to support business decisions by allowing data consolidation, analysis and reporting.
Detailed explanation-4: -A data warehouse is a central repository of information that can be analyzed to make more informed decisions. Data flows into a data warehouse from transactional systems, relational databases, and other sources, typically on a regular cadence.
Detailed explanation-5: -A database is any collection of data organized for storage, accessibility, and retrieval. A data warehouse is a type of database the integrates copies of transaction data from disparate source systems and provisions them for analytical use.