Question 1

Distinguish between the two-tier and three-tier client server model. Describe when each would be used.

Accepted Answer

In a two-tier architecture, the server h

Question 2

This chapter stressed the importance of data normalization when constructing a relational database. Why then is it important to denormalize data in a data warehouse?

Accepted Answer

Wherever possible, normalized tables per

Question 3

An access control list specifies the user-ID, the resources available to the user, and the level of permission granted.

Accepted Answer

A) True 
 B)False

Question 4

RBAC assigns access permissions to the role an individual plays in the organization rather than directly to the individual.

Accepted Answer

A) True 
 B)False

Question 5

Slicing and dicing permits the disaggregation of data to reveal underlying details.

Accepted Answer

A) True 
 B)False

Question 6

OLAP stands for on-line application processing.

Accepted Answer

A) True 
 B)False

Question 7

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 8

Internal efficiency is cited as one reason for separating the data warehouse from the operational database. Explain.

Accepted Answer

The structural and operational requireme

Question 9

Organizations using ERP systems employ an internal control tool called a role.

Accepted Answer

A) True 
 B)False

Question 10

What is the purpose of role- based governance software?

Accepted Answer

It monitors role creation and

Question 11

How can a firm acquire bolt-on software? What are the options?

Accepted Answer

When a firm needs additional function no

Question 12

The client/server model is a form of network topology in which user computers, called clients, access ERP programs and data via a host computer called a server.

Accepted Answer

A) True 
 B)False

Question 13

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 technique used to restrict access to data marts. 
E)  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 technique used to restrict access to data marts. 
E)  a database structure that many of the leading ERPs use to support OLTP applications.

Question 14

The setup of a data warehouse includes

Accepted Answer

A)  modeling the data 
B)  extracting data from operational databases 
C)  cleansing the data 
D)  all of the above 
A)  modeling the data 
B)  extracting data from operational databases 
C)  cleansing the data 
D)  all of the above

Question 15

How is the access control list approach different from RBAC?

Accepted Answer

The access control list approach assigns

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 the closed database architecture?

Accepted Answer

The closed database architecture is simi

Question 18

Auditors of ERP systems

Accepted Answer

A)  need not be concerned about segregation of duties because these systems possess strong computer controls. 
B)  focus on output controls such as independent verification to reconcile batch totals. 
C)  are concerned that managers fail to exercise adequate care in assigning permissions. 
D)  do not view the data warehouse as an audit or control issue at all because financial records are not stored there. 
E)  need not review access levels granted to users because these are determined when the system is configured and never change. 
A)  need not be concerned about segregation of duties because these systems possess strong computer controls. 
B)  focus on output controls such as independent verification to reconcile batch totals. 
C)  are concerned that managers fail to exercise adequate care in assigning permissions. 
D)  do not view the data warehouse as an audit or control issue at all because financial records are not stored there. 
E)  need not review access levels granted to users because these are determined when the system is configured and never change.

Question 19

How are OLTP and OLAP different? Give examples of their use.

Accepted Answer

On-line transaction processing (OLTP) in

Question 20

Which statement is true?

Accepted Answer

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

Distinguish between the two-tier and three-tier client server model. Describe when each would be used.

This chapter stressed the importance of data normalization when constructing a relational database. Why then is it important to denormalize data in a data warehouse?

An access control list specifies the user-ID, the resources available to the user, and the level of permission granted.

RBAC assigns access permissions to the role an individual plays in the organization rather than directly to the individual.

Slicing and dicing permits the disaggregation of data to reveal underlying details.

OLAP stands for on-line application processing.

Most ERPs are based on which network model?

Internal efficiency is cited as one reason for separating the data warehouse from the operational database. Explain.

Organizations using ERP systems employ an internal control tool called a role.

What is the purpose of role- based governance software?

How can a firm acquire bolt-on software? What are the options?

The client/server model is a form of network topology in which user computers, called clients, access ERP programs and data via a host computer called a server.

Closed database architecture is

The setup of a data warehouse includes

How is the access control list approach different from RBAC?

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

What is the closed database architecture?

Auditors of ERP systems

How are OLTP and OLAP different? Give examples of their use.

Which statement is true?

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

Distinguish between the two-tier and three-tier client server model. Describe when each would be used.

This chapter stressed the importance of data normalization when constructing a relational database. Why then is it important to denormalize data in a data warehouse?

An access control list specifies the user-ID, the resources available to the user, and the level of permission granted.

RBAC assigns access permissions to the role an individual plays in the organization rather than directly to the individual.

Slicing and dicing permits the disaggregation of data to reveal underlying details.

OLAP stands for on-line application processing.

Most ERPs are based on which network model?

Internal efficiency is cited as one reason for separating the data warehouse from the operational database. Explain.

Organizations using ERP systems employ an internal control tool called a role.

What is the purpose of role- based governance software?

How can a firm acquire bolt-on software? What are the options?

The client/server model is a form of network topology in which user computers, called clients, access ERP programs and data via a host computer called a server.

Closed database architecture is

The setup of a data warehouse includes

How is the access control list approach different from RBAC?

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

What is the closed database architecture?

Auditors of ERP systems

How are OLTP and OLAP different? Give examples of their use.

Which statement is true?

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