Question 1

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 B

Question 2

What are the basic stages of the data warehousing process?

Accepted Answer

modeling data for the data warehouse,
extracting data from the operational databases,
cleansing the extracted data,
transforming data into the warehouse model, and
loading the data into the data warehouse database

Question 3

In two-tier architecture, the database and application functions are separated.

Accepted Answer

A) True 
 B)False  False

Question 4

Define OLAP and give some examples.

Accepted Answer

On-line analytical processing (OLAP) inc

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

What is SCM software?

Accepted Answer

Supply-chain management software is desi

Question 8

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 9

What is a role?

Accepted Answer

It is the task an individual p

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

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

Accepted Answer

Centralized organizations may employ two

Question 12

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 13

Drill-down capability is an OLAP feature of data mining tools.

Accepted Answer

A) True 
 B)False

Question 14

What is scalability?

Accepted Answer

System scalability refers to t

Question 15

What is an access control list?

Accepted Answer

It is a technique fo

Question 16

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 17

A two-tier architecture approach is used primarily for wide area network (WAN) applications.

Accepted Answer

A) True 
 B)False

Question 18

Data warehousing processes do 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 19

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 20

What is the big-bang approach?

Accepted Answer

The big-bang approach to conve

Data cleansing involves all of the following except

What are the basic stages of the data warehousing process?

In two-tier architecture, the database and application functions are separated.

Define OLAP and give some examples.

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

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

What is SCM software?

A data mart is

What is a role?

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

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

Core applications are

Drill-down capability is an OLAP feature of data mining tools.

What is scalability?

What is an access control list?

Which statement is LEAST accurate?

A two-tier architecture approach is used primarily for wide area network (WAN) applications.

Data warehousing processes do not include

Which statements about data warehousing is not correct?

What is the big-bang approach?

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

Construct, Deliver, and Maintain Systems Projects

IT Controls Part I: Sarbanes-Oxley and It Governance

IT Controls Part II: Security and Access

IT Controls Part III: Systems Development, Program Changes, and Application Controls

Filters

Exam 11: Enterprise Resource Planning Systems

Data cleansing involves all of the following except

What are the basic stages of the data warehousing process?

In two-tier architecture, the database and application functions are separated.

Define OLAP and give some examples.

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

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

What is SCM software?

A data mart is

What is a role?

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

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

Core applications are

Drill-down capability is an OLAP feature of data mining tools.

What is scalability?

What is an access control list?

Which statement is LEAST accurate?

A two-tier architecture approach is used primarily for wide area network (WAN) applications.

Data warehousing processes do not include

Which statements about data warehousing is not correct?

What is the big-bang approach?

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

Construct, Deliver, and Maintain Systems Projects

IT Controls Part I: Sarbanes-Oxley and It Governance

IT Controls Part II: Security and Access

IT Controls Part III: Systems Development, Program Changes, and Application Controls

Filters