Enterprise Resource Planning (ERP)

Separating the data warehouse from the operations databases occurs for all of the following reasons except

• make the management of the databases more economical
• to increase the efficiency of data mining processes
• to integrate legacy system data into a form that permits entity-wide analysis
• to permit the integration of data from diverse sources

Data cleansing involves all of the following except

• filtering out or repairing invalid data
• summarizing data for ease of extraction
• transforming data into standard business terms
• formatting data from legacy systems

Extracting data for a data warehouse

• cannot be done from flat files.
• should only involve active files.
• requires that the files be out of service.
• follows the cleansing of data.

The setup of a data warehouse includes

• modeling the data
• extracting data from operational databases
• cleansing the data
• all of the above

Most ERPs are based on which network model?

• peer to peer
• client-server
• ring topology
• bus topology

Which statement about ERP installation is least accurate?

• For the ERP to be successful, process reengineering must occur.
• ERP fails because some important business process is not supported.
• When a business is diversified, little is gained from ERP installation.
• The phased-in approach is more suited to diversified businesses.

Auditors of ERP systems

• need not worry about segregation of duties.
• may feel that the data warehouse is too clean and free from errors.
• find independent verification easy
• need not worry about system access since the ERP determines it.

Which statement is true?

• ERPs are infinitely scalable.
• Performance problems usually stem from technical problems, not business process reengineering.
• The better ERP can handle any problems an organization can have.
• ERP systems can be modified using bolt-on software.

Which statement is true?

• In a two-tier architecture, the server handles both application and database duties.
• In the three-tier model the database and application functions are separated.
• This three-tier model is typical of large production ERP systems that use wide area networks (WANs) for connectivity
• Some ERP vendors use two-tier model for local area network (LAN) applications.
• All statements are true

Which statement is true?

• 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.
• Core applications are produced by third-party vendors which can be added onto an ERP to provide function not built into the ERP.
• On-line analytical processsor (OLAP) includes decision support, modeling, information retrieval, ad hoc reporting and analysis, and what-if analysis
• Bolt-on software are those that support the day-to-day activities of the business, e.g., sales, distribution, shop floor control, logistics.