Question 1

Generally speaking,an enterprise data warehouse is directly accessible by end users.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following functions manages just the interface between system users and the software,including the display and printing of forms and reports and possibly validating system inputs?

Accepted Answer

A) data analysis 
B) data presentation 
C) data management 
D) transport management 
A) data analysis 
B) data presentation 
C) data management 
D) transport management

Question 3

File server-based architectures benefit from having a very fast hard disk and cache memory in both clients and the server,enhancing their ability to transfer files to and from the network,RAM,and hard disk.

Accepted Answer

A) True 
 B)False

Question 4

An advantage to using file servers on local area networks is the ability to centralize data control.

Accepted Answer

A) True 
 B)False

Question 5

The process of linking together previous stand-alone personal computers to form networks that support workgroup computing is sometimes called:

Accepted Answer

A) upsizing 
B) downsizing 
C) upgrading 
D) communicating 
A) upsizing 
B) downsizing 
C) upgrading 
D) communicating

Question 6

The primary characteristic of a client-based LAN is that:

Accepted Answer

A) all data manipulation is performed at the file server,not at the client PC 
B) all data manipulation is performed at the client PC,not at the file server 
C) each client has a copy of the database and performs all data manipulations 
D) the database is stored on the file server and all data manipulations are performed by the file server 
A) all data manipulation is performed at the file server,not at the client PC 
B) all data manipulation is performed at the client PC,not at the file server 
C) each client has a copy of the database and performs all data manipulations 
D) the database is stored on the file server and all data manipulations are performed by the file server

Question 7

Which of the following statements regarding the differences between file server and client/server architectures is true?

Accepted Answer

A) While the file server architecture involves efficient data transfers,the client/server architecture has large file and data transfers. 
B) Servers and clients perform processing in a file server architecture.Only servers perform processing in a client/server architecture. 
C) While database security and integrity on a file server architecture is high,it is low on the client/server architecture. 
D) While software maintenance on the file server architecture is considered low,software maintenance on the client/server architecture is mixed since some new parts must be delivered to each client. 
A) While the file server architecture involves efficient data transfers,the client/server architecture has large file and data transfers. 
B) Servers and clients perform processing in a file server architecture.Only servers perform processing in a client/server architecture. 
C) While database security and integrity on a file server architecture is high,it is low on the client/server architecture. 
D) While software maintenance on the file server architecture is considered low,software maintenance on the client/server architecture is mixed since some new parts must be delivered to each client.

Question 8

Match each of the following terms with its corresponding definition.
-A system designed to support decision making based on stable point-in-time or historical data.

Accepted Answer

A) data mart 
B) data warehouse 
C) enterprise data warehouse 
D) informational system 
E) online analytical processing
F)online transaction processing
G)operational system 
A) data mart 
B) data warehouse 
C) enterprise data warehouse 
D) informational system 
E) online analytical processing
F)online transaction processing
G)operational system

Question 9

Match each of the following terms with its corresponding definition.
-A measurement of how far into the existing technology infrastructure a system penetrates.

Accepted Answer

A) context development 
B) customization 
C) integration depth 
D) organizational breadth 
E) personalization 
A) context development 
B) customization 
C) integration depth 
D) organizational breadth 
E) personalization

Question 10

Which of the following client/server architectures combines the best features of the distributed function and distributed database by splitting both of these across client and server,with presentation functions under the exclusive responsibility of the client machine?

Accepted Answer

A) distributed presentation 
B) remote data management 
C) distributed management 
D) distributed processing 
A) distributed presentation 
B) remote data management 
C) distributed management 
D) distributed processing

Question 11

An advantage of client/server architectures is the ability to decouple the client environment from the server environment.

Accepted Answer

A) True 
 B)False

Question 12

__________ is the use of graphical software tools that provide complex analysis of data stored in a database.

Accepted Answer

Online ana

Question 13

The use of graphical software tools that provide complex analysis of data stored in a database best defines:

Accepted Answer

A) on-line knowledge analysis 
B) on-line transaction processing 
C) on-line analytical processing 
D) on-line critical processing 
A) on-line knowledge analysis 
B) on-line transaction processing 
C) on-line analytical processing 
D) on-line critical processing

Question 14

XSL-based formatting consists of methods for transforming XML documents into a generic comprehensive form and formatting the generic comprehensive form into a device specific form.

Accepted Answer

A) True 
 B)False

Question 15

Providing Internet content to users based upon knowledge of that customer defines customization.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is not an Internet standard?

Accepted Answer

A) BIND 
B) HTML 
C) HTTP 
D) OOAD 
A) BIND 
B) HTML 
C) HTTP 
D) OOAD

Question 17

__________ is a combination of hardware,software,and communication technologies that bring together data management,presentation,and analysis into a three-tiered client/server environment.

Accepted Answer

The answer of __________ is a combination of hardware,software,and communication...

Question 18

In a three-layer data warehouse architecture,users access the data that have been derived from the enterprise data warehouse that are stored in data marts.

Accepted Answer

A) True 
 B)False

Question 19

A centralized,integrated data warehouse that is the control point and single source of all data made available to end users for decision-support applications throughout the entire organization best describes a(n):

Accepted Answer

A) information desk 
B) enterprise data warehouse 
C) centralized data mart 
D) data center 
A) information desk 
B) enterprise data warehouse 
C) centralized data mart 
D) data center

Question 20

To support concurrent access from multiple users of a shared database,the LAN modules of a DBMS add:

Accepted Answer

A) concurrent access controls 
B) extra security features 
C) query or transaction queuing management 
D) all of the above 
A) concurrent access controls 
B) extra security features 
C) query or transaction queuing management 
D) all of the above

Generally speaking,an enterprise data warehouse is directly accessible by end users.

Which of the following functions manages just the interface between system users and the software,including the display and printing of forms and reports and possibly validating system inputs?

File server-based architectures benefit from having a very fast hard disk and cache memory in both clients and the server,enhancing their ability to transfer files to and from the network,RAM,and hard disk.

An advantage to using file servers on local area networks is the ability to centralize data control.

The process of linking together previous stand-alone personal computers to form networks that support workgroup computing is sometimes called:

The primary characteristic of a client-based LAN is that:

Which of the following statements regarding the differences between file server and client/server architectures is true?

Match each of the following terms with its corresponding definition. -A system designed to support decision making based on stable point-in-time or historical data.

Match each of the following terms with its corresponding definition. -A measurement of how far into the existing technology infrastructure a system penetrates.

Which of the following client/server architectures combines the best features of the distributed function and distributed database by splitting both of these across client and server,with presentation functions under the exclusive responsibility of the client machine?

An advantage of client/server architectures is the ability to decouple the client environment from the server environment.

__________ is the use of graphical software tools that provide complex analysis of data stored in a database.

The use of graphical software tools that provide complex analysis of data stored in a database best defines:

XSL-based formatting consists of methods for transforming XML documents into a generic comprehensive form and formatting the generic comprehensive form into a device specific form.

Providing Internet content to users based upon knowledge of that customer defines customization.

Which of the following is not an Internet standard?

__________ is a combination of hardware,software,and communication technologies that bring together data management,presentation,and analysis into a three-tiered client/server environment.

In a three-layer data warehouse architecture,users access the data that have been derived from the enterprise data warehouse that are stored in data marts.

A centralized,integrated data warehouse that is the control point and single source of all data made available to end users for decision-support applications throughout the entire organization best describes a(n):

To support concurrent access from multiple users of a shared database,the LAN modules of a DBMS add:

The Systems Development Environment

The Origins of Software

Managing the Information Systems Project

Identifying and Selecting Systems Development Projects

Initiating and Planning Systems Development Projects

Determining System Requirements

Structuring System Process Requirements

Structuring System Data Requirements

Designing Databases

Designing Forms and Reports

Designing Interfaces and Dialogues

System Implementation

Maintaining Information Systems

Object-Oriented Analysis and Design: Use Cases

Object-Oriented Analysis and Design: Activity Diagrams

Objected-Oriented Analysis and Design: Object Modeling-Class Diagrams

Object-Oriented Analysis and Design: Sequence Diagrams

Filters

Exam 12: Designing Distributed and Internet Systems

Generally speaking,an enterprise data warehouse is directly accessible by end users.

Which of the following functions manages just the interface between system users and the software,including the display and printing of forms and reports and possibly validating system inputs?

File server-based architectures benefit from having a very fast hard disk and cache memory in both clients and the server,enhancing their ability to transfer files to and from the network,RAM,and hard disk.

An advantage to using file servers on local area networks is the ability to centralize data control.

The process of linking together previous stand-alone personal computers to form networks that support workgroup computing is sometimes called:

The primary characteristic of a client-based LAN is that:

Which of the following statements regarding the differences between file server and client/server architectures is true?

Match each of the following terms with its corresponding definition. -A system designed to support decision making based on stable point-in-time or historical data.

Match each of the following terms with its corresponding definition. -A measurement of how far into the existing technology infrastructure a system penetrates.

Which of the following client/server architectures combines the best features of the distributed function and distributed database by splitting both of these across client and server,with presentation functions under the exclusive responsibility of the client machine?

An advantage of client/server architectures is the ability to decouple the client environment from the server environment.

__________ is the use of graphical software tools that provide complex analysis of data stored in a database.

The use of graphical software tools that provide complex analysis of data stored in a database best defines:

XSL-based formatting consists of methods for transforming XML documents into a generic comprehensive form and formatting the generic comprehensive form into a device specific form.

Providing Internet content to users based upon knowledge of that customer defines customization.

Which of the following is not an Internet standard?

__________ is a combination of hardware,software,and communication technologies that bring together data management,presentation,and analysis into a three-tiered client/server environment.

In a three-layer data warehouse architecture,users access the data that have been derived from the enterprise data warehouse that are stored in data marts.

A centralized,integrated data warehouse that is the control point and single source of all data made available to end users for decision-support applications throughout the entire organization best describes a(n):

To support concurrent access from multiple users of a shared database,the LAN modules of a DBMS add:

The Systems Development Environment

The Origins of Software

Managing the Information Systems Project

Identifying and Selecting Systems Development Projects

Initiating and Planning Systems Development Projects

Determining System Requirements

Structuring System Process Requirements

Structuring System Data Requirements

Designing Databases

Designing Forms and Reports

Designing Interfaces and Dialogues

System Implementation

Maintaining Information Systems

Object-Oriented Analysis and Design: Use Cases

Object-Oriented Analysis and Design: Activity Diagrams

Objected-Oriented Analysis and Design: Object Modeling-Class Diagrams

Object-Oriented Analysis and Design: Sequence Diagrams

Filters