Question 1

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  True

Question 2

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  True

Question 3

When would it be appropriate to use factless fact tables?

Accepted Answer

There are some situations where we would want to just keep keys to dimensions but no facts. One case would be a data warehouse to keep track of events, such as attendance in a course. Another case would be coverage, taking inventory of the set of possible occurrences.

Question 4

Which of the following organizational trends does not encourage the need for data warehousing?

Accepted Answer

A)  Multiple, nonsynchronized systems 
B)  Focus on customer relationship management 
C)  Downsizing 
D)  Focus on supplier relationship management 
A)  Multiple, nonsynchronized systems 
B)  Focus on customer relationship management 
C)  Downsizing 
D)  Focus on supplier relationship management

Question 5

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 6

Medical claims and pharmaceutical data would be an example of big data.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

A fact table holds descriptive data about the business.

Accepted Answer

A) True 
 B)False

Question 9

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 10

The first requirement for building a user-friendly interface is a set of metadata that describes the data in the data mart in business terms that users can easily understand.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is true of data visualization?

Accepted Answer

A)  It is more difficult to observe trends and patterns in data. 
B)  Correlations and clusters in data can be easily identified. 
C)  It is often used in conjunction with poems. 
D)  It is generally not helpful for decision making. 
A)  It is more difficult to observe trends and patterns in data. 
B)  Correlations and clusters in data can be easily identified. 
C)  It is often used in conjunction with poems. 
D)  It is generally not helpful for decision making.

Question 12

A logical data mart is a(n):

Accepted Answer

A)  data mart consisting of only logical data. 
B)  data mart created by a relational view of a slightly denormalized data warehouse. 
C)  integrated, subject-oriented, detailed database designed to serve operational users. 
D)  centralized, integrated data warehouse. 
A)  data mart consisting of only logical data. 
B)  data mart created by a relational view of a slightly denormalized data warehouse. 
C)  integrated, subject-oriented, detailed database designed to serve operational users. 
D)  centralized, integrated data warehouse.

Question 13

Every key used to join the fact table with a dimension table should be a ________ key.

Accepted Answer

A)  primary 
B)  surrogate 
C)  foreign 
D)  secondary 
A)  primary 
B)  surrogate 
C)  foreign 
D)  secondary

Question 14

The real-time data warehouse is characterized by which of the following?

Accepted Answer

A)  It accepts batch feeds of transaction data. 
B)  Data are immediately transformed and loaded into the warehouse. 
C)  It provides periodic access for the transaction processing systems to an enterprise data warehouse. 
D)  It is based on Oracle technology. 
A)  It accepts batch feeds of transaction data. 
B)  Data are immediately transformed and loaded into the warehouse. 
C)  It provides periodic access for the transaction processing systems to an enterprise data warehouse. 
D)  It is based on Oracle technology.

Question 15

Discuss the history of data warehousing.

Accepted Answer

Several key advances in information syst

Question 16

________ is an ill-defined term applied to databases where size strains the ability of commonly used relational DBMSs to manage the data.

Accepted Answer

A)  Mean data 
B)  Small data 
C)  Star data 
D)  Big data 
A)  Mean data 
B)  Small data 
C)  Star data 
D)  Big data

Question 17

Explain the dependent data mart and operational data store architecture.

Accepted Answer

The dependent data mart and operational

Question 18

An independent data mart is filled with data extracted from the operational environment without the benefit of a data warehouse.

Accepted Answer

A) True 
 B)False

Question 19

Logical data marts are physically separate databases from the enterprise data warehouse.

Accepted Answer

A) True 
 B)False

Question 20

What are some approaches to handling slowly changing dimensions?

Accepted Answer

Dimensional data changes slowly over tim

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.

When would it be appropriate to use factless fact tables?

Which of the following organizational trends does not encourage the need for data warehousing?

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.

Medical claims and pharmaceutical data would be an example of big data.

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

A fact table holds descriptive data about the business.

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

The first requirement for building a user-friendly interface is a set of metadata that describes the data in the data mart in business terms that users can easily understand.

Which of the following is true of data visualization?

A logical data mart is a(n):

Every key used to join the fact table with a dimension table should be a ________ key.

The real-time data warehouse is characterized by which of the following?

Discuss the history of data warehousing.

________ is an ill-defined term applied to databases where size strains the ability of commonly used relational DBMSs to manage the data.

Explain the dependent data mart and operational data store architecture.

An independent data mart is filled with data extracted from the operational environment without the benefit of a data warehouse.

Logical data marts are physically separate databases from the enterprise data warehouse.

What are some approaches to handling slowly changing dimensions?

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 9: Data Warehousing

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.

When would it be appropriate to use factless fact tables?

Which of the following organizational trends does not encourage the need for data warehousing?

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.

Medical claims and pharmaceutical data would be an example of big data.

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

A fact table holds descriptive data about the business.

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

The first requirement for building a user-friendly interface is a set of metadata that describes the data in the data mart in business terms that users can easily understand.

Which of the following is true of data visualization?

A logical data mart is a(n):

Every key used to join the fact table with a dimension table should be a ________ key.

The real-time data warehouse is characterized by which of the following?

Discuss the history of data warehousing.

________ is an ill-defined term applied to databases where size strains the ability of commonly used relational DBMSs to manage the data.

Explain the dependent data mart and operational data store architecture.

An independent data mart is filled with data extracted from the operational environment without the benefit of a data warehouse.

Logical data marts are physically separate databases from the enterprise data warehouse.

What are some approaches to handling slowly changing dimensions?

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters