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.