Question 1

Define OLAP and give some examples.

Accepted Answer

Online analytical processing (OLAP)inclu

Question 2

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 3

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

Accepted Answer

Centralized organizations may employ two

Question 4

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

Accepted Answer

Depending on the unique charac

Question 5

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

Accepted Answer

Normalizing data in an operational datab

Question 6

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 7

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

Accepted Answer

Many decision makers need similar inform

Question 8

Which of the following statements is not true?

Accepted Answer

A) In a typical two-tier client server system, the server handles both application and database duties. 
B) Client computers are responsible for presenting data to the user and passing user input back to the server. 
C) In three-tier client server architecture, one tier is for user presentations, one is for database and applications, and the third is for Internet access. 
D) The database and application functions are separate in the three-tier model. 
A) In a typical two-tier client server system, the server handles both application and database duties. 
B) Client computers are responsible for presenting data to the user and passing user input back to the server. 
C) In three-tier client server architecture, one tier is for user presentations, one is for database and applications, and the third is for Internet access. 
D) The database and application functions are separate in the three-tier model.

Question 9

Efficient supply-chain management provides firms with a competitive advantage.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

The conclusion that a data warehouse mus

Question 11

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 12

What is data cleansing?

Accepted Answer

Data cleansing involves filter

Question 13

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 a 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 a requirement of databases included in a data warehouse.

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Define ERP.

Accepted Answer

Enterprise resource planning s

Define OLAP and give some examples.

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

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

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

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

Which statement about ERP installation is least accurate?

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

Which of the following statements is not true?

Efficient supply-chain management provides firms with a competitive advantage.

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

The setup of a data warehouse includes

What is data cleansing?

Which statements about data warehousing is not correct?

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

Define ERP.

The Information System: an Accountants 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

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

Auditing It Controls Part I: Sarbanes-Oxley and It Governance

Auditing It Controls Part II: Security and Access

Auditing It Controls Part III: Systems Development, program Changes, and Application Auditing

Filters

Exam 11: Enterprise Resource Planning Systems

Define OLAP and give some examples.

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

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

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

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

Which statement about ERP installation is least accurate?

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

Which of the following statements is not true?

Efficient supply-chain management provides firms with a competitive advantage.

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

The setup of a data warehouse includes

What is data cleansing?

Which statements about data warehousing is not correct?

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

Define ERP.

The Information System: an Accountants 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

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

Auditing It Controls Part I: Sarbanes-Oxley and It Governance

Auditing It Controls Part II: Security and Access

Auditing It Controls Part III: Systems Development, program Changes, and Application Auditing

Filters