Module 4 Quiz

Given this table, which of the four columns does not illustrate a dimension?

D

In a star schema, most of the actual data rows are found in the ____.

fact table(s)

An example of a ____ operation would be a decision maker shifting their sales data focus from the daily to the quarterly level.

roll-up

In a ____ operation, one or more dimensions are set to specific values and the remaining data cube is displayed

slice

In a star schema, a ____ relationship connects from each of the outer tables to the central table(s).

1-to-M

Which of these is a disadvantage of providing data using a multidimensional cube instead of in relational tables?

storage space

Which of the following would not be an additive measure?

street numbers

Examples of ____ include a university that does not uniformly have departments in all of its constituent colleges or products that do not neatly fit in a category under analysis.

summarizability problems

Which of these is not an example of a dimension hierarchy?

Equipment: printer, copier, fax machine

A data cube is limited to three "sides" such as in the the textbook's Figure 13.1 which has "sides" Location, Product, and Time.

False

An advantage of using a time series is that many statistical functions can operate directly on time-series data.

True

In a star schema, the fact table(s) are in the center and the dimension tables are connected only to the fact table(s).

True

Sparsity in a data cube indicates the extent of empty cells.

True

In a ____ operation, a dimension is replaced with a subset of values of the dimension.

dice

In a ____ operation, users navigate from a more general level to a more specific level.

drill-down