Question 1

A system that is used to support decision making based on stable,point-in-time or historical data is called a(n)________ system.

Accepted Answer

informational

Question 2

An enterprise data warehouse that accepts near-real time feeds of transactional data and immediately transforms and loads the appropriate data is called a real-time data warehouse.

Accepted Answer

A) True 
 B)False  True

Question 3

When we consider data in the data warehouse to be time-variant,we mean:

Accepted Answer

A)  that the time of storage varies. 
B)  data in the warehouse contain a time dimension so that they may be used to study trends and changes. 
C)  that there is a time delay between when data are posted and when we report on the data. 
D)  none of the above. 
A)  that the time of storage varies. 
B)  data in the warehouse contain a time dimension so that they may be used to study trends and changes. 
C)  that there is a time delay between when data are posted and when we report on the data. 
D)  none of the above. B

Question 4

A(n)________ data mart is filled exclusively from the enterprise data warehouse and its reconciled data.

Accepted Answer

The answer of A(n)________ data mart is filled exclusively from...

Question 5

An operational data store typically holds a history of snapshots of the state of an organization whereas an enterprise data warehouse does not typically contain history.

Accepted Answer

A) True 
 B)False

Question 6

What is data mining and what are its goals?

Accepted Answer

Data mining is knowledge discovery using

Question 7

Discuss the three-layer data architecture.

Accepted Answer

The three-layer data architecture descri

Question 8

What is the surrogate key rule for the Star schema and what are the main reasons for this rule?

Accepted Answer

Each and every key used to join the fact

Question 9

Rule discovery searches for patterns and correlations in large data sets.

Accepted Answer

A) True 
 B)False

Question 10

Explain a situation where multiple fact tables may be necessary.

Accepted Answer

Multiple fact tables are useful in situa

Question 11

A data warehouse of limited scope and size,fed by an enterprise data warehouse,is called a(n)________.

Accepted Answer

The answer of A data warehouse of limited scope and...

Question 12

A data mart is a data warehouse that contains data that can be used across the entire organization.

Accepted Answer

A) True 
 B)False

Question 13

Discuss the difference between transient data and periodic data.

Accepted Answer

Transient data are data in whi

Question 14

One characteristic of independent data marts is complexity for end users when they need to access data in separate data marts.This complexity is caused by not only having to access data from separate databases,but also from:

Accepted Answer

A)  the possibility of a new generation of inconsistent data systems, the data marts themselves. 
B)  lack of user training. 
C)  denormalized data. 
D)  incongruent data formats. 
A)  the possibility of a new generation of inconsistent data systems, the data marts themselves. 
B)  lack of user training. 
C)  denormalized data. 
D)  incongruent data formats.

Question 15

Rotating the view of a multidimensional database for a particular data point is called data:

Accepted Answer

A)  cubing. 
B)  drill-down. 
C)  dicing. 
D)  pivoting. 
A)  cubing. 
B)  drill-down. 
C)  dicing. 
D)  pivoting.

Question 16

Data visualization is the representation of data in ________ and ________ formats for human analysis.

Accepted Answer

graphical;

Question 17

An operational data store is typically a relational database and normalized,but it is tuned for decision-making applications.

Accepted Answer

A) True 
 B)False

Question 18

All of the following are ways to handle changing dimensions EXCEPT:

Accepted Answer

A)  overwrite the current value with the new value. 
B)  for each dimension attribute that changes, create a current value field and as many old value fields as we wish. 
C)  create a new dimension table row each time the dimension object changes. 
D)  create a snowflake schema. 
A)  overwrite the current value with the new value. 
B)  for each dimension attribute that changes, create a current value field and as many old value fields as we wish. 
C)  create a new dimension table row each time the dimension object changes. 
D)  create a snowflake schema.

Question 19

An operational data store (ODS)is not designed for use by operational users.

Accepted Answer

A) True 
 B)False

Question 20

All of the following are limitations of the independent data mart EXCEPT:

Accepted Answer

A)  separate extraction, transformation, and loading processes are developed for each data mart. 
B)  data marts may not be consistent with one another. 
C)  there is no capability to drill down into greater detail in other data marts. 
D)  it is often more expedient to build a data mart than a data warehouse. 
A)  separate extraction, transformation, and loading processes are developed for each data mart. 
B)  data marts may not be consistent with one another. 
C)  there is no capability to drill down into greater detail in other data marts. 
D)  it is often more expedient to build a data mart than a data warehouse.

A system that is used to support decision making based on stable,point-in-time or historical data is called a(n)________ system.

An enterprise data warehouse that accepts near-real time feeds of transactional data and immediately transforms and loads the appropriate data is called a real-time data warehouse.

When we consider data in the data warehouse to be time-variant,we mean:

A(n)________ data mart is filled exclusively from the enterprise data warehouse and its reconciled data.

An operational data store typically holds a history of snapshots of the state of an organization whereas an enterprise data warehouse does not typically contain history.

What is data mining and what are its goals?

Discuss the three-layer data architecture.

What is the surrogate key rule for the Star schema and what are the main reasons for this rule?

Rule discovery searches for patterns and correlations in large data sets.

Explain a situation where multiple fact tables may be necessary.

A data warehouse of limited scope and size,fed by an enterprise data warehouse,is called a(n)________.

A data mart is a data warehouse that contains data that can be used across the entire organization.

Discuss the difference between transient data and periodic data.

One characteristic of independent data marts is complexity for end users when they need to access data in separate data marts.This complexity is caused by not only having to access data from separate databases,but also from:

Rotating the view of a multidimensional database for a particular data point is called data:

Data visualization is the representation of data in and formats for human analysis.

An operational data store is typically a relational database and normalized,but it is tuned for decision-making applications.

All of the following are ways to handle changing dimensions EXCEPT:

An operational data store (ODS)is not designed for use by operational users.

All of the following are limitations of the independent data mart EXCEPT:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 9: Data Warehousing

A system that is used to support decision making based on stable,point-in-time or historical data is called a(n)________ system.

An enterprise data warehouse that accepts near-real time feeds of transactional data and immediately transforms and loads the appropriate data is called a real-time data warehouse.

When we consider data in the data warehouse to be time-variant,we mean:

A(n)________ data mart is filled exclusively from the enterprise data warehouse and its reconciled data.

An operational data store typically holds a history of snapshots of the state of an organization whereas an enterprise data warehouse does not typically contain history.

What is data mining and what are its goals?

Discuss the three-layer data architecture.

What is the surrogate key rule for the Star schema and what are the main reasons for this rule?

Rule discovery searches for patterns and correlations in large data sets.

Explain a situation where multiple fact tables may be necessary.

A data warehouse of limited scope and size,fed by an enterprise data warehouse,is called a(n)________.

A data mart is a data warehouse that contains data that can be used across the entire organization.

Discuss the difference between transient data and periodic data.

One characteristic of independent data marts is complexity for end users when they need to access data in separate data marts.This complexity is caused by not only having to access data from separate databases,but also from:

Rotating the view of a multidimensional database for a particular data point is called data:

Data visualization is the representation of data in ________ and ________ formats for human analysis.

An operational data store is typically a relational database and normalized,but it is tuned for decision-making applications.

All of the following are ways to handle changing dimensions EXCEPT:

An operational data store (ODS)is not designed for use by operational users.

All of the following are limitations of the independent data mart EXCEPT:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Data visualization is the representation of data in and formats for human analysis.