Question 1

Day-to-day transactions are stored in the operational database.

Accepted Answer

A) True 
 B)False

Question 2

The role model assigns specific access privileges directly to individuals.

Accepted Answer

A) True 
 B)False

Question 3

What is meant by the OLAP term "consolidation"?

Accepted Answer

Consolidation is the aggregati

Question 4

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 5

Almost all ERP implementations involve an outside consultant.

Accepted Answer

A) True 
 B)False

Question 6

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 7

Data entered into the data warehouse must be normalized.

Accepted Answer

A) True 
 B)False

Question 8

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 9

Why does data need to be "cleansed"?

Accepted Answer

Data cleansing involves filter

Question 10

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 b

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Supply chain management software

Accepted Answer

A)  is typically under the control of external partners in the chain. 
B)  links all of the partners in the chain, including vendors, carriers, third-party firms, and information systems providers. 
C)  cannot be integrated into an overall ERP. 
D)  none of the above 
A)  is typically under the control of external partners in the chain. 
B)  links all of the partners in the chain, including vendors, carriers, third-party firms, and information systems providers. 
C)  cannot be integrated into an overall ERP. 
D)  none of the above

Question 13

Which statement is LEAST accurate?

Accepted Answer

A)  Implementing an ERP system has as much to do with changing the way an organization does business than it does with technology. 
B)  The big-bang approach to ERP implementation is generally riskier than the phased in approach. 
C)  To take full advantage of the ERP process, reengineering will need to occur. 
D)  A common reason for ERP failure is that the ERP does not support one or more important business processes of the organization 
A)  Implementing an ERP system has as much to do with changing the way an organization does business than it does with technology. 
B)  The big-bang approach to ERP implementation is generally riskier than the phased in approach. 
C)  To take full advantage of the ERP process, reengineering will need to occur. 
D)  A common reason for ERP failure is that the ERP does not support one or more important business processes of the organization

Question 14

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 15

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 16

What is the closed database architecture?

Accepted Answer

The closed database architecture is simi

Question 17

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

Accepted Answer

When a firm needs additional function no

Question 18

What are the basic stages of the data warehousing process?

Accepted Answer

modeling data for the data warehouse,
ex

Question 19

What is the "Big-Bang" approach?

Accepted Answer

The big-bang approach to conve

Question 20

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

Day-to-day transactions are stored in the operational database.

The role model assigns specific access privileges directly to individuals.

What is meant by the OLAP term "consolidation"?

Data cleansing involves all of the following except

Almost all ERP implementations involve an outside consultant.

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

Data entered into the data warehouse must be normalized.

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

Why does data need to be "cleansed"?

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

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

Supply chain management software

Which statement is LEAST accurate?

Auditors of ERP systems

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

What is the closed database architecture?

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

What are the basic stages of the data warehousing process?

What is the "Big-Bang" approach?

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

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

Day-to-day transactions are stored in the operational database.

The role model assigns specific access privileges directly to individuals.

What is meant by the OLAP term "consolidation"?

Data cleansing involves all of the following except

Almost all ERP implementations involve an outside consultant.

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

Data entered into the data warehouse must be normalized.

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

Why does data need to be "cleansed"?

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

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

Supply chain management software

Which statement is LEAST accurate?

Auditors of ERP systems

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

What is the closed database architecture?

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

What are the basic stages of the data warehousing process?

What is the "Big-Bang" approach?

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

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