Question 1

Conformed dimensions allow users to do the following:

Accepted Answer

A)  delete correlated data. 
B)  query across fact tables with consistency. 
C)  identify viruses in web sites. 
D)  fix viruses in html documents. 
A)  delete correlated data. 
B)  query across fact tables with consistency. 
C)  identify viruses in web sites. 
D)  fix viruses in html documents.

Question 2

Drill-down involves analyzing a given set of data at a finer level of detail.

Accepted Answer

A) True 
 B)False

Question 3

Data transformation is not an important part of the data reconciliation process.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is NOT an objective of derived data?

Accepted Answer

A)  Ease of use for decision support systems 
B)  Faster response time for user queries 
C)  Support data mining applications 
D)  Eliminate the need for application software 
A)  Ease of use for decision support systems 
B)  Faster response time for user queries 
C)  Support data mining applications 
D)  Eliminate the need for application software

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Data may be loaded from the staging area into the warehouse by following:

Accepted Answer

A)  SQL commands (Insert/Update). 
B)  SQL purge. 
C)  custom-written letters. 
D)  virus checking. 
A)  SQL commands (Insert/Update). 
B)  SQL purge. 
C)  custom-written letters. 
D)  virus checking.

Question 7

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 8

Loading data into a data warehouse does NOT involve:

Accepted Answer

A)  appending new rows to the tables in the warehouse. 
B)  updating existing rows with new data. 
C)  purging data that have become obsolete or were incorrectly loaded. 
D)  formatting the hard drive. 
A)  appending new rows to the tables in the warehouse. 
B)  updating existing rows with new data. 
C)  purging data that have become obsolete or were incorrectly loaded. 
D)  formatting the hard drive.

Question 9

There are applications for fact tables without any nonkey data, only the foreign keys for the associated dimensions.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

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 13

A data mart is a(n):

Accepted Answer

A)  enterprise-wide data warehouse. 
B)  smaller system built upon file processing technology. 
C)  data warehouse that is limited in scope. 
D)  generic on-line shopping site. 
A)  enterprise-wide data warehouse. 
B)  smaller system built upon file processing technology. 
C)  data warehouse that is limited in scope. 
D)  generic on-line shopping site.

Question 14

In the load and index stage of ETL, what is the difference between refresh mode and update mode?

Accepted Answer

Refresh mode is an approach to filling a

Question 15

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 16

Informational systems are designed for all of the following EXCEPT:

Accepted Answer

A)  running a business in real time. 
B)  supporting decision making. 
C)  complex queries. 
D)  data mining. 
A)  running a business in real time. 
B)  supporting decision making. 
C)  complex queries. 
D)  data mining.

Question 17

A fact table holds descriptive data about the business.

Accepted Answer

A) True 
 B)False

Question 18

An approach in which only changes in the source data are written to the data warehouse is called refresh mode.

Accepted Answer

A) True 
 B)False

Question 19

An approach to filling a data warehouse that employs bulk rewriting of the target data periodically is called:

Accepted Answer

A)  dump mode. 
B)  overwrite mode. 
C)  refresh mode. 
D)  update mode. 
A)  dump mode. 
B)  overwrite mode. 
C)  refresh mode. 
D)  update mode.

Question 20

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

Accepted Answer

A) True 
 B)False

Conformed dimensions allow users to do the following:

Drill-down involves analyzing a given set of data at a finer level of detail.

Data transformation is not an important part of the data reconciliation process.

Which of the following is NOT an objective of derived data?

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

Data may be loaded from the staging area into the warehouse by following:

A logical data mart is a(n):

Loading data into a data warehouse does NOT involve:

There are applications for fact tables without any nonkey data, only the foreign keys for the associated dimensions.

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

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

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

A data mart is a(n):

In the load and index stage of ETL, what is the difference between refresh mode and update mode?

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:

Informational systems are designed for all of the following EXCEPT:

A fact table holds descriptive data about the business.

An approach in which only changes in the source data are written to the data warehouse is called refresh mode.

An approach to filling a data warehouse that employs bulk rewriting of the target data periodically is called:

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

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

Conformed dimensions allow users to do the following:

Drill-down involves analyzing a given set of data at a finer level of detail.

Data transformation is not an important part of the data reconciliation process.

Which of the following is NOT an objective of derived data?

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

Data may be loaded from the staging area into the warehouse by following:

A logical data mart is a(n):

Loading data into a data warehouse does NOT involve:

There are applications for fact tables without any nonkey data, only the foreign keys for the associated dimensions.

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

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

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

A data mart is a(n):

In the load and index stage of ETL, what is the difference between refresh mode and update mode?

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:

Informational systems are designed for all of the following EXCEPT:

A fact table holds descriptive data about the business.

An approach in which only changes in the source data are written to the data warehouse is called refresh mode.

An approach to filling a data warehouse that employs bulk rewriting of the target data periodically is called:

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

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