Lecture 2 Quiz

Question 1

emerged during the 1990s to support data analyses, rather than performing and recording on-line transactions

Answer 1

Multidimensional data models

Question 2

3 Important Application Areas of multidimensional data models

Answer 2

data warehousing, on-line analytical processing, data minkng

Question 3

a large repository of integrated data obtained from several sources in an enterprise for the specific purpose of data analysis

Answer 3

data warehouse

Question 4

performing queries that aggregate large amounts of detailed or granular data to find overall trends

Answer 4

on-line analytical processing

Question 5

semi-automatically discover unknown knowledge in large databases, often with multidimensional data

Answer 5

data mining

Question 6

a multidimensional data structure for capturing and analyzing data; can support multiple dimensions and hierarchies

Answer 6

cube

Question 7

help provide as much context to the data as possible; are used for selection and grouping of data at a desired level of detail

Answer 7

Dimensions

Question 8

objects that represent the subjects of the desired analyses or a business measure

Answer 8

Facts

Question 9

other types of facts

Answer 9

measureless facts, state facts

Question 10

3 relational representations of multidimensional models

Answer 10

star schema, snowflake schema, fact constellation

Question 11

a fact table surrounded by a set of dimension tables

Answer 11

star schema

Question 12

[T or F] Each row in the fact table is a measure while each row in the dimension table is an attribute of the dimension.

Answer 12

T

Question 13

a refinement of star schema where some dimensions are normalized to avoid redundancy

Answer 13

snowflake schema

Question 14

multiple fact tables sharing common or conformed dimension tables

Answer 14

fact constellation

Question 15

a collection of related cubes

Answer 15

data warehouse

Question 16

a subject-oriented, integrated, time variant, and non-volatile collection of data in support of management’s decision making process

Answer 16

data warehouse

Question 17

organized around major subjects, such as customer, product, and sales, that concern the business to allow easy analysis for them

Answer 17

subject-oriented

Question 18

constructed by integrating multiple, heterogeneous data sources

Answer 18

integrated

Question 19

the process of extracting data from different source systems, and transforming the data into an integrated format, and loading the data into the data warehouse

Answer 19

Extract-Transform-Load

Question 20

specifying exactly what an individual fact table row represents

Answer 20

declaring the grain

Question 21

answers the question “what are we measuring in this process?”

Answer 21

identifying facts