OLAP that is based on relational data that comes from data sources that use RDBMS and also stores data in relational form is called

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]

A	HELLO
B	ROLAP
C	MOLAP
D	Dedicated SQL Server

Explanation:

Detailed explanation-1: -ROLAP, or relational OLAP, is multidimensional data analysis that operates directly on data on relational tables, without first reorganizing the data into a cube.

Detailed explanation-2: -There are three main types of OLAP: MOLAP, HOLAP, and ROLAP. These categories are mainly distinguished by the data storage mode. For example, MOLAP is a multi-dimensional storage mode, while ROLAP is a relational mode of storage.

Detailed explanation-3: -Relational OLAP ROLAP servers are placed between relational back-end server and client front-end tools. To store and manage warehouse data, ROLAP uses relational or extended-relational DBMS.

Detailed explanation-4: -Analysis Services. Online analytical processing (OLAP) is a technology that organizes large business databases and supports complex analysis. It can be used to perform complex analytical queries without negatively affecting transactional systems.

There is 1 question to complete.

FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

DATA WAREHOUSING AND DATA MINING