Question 1

OLAP includes decision support,modeling,information retrieval,and what-if analysis.

Accepted Answer

A) True 
 B)False

Question 2

If a chosen ERP cannot handle a specific company process bolt-on software may be available.

Accepted Answer

A) True 
 B)False

Question 3

Why does data need to be "cleansed"?

Accepted Answer

Data cleansing involves filter

Question 4

Data entered into the data warehouse must be normalized.

Accepted Answer

A) True 
 B)False

Question 5

Why must a data warehouse include both detail and summary data?

Accepted Answer

Many decision makers need similar inform

Question 6

What is meant by the OLAP term - consolidation

Accepted Answer

Consolidation is the aggregati

Question 7

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 8

OLAP stands for on-line application processing.

Accepted Answer

A) True 
 B)False

Question 9

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 10

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 11

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

Accepted Answer

Successful implementation of an ERP requ

Question 12

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 13

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

Accepted Answer

A) True 
 B)False

Question 14

The primary goal of installing an ERP system is achieving business process reengineering to improve customer service,reduce production time,increase productivity,and improve decision-making.

Accepted Answer

A) True 
 B)False

Question 15

Separating the data warehouse from the operations databases occurs for all of the following reasons except

Accepted Answer

A)  to make the management of the databases more economical 
B)  to increase the efficiency of data mining processes 
C)  to integrate legacy system data into a form that permits entity-wide analysis 
D)  to permit the integration of data from diverse sources 
A)  to make the management of the databases more economical 
B)  to increase the efficiency of data mining processes 
C)  to integrate legacy system data into a form that permits entity-wide analysis 
D)  to permit the integration of data from diverse sources

Question 16

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

Accepted Answer

Most organizations want to grow.When a n

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

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 19

What is scalability?

Accepted Answer

System scalability refers to t

Question 20

Describe the three-tier client server model.

Accepted Answer

The database and application functions a

OLAP includes decision support,modeling,information retrieval,and what-if analysis.

If a chosen ERP cannot handle a specific company process bolt-on software may be available.

Why does data need to be "cleansed"?

Data entered into the data warehouse must be normalized.

Why must a data warehouse include both detail and summary data?

What is meant by the OLAP term - consolidation

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

OLAP stands for on-line application processing.

Core applications are

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

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

Data warehousing processes does not include

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

The primary goal of installing an ERP system is achieving business process reengineering to improve customer service,reduce production time,increase productivity,and improve decision-making.

Separating the data warehouse from the operations databases occurs for all of the following reasons except

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

Legacy systems are

A data mart is

What is scalability?

Describe the three-tier client server model.

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

OLAP includes decision support,modeling,information retrieval,and what-if analysis.

If a chosen ERP cannot handle a specific company process bolt-on software may be available.

Why does data need to be "cleansed"?

Data entered into the data warehouse must be normalized.

Why must a data warehouse include both detail and summary data?

What is meant by the OLAP term - consolidation

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

OLAP stands for on-line application processing.

Core applications are

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

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

Data warehousing processes does not include

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

The primary goal of installing an ERP system is achieving business process reengineering to improve customer service,reduce production time,increase productivity,and improve decision-making.

Separating the data warehouse from the operations databases occurs for all of the following reasons except

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

Legacy systems are

A data mart is

What is scalability?

Describe the three-tier client server model.

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