WorksheetsTN Integration
Total questions: 114
Worksheet time: 57mins
Name
Class
Date
1.
Choose the best answer for this question "What does system integration mean?"
a)
It means many separate systems need to become one.
b)
More than one application, module or component that can't use anymore, so they have to replace by another new one.
c)
More than one application, module or component that can share data and present user with consistent information.
d)
More than one application, module or component that can connect to the same databases.
2.
What are the advantages for integrating legacy systems?
a)
Support for electronic commerce and cost saving.
b)
Common security infrastructure and management information.
c)
Both a and b are correct.
d)
None is correct.
3.
Why system integrated can support information management?
a)
Because data consistency and accessibility
b)
Because data and process consistency.
c)
Because we can analyses historical data.
d)
All are correct.
4.
What is an important issue we can get when system integrated support for electronic commerce?
a)
Greater data
b)
Greater security risks
c)
Complex process
d)
Reliable communication of information.
5.
How can the system integrated operate reliable?
a)
Redundancy
b)
Backup and recovery designed into the system.
c)
Hire more employee.
d)
A and b are correct.
6.
Why are integration heuristics important?
a)
Because they were the rules and formulas for the integration system.
b)
Because system engineers have only worked on a few complex systems in their lifetime.
c)
Because the integration system does not yet have the rules and formulas.
d)
Both b and c are correct.
7.
What are the basic differs from System Integration life cycle and Software Development life cycle?
a)
Legacy system analysis.
b)
Testing.
c)
Dependencies.
d)
All are correct.
8.
When will you choose the Agile to integrate two systems?
a)
Defined requirements when project starts.
b)
When user involve to project.
c)
When apply for a large project.
d)
When approach structurally
9.
What are different types of system integration life cycles?
a)
Presentation, Data and Functional Integration
b)
Waterfall, Spiral, Agile.
c)
Requirements and specification, design and implementation.
d)
Requirements and specification, implementation and testing
10.
Which phases are emphasized in system integration life cycles?
a)
Requirements and specification
b)
Testing, Maintenance and Retirement
c)
Both a and b are correct
d)
None is correct.
11.
What need you do in requirements and specification phase when you want to integrate two systems?
a)
Collect requirements.
b)
Identify user involve
c)
Legacy system analysis.
d)
None is correct.
12.
Why is testing in system integration more complex than in system development?
a)
Because design tests that are within system integrator's control
b)
Data adhere to specifications
c)
Have to test all scenarios.
d)
All are correct.
13.
Why do the legacy systems need to remain in place until new systems are completely integrated?
a)
To minimize changing.
b)
To reduce cost.
c)
For system integrated be tested in planned.
d)
To operating easier.
14.
Is process the most important choice system integration projects? Why?
a)
Yes. Easy to control and monitor the result of project.
b)
No. The engineers who give the solutions for the problems is the most important.
c)
Yes. Following the process will get the right solutions.
d)
å¨åŠ›No. Both the engineers, who give the solutions for the problems, and process are needed.
15.
Which factors affect to selection process for system integration?
a)
Ability to handle rapidly changing (unstable) set of requirements
b)
Complexity or size of product
c)
Suitability for small development team
d)
All are correct.
16.
How many types of integration model are there? And what are they?
a)
4-Waterfall, Rapid Application Development, Spiral, Agile.
b)
3-Waterfall, Spiral, Agile.
c)
3-Presentation, Functional and Data Integration.
d)
Both a and c are correct.
17.
Which are the characteristics of Presentation Integration?
a)
Database is independent and may have inconsistent information.
b)
It's read only.
c)
Both a and b are correct.
d)
None is correct.
18.
Which is advantage of Presentation Model?
a)
Easy to implement
b)
Information presentation often meets user need
c)
Legacy applications unaffected.
d)
All are correct.
19.
When is it appropriate to use the Presentation Model?
a)
Data cannot be accessed directly.
b)
Integrate with an application whose only useful and implementable integration is through its presentation.
c)
Both a and b are correct.
d)
Data can be accessed directly.
20.
What are characteristics of the Data Integration model?
a)
Data is accessed directly from all data sources.
b)
Information can be updated in both data sources.
c)
A and b are correct.
d)
None is correct.
21.
When is it appropriate to use the Data Integration model?
a)
Allows data to be extracted from one source and reformatted and updated in another database.
b)
You can combine data from multiple sources for analysis and decision making.
c)
None is correct.
d)
A and b are correct
22.
What are the disadvantages of Data Integration model?
a)
Data may be inconsistent
b)
Inability to access business logic in legacy applications may constrain available functionality
c)
Redundant code possible.
d)
All are correct.
23.
What are advantages of Functional Integration model?
a)
Complete access to all data and business logic and can update legacy applications if necessary.
b)
Can't update legacy applications.
c)
Data is inconsistent in the system.
d)
Data is redundancy in the system.
24.
What is disadvantage of Functional Integration model?
a)
Data may be consistent.
b)
Legacy applications can unhelpful.
c)
It is the most difficult to implement.
d)
All are correct.
25.
How many integrated system services are there? What are they?
a)
3- Naming, security and authentication service.
b)
3-Naming, security and reliability service.
c)
3-Authentication, Access control, Reliability service.
d)
4- Authentication, access control, balancing, data redundancy service.
26.
What is a naming service?
a)
A server to store the name of system entities.
b)
A software that converts a name into a physical address.
c)
A Domain name service.
d)
A set of names.
27.
What is the problem when integrated system has naming services?
a)
Entities don't have name.
b)
Entities can't be found
c)
Resolving duplicate names.
d)
User don't know how to find other system entities.
28.
What can we do to have a security service?
a)
Load balancing and data redundancy.
b)
Authenticated, access control and logging activities.
c)
None is correct.
d)
Both a and b are correct.
29.
How can an integrated system reliability?
a)
Replication
b)
Data redundancy.
c)
Load balance.
d)
All are correct.
30.
After data sources updated, how long will the system be in the consistent state?
a)
Real time
b)
Near real time
c)
One day
d)
Based on user requirements.
31.
What is ACID stand for?
a)
Automatic- Consistency- Information- Durability.
b)
Autonomous - Completion - Identified - Durability.
c)
Atomicity- Consistency - Isolation - Durability.
d)
Atomicity- Completion - Isolation- Durability.
32.
Why are the integration guidelines important when designing an integrated system?
a)
Because the system integrator does not have complete control over the integrated system, so minimizing dependencies and changes in each application.
b)
Because they are heuristics.
c)
Because they help maximizing coupling.
d)
Because they are the way to integrate two applications.
33.
How many *integration styles* are there? What are they?
a)
2- File Transfer, Shared databases.
b)
3- File Transfer, Shared databases, Messaging system.
c)
4- File Transfer, Shared databases, Remote Procedure Invocation, Messaging Systems.
d)
None is correct.
34.
What are the disadvantages of file integration style?
a)
The integrator workload with formats, file management, bad data.
b)
No special tool necessary.
c)
Receiving application can manipulate file data.
d)
Almost all applications use/produce files.
35.
What are the advantages of shared database integration?
a)
Data is inconsistency
b)
Multiple file formats
c)
Database may become performance bottleneck.
d)
Data consistency and standard query language.
36.
What are the disadvantages of shared database integration?
a)
Data is inconsistency.
b)
No multiple files format
c)
Database may become performance bottleneck.
d)
Single technology.
37.
What are the advantages of messaging system style?
a)
Asynchronous data transfer.
b)
Choice among topologies.
c)
Timeliness and reliability.
d)
All are correct.
38.
How many *architectures are there for data integration*?
a)
4
b)
3
c)
2
d)
1
39.
Which are common mistakes in data integration?
a)
Creating a big new database.
b)
Integrate data at all sites.
c)
Analyzing legacy database to finish developing a's new database
d)
Testing without a sufficient set of real data.
40.
What is the main goal of database normalization?
a)
Restructure the logical data model of a database to eliminate redundancy.
b)
Reduce the potential for data anomalies.
c)
Not is correct.
d)
Both a and b are correct.
41.
What is some of important security terms?
a)
Authentication, authorization, Audit.
b)
Authentication, access control, logging activity.
c)
Load balance, data redundancy.
d)
None is correct.
42.
What are system security architecture?
a)
The system has enough security level.
b)
3 security architecture to protect the system.
c)
The policies, procedures, and technologies that mitigate the risk
d)
The technologies that ensure system security.
43.
What is not an important security term?
a)
Authorization
b)
Security protocol
c)
Non repudiation
d)
Replication
44.
Authorization (á»§y quyá»n) is...?
a)
The determination of claimed identify
b)
The determination of access to resources
c)
The prevention of a principal from denying participation.
d)
The rules that govern communications between principals.
45.
What take place first to ensure security system?
a)
Automation
b)
Authorization (á»§y quyá»n)
c)
Authentication (xác thực)
d)
Atomicity
46.
Which kind of technique can make sure non- repudiation?
a)
Encryption
b)
Decryption
c)
Defense
d)
Digital signatures.
47.
System should be defensed in ...?
a)
Depth better than breadth
b)
Breadth better than depth
c)
Depth
d)
Depth and breadth. (Chiá»u sâu + rá»™ng)
48.
Which order is preferred to ensure the system defensed in depth?
a)
Protect - Detect-Recover
b)
Detect Protect-Recover
c)
Detect Recover-Protect
d)
Protect Recover - Detect
49.
What are advantages of symmetric key cryptography?
a)
Key are relative long.
b)
Key must be replaced often
c)
The encryption and decryption algorithms can be fast in both hardware and software.
d)
Key distribution is easy,
50.
What are disadvantages of symmetric key cryptography?
a)
Key is relatively short.
b)
Key distribution is a problem.
c)
Key must be replaced often.
d)
B and c are correct.
51.
What are advantages of Asymmetric key cryptography?
a)
Key is hard to distribute.
b)
Key does not have to be replaced as often and distribution is easy.
c)
Key is short
d)
Key need to replace often.
52.
What are disadvantages of asymmetric key cryptography?
a)
Encryption algorithms are normally slower than symmetric -Key cipher
b)
Key much longer than 1000bits.
c)
Security is based on the difficulty of factoring large numbers.
d)
All are correct.
53.
Integration of security service is...?
a)
Easy.
b)
An option decision.
c)
Difficult and more risk than security of each component.
d)
More risk than the risk of each component.
54.
What events are being logged?
a)
Read or write data
b)
Authentication events
c)
A and b are correct
d)
None is correct
55.
What is some kind of access control?
a)
Mandatory access control, Discretionary access control, role-based access control, rule-based access control
b)
Mandatory access control, Role-based access control.
c)
Multilevel access control.
d)
None is correct.
56.
What are different types of middleware?
a)
Point to point, broadcasting, CORBA.
b)
Message oriented middleware, Object architectures, transaction processing.
c)
Point to point, broadcast, MSMQ.
d)
Com+, CORBA, Enterprise Java Beans.
57.
What object architectures are commonly used?
a)
Transaction processing.
b)
Message oriented middleware.
c)
CORBA, COM+, EJB.
d)
All are correct.
58.
Choose a middleware that can enforcement of ACID properties for all intersystem transactions?
a)
TPM (Transaction Processing Monitor)
b)
OTM (Object-Transaction Monitor)
c)
MTM (Message-Transaction Monitor)
d)
All are correct.
59.
Mega Money Bank's customer want to change their address through website. What's your solution for the middleware that effective and easiest to implement?
a)
Message oriented Middleware.
b)
Object architectures.
c)
Transaction processing
d)
Object-Transaction Monitor.
60.
Mega Money Bank's customer want to transfer fund from checking account to saving account through website. What's your best choices for the middleware that effectively?
a)
Message oriented middleware
b)
Object architecture.
c)
Transaction processing
d)
All are correct.
61.
The two greatest benefits to cost reduction are exemplified in the areas of inventory costs and personnel costs
a)
true
b)
false
62.
Which of the following is not an area of tangible benefit in regard to integration of systems
a)
Reduction of IT costs
b)
Reduction of cycle times
c)
Reduction of inventory costs
d)
Reduction of shipping costs
63.
Which of the following is not considered an intangible benefit to enterprise integration
a)
Improved availability of information
b)
Increase in customer responsiveness
c)
Creation of standards for information resources
d)
Increased customer service
64.
One of the major reasons for enterprise integration is organizational concerns about operations
a)
true
b)
false
65.
Which of the following is considered an intangible benefit to enterprise integration
a)
Increased customer service
b)
Increase in customer responsiveness
c)
Reduction of cycle times
d)
Reduction of shipping costs
66.
The two greatest benefits in cost reduction are exemplified in the areas of inventory costs and IT costs
a)
true
b)
false
67.
One of the major reasons for enterprise integration is organizational concerns about technology
a)
true
b)
false
68.
Which of the following are not specific characteristics in regard to the business process definition
a)
processes are a sequence of activities
b)
processes have an end or purpose
c)
involve interaction
d)
evolve over scalable architectures
69.
Processes are highly measurable in that they indirectly relate to organizational goals.
a)
true
b)
false
70.
A focus on process usually doesn't encourages greater focus on customers
a)
true
b)
false
71.
Evaluation of the performance of an information system is dependent on which of the following factors:
a)
number of users and user expectations
b)
number of users and management expectations
c)
number of managers
d)
management expectations
72.
Which of the following is a generic solution to the challenge of performance?
a)
scalable solutions
b)
reliable solutions
c)
transparent solutions
d)
server solutions
73.
Redundancy is the most common and dependable way to ensure reliability into a system.
a)
true
b)
false
74.
Redundancy is the most inconsistent and unpredictable way to ensure reliability into a system.
a)
true
b)
false
75.
The simplest way to achieve load balancing is to:
a)
maintain a list of available servers and pass incoming requests to those servers
b)
distribute the load of data transfer to a single server with high capacity
c)
buy the latest load balancing software
d)
institute single tier architecture
76.
The presentation layer of an n-tier architecture does not contain which of the following
a)
Browser
b)
Database and Processing Applications
c)
Processing Applications and Web Services
d)
Web Services
77.
Building an IT infrastructure requires:
a)
short-term view and company partner commitment
b)
long-term view and senior-level commitment
c)
senior-level commitment
d)
company partner commitment
78.
A 3-tier Client/Server architecture not consist of which of the following?
a)
Presentation tier
b)
Business Logic Tier
c)
Business Logistics Tier
d)
Data Tier
79.
A file made up of rows and columns where the rows are records and the columns describe the data.
a)
attribute
b)
flat file
c)
table
d)
tuple
80.
Another name for a relation is:
a)
attribute
b)
flat file
c)
table
d)
tuple
81.
The first model to separate data from its processing. It was able to handle large amounts of data but lacked the expressiveness needed to represent many business situations.
a)
hierarchical
b)
network
c)
object
d)
relational
82.
Which of the following consist of a database layer, application layer, and presentation layer?
a)
DB2
b)
ERP
c)
SAP
d)
AG
83.
Which of the following are not relational Databases?
a)
Oracle
b)
DB2
c)
ERP
d)
Access
84.
A distributed database offers redundancy, robustness, locking features, and security.
a)
true
b)
false
85.
A distributed database offers redundancy, locking features, security and transaction protocols for TCP/IP
a)
true
b)
false
86.
Which of the following allow for dynamic load balancing and control over localized messages
a)
Having application servers in a WAN
b)
Having application servers in a LAN
c)
Having Control functions run at the Data Server
d)
Having Control functions run on the Presentation Layer
87.
Which of the following allow for filling input fields with default values or database values
a)
Presentation Layer
b)
Database Layer
c)
Application Layer
d)
Router Layer
88.
Which of the following are not key issues regarding enterprise wide systems
a)
use of standard technologies for database management
b)
standard protocols for data communication
c)
scalability of system to large enterprise organizations
d)
cross platform capability for hardware and software
89.
Which of the following allowed the creation of online transaction processing systems
a)
database and scanning technology advances, communication advances.
b)
communication advances and DB2.
c)
DB2
d)
SAP
90.
Because building information systems is so complex, there is only one correct definition for the SDLC.
a)
true
b)
false
91.
Traditionally, software development has been characterized by:
a)
Reengineering the organization
b)
Implementing stock technical solutions
c)
Writing computer code and implementing stock technical solutions
d)
Building applications in cycles and writing computer code.
92.
Because enterprise systems are rarely custom-built for a company, making major modifications to the software is advised against.
a)
true
b)
false
93.
Prior to the past decade, information systems development has concentrated on:
a)
Reusability of code
b)
Writing computer programs
c)
Testing and installing software
d)
Implementing systems in organizational settings
94.
Which of the following is not a cause of the system development life cycle being turned inside out?
a)
Recognition of the technical limitations of the code-centric view of information systems
b)
Growing recognition of the importance of the organizational context
c)
Improvements in telecommunications systems
d)
Realization that other hi-tech aspects of applications such as databases and networks are important
95.
As a result of changes during the last decade, building information systems is now focused on:
a)
Reusability of code
b)
Writing computer programs
c)
Testing and installing software
d)
Implementing systems in organizational settings
96.
Implementation comprises trivial activities related to putting the system in its organizational setting.
a)
true
b)
false
97.
We now recognize that information systems are not technical.
a)
true
b)
false
98.
Deciding who and when to hire, creating a budget, and setting up ways to measure the project outcomes occurs during this specific part of implementing an enterprise system.
a)
Coding
b)
Implementation
c)
Planning
d)
Realization
99.
Installation of software occurs within which phase of enterprise system implementation:
a)
Initiation
b)
Planning
c)
Analysis & process design
d)
Realization
100.
Setting the project mission and making important decisions about the scale of the project occurs during this specific part of implementing an enterprise system.
a)
Planning
b)
Coding
c)
Initiation
d)
Transition
101.
Assessing the firm’s overall security requirements occurs within which phase of enterprise system implementation
a)
Initiation
b)
Planning
c)
Analysis & process design
d)
Realization
102.
Determining the functionality to be included in each part of an implementation project occurs during which of the following phase.
a)
Initiation
b)
Planning
c)
Analysis & process design
d)
Realization
103.
What are some of the most important factors to consider when choosing an implementation partner?
a)
Experience of the partner
b)
Security requirements of the system
c)
Restraining forces
d)
Extraterrestrial concerns
104.
A project team member who has a strong understanding of the data in an information system that is being replaced by a new enterprise system is a:
a)
Business process expert
b)
Technical expert
c)
Geographic business process expert
d)
Change management expert
105.
The main factor that influences the selection of people to staff an implementation project is:
a)
funding of project
b)
consulting resources
c)
project scope
d)
top management support
106.
Consultants are often highly specialized in their areas of knowledge.
a)
true
b)
false
107.
What are some of the limitations of data warehouses?
a)
Data are not absolutely current
b)
Users of data want to combine data from several sources
c)
Data are unstructured
d)
Users of data want to quickly access the data
108.
To support systems design, graphical representations are prepared and take the form of , collaboration/communications, and component diagrams.
a)
Programs
b)
Software
c)
Data Flow
d)
Projects
109.
The systems engineering team for programs and projects are responsible for many things. Choose one task that they are not responsible for below.
a)
Analyze the system architecture and design
b)
Development of software requirements
c)
Management of budget
d)
Allocate system requirements
110.
Using this type of plan enables performance to do the following:
a)
Be more effective and productive
b)
Enables technical planners to spend more time planning
c)
None of the above
d)
All of the above
111.
It is not necessary to have a plan to document and provide the technical expertise to execute activities throughout a software design/development life cycle.
a)
true
b)
false
112.
Software requirements establish the principals for software design and integration test activities for both software and systems integration.
a)
true
b)
false
113.
The integration of requirements is the of a functional architecture into optimal design solutions.
a)
Beginning
b)
Execution
c)
Transformation
d)
Process
114.
Technical data or information that describing or specifying the design or details, explaining the capabilities, and providing instructions for using software.
a)
Software Engineering
b)
Software Documentation
c)
Software Design
d)
Software Life Cycle
100 %
