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