1. MULTIPLE CHOICE
1. B
2. E
3. D
2.
Chapter 1 Page 2
3. problems
1. DATA WAREHOUSE ACCESS CONTROL
Merit: The primary reason for a data warehousing is to optimize the business.
Many organizations’ management personnel feel that more strategic benefit
can be gained by sharing data externally. By providing customers and suppliers
Control: Access control is a vital feature of a data warehouse that is shared with
customers and suppliers. The following control issues need to be considered:
Chapter 1 Page 3
2. PROJECT IMPLEMENTATION
Chapter 1 Page 4
While the big bang method has certain advantages, it has been associated with
numerous system failures. Since the new ERP system means new ways of
conducting business, getting the entire organization on-board and in sync can
be a problem. On day one of the implementation, no one within the
organization will have had any experience with the new system. In a sense,
everyone in the company is a trainee learning a new job. The new ERP will
initially meet with opposition, because using it involves compromise. The
Because of the disruptions associated with the big bang, the phased-in approach
has emerged as a popular alternative. It is particularly suited to diversified
organizations with units that do not share common processes and data. In these
Chapter 1 Page 5
The technological culture must also be assessed. Organizations that lack technical
support staff for the new system, or have a user base that is unfamiliar with
3. OLTP VERSUS OLAP SERVERS
a. On-line transaction (OLTP) processing is appropriate because the amount
Chapter 1 Page 6
d. OLAP. While this system will analyze simple transactions, the volume of activity and
f. OLAP. While OLTP has been sufficient to provide the information requirements to
date, the company is not meeting its goals, and an understanding of the business
Chapter 1 Page 7
4. SELECTING A CONSULTANT
Consulting firms, particularly the big four with large ERP practices, are
desperately short of human resources at times. We saw this in the mid-to-late
A common complaint is that consulting firms promise experienced professionals but
deliver incompetent trainees. They have been accused of employing a
bait-and-switch maneuver to get contracts. At the initial engagement interview, the
Consulting firms, not wanting to turn away business, are perhaps guilty of
overbooking their consulting staff. However, the consequences are far graver than
the inconvenience of missing a flight. Currently a number of lawsuits have been filed
Chapter 1 Page 8
Chapter 1 Page 9
5. AUDITING ERP DATABASES
While organization’s data warehouse is an excellent resource for performing
analytical reviews, I will need to gain an understanding of the procedures used
to populate the warehouse. I am concerned that your data cleansing
procedures may be sanitizing the warehouse, which could create a false
6. BIG BANG VERSUS PHASED-IN APPROACH
Either approach would require transformation of data from the legacy systems
to a common data warehouse. A phased-in approach has an advantage of
Chapter 1 Page 10
Presuming the goals of a DMV are to correctly tax and license drivers and vehicles,
and to do so expediently, the fact that customers were waiting too long and that
The employees seemed to lack adequate training and seemed not to support the
new system. Phasing-in a new system does not require as many technicians, as the
instruction process can take place over time and across geography. With an
increased number of required technicians, there is a decreased the chance that all
If customers were satisfied with the service they received, and if employees were