WorksheetsEnterprise Resource Planning (ERP)
Total questions: 10
Worksheet time: 11mins
Name
Class
Date
1.
Separating the data warehouse from the operations databases occurs for all of the following reasons except
a)
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
2.
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
3.
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.
4.
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
5.
Most ERPs are based on which network model?
a)
peer to peer
b)
client-server
c)
ring topology
d)
bus topology
6.
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.
7.
Auditors of ERP systems
a)
need not worry about segregation of duties.
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.
8.
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.
9.
Which statement is true?
a)
In a two-tier architecture, the server handles both application and database duties.
b)
In the three-tier model the database and application functions are separated.
c)
This three-tier model is typical of large production ERP systems that use wide area networks (WANs) for connectivity
d)
Some ERP vendors use two-tier model for local area network (LAN) applications.
e)
All statements are true
10.
Which statement is true?
a)
The big-bang approach to conversion to an ERP is the approach which converts from old legacy systems to the new in one step that implements the ERP across the entire company.
b)
Core applications are produced by third-party vendors which can be added onto an ERP to provide function not built into the ERP.
c)
On-line analytical processsor (OLAP) includes decision support, modeling, information retrieval, ad hoc reporting and analysis, and what-if analysis
d)
Bolt-on software are those that support the day-to-day activities of the business, e.g., sales, distribution, shop floor control, logistics.
100 %
