DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
____ operation of OLAP provides alternate presentation of data by rotating it
|
|
Slice
|
|
|
Roll up
|
|
|
Dice
|
|
|
Pivot
|
Explanation:
Detailed explanation-1: -Pivot. The pivot operation is also known as rotation. It rotates the data axes in view in order to provide an alternative presentation of data.
Detailed explanation-2: -The pivot operation is also called a rotation. Pivot is a visualization operations which rotates the data axes in view to provide an alternative presentation of the data.
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.
There is 1 question to complete.