Question 1

Discuss the limitations of the independent data mart architecture.

Accepted Answer

There are several limitations to the ind

Question 2

Which of the following factors drive the need for data warehousing?

Accepted Answer

A)  Businesses need an integrated view of company information. 
B)  Informational data must be kept together with operational data. 
C)  Data warehouses generally have better security. 
D)  None of the above 
A)  Businesses need an integrated view of company information. 
B)  Informational data must be kept together with operational data. 
C)  Data warehouses generally have better security. 
D)  None of the above

Question 3

A ________ data mart is created by a relation view of a data warehouse.

Accepted Answer

The answer of A ________ data mart is created by...

Question 4

The ________ schema is an expanded version of a star schema in which dimension tables are normalized into several related tables.

Accepted Answer

The answer of The ________ schema is an expanded version...

Question 5

Analyzing a given set of data at a finer level of detail is called ________.

Accepted Answer

The answer of Analyzing a given set of data at...

Question 6

Advances in computer hardware,particularly the emergence of affordable mass storage and parallel computer architectures,was one of the key advances that led to the emergence of data warehousing.

Accepted Answer

A) True 
 B)False

Question 7

Operational metadata are derived from the enterprise data model.

Accepted Answer

A) True 
 B)False

Question 8

Informational systems are designed to support decision making based on historical point-in-time and prediction data.

Accepted Answer

A) True 
 B)False

Question 9

A star schema contains both fact and ________ tables.

Accepted Answer

A)  narrative 
B)  cross functional 
C)  dimension 
D)  starter 
A)  narrative 
B)  cross functional 
C)  dimension 
D)  starter

Question 10

Going from a summary view to progressively lower levels of detail is called data:

Accepted Answer

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

Question 11

All of the following are unique characteristics of a logical data mart EXCEPT:

Accepted Answer

A)  logical data marts are not physically separate databases, but rather a relational view of a data warehouse. 
B)  the data mart is always up-to-date since data in a view is created when the view is referenced. 
C)  the process of creating a logical data mart is lengthy. 
D)  data are moved into the data warehouse rather than a separate staging area. 
A)  logical data marts are not physically separate databases, but rather a relational view of a data warehouse. 
B)  the data mart is always up-to-date since data in a view is created when the view is referenced. 
C)  the process of creating a logical data mart is lengthy. 
D)  data are moved into the data warehouse rather than a separate staging area.

Question 12

What are some approaches to handling slowly changing dimensions?

Accepted Answer

Dimensional data changes slowly over tim

Question 13

An enterprise data warehouse is the control point and single source of all data made available to end users for decision support applications.

Accepted Answer

A) True 
 B)False

Question 14

Periodic data are data that are never physically altered or deleted once they have been added to the store.

Accepted Answer

A) True 
 B)False

Question 15

Improvements in database technology,particularly the development of the ________,led to the emergence of data warehousing.

Accepted Answer

relational

Question 16

What is a logical data mart and what makes this architecture unique?

Accepted Answer

A logical data mart is created by a rela

Question 17

________ is knowledge discovery using statistics,artificial intelligence,and computer graphics.

Accepted Answer

The answer of ________ is knowledge discovery using statistics,artificial intelligence,and...

Question 18

When would it be appropriate to use factless fact tables?

Accepted Answer

There are some situations where we would

Question 19

Data that are detailed,current,and intended to be the single,authoritative source of all decision support applications are called ________ data.

Accepted Answer

A)  reconciled 
B)  subject 
C)  derived 
D)  detailed 
A)  reconciled 
B)  subject 
C)  derived 
D)  detailed

Question 20

The enterprise data model controls the phased evolution of the data warehouse.

Accepted Answer

A) True 
 B)False

Discuss the limitations of the independent data mart architecture.

Which of the following factors drive the need for data warehousing?

A ________ data mart is created by a relation view of a data warehouse.

The ________ schema is an expanded version of a star schema in which dimension tables are normalized into several related tables.

Analyzing a given set of data at a finer level of detail is called ________.

Advances in computer hardware,particularly the emergence of affordable mass storage and parallel computer architectures,was one of the key advances that led to the emergence of data warehousing.

Operational metadata are derived from the enterprise data model.

Informational systems are designed to support decision making based on historical point-in-time and prediction data.

A star schema contains both fact and ________ tables.

Going from a summary view to progressively lower levels of detail is called data:

All of the following are unique characteristics of a logical data mart EXCEPT:

What are some approaches to handling slowly changing dimensions?

An enterprise data warehouse is the control point and single source of all data made available to end users for decision support applications.

Periodic data are data that are never physically altered or deleted once they have been added to the store.

Improvements in database technology,particularly the development of the ________,led to the emergence of data warehousing.

What is a logical data mart and what makes this architecture unique?

________ is knowledge discovery using statistics,artificial intelligence,and computer graphics.

When would it be appropriate to use factless fact tables?

Data that are detailed,current,and intended to be the single,authoritative source of all decision support applications are called ________ data.

The enterprise data model controls the phased evolution of the data warehouse.

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

Discuss the limitations of the independent data mart architecture.

Which of the following factors drive the need for data warehousing?

A ________ data mart is created by a relation view of a data warehouse.

The ________ schema is an expanded version of a star schema in which dimension tables are normalized into several related tables.

Analyzing a given set of data at a finer level of detail is called ________.

Advances in computer hardware,particularly the emergence of affordable mass storage and parallel computer architectures,was one of the key advances that led to the emergence of data warehousing.

Operational metadata are derived from the enterprise data model.

Informational systems are designed to support decision making based on historical point-in-time and prediction data.

A star schema contains both fact and ________ tables.

Going from a summary view to progressively lower levels of detail is called data:

All of the following are unique characteristics of a logical data mart EXCEPT:

What are some approaches to handling slowly changing dimensions?

An enterprise data warehouse is the control point and single source of all data made available to end users for decision support applications.

Periodic data are data that are never physically altered or deleted once they have been added to the store.

Improvements in database technology,particularly the development of the ________,led to the emergence of data warehousing.

What is a logical data mart and what makes this architecture unique?

________ is knowledge discovery using statistics,artificial intelligence,and computer graphics.

When would it be appropriate to use factless fact tables?

Data that are detailed,current,and intended to be the single,authoritative source of all decision support applications are called ________ data.

The enterprise data model controls the phased evolution of the data warehouse.

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