Question 1

A data mart is

Accepted Answer

A) another name for a data warehouse 
B) a database that provides data to an organization's customers 
C) an enterprise resource planning system 
D) a data warehouse created for a single function or department 
A) another name for a data warehouse 
B) a database that provides data to an organization's customers 
C) an enterprise resource planning system 
D) a data warehouse created for a single function or department

Question 2

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 3

A closed database architecture shares data easily.

Accepted Answer

A) True 
 B)False

Question 4

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 pert

Question 5

Which of the following is not 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) The selected system does not adequately meet the adopting firm's economic growth. 
D) 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) The selected system does not adequately meet the adopting firm's economic growth. 
D) ERPs are too large, complex, and generic for them to be well integrated into most company cultures.

Question 6

If an auditor suspected an unusual relationship between a purchasing agent and certain suppliers,how could drill-down be used to collect data?

Accepted Answer

Drill-down capability permits a user to

Question 7

Data entered into the data warehouse must be normalized.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

Online transaction processing (OLTP)invo

Question 9

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

Core applications are

Accepted Answer

A) sales and distribution 
B) business planning 
C) shop floor control and logistics 
D) all of the above 
A) sales and distribution 
B) business planning 
C) shop floor control and logistics 
D) all of the above

Question 11

The recommended data architecture for an ERP includes separate operational and data warehouse databases.

Accepted Answer

A) True 
 B)False

Question 12

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 13

What is the closed database architecture?

Accepted Answer

The closed database architecture is simi

Question 14

What is the fundamental concept behind the rule of least access? Explain why this is a potential problem in an ERP environment.

Accepted Answer

Access privileges (permissions)should be

Question 15

Define the term core applications and give some examples.

Accepted Answer

Core applications are those ap

Question 16

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

Accepted Answer

Successful implementation of an ERP requ

Question 17

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 18

What is a role?

Accepted Answer

A role is the task an individu

Question 19

A two-tier architecture approach is used primarily for wide area network (WAN)applications.

Accepted Answer

A) True 
 B)False

Question 20

What is an access control list?

Accepted Answer

It is a technique fo

A data mart is

Legacy systems are

A closed database architecture shares data easily.

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?

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

If an auditor suspected an unusual relationship between a purchasing agent and certain suppliers,how could drill-down be used to collect data?

Data entered into the data warehouse must be normalized.

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

Online transaction processing programs

Core applications are

The recommended data architecture for an ERP includes separate operational and data warehouse databases.

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

What is the closed database architecture?

What is the fundamental concept behind the rule of least access? Explain why this is a potential problem in an ERP environment.

Define the term core applications and give some examples.

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

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.

What is a role?

A two-tier architecture approach is used primarily for wide area network (WAN)applications.

What is an access control list?

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

Legacy systems are

A closed database architecture shares data easily.

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?

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

If an auditor suspected an unusual relationship between a purchasing agent and certain suppliers,how could drill-down be used to collect data?

Data entered into the data warehouse must be normalized.

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

Online transaction processing programs

Core applications are

The recommended data architecture for an ERP includes separate operational and data warehouse databases.

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

What is the closed database architecture?

What is the fundamental concept behind the rule of least access? Explain why this is a potential problem in an ERP environment.

Define the term core applications and give some examples.

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

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.

What is a role?

A two-tier architecture approach is used primarily for wide area network (WAN)applications.

What is an access control list?

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