Deck 6: The Data Warehouse

Question 1

The purpose of an intersection entity is to replace

A) two one-to-one relationships with a one-to-many relationship
B) two one-to-many relationships with one many-to-many relationship
C) a many-to-many relationship with two one-to-many relationships
D) a one-to-many relationship with two one-to-one relationships

Answer 1

C

Question 2

Defines each dimension of the multidimensional space of a star schema.

A) ELT table
B) dimension table
C) fact table
D) decision table

Answer 2

C

Question 3

Use the OLAP cube to answer questions 10 through 12. Each cell of the cube contains a dollar amount representing total dollars spent for the specified time, region and category.

Which of the following is an example of a dice operation?

A) Which region shows the smallest amount of total dollars spent on restaurant and travel for all quarters?
B) Select all cells where time=Q1 or Q2.
C) Provide a spreadsheet of category and region information for Q1.
D) Select all cells where category = travel, vehicle or retail.

Answer 3

A

Question 4

A variation of the star schema that allows more than one central fact table.

A) snowflake schema
B) linked strar schema
C) distributed star schema
D) constellation schema

Question 5

A one-to-many relationship.

A) brother-sister
B) father-son
C) uncle-nephew
D) teacher-student

Question 6

Operational databases are designed to support _____ whereas decision support systems are design to support __________.

A) transactional processing, data analysis
B) data analysis, transactional processing
C) independent data marts, dependent data marts
D) dependent data marts, independent data marts

Question 7

This process removes redundancies that may be present in a data model.

A) abstraction
B) granularization
C) standardization
D) normalization

Question 8

Use the OLAP cube to answer questions 10 through 12. Each cell of the cube contains a dollar amount representing total dollars spent for the specified time, region and category.

Consider the OLAP cube shown above. The vertical arrow points to:

A) region four, travel
B) region two, travel
C) Q2, travel
D) Q1, travel

Question 9

The level of detail of the information stored in a data warehouse.

A) granularity
B) scope
C) functionality
D) level of query

Question 10

Which of the following is not a primary function of a decision support system?

A) knowledge discovery
B) reporting data
C) processing data
D) analyzing data

Question 11

Use the OLAP cube to answer questions 10 through 12. Each cell of the cube contains a dollar amount representing total dollars spent for the specified time, region and category.

A mapping that allows the attributes of an OLAP cube to be viewed from varying levels of detail.

A) reflection
B) concept hierarchy
C) rotation
D) semantic network Answers to Chapter 6 Questions
Multiple Choice Questions

Question 12

Which of the following is not a characteristic of a data warehouse?

A) contains nonvolatile data
B) is subject oriented
C) supports data processing, collection and management
D) stores data to be reported on, analyzed and tested

Question 13

Use the OLAP cube to answer questions 10 through 12. Each cell of the cube contains a dollar amount representing total dollars spent for the specified time, region and category.

Which of the following is not an example of a slice operation?

A) Select all cells where purchase category = retail.
B) Select all cells where purchase category = retail or vehicle.
C) Provide a spreadsheet of quarter and region information for all cells pertaining to restaurant.
D) Identify the region of peak travel expenditure for each quarter.