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 "drill-down"?

Accepted Answer

Drill-down permits the disaggregation of

Question 3

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 4

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 5

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)  ERP's 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)  ERP's are too large, complex, and generic for them to be well integrated into most company cultures.

Question 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

Data cleansing is a step performed by external auditors to identify and repairing invalid data prior to the audit.

Accepted Answer

A) True 
 B)False

Question 9

What is the purpose of role- based governance systems?

Accepted Answer

Role-based governance systems monitor ro

Question 10

Auditors of ERP systems

Accepted Answer

A)  are concerned about segregation of duties just as they would be in traditional systems. 
B)  focus on output controls such as independent verification because internal processing controls are known to be correct since best practices are used.. 
C)  routinely audit data in the data warehouse because it is know to be clean and free from errors. 
D)  need not review access levels granted to users since these are determined when the system is configured and never change. 
A)  are concerned about segregation of duties just as they would be in traditional systems. 
B)  focus on output controls such as independent verification because internal processing controls are known to be correct since best practices are used.. 
C)  routinely audit data in the data warehouse because it is know to be clean and free from errors. 
D)  need not review access levels granted to users since these are determined when the system is configured and never change.

Question 11

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.

Question 12

On-line transaction processing programs

Accepted Answer

A)  are bolt-on programs used with commercially available ERSs. 
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 ERSs. 
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 13

The primary goal of installing an ERP system is reducing system maintenance costs.

Accepted Answer

A) True 
 B)False

Question 14

Data warehousing processes does not include

Accepted Answer

A)  modeling data 
B)  condensing data 
C)  extracting data 
D)  transforming data 
A)  modeling data 
B)  condensing data 
C)  extracting data 
D)  transforming data

Question 15

ERP implementations are at risk to extensive cost overruns. Discuss three of the more commonly experienced problems area.

Accepted Answer

Training. Training costs are invariably

Question 16

What is scalability?

Accepted Answer

System scalability refers to t

Question 17

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 18

Scalability has several dimensions. What are they? What do they mean for ERP installation?

Accepted Answer

Most organizations want to grow. When a

Question 19

Why do ERP systems need bolt-on software? Give an example.

Accepted Answer

Depending on the unique charac

Question 20

A closed database architecture shares data easily.

Accepted Answer

A) True 
 B)False

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

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

The setup of a data warehouse includes

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

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

Closed database architecture is

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

Data cleansing is a step performed by external auditors to identify and repairing invalid data prior to the audit.

What is the purpose of role- based governance systems?

Auditors of ERP systems

Which statement is true?

On-line transaction processing programs

The primary goal of installing an ERP system is reducing system maintenance costs.

Data warehousing processes does not include

ERP implementations are at risk to extensive cost overruns. Discuss three of the more commonly experienced problems area.

What is scalability?

Legacy systems are

Scalability has several dimensions. What are they? What do they mean for ERP installation?

Why do ERP systems need bolt-on software? Give an example.

A closed database architecture shares data easily.

Auditing and Internal Control

Auditing IT Governance Controls

Auditing Operating Systems and Networks

Auditing Database Systems

Systems Development and Program Change Activities

Transaction Processing and Financial Reporting Systems Overview

Computer Assisted Audit Tools and Techniques

Data Structures and Caatts for Data Extraction

Auditing the Revenue Cycle

Auditing the Expenditure Cycle

Business Ethics, Fraud, and Fraud Detection

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 "drill-down"?

The setup of a data warehouse includes

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

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

Closed database architecture is

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

Data cleansing is a step performed by external auditors to identify and repairing invalid data prior to the audit.

What is the purpose of role- based governance systems?

Auditors of ERP systems

Which statement is true?

On-line transaction processing programs

The primary goal of installing an ERP system is reducing system maintenance costs.

Data warehousing processes does not include

ERP implementations are at risk to extensive cost overruns. Discuss three of the more commonly experienced problems area.

What is scalability?

Legacy systems are

Scalability has several dimensions. What are they? What do they mean for ERP installation?

Why do ERP systems need bolt-on software? Give an example.

A closed database architecture shares data easily.

Auditing and Internal Control

Auditing IT Governance Controls

Auditing Operating Systems and Networks

Auditing Database Systems

Systems Development and Program Change Activities

Transaction Processing and Financial Reporting Systems Overview

Computer Assisted Audit Tools and Techniques

Data Structures and Caatts for Data Extraction

Auditing the Revenue Cycle

Auditing the Expenditure Cycle

Business Ethics, Fraud, and Fraud Detection

Filters