Question 1

What are the basic stages of the data warehousing process?

Accepted Answer

modeling data for the data warehouse,
ex

Question 2

Data entered into the data warehouse must be normalized.

Accepted Answer

A) True 
 B)False

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

On-line transaction processing programs

Accepted Answer

A)  are bolt-on programs used with commercially available ERPs. 
B)  are available in two models-two-tier and three-tier. 
C)  handle large numbers of relatively simple transactions. 
D)  allow users to analyze complex data relationships. 
A)  are bolt-on programs used with commercially available ERPs. 
B)  are available in two models-two-tier and three-tier. 
C)  handle large numbers of relatively simple transactions. 
D)  allow users to analyze complex data relationships.

Question 9

Auditors of ERP systems

Accepted Answer

A)  need not be concerned about segregation of duties because these systems possess strong computer controls. 
B)  focus on output controls such as independent verification to reconcile batch totals. 
C)  are concerned that managers fail to exercise adequate care in assigning permissions. 
D)  do not view the data warehouse as an audit or control issue at all because financial records are not stored there. 
E)  need not review access levels granted to users because these are determined when the system is configured and never change. 
A)  need not be concerned about segregation of duties because these systems possess strong computer controls. 
B)  focus on output controls such as independent verification to reconcile batch totals. 
C)  are concerned that managers fail to exercise adequate care in assigning permissions. 
D)  do not view the data warehouse as an audit or control issue at all because financial records are not stored there. 
E)  need not review access levels granted to users because these are determined when the system is configured and never change.

Question 10

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 11

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 12

The role model assigns specific access privileges directly to individuals.

Accepted Answer

A) True 
 B)False

Question 13

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 pert

Question 14

Auditors of ERP systems

Accepted Answer

A)  need not worry about segregation of duties. 
B)  may feel that the data warehouse is too clean and free from errors. 
C)  find independent verification easy. 
D)  need not worry about system access since the ERP determines it. 
A)  need not worry about segregation of duties. 
B)  may feel that the data warehouse is too clean and free from errors. 
C)  find independent verification easy. 
D)  need not worry about system access since the ERP determines it.

Question 15

The client/server model is a form of network technology in which user computers,called clients,access ERP programs and data via a host computer called a server.

Accepted Answer

A) True 
 B)False

Question 16

ERP implementations are at risk to extensive cost overruns.Discuss three of the more commonly experienced problems area.

Accepted Answer

Training.Training costs are invariably h

Question 17

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.

What are the basic stages of the data warehousing process?

Data entered into the data warehouse must be normalized.

Extracting data for a data warehouse

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

Legacy systems are

Most ERPs are based on which network model?

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

On-line transaction processing programs

Auditors of ERP systems

Which statements about data warehousing is not correct?

Which of the following statements is not true?

The role model assigns specific access privileges directly to individuals.

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?

Auditors of ERP systems

The client/server model is a form of network technology in which user computers,called clients,access ERP programs and data via a host computer called a server.

ERP implementations are at risk to extensive cost overruns.Discuss three of the more commonly experienced problems area.

A data mart is

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

What are the basic stages of the data warehousing process?

Data entered into the data warehouse must be normalized.

Extracting data for a data warehouse

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

Legacy systems are

Most ERPs are based on which network model?

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

On-line transaction processing programs

Auditors of ERP systems

Which statements about data warehousing is not correct?

Which of the following statements is not true?

The role model assigns specific access privileges directly to individuals.

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?

Auditors of ERP systems

The client/server model is a form of network technology in which user computers,called clients,access ERP programs and data via a host computer called a server.

ERP implementations are at risk to extensive cost overruns.Discuss three of the more commonly experienced problems area.

A data mart is

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