Question 1

What is meant by the OLAP term "slicing and dicing"?

Accepted Answer

Slicing and dicing enables the user to examine data from different viewpoints. One slice of data might show sales within each region. Another slice might present sales by product across regions. Slicing and dicing is often performed along a time axis to depict trends and patterns.

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

Supply-chain management software is a type of program that supports efforts relative to moving goods from the raw material stage to the customer.

Accepted Answer

A) True 
 B)False  True

Question 4

This chapter stressed the importance of data normalization when constructing a relational database. Why then is it important to de-normalize data in a data warehouse?

Accepted Answer

Wherever possible, normalized tables per

Question 5

How are OLTP and OLAP different? Give examples of their use.

Accepted Answer

On-line transaction processing (OLTP) in

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Define ERP.

Accepted Answer

Enterprise resource planning s

Question 8

Core applications are also called OLAP.

Accepted Answer

A) True 
 B)False

Question 9

Extracting data for a data warehouse

Accepted Answer

A)  cannot be done from flat files. 
B)  should only involve active files. 
C)  requires that the files be out of service. 
D)  follows the cleansing of data. 
A)  cannot be done from flat files. 
B)  should only involve active files. 
C)  requires that the files be out of service. 
D)  follows the cleansing of data.

Question 10

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

Accepted Answer

A)  OLTP applications 
B)  sales and distribution applications 
C)  business planning applications 
D)  OLAP applications 
A)  OLTP applications 
B)  sales and distribution applications 
C)  business planning applications 
D)  OLAP applications

Question 11

A problem with RBAC is that managers tend to create unnecessary roles

Accepted Answer

A) True 
 B)False

Question 12

The big-bang approach involves converting from old legacy systems to the new ERP in one implementation step.

Accepted Answer

A) True 
 B)False

Question 13

If an auditor suspected an "unusual" relationship between a purchasing agent and certain suppliers, how could "drill-down" be used to collect data?

Accepted Answer

Drill-down capability permits a user to

Question 14

Define OLAP and give some examples.

Accepted Answer

On-line analytical processing (OLAP) inc

Question 15

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

Accepted Answer

Many decision makers need similar inform

Question 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

What is SCM software?

Accepted Answer

Supply-chain management software is desi

Question 19

Most ERPs are based on which network model?

Accepted Answer

A)  peer to peer 
B)  client-server 
C)  ring topology 
D)  bus topology 
A)  peer to peer 
B)  client-server 
C)  ring topology 
D)  bus topology

Question 20

OLAP stands for on-line application processing.

Accepted Answer

A) True 
 B)False

What is meant by the OLAP term "slicing and dicing"?

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

Supply-chain management software is a type of program that supports efforts relative to moving goods from the raw material stage to the customer.

This chapter stressed the importance of data normalization when constructing a relational database. Why then is it important to de-normalize data in a data warehouse?

How are OLTP and OLAP different? Give examples of their use.

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

Define ERP.

Core applications are also called OLAP.

Extracting data for a data warehouse

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

A problem with RBAC is that managers tend to create unnecessary roles

The big-bang approach involves converting from old legacy systems to the new ERP in one implementation step.

If an auditor suspected an "unusual" relationship between a purchasing agent and certain suppliers, how could "drill-down" be used to collect data?

Define OLAP and give some examples.

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

Which of the following statements is not true?

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

What is SCM software?

Most ERPs are based on which network model?

OLAP stands for on-line application processing.

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

What is meant by the OLAP term "slicing and dicing"?

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

Supply-chain management software is a type of program that supports efforts relative to moving goods from the raw material stage to the customer.

This chapter stressed the importance of data normalization when constructing a relational database. Why then is it important to de-normalize data in a data warehouse?

How are OLTP and OLAP different? Give examples of their use.

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

Define ERP.

Core applications are also called OLAP.

Extracting data for a data warehouse

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

A problem with RBAC is that managers tend to create unnecessary roles

The big-bang approach involves converting from old legacy systems to the new ERP in one implementation step.

If an auditor suspected an "unusual" relationship between a purchasing agent and certain suppliers, how could "drill-down" be used to collect data?

Define OLAP and give some examples.

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

Which of the following statements is not true?

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

What is SCM software?

Most ERPs are based on which network model?

OLAP stands for on-line application processing.

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