a) Two dimensional cube
Explanation:
Each cell in the cube is identified for the values for the three dimensional attributes.
The process of viewing the cross-tab (Single dimensional) with a fixed value of one attribute is. a) Slicing b) Dicing c) Pivoting d) Both a and b
OLAP stands for a) Online analytical processing b) Online analysis processing c) Online transaction processing d) Online aggregate processing
It is because of __________ that enables OLAP to achieve great performance for a query. a) Aggregation b) Composition c) Dice d) Hybrid
_____operation of OLAP provides alternate presentation of data by rotating it. a) Slice b) Roll up c) Dice d) Pivot
What is the source of the OLAP cube's metadata? a) Star schema b) Snow flake schema c) Both a and b d) Database
Aggregations are built from the _________________ by changing the granularity on specific dimensions. a) Both c and d below b) schema c) Dimension table d) Fact table
Can the user perform data-entry or editing tasks on OLAP data? a) Yes b) No
Following are three steps in random order for creating a data cube. 1. Chose a data source. Create the query that extracts data from the database. Create the cube from the extracted data. a) 1,2,3 b) 2,1,3 c) 3,2,1 d) 3,1,2
Dice operation is also known as rotate. a) True b) False
The output of an OLAP query is displayed as a a) Matrix b) Pivot c) Both a and b d) excel
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
