Accounting Information Systems, 8e—Test Bank, Chapter 11
Chapter 11—Enterprise Resource Planning Systems
TRUE/FALSE
1. The primary goal of installing an ERP system is reducing system maintenance costs.
2. The recommended data architecture for an ERP includes separate operational and data warehouse
databases.
3. A closed database architecture shares data easily.
4. ERP systems support a smooth and seamless flow of information across organizations.
5. OLAP stands for on-line application processing.
6. The primary goal of installing an ERP system is achieving business process reengineering to improve
customer service, reduce production time, increase productivity, and improve decision-making.
7. Day-to-day transactions are stored in the operational database.
8. Data mining typically focuses on the operational databases.
9. Companies are more likely to modify an ERP to accommodate the company than to modify company
processes to accommodate the ERP.
10. If a chosen ERP cannot handle a specific company process bolt-on software may be available.
11. Core applications are also called OLAP.
12. The client/server model is a form of network technology in which user computers, called clients,
access ERP programs and data via a host computer called a server.
13. A data warehouse is a relational or multi-dimensional database that may require hundreds of gigabytes
of storage.
14. Drill-down capability is an OLAP feature of data mining tools.
15. Supply-chain management software is a type of program that supports efforts relative to moving goods
from the raw material stage to the customer.
16. In two-tier architecture, the database and application functions are separated.
17. Slicing and dicing permits the disaggregation of data to reveal underlying details.
18. Data entered into the data warehouse must be normalized.
19. OLAP includes decision support, modeling, information retrieval, and what-if analysis.
20. Efficient supply-chain management provides firms with a competitive advantage.
21. The big-bang approach involves converting from old legacy systems to the new ERP in one
implementation step.
22. A two-tier architecture approach is used primarily for wide area network (WAN) applications.
23. Data cleansing is a step performed by external auditors to identify and repairing invalid data prior to
the audit.
24. Organizations using ERP systems employ an internal control tool called a role.
ANS: T PTS: 1
25. In spite of the high technology employed in ERP systems, critical business controls such as a three
way match are always performed manually.
26. The role model assigns specific access privileges directly to individuals.
ANS: F PTS: 1
27. An access control list specifies the user-ID, the resources available to the user, and the level of
permission granted.
ANS: T PTS: 1
28. RBAC assigns access permissions to the role an individual plays in the organization rather than
directly to the individual.
29. A problem with RBAC is that managers tend to create unnecessary roles
30. The implementation of an ERP creates an environment with a single point of failure, which places the
organization at risk.
Accounting Information Systems, 8e—Test Bank, Chapter 11
MULTIPLE CHOICE
1. Goals of ERP include all of the following except
a.
improved customer service
b.
improvements of legacy systems
c.
reduced production time
d.
increased production
2. Core applications are
a.
sales and distribution
b.
business planning
c.
shop floor control and logistics
d.
all of the above
3. Data warehousing processes do not include
a.
modeling data
b.
condensing data
c.
extracting data
d.
transforming data
4. Which of the following is usually not part of an ERP’s core applications?
a.
OLTP applications
b.
sales and distribution applications
c.
business planning applications
d.
OLAP applications
5. Which of the following is usually not part of an ERP’s OLAP applications?
a.
logistics
b.
decision support systems
c.
ad hoc analysis
d.
what-if analysis
6. Which of the following statements is least likely to be true about a data warehouse?
a.
It is constructed for quick searching and ad hoc queries.
b.
It was an original part of all ERP systems.
c.
It contains data that are normally extracted periodically from the operating databases.
d.
It may be deployed by organizations that have not implemented an ERP.
7. Which of the following statements is not true?
a.
In a typical two-tier client server system, the server handles both application and database
duties.
b.
Client computers are responsible for presenting data to the user and passing user input
back to the server.
c.
In three-tier client server architecture, one tier is for user presentations, one is for database
and applications, and the third is for Internet access.
d.
The database and application functions are separate in the three-tier model.
8. Which statements about data warehousing is not correct?
a.
The data warehouse should be separate from the operational system.
b.
Data cleansing is a process of transforming data into standard form.
c.
Drill-down is a data-mining tool available to users of OLAP.
d.
Normalization is a requirement of databases included in a data warehouse.
9. Which statement about ERP installation is least accurate?
a.
For the ERP to be successful, process reengineering must occur.
b.
ERP fails because some important business process is not supported.
c.
When a business is diversified, little is gained from ERP installation.
d.
The phased-in approach is more suited to diversified businesses.
10. Which statement is true?
a.
ERPs are infinitely scalable.
b.
Performance problems usually stem from technical problems, not business process
reengineering.
c.
The better ERP can handle any problems an organization can have.
d.
ERP systems can be modified using bolt-on software.
11. Auditors of ERP systems
a.
need not worry about segregation of duties.
Accounting Information Systems, 8e—Test Bank, Chapter 11
b.
may feel that the data warehouse is too clean and free from errors.
c.
find independent verification easy.
d.
need not worry about system access since the ERP determines it.
12. Legacy systems are
a.
old manual systems that are still in place.
b.
flat file mainframe systems developed before client-server computing became standard.
c.
stable database systems after debugging.
d.
advanced systems without a data warehouse.
13. A data mart is
a.
another name for a data warehouse.
b.
a database that provides data to an organization’s customers.
c.
an enterprise resource planning system.
d.
a data warehouse created for a single function or department.
14. Most ERPs are based on which network model?
a.
peer to peer
b.
client-server
c.
ring topology
d.
bus topology
15. On–line transaction processing programs
a.
are bolt-on programs used with commercially available ERPs.
b.
are available in two models–two-tier and three-tier.
c.
handle large numbers of relatively simple transactions.
d.
allow users to analyze complex data relationships.
16. Supply chain management software
a.
is typically under the control of external partners in the chain.
b.
links all of the partners in the chain, including vendors, carriers, third-party firms, and
information systems providers.
c.
cannot be integrated into an overall ERP.
d.
none of the above
17. The setup of a data warehouse includes
a.
modeling the data
b.
extracting data from operational databases
c.
cleansing the data
d.
all of the above
18. Extracting data for a data warehouse
a.
cannot be done from flat files.
b.
should only involve active files.
c.
requires that the files be out of service.
d.
follows the cleansing of data.
19. Data cleansing involves all of the following except
a.
filtering out or repairing invalid data
b.
summarizing data for ease of extraction
c.
transforming data into standard business terms
d.
formatting data from legacy systems
20. Separating the data warehouse from the operations databases occurs for all of the following reasons
except
a.
to make the management of the databases more economical
b.
to increase the efficiency of data mining processes
c.
to integrate legacy system data into a form that permits entity-wide analysis
d.
to permit the integration of data from diverse sources
21. Closed database architecture is
a.
a control technique intended to prevent unauthorized access from trading partners.
b.
a limitation inherent in traditional information systems that prevents data sharing.
c.
a data warehouse control that prevents unclean data from entering the warehouse.
d.
a technique used to restrict access to data marts.
e.
a database structure that many of the leading ERPs use to support OLTP applications.
22. Which of the following is NOT as a risk associated with ERP implementation?
Accounting Information Systems, 8e—Test Bank, Chapter 11
a.
A drop in firm performance after implementation because the firm looks and works
differently than it did while using a legacy system.
b.
Implementing companies have found that staff members, employed by ERP consulting
firms, do not have sufficient experience in implementing new systems.
c.
Implementing firms fail to select systems that properly support their business activities.
d.
The selected system does not adequately meet the adopting firm’s economic growth.
e.
ERPs are too large, complex, and generic for them to be well integrated into most company
cultures.
23. Which statement is LEAST accurate?
a.
Implementing an ERP system has as much to do with changing the way an organization
does business than it does with technology.
b.
The big-bang approach to ERP implementation is generally riskier than the phased in
approach.
c.
To take full advantage of the ERP process, reengineering will need to occur.
d.
A common reason for ERP failure is that the ERP does not support one or more important
business processes of the organization
24. Auditors of ERP systems
a.
are concerned about segregation of duties just as they would be in traditional systems.
b.
focus on output controls such as independent verification because internal processing
controls are known to be correct since best practices are used.
c.
routinely audit data in the data warehouse because it is know to be clean and free from
errors.
d.
need not review access levels granted to users since these are determined when the system
is configured and never change.
25. Which statement is most correct?
a.
SAP is more suited to service industries than manufacturing clients.
b.
J.D. Edwards’s ERP is designed to accept the best practices modules of other vendors.
c.
Oracle evolved from a human resources system.
d.
PeopleSoft is the world’s leading supplier of software for information management.
e.
SoftBrands provides enterprise software for the hospitality and manufacturing sectors.
26. Auditors of ERP systems
a. need not be concerned about segregation of duties because these systems possess strong computer
Accounting Information Systems, 8e—Test Bank, Chapter 11
controls.
b. focus on output controls such as independent verification to reconcile batch totals.
c. are concerned that managers fail to exercise adequate care in assigning permissions.
d. do not view the data warehouse as an audit or control issue at all because financial records are not
stored there.
e. need not review access levels granted to users because these are determined when the system is
configured and never change.
SHORT ANSWER
1. Define ERP.
2. Define the term “core applications” and give some examples.
3. Define OLAP and give some examples.
4. What is bolt-on software?
5. What is SCM software?
6. What is a data warehouse?
7. What is the big–bang approach?
8. Describe the two-tier client server model.
9. What is the client-server model?
10. What is scalability?
11. What is data mining?
12. Why do ERP systems need bolt-on software? Give an example.
13. How can a firm acquire bolt-on software? What are the options?
14. Why does data need to be cleansed?
15. What are the basic stages of the data warehousing process?
16. Describe the three-tier client server model.
17. Why must a data warehouse include both detail and summary data?
18. How does a data warehouse help the external auditor perform the audit?
19. What is the closed database architecture?
20. What is meant by the OLAP term: consolidation?
21. What is meant by the OLAP term: drill-down?
22. What is meant by the OLAP term: slicing and dicing?
23. What should management do to assess the potential benefits from implementing an ERP?
24. Internal efficiency is cited as one reason for separating the data warehouse from the operational
database. Explain.
25. Why are data in a data warehouse stored in unnormalized tables?
26. What is the purpose of role- based governance software?
27. What is a role?
28. What is an access control list?
29. How is the access control list approach different from RBAC?
30. Briefly explain the two general approaches to contingency planning for ERPs.
ESSAY
1. How are OLTP and OLAP different? Give examples of their use.
2. Why does the data warehouse need to be separate from the operational databases?
3. If an auditor suspected an unusual relationship between a purchasing agent and certain suppliers, how
could drill-down be used to collect data?
4. Why must an organization expect the implementation of an ERP to disrupt operations?
Accounting Information Systems, 8e—Test Bank, Chapter 11
5. Scalability has several dimensions. What are they? What do they mean for ERP installation?
6. Distinguish between the two-tier and three-tier client server model. Describe when each would be
used?
7. Data in a data warehouse are in a stable state. Explain how this can hamper data mining analysis?
What can an organization do to alleviate this problem?
8. This chapter stressed the importance of data normalization when constructing a relational database.
Why then is it important to de-normalize data in a data warehouse?
9. ERP implementations are at risk to extensive cost overruns. Discuss three of the more commonly
experienced problems area.
10. Explain the risks associated with the creation of unnecessary roles and why it can happen.
11. What is the fundamental concept behind the rule of least access? Explain why this is a potential
problem in an ERP environment.