Computer Network and Data Warehouse

Chapter 11 Enterprise Resource Planning Systems 1. 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. 2. Each of the following is a necessary element for the successful warehousing of data EXCEPT a. cleansing extracted data. b. transforming data. c. modeling data. d. loading data. e. all of the above are necessary. 3. Which of the following is typically NOT part of an ERP’s OLAP applications? a. decision support systems b. information retrieval c. ad hoc reporting/analysis d. logistics e. what-if analysis 4. There are a number of risks that may be associated with ERP implementation. Which of the following was NOT stated as a risk in the chapter? 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. ERP’s are too large, complex, and generic for them to be well integrated into most company cultures. 5. Which statement is NOT true? a. In a typical two-tier client-server architecture, 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. Two-tier architecture is for local area network (LAN) applications where the demand on the server is restricted to a relatively small