Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

Define the term "core applications" and give some examples.

Accepted Answer

Core applications are those ap

Question 4

Data in a data warehouse are in a stable state.Explain how this can hamper data mining analysis? What can an organization do to alleviate this problem?

Accepted Answer

Typically transaction data are loaded in

Question 5

Why does data need to be cleansed?

Accepted Answer

Data cleansing involves filter

Question 6

Briefly explain the two general approaches to contingency planning for ERPs.

Accepted Answer

Centralized organizations may employ two

Question 7

Which statement is most correct?

Accepted Answer

A)  SAP is more suited to service industries than manufacturing clients. 
B)  J.D. Edwards's ERP is designed to accept the best practices modules of other vendors. 
C)  Oracle evolved from a human resources system. 
D)  PeopleSoft is the world's leading supplier of software for information management. 
E)  SoftBrands provides enterprise software for the hospitality and manufacturing sectors. 
A)  SAP is more suited to service industries than manufacturing clients. 
B)  J.D. Edwards's ERP is designed to accept the best practices modules of other vendors. 
C)  Oracle evolved from a human resources system. 
D)  PeopleSoft is the world's leading supplier of software for information management. 
E)  SoftBrands provides enterprise software for the hospitality and manufacturing sectors.

Question 8

Explain the risks associated with the creation of unnecessary roles and why it can happen.

Accepted Answer

Managers in ERP environments have signif

Question 9

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 10

Describe the three-tier client server model.

Accepted Answer

The database and application functions a

Question 11

Core applications are also called OLAP.

Accepted Answer

A) True 
 B)False

Question 12

How is the access control list approach different from RBAC?

Accepted Answer

The access control list approach assigns

Question 13

Companies are more likely to modify an ERP to accommodate the company than to modify company processes to accommodate the ERP.

Accepted Answer

A) True 
 B)False

Question 14

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 15

What is meant by the OLAP term: consolidation?

Accepted Answer

Consolidation is the aggregati

Question 16

Which of the following statements is least likely to be true about a data warehouse?

Accepted Answer

A)  It is constructed for quick searching and ad hoc queries. 
B)  It was an original part of all ERP systems. 
C)  It contains data that are normally extracted periodically from the operating databases. 
D)  It may be deployed by organizations that have not implemented an ERP. 
A)  It is constructed for quick searching and ad hoc queries. 
B)  It was an original part of all ERP systems. 
C)  It contains data that are normally extracted periodically from the operating databases. 
D)  It may be deployed by organizations that have not implemented an ERP.

Question 17

What is the big-bang approach?

Accepted Answer

The big-bang approach to conve

Question 18

Goals of ERP include all of the following except

Accepted Answer

A)  improved customer service 
B)  improvements of legacy systems 
C)  reduced production time 
D)  increased production 
A)  improved customer service 
B)  improvements of legacy systems 
C)  reduced production time 
D)  increased production

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

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

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

Define the term "core applications" and give some examples.

Data in a data warehouse are in a stable state.Explain how this can hamper data mining analysis? What can an organization do to alleviate this problem?

Why does data need to be cleansed?

Briefly explain the two general approaches to contingency planning for ERPs.

Which statement is most correct?

Explain the risks associated with the creation of unnecessary roles and why it can happen.

The setup of a data warehouse includes

Describe the three-tier client server model.

Core applications are also called OLAP.

How is the access control list approach different from RBAC?

Companies are more likely to modify an ERP to accommodate the company than to modify company processes to accommodate the ERP.

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

What is meant by the OLAP term: consolidation?

Which of the following statements is least likely to be true about a data warehouse?

What is the big-bang approach?

Goals of ERP include all of the following except

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

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

The Information System: An Accountant’s 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

General Ledger, 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

Construct, Deliver, and Maintain Systems Projects

IT Controls : Sarbanes-Oxley and IT Governance

IT Controls : Security and Access

IT Controls : Systems Development Program Changes and Application Controls

Filters

Exam 11: Enterprise Resource Planning Systems

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

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

Define the term "core applications" and give some examples.

Data in a data warehouse are in a stable state.Explain how this can hamper data mining analysis? What can an organization do to alleviate this problem?

Why does data need to be cleansed?

Briefly explain the two general approaches to contingency planning for ERPs.

Which statement is most correct?

Explain the risks associated with the creation of unnecessary roles and why it can happen.

The setup of a data warehouse includes

Describe the three-tier client server model.

Core applications are also called OLAP.

How is the access control list approach different from RBAC?

Companies are more likely to modify an ERP to accommodate the company than to modify company processes to accommodate the ERP.

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

What is meant by the OLAP term: consolidation?

Which of the following statements is least likely to be true about a data warehouse?

What is the big-bang approach?

Goals of ERP include all of the following except

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

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

The Information System: An Accountant’s 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

General Ledger, 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

Construct, Deliver, and Maintain Systems Projects

IT Controls : Sarbanes-Oxley and IT Governance

IT Controls : Security and Access

IT Controls : Systems Development Program Changes and Application Controls

Filters