CAP 4770 Intro Data Mining
Midterm exam questions
with verified solutions
Major distinguishing feature of an online analytical processing
system is that
A) access patterns consist of short atomic transactions
B)manages large amounts of historical data
C)is customer oriented
D) adopts an entity-relationship(ER) data model
B)manages large amounts of historical data
A data warehouse is a ________ collection of data in support of
management's decision making process.
A)subject oriented, integrated, time-invariant, and non volatile
B) subject-oriented, integrated, time-variant and nonvolatile
C)day-to-day oriented, integrated, time-variant and nonvolatile
D)subject-oriented, integrated, time-variant and volatile
B) subject-oriented, integrated, time-variant and nonvolatile
0:00
/
0:14
The bottom layer in a three-tier data warehouse architecture
typically consists of
A) server implemented using a ROLAP or MOLAP model
B) relational database system
C) analysis and API tools
D) client layer
B) relational database system
Consider a data cube measure obtained by applying the mode()
function. The measure is _______.
, A) Algebraic
B) Analytic
C) Distributive
D) Holistic
D) Holistic
In the ______ schema some dimension tables are normalized,
generating additional tables.
A) star
B) galaxy
C) data mart
D) snowflake
D) Snowflake
The ____ OLAP operation performs aggregation on a data cube,
either by climbing up a concept hierarchy for a dimension or by
dimension reduction
A) roll up
B) slice
C) drill-down
D) rotate
A) roll up
Intuitively, the roll up OLAP operation corresponds to concept ____ in
a concept hierarchy
A) forecasting
B) ascension
C) specialization
D) cooperation
B) Ascension
Among the data warehouse applications, ____ applications supports
basic statistical analysis and reporting.
A) information processing
B) star schema
C) data mining
D) analytical processing
Midterm exam questions
with verified solutions
Major distinguishing feature of an online analytical processing
system is that
A) access patterns consist of short atomic transactions
B)manages large amounts of historical data
C)is customer oriented
D) adopts an entity-relationship(ER) data model
B)manages large amounts of historical data
A data warehouse is a ________ collection of data in support of
management's decision making process.
A)subject oriented, integrated, time-invariant, and non volatile
B) subject-oriented, integrated, time-variant and nonvolatile
C)day-to-day oriented, integrated, time-variant and nonvolatile
D)subject-oriented, integrated, time-variant and volatile
B) subject-oriented, integrated, time-variant and nonvolatile
0:00
/
0:14
The bottom layer in a three-tier data warehouse architecture
typically consists of
A) server implemented using a ROLAP or MOLAP model
B) relational database system
C) analysis and API tools
D) client layer
B) relational database system
Consider a data cube measure obtained by applying the mode()
function. The measure is _______.
, A) Algebraic
B) Analytic
C) Distributive
D) Holistic
D) Holistic
In the ______ schema some dimension tables are normalized,
generating additional tables.
A) star
B) galaxy
C) data mart
D) snowflake
D) Snowflake
The ____ OLAP operation performs aggregation on a data cube,
either by climbing up a concept hierarchy for a dimension or by
dimension reduction
A) roll up
B) slice
C) drill-down
D) rotate
A) roll up
Intuitively, the roll up OLAP operation corresponds to concept ____ in
a concept hierarchy
A) forecasting
B) ascension
C) specialization
D) cooperation
B) Ascension
Among the data warehouse applications, ____ applications supports
basic statistical analysis and reporting.
A) information processing
B) star schema
C) data mining
D) analytical processing
