Question 1

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 2

When would it be appropriate to use factless fact tables?

Accepted Answer

There are some situations where we would

Question 3

Event-driven propagation:

Accepted Answer

A)  provides a means to duplicate data for events. 
B)  pushes data to duplicate sites as an event occurs. 
C)  pulls duplicate data from redundant sites. 
D)  triggers a virus. 
A)  provides a means to duplicate data for events. 
B)  pushes data to duplicate sites as an event occurs. 
C)  pulls duplicate data from redundant sites. 
D)  triggers a virus.

Question 4

When determining the size of a fact table, estimating the number of possible values for each dimension associated with the fact table is equivalent to:

Accepted Answer

A)  determining the number of DDL statements made to create a table. 
B)  determining the number of possible values for each foreign key in the fact table. 
C)  determining the number of DML statements made to create a table. 
D)  determining the number of TRIGGERS used in the database. 
A)  determining the number of DDL statements made to create a table. 
B)  determining the number of possible values for each foreign key in the fact table. 
C)  determining the number of DML statements made to create a table. 
D)  determining the number of TRIGGERS used in the database.

Question 5

Discuss the four key terms (subject-oriented, integrated, time-variant, and nonupdateable) related to data warehousing.

Accepted Answer

A data warehouse is subject-oriented, me

Question 6

Update mode is used to create a data warehouse.

Accepted Answer

A) True 
 B)False

Question 7

What is data mining, and what are its goals?

Accepted Answer

Data mining is knowledge discovery using

Question 8

Explain the difference between operational and informational systems as well as the primary factors that contribute to the need for separation.

Accepted Answer

An operational system is built to run a

Question 9

The characteristic that indicates that a data warehouse is organized around key high-level entities of the enterprise is:

Accepted Answer

A)  subject-oriented. 
B)  integrated. 
C)  time-variant. 
D)  nonvolatile. 
A)  subject-oriented. 
B)  integrated. 
C)  time-variant. 
D)  nonvolatile.

Question 10

After the extract, transform, and load is done on data, the data warehouse is never fully normalized.

Accepted Answer

A) True 
 B)False

Question 11

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 12

Discuss the history of data warehousing.

Accepted Answer

Several key advances in information syst

Question 13

ETL is short for Extract, Transform, Load.

Accepted Answer

A) True 
 B)False

Question 14

The key discovery that triggered the development of data warehouses was:

Accepted Answer

A)  computer viruses. 
B)  new ways to present information using mobile devices. 
C)  the recognition of the differences between transactional systems and informational systems. 
D)  the invention of the iPad. 
A)  computer viruses. 
B)  new ways to present information using mobile devices. 
C)  the recognition of the differences between transactional systems and informational systems. 
D)  the invention of the iPad.

Question 15

Refresh mode is an approach to filling the data warehouse that employs bulk rewriting of the target data at periodic intervals.

Accepted Answer

A) True 
 B)False

Question 16

The data reconciliation process is responsible for transforming operational data to reconciled data.

Accepted Answer

A) True 
 B)False

Question 17

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

Question 18

Multidimensional OLAP (MOLAP) tools use variations of SQL and view the database as a relational database, in either a star schema or other normalized or denormalized set of tables.

Accepted Answer

A) True 
 B)False

Question 19

Explain the four basic steps to build an independent data mart.

Accepted Answer

1. Extraction-data are extracted from in

Question 20

Discuss data governance and what needs to be included in a data governance program.

Accepted Answer

Data governance is a set of processes an

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?

Event-driven propagation:

When determining the size of a fact table, estimating the number of possible values for each dimension associated with the fact table is equivalent to:

Discuss the four key terms (subject-oriented, integrated, time-variant, and nonupdateable) related to data warehousing.

Update mode is used to create a data warehouse.

What is data mining, and what are its goals?

Explain the difference between operational and informational systems as well as the primary factors that contribute to the need for separation.

The characteristic that indicates that a data warehouse is organized around key high-level entities of the enterprise is:

After the extract, transform, and load is done on data, the data warehouse is never fully normalized.

A star schema contains both fact and ________ tables.

Discuss the history of data warehousing.

ETL is short for Extract, Transform, Load.

The key discovery that triggered the development of data warehouses was:

Refresh mode is an approach to filling the data warehouse that employs bulk rewriting of the target data at periodic intervals.

The data reconciliation process is responsible for transforming operational data to reconciled data.

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.

Multidimensional OLAP (MOLAP) tools use variations of SQL and view the database as a relational database, in either a star schema or other normalized or denormalized set of tables.

Explain the four basic steps to build an independent data mart.

Discuss data governance and what needs to be included in a data governance program.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 9: Data Warehousing and Data Integration

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?

Event-driven propagation:

When determining the size of a fact table, estimating the number of possible values for each dimension associated with the fact table is equivalent to:

Discuss the four key terms (subject-oriented, integrated, time-variant, and nonupdateable) related to data warehousing.

Update mode is used to create a data warehouse.

What is data mining, and what are its goals?

Explain the difference between operational and informational systems as well as the primary factors that contribute to the need for separation.

The characteristic that indicates that a data warehouse is organized around key high-level entities of the enterprise is:

After the extract, transform, and load is done on data, the data warehouse is never fully normalized.

A star schema contains both fact and ________ tables.

Discuss the history of data warehousing.

ETL is short for Extract, Transform, Load.

The key discovery that triggered the development of data warehouses was:

Refresh mode is an approach to filling the data warehouse that employs bulk rewriting of the target data at periodic intervals.

The data reconciliation process is responsible for transforming operational data to reconciled data.

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.

Multidimensional OLAP (MOLAP) tools use variations of SQL and view the database as a relational database, in either a star schema or other normalized or denormalized set of tables.

Explain the four basic steps to build an independent data mart.

Discuss data governance and what needs to be included in a data governance program.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters