- 1. is the process of connecting different computing systems, applications, and software so that they can work together as a coordinated whole.
A) Data Integration B) System Integration C) e-commerce platform
- 2. A company’s Sales System, Inventory System, and Accounting System share data automatically so that when a product is sold, inventory updates and accounting records are adjusted instantly. is an example of
A) System Integration B) Application Integration C) Enterprise Integration
- 3. What is one common problem organizations face without integration?
A) Slow processes B) Data duplication C) Manual updates
- 4. Which of the following is a benefit of integration?
A) Increased errors B) Automated tasks C) More manual work
- 5. How does integration improve accuracy?
A) By increasing manual input B) By adding more systems C) Through real-time, consistent data
- 6. What happens to processes in an organization that lacks integration?
A) They slow down B) They fully automate C) They operate in real time
- 7. Which benefit of integration helps departments work together smoothly?
A) System isolation B) Collaboration C) Manual data entry
- 8. What is a common issue when data is stored in separate systems?
A) Data duplication B) Unified data C) Automated processes
- 9. It is the process of connecting different computing systems so they can work together as one coordinated whole.
A) System Automation B) System Integration C) Digital Processing
- 10. This integration technology uses HTTP, is lightweight, and is widely used in modern applications.
A) REST B) WSDL C) XML-RPC
- 11. A technology that acts as a “bridge” connecting different systems or databases.
A) Middleware B) Switch C) Firewall
- 12. Which integration tool extracts data from a source, transforms it, and loads it into a data warehouse?
A) Load Balancer B) REST API C) ETL Tool
- 13. A central communication backbone that routes, transforms, and manages messages between systems.
A) Switchboard B) Data Hub C) Enterprise Service Bus (ESB)
- 14. This web service protocol is XML-based, secure, but more complex.
A) SOAP B) JSON C) REST
- 15. Tool used to create, secure, publish, and monitor APIs.
A) CDN B) API Management Tool C) Compiler
- 16. A cloud-based integration platform that allows connecting apps without coding.
A) Visual Basic B) Zapier C) BIOS
- 17. Microsoft’s integration tool used to manage enterprise data workflows (part of SQL Server).
A) SSIS B) MS DOS C) OneDrive
- 18. Technology that allows systems to communicate over the internet using standardized protocols.
A) Router B) Web Services C) Hypervisor
- 19. This integration approach reduces errors by enabling real-time, consistent data sharing between systems.
A) Virtualization B) Web Caching C) System Integration
- 20. Example of an API management tool.
A) Postman B) WinRAR C) Oracle Java
- 21. A platform used for message brokering in middleware.
A) MuleSoft B) Windows Media Player C) VLC
- 22. This challenge occurs when systems cannot easily exchange data due to different formats or vendor technologies.
A) Network Cabling Fault B) Port Forwarding C) System Compatibility Issue
- 23. It ensures that data passed during integration is safe through authentication, encryption, and access control.
A) Data Typing B) Data Security C) Data Sorting
- 24. This technologies are frameworks and standards that make systems work together smoothly.
A) Web Services B) Integration Technologies C) Middleware
- 25. is a central communication backbone that allows different applications to interact through a unified bus system.
A) Middleware B) Enterprise Service Bus (ESB) C) API Management Tools
- 26. Apache Camel, Mule ESB, WSO2 ESB is an example of
A) API Management Tools B) Enterprise Service Bus (ESB) C) Middleware
- 27. Used to create, secure, and monitor APIs that connect systems.
A) API Management Tools B) ETL (Extract, Transform, Load) Tools C) Cloud-Based Integration Tools
- 28. Used in data integration — extract data from sources, transform it, and load into a data warehouse.
A) API Management Tools B) Cloud-Based Integration Tools C) ETL (Extract, Transform, Load) Tools
- 29. Allow integration of cloud apps and on-premise systems.
A) API Management Tools B) ETL (Extract, Transform, Load) Tools C) Cloud-Based Integration Tools
- 30. CRM connected with email automation tools
A) Application Integration B) Data Integration C) Enterprise Integration
- 31. the process of combining data from different sources to provide a unified view.
A) Data Processing B) Data Integration C) Data Migration
- 32. The process of moving data from one system to another is known as:
A) Data Conversion B) Data Cleaning C) Data Migration
- 33. When a university combines enrollment, LMS, and library data into a single dashboard, this is an example of:
A) Data Synchronization B) Data Integration C) Application Migration
- 34. Migrating data from MySQL to Azure SQL Database is an example of:
A) Format Migration B) Database Migration C) Business Process Migration
- 35. Which type of data integration involves humans manually copying or importing CSV files?
A) Manual Data Integration B) Middleware-Based Integration C) Common Storage Integration
- 36. Which integration approach uses APIs, webhooks, or microservices to exchange data?
A) Storage Integration B) Application-Based Integration C) Middleware-Based Integration
- 37. A reporting tool that reads data directly from multiple databases without copying it uses:
A) Cloud Migration B) Uniform Data Access Integration C) Database Federation
- 38. Which widely used model copies data from different sources into a central repository like a data warehouse?
A) Uniform Data Access B) Common Storage Integration C) Distributed Storage
- 39. Moving data from local disk storage to cloud storage is an example of:
A) Storage Migration B) System Upgrade C) Cloud Transformation
- 40. Migrating from an on-premise ERP to SAP S/4HANA Cloud is what type of migration?
A) Database Migration B) Business Process Migration C) Application Migration
- 41. The ETL process performs transformations at what stage?
A) After loading B) During mapping C) Before loading
- 42. Which ETL/ELT tool is commonly used in cloud-based transformations?
A) MySQL Workbench B) AWS Glue C) NetBeans
- 43. Duplicate records, incomplete data, and wrong formats are examples of:
A) Schema Mismatch B) Integration Errors C) Data Quality Issues
- 44. Matching fields such as student_fname → first_name refers to:
A) Data Mapping B) Data Profiling C) Data Warehousing
- 45. Which real-world example involves integrating payment gateways, inventory systems, and delivery partners?
A) Government Portals B) University Enrollment Systems C) E-commerce Platforms
- 46. Moving data from MySQL (local server) to Azure SQL Database (cloud). is an example of
A) Data Integration B) Application-Based Integration C) Data Migration
- 47. Company merges and adopts new HR and payroll systems.
A) Cloud Migration B) Business Process Migration C) Application Migration
- 48. What security threat occurs when a hacker intercepts data traveling between integrated systems?
A) Injection Attack B) Man-in-the-Middle (MITM) Attack C) API Rate Limiting
- 49. Which core security control verifies who is trying to access a system?
A) Authentication B) Authorization C) Logging
- 50. Which compliance standard protects the personal data of EU citizens
A) GDPR B) Data Privacy Act of 2012 C) HIPAA
- 51. What security mechanism protects data so that only authorized systems can read it, either in transit or at rest?
A) API Gateway B) Encryption C) Logging and Monitoring
- 52. Which integration architecture model follows the principle “Never trust, always verify”?
A) Message Queue B) Firewall Filtering C) Zero Trust Architecture
- 53. exposed publicly without proper security can be exploited.
A) Data Leakage B) API Attacks C) Man-in-the-Middle Attacks (MITM)
- 54. Weak authentication lets attackers enter integrated systems.
A) Injection Attacks B) Misconfigured Cloud Components C) Unauthorized Access
- 55. Sensitive data transferred without encryption gets exposed.
A) API Attacks B) Injection Attacks C) Data Leakage
- 56. Malicious data sent through APIs or middleware to corrupt systems.
A) Injection Attacks B) Misconfigured Cloud Components C) API Attacks
- 57. Cloud-based integrations left public accidentally.
A) Data Leakage B) Misconfigured Cloud Components C) Injection Attacks
- 58. 4111-1111-1111-1234 → --****-1234
A) Data Masking and Tokenization B) Logging and Monitoring C) API Security
- 59. Protects personal data of Filipinos.
A) HIPAA B) ISO 27001 C) Data Privacy Act 2012
- 60. Protects confidential health information.
A) ISO 27001 B) HIPAA C) Data Privacy Act 2012
- 61. Framework for managing information security.
A) Data Privacy Act 2012 B) ISO 27001 C) HIPAA
- 62. is the blueprint that outlines how different software applications, systems, and data sources within an organization are connected to work together.
A) Integration Architecture B) N-tier Architecture C) Monolith Architecture
- 63. All-in-one system, single codebase
A) N-tier Architecture B) Monolithic Architecture C) Integration Architecture
- 64. Online banking apps connecting to bank servers
A) Monolithic Architecture B) Client-Server Model C) N-tier Architecture
- 65. Clients request services from a central server
A) Client-Server Model B) Monolithic Architecture C) N-tier Architecture
- 66. Web app (React frontend → Node.js backend → MySQL database)
A) N-tier Architecture B) Monolithic Architecture C) Client-Server Model
- 67. Multi-layer system (presentation, business logic, database)
A) Monolithic Architecture B) N-tier Architecture C) Client-Server Model
- 68. Systems built from independent services
A) Monolithic Architecture B) Client-Server Model C) Service-Oriented Architecture
- 69. Small, independent services communicating via APIs
A) Service-Oriented Architecture B) Microservices C) Client-Server Model
- 70. software layer between OS and applications.
A) Data Translation B) Middleware C) Microservices
- 71. •Converts data formats between different systems.
A) Authentication & Authorization B) Data Translation C) Messaging Services
- 72. a set of rules that allow different software applications to communicate with each other
A) API B) GDPR C) REST
- 73. also called Web Services is an extensively used API over the web and can be easily accessed using the HTTP protocols.
A) REST B) WEB API C) API
- 74. In this type of API, the programmers get the local middleware services.
A) API B) WEB API C) LOCAL API
- 75. It makes a remote program appear to be local by making use of RPCs (Remote Procedural Calls).
A) WEB API B) PROGRAM API C) API
- 76. All systems working together (payment, inventory, shipping) to complete a transaction is an example of:
A) Manual Processing B) System Integration C) System Isolation
- 77. Bank-to-bank communication.
A) SOAP B) REST
- 78. Simplifies complex integrations by routing, transforming, and managing messages.
A) WEB services B) Middleware C) ESB
- 79. Talend, Informatica, Microsoft SSIS, Pentaho are examples of
A) ESB B) ETL
- 80. Postman, Apigee (Google), Kong, AWS API Gateway are examples of
A) ESB B) API Management Tools C) ETL
|