OLAP

Fill in the blank: A data warehouse is a _____ database specifically tailored for query and _____. a) relational ... analysis b) relational ... processing c) traditional ... analysis d) traditional ... processing

A

Using a Data Warehouse, what are the two approaches to data organization that are used? a) Dimensional & Normalized b) Dimensional & De-normalized c) Consolidation & Normalized d) Consolidation & De-normalized

A

Who realized the need for for businesses to have data warehouses? a) Bill Inmon b) Bill Gates c) Ralph Kimball d) McLovin

A

In what year was the first OLAP product released? a) 1965 b) 1975 c) 1980 d) 1985

B

Using a data warehouse, in order to aggregate data (going from more detailed to less detailed) one would perform which operation? a) RollDown b) RollUp c) Slicing d) Dicing

B

Which system would be best to use for a revenue analysis? a) OLAP system with a transactional database b) OLAP system with a data warehouse c) OLTP system with a transactional database d) OLTP system with a data warehouse

B

What is a downside of using a cube to store data? a) It returns results slowly b) It cannot sort data c) A lot of memory is used to store a cube d) There is no downside

C

Which of these statements is true​? a) Data warehouses use multiple databases to perform transactional processing b) Databases use multiple data warehouses to perform analytical processing c) Data warehouses use multiple databases to perform analytical processing d) Databases use multiple data warehouses to perform transactional processing

C

"Slicing and dicing" utilizes a ____ in order to select a set of data along a _____ or _____. a) Cube ... dimensional ... multidimensional database. b) Data warehouse ... row ... column. c) OLAP system ... slice ... dice. d) Cube ... single ... multiple dimensions.

D

What does OLAP stand for? a) Object List Association Processing b) Online Arithmetic Processing c) Operator Language Analysis Processing d) Online Analytical Processing

D