Data Warehouse provides the best support for analysis while OLAP carries out the ..... task.

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]

Data Warehouse provides the best support for analysis while OLAP carries out the ____ task.

A	Mandatory
B	Whole
C	Analysis
D	Prediction

Explanation:

Detailed explanation-1: -The data warehouse supports on-line analytical processing (OLAP), the functional and performance requirements of which are quite different from those of the on-line transaction processing (OLTP) applications traditionally supported by the operational databases.

Detailed explanation-2: -Data Warehouse is the example of OLAP system. OLTP stands for On-Line Transactional processing. It is used for maintaining the online transaction and record integrity in multiple access environments. OLTP is a system that manages very large number of short online transactions for example, ATM.

Detailed explanation-3: -A data warehouse is an archive while OLAP is one of the technologies that analyze and evaluate its stored information. In a data warehouse, OLAP allows for fast querying and analysis of data from different perspectives. It also helps in pre-aggregating and pre-calculating the information available in the archive.

Detailed explanation-4: -Data warehousing and on-line analytical processing (OLAP) are essential elements of decision support, which has increasingly become a focus of the database industry. s. An OLAP system is market-oriented and is used for data analysis by knowledge workers, including managers, executives and analysts.

There is 1 question to complete.

FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

DATA WAREHOUSING AND DATA MINING