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) 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
Created with That Quiz — the site for test creation and grading in math and other subjects.