Mid-Term
Among the data warehouse applications, __ applications supports basic statistical analysis and reporting
information processing
The __ OLAP operation performs a selection on one dimension of the given cube
slice
Consider the 2-D data cube LOCATION RESOURCE Brazil 8,233 United States 3,069 Canada 2,902 China 2,840 Colombia 2,132 Which represents information on freshwater resources per country (in kms cubed). The cube contains the dimensions location and resource. The concept hierarchy for location is defined as the total order "country < continent." Which operation materializes the view provided below? LOCATION RESOURCE Canada 2,902 China 2,840
dice
in an outline transaction processing system, the typical unit of work is
A simple transaction
Which of the following is NOT a data warehosue?
A system that supports users in making decisions based on current data
Consider a data cube measure obtained by applying the mode() function. The measure is __
Holistic
A data mart__
IS a simpler data warehouse that contains data about specific group of users
It is often useful to summarize data by replacing low level values with higher concept elements, for example, an instructor may prefer to view students grades summarized by grade groups, say "passing" and "not passing." That process is known as __
data generalization
Among the data warehouse application, __ applications supports knowledge discovery.
data mining
Consider the 2-D data cube LOCATION RESOURCE Brazil 8,233 United States 3,069 Canada 2,902 China 2,840 Colombia 2,132 Which represents information on freshwater resources per country (in kms cubed). The cube contains the dimensions location and resource. The concept hierarchy for location is defined as the total order "country < continent." Which operation materializes the view provided below? LOCATION RESOURCE United States 3,069
slicing
In the __ schema some dimension tables are normalized, generating additional tables.
snowflake
Intuitively, the drill-down OLAP operation corresponds to concept__ in a concept hierarchy.
specialization
A form of dimensional modeling used in online analytical processing systems is the __
star schema
In the __ method, the process to design and construct a data warehouse is sequential, moving onto each phase only if the previous phase is complete
waterfall
A data warehouse is a __ collection of data in support of managements decision making process.
subject-oriented, integrated, time-variant, and nonvolatile
How many cuboids are there in a 5-dimensional data cube if there were no hierarchies associated to any dimension?
32 Formula is 2^N-Dimensions
Intuitively, the roll-up OLAP operation corresponds to concept__ in a concept hierarchy.
Ascension
__ describe or define warehouse elements
Metadata
Consider the 2-D data cube LOCATION RESOURCE Brazil 8,233 United States 3,069 Canada 2,902 China 2,840 Colombia 2,132 Which represents information on freshwater resources per country (in kms cubed). The cube contains the dimensions location and resource. The concept hierarchy for location is defined as the total order "country < continent." Which operation materializes the view provided below? LOCATION RESOURCE South America 10,365 North America 5,971 Asia 2,840
Roll-up
The __ OLAP operation performs aggregation on a data cube, either by climbing up a concept hierarchy for a dimension or by dimension reduction.
Roll-up
The bottom layer in a three-tier data warehouse architecture typically consists of __
a relational database system
Consider a data cube measure obtained by applying the average() function. The measure is ___.
algebraic
In attribute-oriented induction, data relevant to the task at hand is collected and then generalization is performed by either attribute generalization or__
attribute removal
Attribute-oriented induction is an alternative to the _____ approach for data
concept hierarchies
Consider a data cube measure obtained by applying the sum() function. The measure is __
distributive
Consider the 2-D data cube LOCATION RESOURCE South America 10,365 North America 5,971 Asia 2,840 Which represents information on freshwater resources per country (in kms cubed). The cube contains the dimensions location and resource. The concept hierarchy for location is defined as the total order "country < continent." Which operation materializes the view provided below? LOCATION RESOURCE Brazil 8,233 United States 3,069 Canada 2,902 China 2,840 Colombia 2,132
drill-down
The __ OLAP operation is realized by either stepping down a concept hierarchy for a dimension or introducing additional dimensions
drill-down
A major feature of a data warehouse is that__
is time variant
An advantage of the spiral method to design and construct a data warehouse is that__
modifications can be done quickly.