Data Warehousing and OLAP
What is a cuboid?: -Data cube itself -A part of data cube which gives a level of summarization of data -a smaller version of a data cube -A larger data cube
A part of data cube which gives a level of summarization of data
Which of the following is NOT true about OLAP Server Architectures? -HOLAP (HYBRID online analytical processing) server combines ROLAP and MOLAP benefitting from the greater scalability of ROLAP and the faster computation of MOLAP -MOLAP server maps multidimensional data views directly to array structures -ROLAP server uses an extended relational DBMS that maps OLAP operations on multidimensional data to standard relational operations -The advantage of using a data cube in MOLAP is that it allows fast indexing to precomputed summarized data -All of the above
All of the above
Which type of data models are used by databases configured for OLAP?" -Two dimensional -Multi-dimensional -imte-dimensional -single dimensional
Multi-dimensional
OLAP stands for: -Online transaction processing -online aggregate processing -online application processing -online analytical processing
Online analytical processing
___ operation of OLAP provides alternate presentation of data by rotating it: -Slice -pivot -rollup -dice
Pivot
The operation of moving from finer-granularity data to a coarser granularity (by means of aggregation) is called a ___ -Drill down -dicing -pivoting rollup
Rollup
What are facts in DW? -data attributes -boolean values -numeric measures -data types
numeric measures
What are dimensions in Data Warehouses (DW)?: -perspective of records -data -different values of records -reference of data
perspective of records
Which of the following is NOT true about Data Warehousing?: -Use star scema, snowflake schema, or fact constellations -a data cube consists of dimensions and measures -single-dimensional model is used typically for the design of a data warehouse -provides OLAP operations eg. drilling, rolling, slicing, dicing, and pivoting -the construction of data warehouses involves data cleaning, data integration, and data transformartion
single-dimensional model is used typically for the design of a data warehouse
W.H. Inmon said "A data warehouse is a ___, ___, ___, and ___ colection of data in support of management's decision making process." Which of the following is correct: -subject oriented, integrated, nonvolatile, time-variant -consolidated, historical, big, aggregated -subject-oriented, integrated, time-variant, volatile -collected, summarized, visualized, time-sensitive
subject oriented, integrated, nonvolatile, time-variant
