Question 1

Of the following applications or application systems, the one that would be considered a decision support system is ____.

Accepted Answer

A)  a system that links companies in a supply chain 
B)  a hospital application that makes patient records available to all doctors and other health care professionals who are treating patients 
C)  a university course and grade record keeping system 
D)  a system that provides the management of a retail chain with data helpful in choosing sites for new stores 
E)  a payroll system 
A)  a system that links companies in a supply chain 
B)  a hospital application that makes patient records available to all doctors and other health care professionals who are treating patients 
C)  a university course and grade record keeping system 
D)  a system that provides the management of a retail chain with data helpful in choosing sites for new stores 
E)  a payroll system D

Question 2

An enterprise data warehouse (EDW) ____.

Accepted Answer

A)  must be the sum of all of a company's data marts 
B)  is designed to support a department or a related group of departments 
C)  cannot exist without data marts being present 
D)  must be fully normalized 
E)  supports an entire company or a major part of one 
A)  must be the sum of all of a company's data marts 
B)  is designed to support a department or a related group of departments 
C)  cannot exist without data marts being present 
D)  must be fully normalized 
E)  supports an entire company or a major part of one E

Question 3

A way to store data warehouse data in a relational database structure is with a model known as the ____ schema.

Accepted Answer

A)  network 
B)  multi-pronged 
C)  pointer 
D)  star 
E)  ring 
A)  network 
B)  multi-pronged 
C)  pointer 
D)  star 
E)  ring D

Question 4

Data warehouse data is less problematic if denormalized than operational data would be.

Accepted Answer

A) True 
 B)False

Question 5

____ is a decision support methodology based on viewing data in multiple dimensions.

Accepted Answer

A)  Data mining 
B)  Market basket analysis 
C)  Neural networks 
D)  Online analytic processing 
E)  Data transformation 
A)  Data mining 
B)  Market basket analysis 
C)  Neural networks 
D)  Online analytic processing 
E)  Data transformation

Question 6

There is a(n) _____ relationship between each dimension table entity and the fact table entity in a star schema data warehouse structure.

Accepted Answer

A)  standard 
B)  structured 
C)  unstructured 
D)  many-to-many 
E)  one-to-many 
A)  standard 
B)  structured 
C)  unstructured 
D)  many-to-many 
E)  one-to-many

Question 7

Neural networks and genetic algorithms are among the techniques for data mining.

Accepted Answer

A) True 
 B)False

Question 8

Generally, one of the dimensions of any data warehouse is ____.

Accepted Answer

A)  distance 
B)  time 
C)  energy 
D)  information 
E)  pallets 
A)  distance 
B)  time 
C)  energy 
D)  information 
E)  pallets

Question 9

Data warehouse data is characterized as volatile.

Accepted Answer

A) True 
 B)False

Question 10

Consider the following relational database for the Central Zoo. Central Zoo wants to maintain information about its animals, the enclosures in which they live, and its zookeepers and the services they perform for the animals. In addition, Central Zoo has a program by which people can be sponsor of animals. Central Zoo wants to track its sponsors, their dependents, and associated data.
Each animal has a unique animal number and each enclosure has a unique enclosure number. An animal can live in only one enclosure. An enclosure can have several animals in it or it can be currently empty. A zookeeper has a unique employee number. Every animal has been cared for by at least one and generally many zookeepers; each zookeeper has cared for at least one and generally many animals. Each time a zookeeper performs a specific, significant service for an animal the service type, date, and time are recorded. A zookeeper may perform a particular service on a particular animal more than once on a given day.
A sponsor, who has a unique sponsor number and a unique social security number, sponsors at least one and possibly several animals. An animal may have several sponsors or none. For each animal that a particular sponsor sponsors, the zoo wants to track the annual sponsorship contribution and renewal date. In addition, Central Zoo wants to keep track of each sponsor's dependents. A sponsor may have several dependents or none. A dependent is associated with exactly one sponsor.
 $$\begin{array} { | l | l | l | l | l |} 
\hline \text { Enclosure } & & && \text { Date } \
\text { Number } & \text { Type } & \text { Location } & \text { Size } & \text { Built } \
\hline
\end{array}$$ ENCLOSURE Relation
 $$\begin{array} { | l | l | l | l | l | l | l | } 
\hline \text { Animal } & & \text { Animal } & & \text { Country } & & \text { Enclosure } \
\text { Number } & \text { Species } & \text { Narne } & \text { Gender } & \text { Of Birth } & \text { Weight } & \text { Number } \
\hline
\end{array}$$ ANIMAL Relation
 $$\begin{array} { | l | l | l | l | } 
\hline \text { Employee } & \text { Employee } & & \text { Year } \
\text { Number } & \text { Name } & \text { Title } & \text { Hired } \
\hline
\end{array}$$ ZOOKEEPER Relation
 $$\begin{array} { | l | l | l | l | l |} 
\hline\text { Animal } & \text { Employee } & \text { Service } & & \
\text { Number } & \text { Number } & \text { Type } & \text { Date } & \text { Time } \
\hline
\end{array}$$ CARES FOR Relation
 $$\begin{array} { | l | l | l | l | l |} 
\hline \text { Sponsor } & \text { Social Security } & \text { Sponsor } & & \
\text { Number } & \text { Number } & \text { Narne } & \text { Address } & \text { Telephone } \
\hline
\end{array}$$ SPONSOR Relation
 $$\begin{array} { | l | l | l | l | } 
\hline \text { Animal } & \text { Sponsor } & \text { Annual } & \text { Renewal } \
\text { Number } & \text { Number } & \text { Contribution } & \text { Date }\
\hline
\end{array}$$ CONTRIBUTION Relation
 $$\begin{array} { | l | l | l | l | } 
\hline \text { Sponsor } & \text { Dependent } & & \text { Date of } \
\text { Number } & \text { Name } & \text { Relationship } & \text { Birth } \
\hline
\end{array}$$ DEPENDENT Relation 
a. Design a multidimensional database using a star schema for a data warehouse for the Central Zoo business environment. The subject will be "sponsorship" which represents a particular sponsor sponsoring a particular animal. Be sure to keep track of the annual contribution and the renewal date for the sponsorship. Assume that the annual contribution can change with the renewal date, i.e. it can be different in different years.
b. Describe three OLAP uses of this data warehouse.
c. Describe one data mining use of this data warehouse.

Accepted Answer

a. The fact table will be SPONSORSHIP. D

Question 11

All of the following are categories or techniques of data transformation during the building of a data warehouse, except ____.

Accepted Answer

A)  coding scheme conversion 
B)  unit of measure conversion 
C)  aggregation 
D)  questionable data conversion 
E)  combining values from different attributes in transactional databases into a single attribute in the data warehouse 
A)  coding scheme conversion 
B)  unit of measure conversion 
C)  aggregation 
D)  questionable data conversion 
E)  combining values from different attributes in transactional databases into a single attribute in the data warehouse

Question 12

All of the following are data mining techniques, except ____.

Accepted Answer

A)  case-based learning 
B)  decision trees 
C)  data enrichment 
D)  neural networks 
E)  genetic algorithms 
A)  case-based learning 
B)  decision trees 
C)  data enrichment 
D)  neural networks 
E)  genetic algorithms

Question 13

Data in the data warehouse may be a perpetually moving target because of increasing and shifting user demands.

Accepted Answer

A) True 
 B)False

Question 14

____ is the process of copying data from the transactional databases in preparation for loading it into the data warehouse.

Accepted Answer

A)  Data extraction 
B)  Data manipulation 
C)  Data cleaning 
D)  Data transformation 
E)  Data loading 
A)  Data extraction 
B)  Data manipulation 
C)  Data cleaning 
D)  Data transformation 
E)  Data loading

Question 15

One type of data cleaning is to determine the correct value for impossible data.

Accepted Answer

A) True 
 B)False

Question 16

If the enterprise data warehouse was created first in a company and then later data was extracted from it to create one or more data marts, this is known as ____ development.

Accepted Answer

A)  minor-to-major 
B)  major-to-minor 
C)  bottom-up 
D)  top-down 
E)  sideways 
A)  minor-to-major 
B)  major-to-minor 
C)  bottom-up 
D)  top-down 
E)  sideways

Question 17

A snowflake design is a feature of a star schema in which one dimension table leads to another.

Accepted Answer

A) True 
 B)False

Question 18

Data in a typical data warehouse ____.

Accepted Answer

A)  is frequently updated by changing existing attribute values as the values change in the operational database 
B)  grows as new data is appended to the end of the existing tables 
C)  does not require timestamps 
D)  is always fully detailed, not summarized data 
E)  is organized according to the company's TPS applications 
A)  is frequently updated by changing existing attribute values as the values change in the operational database 
B)  grows as new data is appended to the end of the existing tables 
C)  does not require timestamps 
D)  is always fully detailed, not summarized data 
E)  is organized according to the company's TPS applications

Question 19

Adding data acquired from outside of the company to the data warehouse is known as data extraction.

Accepted Answer

A) True 
 B)False

Question 20

All of the following are desirable types of background knowledge for a data warehouse administrator to have, except ____.

Accepted Answer

A)  business expertise 
B)  data expertise 
C)  technical expertise 
D)  All of the above. 
E)  None of the above. 
A)  business expertise 
B)  data expertise 
C)  technical expertise 
D)  All of the above. 
E)  None of the above.

Of the following applications or application systems, the one that would be considered a decision support system is ____.

An enterprise data warehouse (EDW) ____.

A way to store data warehouse data in a relational database structure is with a model known as the ____ schema.

Data warehouse data is less problematic if denormalized than operational data would be.

____ is a decision support methodology based on viewing data in multiple dimensions.

There is a(n) _____ relationship between each dimension table entity and the fact table entity in a star schema data warehouse structure.

Neural networks and genetic algorithms are among the techniques for data mining.

Generally, one of the dimensions of any data warehouse is ____.

Data warehouse data is characterized as volatile.

All of the following are categories or techniques of data transformation during the building of a data warehouse, except ____.

All of the following are data mining techniques, except ____.

Data in the data warehouse may be a perpetually moving target because of increasing and shifting user demands.

____ is the process of copying data from the transactional databases in preparation for loading it into the data warehouse.

One type of data cleaning is to determine the correct value for impossible data.

If the enterprise data warehouse was created first in a company and then later data was extracted from it to create one or more data marts, this is known as ____ development.

A snowflake design is a feature of a star schema in which one dimension table leads to another.

Data in a typical data warehouse ____.

Adding data acquired from outside of the company to the data warehouse is known as data extraction.

All of the following are desirable types of background knowledge for a data warehouse administrator to have, except ____.

Data: the New Corporate Resource

Data Modeling

The Database Management System Concept

Relational Data Retrieval: SQL

The Relational Database Model: Introduction

The Relational Database Model: Additional Concepts

Logical Database Design

Physical Database Design

Object-Oriented Database Management

Data Administration, Database Administration, and Data Dictionaries

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

Database and the Internet

Filters

Exam 13: The Data Warehouse

Of the following applications or application systems, the one that would be considered a decision support system is ____.

An enterprise data warehouse (EDW) ____.

A way to store data warehouse data in a relational database structure is with a model known as the ____ schema.

Data warehouse data is less problematic if denormalized than operational data would be.

____ is a decision support methodology based on viewing data in multiple dimensions.

There is a(n) _____ relationship between each dimension table entity and the fact table entity in a star schema data warehouse structure.

Neural networks and genetic algorithms are among the techniques for data mining.

Generally, one of the dimensions of any data warehouse is ____.

Data warehouse data is characterized as volatile.

All of the following are categories or techniques of data transformation during the building of a data warehouse, except ____.

All of the following are data mining techniques, except ____.

Data in the data warehouse may be a perpetually moving target because of increasing and shifting user demands.

____ is the process of copying data from the transactional databases in preparation for loading it into the data warehouse.

One type of data cleaning is to determine the correct value for impossible data.

If the enterprise data warehouse was created first in a company and then later data was extracted from it to create one or more data marts, this is known as ____ development.

A snowflake design is a feature of a star schema in which one dimension table leads to another.

Data in a typical data warehouse ____.

Adding data acquired from outside of the company to the data warehouse is known as data extraction.

All of the following are desirable types of background knowledge for a data warehouse administrator to have, except ____.

Data: the New Corporate Resource

Data Modeling

The Database Management System Concept

Relational Data Retrieval: SQL

The Relational Database Model: Introduction

The Relational Database Model: Additional Concepts

Logical Database Design

Physical Database Design

Object-Oriented Database Management

Data Administration, Database Administration, and Data Dictionaries

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

Database and the Internet

Filters