The Data Warehouse, Chapter 15

____ is a measurement of the density of the data held in the data cube.
1. Compactness
2. Concentration
3. Mass
4. Sparsity
____ are numeric measurements or values that represent a specific business aspect or activity.
1. Tables
2. Schemas
3. Facts
4. Attributes
When you ____ the data, you are aggregating the data to a higher level.
1. drill down
2. drill up
3. wrap up
4. roll up
The end user GUI might be a custom-made program or a plug-in module that is integrated with Lotus 123, Microsoft Excel, or other third party data ____ and query tools.
1. analysis
2. base
3. processing
4. integration
Decision ____ is a methodology designed to extract information from data and to use such information as a basis for decision making.
1. management
2. support
3. mining
4. analysis
Running the OLAP GUI on client workstations and the OLAP engine on a shared computer results in a more practical ____ than running both on the same computer.
1. interface
2. processing system
3. architecture
4. support system
____ is defined as "surroundings or atmosphere."
1. Architecture
2. Arrangement
3. Relational data
4. Environment
____ makes a copy of a table and places it in a different location, to improve access time.
1. Periodicity
2. Aggregation
3. Partitioning
4. Replication
Data cubes can grow to n-number of dimensions, thus becoming ____.
1. memory cubes
2. dimensional cubes
3. hypercubes
4. star data cubes
Client/server ____ provide(s) a framework within which new systems can be designed, developed, and implemented.
1. interfaces
2. architecture
3. processing
4. support
During the ____ phase of implementing a data warehouse, the designer must, among other tasks, identify and interview key users, define the main subjects, and identify the operational data model.
1. initial data gathering
2. design and mapping
3. loading and testing
4. rollout and feedback
During the data ____ phase of data mining, the main data sets to be used by the data mining operation are identified and cleansed of any data impurities.
1. analysis
2. preparation
3. classification
4. acquisition
Multidimensional data analysis is also affected by how the database system handles ____.
1. main memory
2. hypercubes
3. warehouses
4. sparsity
Multidimensional online analytical processing extends OLAP functionality to multidimensional ____ management systems.
1. online
2. database
3. processing
4. data
Many of the OLAP interface features are "borrowed" from previous generations of data ____ tools.
1. module
2. processing
3. filtering
4. analysis
____ are qualifying characteristics that provide additional perspectives to a given fact.
1. Views
2. Attributes
3. Dimensions
4. Tact tables
Using multidimensional jargon, the ability to focus on slices of the cube to perform a more detailed analysis is known as ____.
1. star cuts
2. slice and dice
3. microscoping
4. TPL processing
Given the importance and universality of this dimension from a data analysis perspective, many vendors have added automatic ____ dimension management features to their data warehousing products.
1. space
2. time
3. location
4. product
A ____ view is a dynamic table that contains not only the SQL query command to generate the rows, but also stores the actual rows.
1. structural
2. materialized
3. CUBE
4. rollup
MOLAP's premise is that ____ databases are best suited to manage, store, and analyze multidimensional data.
1. multidimensional
2. one-dimensional
3. two-dimensional
4. relational

The Data Warehouse, Chapter 15

Quiz