Question 1

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 2

The client/server model is a form of network technology 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 3

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

Accepted Answer

Training.Training costs are invariably h

Question 4

Which statements about data warehousing is not correct?

Accepted Answer

A)  The data warehouse should be separate from the operational system. 
B)  Data cleansing is a process of transforming data into standard form. 
C)  Drill-down is a data-mining tool available to users of OLAP. 
D)  Normalization is an requirement of databases included in a data warehouse. 
A)  The data warehouse should be separate from the operational system. 
B)  Data cleansing is a process of transforming data into standard form. 
C)  Drill-down is a data-mining tool available to users of OLAP. 
D)  Normalization is an requirement of databases included in a data warehouse.

Question 5

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 6

Which of the following is usually not part of an ERP's core applications?

Accepted Answer

A)  OLTP applications 
B)  sales and distribution applications 
C)  business planning applications 
D)  OLAP applications 
A)  OLTP applications 
B)  sales and distribution applications 
C)  business planning applications 
D)  OLAP applications

Question 7

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

Accepted Answer

Normalizing data in an operational datab

Question 8

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

Accepted Answer

Depending on the unique charac

Question 9

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 10

Which statement about ERP installation is least accurate?

Accepted Answer

A)  For the ERP to be successful, process reengineering must occur. 
B)  ERP fails because some important business process is not supported. 
C)  When a business is diversified, little is gained from ERP installation. 
D)  The phased-in approach is more suited to diversified businesses. 
A)  For the ERP to be successful, process reengineering must occur. 
B)  ERP fails because some important business process is not supported. 
C)  When a business is diversified, little is gained from ERP installation. 
D)  The phased-in approach is more suited to diversified businesses.

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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 ha

Question 13

ERP systems support a smooth and seamless flow of information across organizations.

Accepted Answer

A) True 
 B)False

Question 14

What is meant by the OLAP term - Slicing and dicing?

Accepted Answer

Slicing and dicing enables the user to e

Question 15

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 16

Data mining typically focuses on the operational databases.

Accepted Answer

A) True 
 B)False

Question 17

Data cleansing involves all of the following except

Accepted Answer

A)  filtering out or repairing invalid data 
B)  summarizing data for ease of extraction 
C)  transforming data into standard business terms 
D)  formatting data from legacy systems 
A)  filtering out or repairing invalid data 
B)  summarizing data for ease of extraction 
C)  transforming data into standard business terms 
D)  formatting data from legacy systems

Question 18

Which of the following is usually not part of an ERP's OLAP applications?

Accepted Answer

A)  logistics 
B)  decision support systems 
C)  ad hoc analysis 
D)  what-if analysis 
A)  logistics 
B)  decision support systems 
C)  ad hoc analysis 
D)  what-if analysis

Question 19

What is the client-server model?

Accepted Answer

The client-server model is a form of net

Question 20

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

Accepted Answer

A) True 
 B)False

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

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

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

Which statements about data warehousing is not correct?

The setup of a data warehouse includes

Which of the following is usually not part of an ERP's core applications?

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

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

Auditors of ERP systems

Which statement about ERP installation is least accurate?

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

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

ERP systems support a smooth and seamless flow of information across organizations.

What is meant by the OLAP term - Slicing and dicing?

Which statement is true?

Data mining typically focuses on the operational databases.

Data cleansing involves all of the following except

Which of the following is usually not part of an ERP's OLAP applications?

What is the client-server model?

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

Auditing and Internal Control

Auditing IT Governance Controls

Security Part I: Auditing Operating Systems and Networks

IT Security Part II: Auditing Database Systems

Systems Development and Program Change Activities

Overview of Transaction Processing and Financial Reporting Systems

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

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

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

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

Which statements about data warehousing is not correct?

The setup of a data warehouse includes

Which of the following is usually not part of an ERP's core applications?

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

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

Auditors of ERP systems

Which statement about ERP installation is least accurate?

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

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

ERP systems support a smooth and seamless flow of information across organizations.

What is meant by the OLAP term - Slicing and dicing?

Which statement is true?

Data mining typically focuses on the operational databases.

Data cleansing involves all of the following except

Which of the following is usually not part of an ERP's OLAP applications?

What is the client-server model?

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

Auditing and Internal Control

Auditing IT Governance Controls

Security Part I: Auditing Operating Systems and Networks

IT Security Part II: Auditing Database Systems

Systems Development and Program Change Activities

Overview of Transaction Processing and Financial Reporting Systems

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