Sysinsy
  • 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) e-commerce platform
C) System Integration
  • 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) Application Integration
B) Enterprise Integration
C) System Integration
  • 3. What is one common problem organizations face without integration?
A) Slow processes
B) Manual updates
C) Data duplication
  • 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 operate in real time
B) They slow down
C) They fully automate
  • 7. Which benefit of integration helps departments work together smoothly?
A) Collaboration
B) System isolation
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 Integration
B) System Automation
C) Digital Processing
  • 10. This integration technology uses HTTP, is lightweight, and is widely used in modern applications.
A) XML-RPC
B) WSDL
C) REST
  • 11. A technology that acts as a “bridge” connecting different systems or databases.
A) Firewall
B) Middleware
C) Switch
  • 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) JSON
B) SOAP
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) BIOS
B) Visual Basic
C) Zapier
  • 17. Microsoft’s integration tool used to manage enterprise data workflows (part of SQL Server).
A) OneDrive
B) MS DOS
C) SSIS
  • 18. Technology that allows systems to communicate over the internet using standardized protocols.
A) Web Services
B) Hypervisor
C) Router
  • 19. This integration approach reduces errors by enabling real-time, consistent data sharing between systems.
A) Web Caching
B) System Integration
C) Virtualization
  • 20. Example of an API management tool.
A) Oracle Java
B) WinRAR
C) Postman
  • 21. A platform used for message brokering in middleware.
A) VLC
B) Windows Media Player
C) MuleSoft
  • 22. This challenge occurs when systems cannot easily exchange data due to different formats or vendor technologies.
A) System Compatibility Issue
B) Network Cabling Fault
C) Port Forwarding
  • 23. It ensures that data passed during integration is safe through authentication, encryption, and access control.
A) Data Sorting
B) Data Typing
C) Data Security
  • 24. This technologies are frameworks and standards that make systems work together smoothly.
A) Web Services
B) Middleware
C) Integration Technologies
  • 25. is a central communication backbone that allows different applications to interact through a unified bus system.
A) Enterprise Service Bus (ESB)
B) API Management Tools
C) Middleware
  • 26. Apache Camel, Mule ESB, WSO2 ESB is an example of
A) API Management Tools
B) Middleware
C) Enterprise Service Bus (ESB)
  • 27. Used to create, secure, and monitor APIs that connect systems.
A) ETL (Extract, Transform, Load) Tools
B) Cloud-Based Integration Tools
C) API Management 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) Cloud-Based Integration Tools
B) API Management Tools
C) ETL (Extract, Transform, Load) 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 Migration
B) Data Cleaning
C) Data Conversion
  • 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) Business Process Migration
C) Database Migration
  • 35. Which type of data integration involves humans manually copying or importing CSV files?
A) Common Storage Integration
B) Manual Data Integration
C) Middleware-Based Integration
  • 36. Which integration approach uses APIs, webhooks, or microservices to exchange data?
A) Middleware-Based Integration
B) Application-Based Integration
C) Storage Integration
  • 37. A reporting tool that reads data directly from multiple databases without copying it uses:
A) Uniform Data Access Integration
B) Database Federation
C) Cloud Migration
  • 38. Which widely used model copies data from different sources into a central repository like a data warehouse?
A) Common Storage Integration
B) Uniform Data Access
C) Distributed Storage
  • 39. Moving data from local disk storage to cloud storage is an example of:
A) System Upgrade
B) Cloud Transformation
C) Storage Migration
  • 40. Migrating from an on-premise ERP to SAP S/4HANA Cloud is what type of migration?
A) Business Process Migration
B) Application Migration
C) Database Migration
  • 41. The ETL process performs transformations at what stage?
A) During mapping
B) Before loading
C) After loading
  • 42. Which ETL/ELT tool is commonly used in cloud-based transformations?
A) MySQL Workbench
B) NetBeans
C) AWS Glue
  • 43. Duplicate records, incomplete data, and wrong formats are examples of:
A) Data Quality Issues
B) Integration Errors
C) Schema Mismatch
  • 44. Matching fields such as student_fname → first_name refers to:
A) Data Warehousing
B) Data Profiling
C) Data Mapping
  • 45. Which real-world example involves integrating payment gateways, inventory systems, and delivery partners?
A) Government Portals
B) E-commerce Platforms
C) University Enrollment Systems
  • 46. Moving data from MySQL (local server) to Azure SQL Database (cloud). is an example of
A) Data Migration
B) Application-Based Integration
C) Data Integration
  • 47. Company merges and adopts new HR and payroll systems.
A) Business Process Migration
B) Application Migration
C) Cloud Migration
  • 48. What security threat occurs when a hacker intercepts data traveling between integrated systems?
A) Injection Attack
B) API Rate Limiting
C) Man-in-the-Middle (MITM) Attack
  • 49. Which core security control verifies who is trying to access a system?
A) Logging
B) Authentication
C) Authorization
  • 50. Which compliance standard protects the personal data of EU citizens
A) Data Privacy Act of 2012
B) GDPR
C) HIPAA
  • 51. What security mechanism protects data so that only authorized systems can read it, either in transit or at rest?
A) Logging and Monitoring
B) Encryption
C) API Gateway
  • 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) API Attacks
B) Data Leakage
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) Data Leakage
B) Injection Attacks
C) API Attacks
  • 56. Malicious data sent through APIs or middleware to corrupt systems.
A) Misconfigured Cloud Components
B) Injection Attacks
C) API Attacks
  • 57. Cloud-based integrations left public accidentally.
A) Injection Attacks
B) Misconfigured Cloud Components
C) Data Leakage
  • 58. 4111-1111-1111-1234 → --****-1234
A) Data Masking and Tokenization
B) API Security
C) Logging and Monitoring
  • 59. Protects personal data of Filipinos.
A) Data Privacy Act 2012
B) HIPAA
C) ISO 27001
  • 60. Protects confidential health information.
A) Data Privacy Act 2012
B) HIPAA
C) ISO 27001
  • 61. Framework for managing information security.
A) HIPAA
B) Data Privacy Act 2012
C) ISO 27001
  • 62. is the blueprint that outlines how different software applications, systems, and data sources within an organization are connected to work together.
A) Monolith Architecture
B) N-tier Architecture
C) Integration Architecture
  • 63. All-in-one system, single codebase
A) Monolithic Architecture
B) N-tier Architecture
C) Integration Architecture
  • 64. Online banking apps connecting to bank servers
A) Client-Server Model
B) N-tier Architecture
C) Monolithic Architecture
  • 65. Clients request services from a central server
A) N-tier Architecture
B) Monolithic Architecture
C) Client-Server Model
  • 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) Client-Server Model
C) Microservices
  • 70. software layer between OS and applications.
A) Microservices
B) Middleware
C) Data Translation
  • 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) WEB API
B) API
C) REST
  • 74. In this type of API, the programmers get the local middleware services.
A) API
B) LOCAL API
C) WEB API
  • 75. It makes a remote program appear to be local by making use of RPCs (Remote Procedural Calls).
A) PROGRAM API
B) WEB API
C) API
  • 76. All systems working together (payment, inventory, shipping) to complete a transaction is an example of:
A) System Integration
B) System Isolation
C) Manual Processing
  • 77. Bank-to-bank communication.
A) SOAP
B) REST
  • 78. Simplifies complex integrations by routing, transforming, and managing messages.
A) WEB services
B) ESB
C) Middleware
  • 79. Talend, Informatica, Microsoft SSIS, Pentaho are examples of
A) ETL
B) ESB
  • 80. Postman, Apigee (Google), Kong, AWS API Gateway are examples of
A) ETL
B) API Management Tools
C) ESB
Created with That Quiz — the site for test creation and grading in math and other subjects.