WorksheetsData Integration and Synchronization Quiz
Total questions: 60
Worksheet time: 30mins
What does data integration primarily aim to achieve?
Separating datasets into silos
Unifying data from multiple sources into a single view
Preventing access to external data
Storing data only in legacy systems
Which data integration pattern involves moving data from a source system to a target system at a single point in time?
Broadcast
Migration
Correlation
Aggregation
In migration, what ensures that the copied data matches the original?
Manual inspection by users
Random sampling
Thorough validation of the final state
Broadcasting updates
Which pattern distributes data from a single source to multiple destinations, often in real-time?
Aggregation
Broadcast
Synchronization
Correlation
What is the main characteristic of broadcast integration?
It transfers all historical data every cycle.
It only processes newly changed data since the last transfer.
It requires manual scheduling of updates.
It filters out irrelevant records.
Which pattern combines two datasets from separate systems so both remain up-to-date while functioning independently?
Aggregation
Bi-directional synchronization
Migration
File-based integration
A hospital requesting only patient records already existing in its system from external doctors is an example of which pattern?
Correlation
Broadcast
Migration
Aggregation
Which integration pattern provides a centralized real-time view by merging data from many systems into one?
Migration
Broadcast
Aggregation
Correlation
Which integration type connects systems directly on a one-to-one basis without a mediator?
Hub-and-spoke integration
Point-to-point integration
Publish-subscribe integration
Real-time integration
What is the main drawback of point-to-point integration as the number of systems grows?
It becomes too asynchronous.
It lacks support for batch processing.
Complexity increases with too many direct connections.
It prevents real-time data transfer.
In hub-and-spoke integration, what role does the hub play?
Acts as a direct connector between systems
Serves as a central mediator for data exchange
Prevents real-time synchronization
Stores raw data permanently
Which integration pattern relies on a message broker to deliver messages asynchronously to subscribers?
Request-response
File-based
Publish-subscribe
Real-time
An e-commerce site contacting a payment gateway for immediate confirmation of a transaction uses which integration?
Migration
Request-response
Broadcast
Aggregation
Which integration pattern involves systems exchanging data through predefined file formats such as CSV or XML?
File-based integration
Real-time integration
Correlation
Hub-and-spoke integration
Real-time integration emphasizes which key characteristic?
Scheduled batch processing of data
Immediate data exchange triggered by events
Delaying updates to reduce latency
Only migrating data once
What is the main goal of data synchronization?
To back up data in case of system failure
To maintain data consistency across systems and devices
To convert data into different formats
To permanently archive old records
Which issue is prevented by proper data synchronization?
Data compression
Data silos and redundancy
Data mining and warehousing
Data encryption
Data integration refers to:
Converting structured data into unstructured data
Combining software and applications to work together
Making backup copies of a database
Deleting outdated information
What type of synchronization updates flow in one direction only?
Two-way synchronization
One-way synchronization
Replication
Integration
A two-way data sync between Google Calendar and Outlook ensures:
Updates only in Outlook are reflected in Google Calendar
Only historical data is synchronized
Changes in both systems are reflected in each other
Data is archived for reporting
Which of the following is NOT a benefit of data synchronization?
Improved collaboration
Reduced data corruption
Increased data silos
Better decision-making
Which synchronization option is usually built into the application through APIs?
Custom integrations
Third-party iPaaS
Native integrations
Data virtualization
What is a drawback of custom integrations?
Lack of flexibility
Expensive and complex to maintain
Cannot work in real time
No support for cloud systems
Which data integration strategy loads data first, then performs transformations in the target system?
ETL
ELT
Virtualization
Synchronization
What does data transformation mainly involve?
Converting data into consistent formats
Archiving old records
Creating multiple database replicas
Encrypting sensitive data
Which application of data transformation ensures clean and reliable data?
Data migration
Data quality improvement
System integration
Analytics
What is the purpose of data cleansing?
To encrypt data in transmission
To delete duplicate and inconsistent records
To replicate entire datasets
To backup historical data
Which concept focuses on managing key entities like customers, products, and suppliers consistently?
Master Data Replication (MDR)
Master Data Management (MDM)
Master Data Cleansing (MDC)
Master Data Virtualization (MDV)
Which real-world application relies heavily on offline-to-online synchronization?
Data warehouses
Mobile email apps
Business intelligence dashboards
Financial reporting systems
What is the main purpose of hybrid cloud architecture?
To replace private cloud with public cloud
To connect on-premises and cloud environments under a unified system
To eliminate the need for data integration
To host only legacy applications
Which is a key advantage of hybrid cloud?
Eliminates the need for security
Allows unified management of multiple environments
Only supports public cloud applications
Removes the need for legacy systems
a key advantage of hybrid cloud?
Eliminates the need for security
Allows unified management of multiple environments
Only supports public cloud applications
Removes the need for legacy systems
What does the Cloud and Service Fabric in hybrid architecture do?
Handles financial reporting
Consolidates provisioning, deployment, and management of services
Performs data replication
Provides only on-premises solutions
Which integration perspective focuses on linking applications across environments?
Data integration
Infrastructure integration
Application integration
Cloud-native integration
What does data integration in hybrid systems primarily achieve?
Converts structured data to unstructured data
Synchronizes and harmonizes information across environments
Replaces cloud-native services
Deletes redundant data automatically
Infrastructure integration ensures:
Security policies are ignored
On-premises and cloud systems can work together seamlessly
Only private cloud resources are used
Legacy systems are removed
Which platform is designed specifically to develop and run applications in the cloud?
Data warehouse
Cloud-native platform
ETL system
On-premises server
An example of an integration pattern where one service calls another directly is:
Data streaming
Request/response
Event-driven messaging
Data replication
Event-driven architecture is best suited for:
Synchronous transactions
Real-time notifications and loose coupling
Batch data transfers
File backups
Which integration pattern is commonly used for analytics and IoT data?
File transfer
Data streaming
Replication
Direct API calls
Why is governance important in hybrid cloud?
To allow uncontrolled data flows
To ensure compliance, consistency, and accountability
To reduce integration costs only
To speed up software updates
Which of the following is a governance concern in hybrid environments?
Unified branding
Data security and compliance
Application colors and UI
Number of physical servers
What role does identity and access management (IAM) play in hybrid systems?
Monitors application performance only
Controls who can access resources and what they can do
Handles database migrations
Provides cloud cost optimization
Which integration challenge often arises in hybrid cloud?
Too many legacy interfaces
Seamless real-time connectivity across different systems
Lack of public cloud providers
No need for backup systems
A best practice for securing hybrid integrations is:
Ignoring encryption to reduce latency
Using standardized APIs and encrypted data channels
Removing all monitoring tools
Allowing unrestricted data transfers
What does ESB stand for?
Enterprise Software Base
Enterprise Service Bus
Enterprise System Bridge
Enterprise Security Base
What is the primary function of an Enterprise Service Bus (ESB)?
Store enterprise data permanently
Provide a uniform way of moving work and messages across application components
Replace all legacy applications
Enforce programming language standards
ESB is best described as a:
Database management system
Middleware infrastructure for integration
Standalone programming language
Hardware network switch
The ESB can be compared to a collection of switches because it:
Directly stores business policies
Guides messages between applications based on content and policy rules
Replaces internet routers
Generates random workflows
Which integration model is ESB most closely related to?
Hub-and-spoke
Peer-to-peer networking
Service-oriented architecture (SOA)
Data warehousing
What differentiates ESB from microservices?
ESB is core to the process flow, while microservices are loosely connected via APIs
Microservices replace middleware, while ESB stores data
ESB requires one programming language, microservices do not
Microservices rely only on SOAP, ESB relies on REST
Which of the following is a benefit of using an ESB?
Complex monitoring and reduced flexibility
Easier modification of application components and enforcing compliance
Mandatory use of a single language
Elimination of middleware standards
Which feature of ESB improves reliability during system failures?
Protocol conversion
Failover support
Static routing
Batch-only processing
One major problem with ESBs is that:
They do not support multiple data formats
There is no universally accepted standard for their functions
They can only work with Java-based systems
They require cloud-only deployment
The function that most clearly distinguishes ESBs from other middleware technologies is:
Ability to encrypt all data
Ability to direct messages based on a policy language
Ability to run batch jobs
Ability to provide GUIs for developers
What is Enterprise Application Integration (EAI)?
A programming language for ESBs
A framework for integrating computer systems and applications
A replacement for middleware tools
A security-only standard for enterprises
How does ESB relate to EAI?
ESB is the concept, and EAI is the tool
EAI is the concept, and ESB is one possible implementation
Both are identical integration models
EAI only applies to microservices, not ESB
Which of the following is an ESB advantage for application integration?
Simplifies message routing, mediation, and orchestration
Restricts interoperability to a single vendor
Prevents use of monitoring tools
Eliminates the need for security policies
Why is ESB referred to as a "bus"?
Because it physically transports data like a USB cable
Because it functions similarly to a computer bus, but at a higher abstraction
Because it is a hardware component
Because it requires scheduled stops like a vehicle bus
Which statement best summarizes ESB's role in SOA (Service-Oriented Architecture)?
ESB eliminates SOA requirements
ESB enforces static coupling between services
ESB acts as a platform that supports routing, transformation, and loose coupling of services
ESB forces all services to use the same schema
