Question 1

A data warehouse is a relational or multi-dimensional database that may require hundreds of gigabytes of storage.

Accepted Answer

A) True 
 B)False

Question 2

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 3

Describe the two-tier client server model.

Accepted Answer

In a two-tier architecture,the server ha

Question 4

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) all of the above 
A) cannot be done from flat files 
B) should only involve active files 
C) requires that the files be out of service 
D) all of the above

Question 5

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 6

What is data mining?

Accepted Answer

Data mining is the process of

Question 7

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

Accepted Answer

A) The data is used in different ways that requires it to be physically separate. 
B) No ERP system incorporates data warehousing capability. 
C) Audit controls require that data for management analysis be kept separate from transaction data. 
D) A separate centralized data warehouse is an effective means of collecting data from diverse sources. 
A) The data is used in different ways that requires it to be physically separate. 
B) No ERP system incorporates data warehousing capability. 
C) Audit controls require that data for management analysis be kept separate from transaction data. 
D) A separate centralized data warehouse is an effective means of collecting data from diverse sources.

Question 8

What is scalability?

Accepted Answer

System scalability refers to t

Question 9

Closed database architecture is

Accepted Answer

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 database structure that many of the leading ERPs use to support OLTP applications 
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 database structure that many of the leading ERPs use to support OLTP applications

Question 10

In spite of the high technology employed in ERP systems,critical business controls such as a three-way match are always performed manually.

Accepted Answer

A) True 
 B)False

Question 11

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?

Accepted Answer

Typically,transaction data are loaded in

Question 12

What is meant by the OLAP term: consolidation?

Accepted Answer

Consolidation is the aggregati

Question 13

If a chosen ERP cannot handle a specific company process bolt-on software may be available.

Accepted Answer

A) True 
 B)False

Question 14

What is the big bang approach?

Accepted Answer

The big bang approach to conve

Question 15

Supply-chain management software is a type of program that supports efforts related to moving goods from the raw material stage to the customer.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) opposition to changes in the business culture 
B) choosing the wrong ERP 
C) choosing the wrong consultant 
D) All of these are risks associated with ERP implementations. 
A) opposition to changes in the business culture 
B) choosing the wrong ERP 
C) choosing the wrong consultant 
D) All of these are risks associated with ERP implementations.

Question 17

What is bolt-on software?

Accepted Answer

Bolt-on software is software p

Question 18

Explain the risks associated with the creation of unnecessary roles and why it can happen.

Accepted Answer

Managers in ERP environments have signif

Question 19

Most ERPs are based on which network model?

Accepted Answer

A) peer to peer 
B) client-server 
C) ring topology 
D) bus topology 
A) peer to peer 
B) client-server 
C) ring topology 
D) bus topology

Question 20

What is meant by the OLAP term: drill-down?

Accepted Answer

Drill-down permits the disaggregation of

A data warehouse is a relational or multi-dimensional database that may require hundreds of gigabytes of storage.

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

Describe the two-tier client server model.

Extracting data for a data warehouse

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

What is data mining?

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

What is scalability?

Closed database architecture is

In spite of the high technology employed in ERP systems,critical business controls such as a three-way match are always performed manually.

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?

What is meant by the OLAP term: consolidation?

If a chosen ERP cannot handle a specific company process bolt-on software may be available.

What is the big bang approach?

Supply-chain management software is a type of program that supports efforts related to moving goods from the raw material stage to the customer.

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

What is bolt-on software?

Explain the risks associated with the creation of unnecessary roles and why it can happen.

Most ERPs are based on which network model?

What is meant by the OLAP term: drill-down?

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

Auditing It Controls Part I: Sarbanes-Oxley and It Governance

Auditing It Controls Part II: Security and Access

Auditing It Controls Part III: Systems Development, program Changes, and Application Auditing

Filters

Exam 11: Enterprise Resource Planning Systems

A data warehouse is a relational or multi-dimensional database that may require hundreds of gigabytes of storage.

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

Describe the two-tier client server model.

Extracting data for a data warehouse

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

What is data mining?

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

What is scalability?

Closed database architecture is

In spite of the high technology employed in ERP systems,critical business controls such as a three-way match are always performed manually.

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?

What is meant by the OLAP term: consolidation?

If a chosen ERP cannot handle a specific company process bolt-on software may be available.

What is the big bang approach?

Supply-chain management software is a type of program that supports efforts related to moving goods from the raw material stage to the customer.

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

What is bolt-on software?

Explain the risks associated with the creation of unnecessary roles and why it can happen.

Most ERPs are based on which network model?

What is meant by the OLAP term: drill-down?

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

Auditing It Controls Part I: Sarbanes-Oxley and It Governance

Auditing It Controls Part II: Security and Access

Auditing It Controls Part III: Systems Development, program Changes, and Application Auditing

Filters