Question 1

Why does the data warehouse need to be separate from the operational databases?

Accepted Answer

The conclusion that a data warehouse mus

Question 2

What is meant by the OLAP term: slicing and dicing?

Accepted Answer

Slicing and dicing enables the user to e

Question 3

Why must an organization expect the implementation of an ERP to disrupt operations?

Accepted Answer

Successful implementation of an ERP requ

Question 4

On-line transaction processing programs

Accepted Answer

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. 
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.

Question 5

Extracting data for a data warehouse

Accepted Answer

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. 
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.

Question 6

Supply chain management software

Accepted Answer

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 
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

Question 7

The role model assigns specific access privileges directly to individuals.

Accepted Answer

A) True 
 B)False

Question 8

Goals of ERP include all of the following except

Accepted Answer

A)  improved customer service 
B)  improvements of legacy systems 
C)  reduced production time 
D)  increased production 
A)  improved customer service 
B)  improvements of legacy systems 
C)  reduced production time 
D)  increased production

Question 9

A closed database architecture shares data easily.

Accepted Answer

A) True 
 B)False

Question 10

Why are data in a data warehouse stored in unnormalized tables?

Accepted Answer

Normalizing data in an operational datab

Question 11

Companies are more likely to modify an ERP to accommodate the company than to modify company processes to accommodate the ERP.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is NOT a reason that data warehouses be created and maintained separately from operational databases?

Accepted Answer

A)  It is impractical to keep both operational and archive data in the same database. 
B)  The continued influence of legacy systems. 
C)  A separate centralized data warehouse is an effective means of collecting data from diverse sources. 
D)  All of these are reasons that data warehouses are maintained separately. 
A)  It is impractical to keep both operational and archive data in the same database. 
B)  The continued influence of legacy systems. 
C)  A separate centralized data warehouse is an effective means of collecting data from diverse sources. 
D)  All of these are reasons that data warehouses are maintained separately.

Question 13

The big-bang approach involves converting from old legacy systems to the new ERP in one implementation step.

Accepted Answer

A) True 
 B)False

Question 14

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.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is NOT as a risk associated with ERP implementation?

Accepted Answer

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. 
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.

Question 16

Legacy systems are

Accepted Answer

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. 
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.

Question 17

The implementation of an ERP creates an environment with a single point of failure, which places the organization at risk.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following statements is not true?

Accepted Answer

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. 
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.

Question 19

Core applications are also called OLAP.

Accepted Answer

A) True 
 B)False

Question 20

Define ERP.

Accepted Answer

Enterprise resource planning s

Why does the data warehouse need to be separate from the operational databases?

What is meant by the OLAP term: slicing and dicing?

Why must an organization expect the implementation of an ERP to disrupt operations?

On-line transaction processing programs

Extracting data for a data warehouse

Supply chain management software

The role model assigns specific access privileges directly to individuals.

Goals of ERP include all of the following except

A closed database architecture shares data easily.

Why are data in a data warehouse stored in unnormalized tables?

Companies are more likely to modify an ERP to accommodate the company than to modify company processes to accommodate the ERP.

Which of the following is NOT a reason that data warehouses be created and maintained separately from operational databases?

The big-bang approach involves converting from old legacy systems to the new ERP in one implementation step.

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.

Which of the following is NOT as a risk associated with ERP implementation?

Legacy systems are

The implementation of an ERP creates an environment with a single point of failure, which places the organization at risk.

Which of the following statements is not true?

Core applications are also called OLAP.

Define ERP.

The Information System: an Accountants Perspective

Introduction to Transaction Processing

Ethics, Fraud, and Internal Control

The Revenue Cycle

The Expenditure Cycle Part I: Purchases and Cash Disbursements Procedures

The Expenditure Cycle Part II: Payroll Processing and Fixed Asset Procedures

The Conversion Cycle

Financial Reporting, and Management Reporting Systems

Database Management Systems

The Rea Approach to Business Process Modeling

Electronic Commerce Systems

Managing the Systems Development Life Cycle

Construct, Deliver, and Maintain Systems Projects

IT Controls Part I: Sarbanes-Oxley and It Governance

IT Controls Part II: Security and Access

IT Controls Part III: Systems Development, Program Changes, and Application Controls

Filters

Exam 11: Enterprise Resource Planning Systems

Why does the data warehouse need to be separate from the operational databases?

What is meant by the OLAP term: slicing and dicing?

Why must an organization expect the implementation of an ERP to disrupt operations?

On-line transaction processing programs

Extracting data for a data warehouse

Supply chain management software

The role model assigns specific access privileges directly to individuals.

Goals of ERP include all of the following except

A closed database architecture shares data easily.

Why are data in a data warehouse stored in unnormalized tables?

Companies are more likely to modify an ERP to accommodate the company than to modify company processes to accommodate the ERP.

Which of the following is NOT a reason that data warehouses be created and maintained separately from operational databases?

The big-bang approach involves converting from old legacy systems to the new ERP in one implementation step.

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.

Which of the following is NOT as a risk associated with ERP implementation?

Legacy systems are

The implementation of an ERP creates an environment with a single point of failure, which places the organization at risk.

Which of the following statements is not true?

Core applications are also called OLAP.

Define ERP.

The Information System: an Accountants Perspective

Introduction to Transaction Processing

Ethics, Fraud, and Internal Control

The Revenue Cycle

The Expenditure Cycle Part I: Purchases and Cash Disbursements Procedures

The Expenditure Cycle Part II: Payroll Processing and Fixed Asset Procedures

The Conversion Cycle

Financial Reporting, and Management Reporting Systems

Database Management Systems

The Rea Approach to Business Process Modeling

Electronic Commerce Systems

Managing the Systems Development Life Cycle

Construct, Deliver, and Maintain Systems Projects

IT Controls Part I: Sarbanes-Oxley and It Governance

IT Controls Part II: Security and Access

IT Controls Part III: Systems Development, Program Changes, and Application Controls

Filters