Integration and Interoperability

Question 1

Define integration and interoperability

Answer 1

Managing the movement and consolidation of data within and between applications and organisations

Question 2

Deliverables of integration and interoperability

Answer 2

• DII architecture
• Data exchange Specifications
• Data Access Agreements
• Data Services
• Complex Event Processing (Thresholds and Alerts)

Question 3

Metrics of integration and interoperability

Answer 3

• volumes
• latency
• value delivered
• costs and times

Question 4

Integration

Answer 4

movement and consolidation of data into consistent forms

Question 5

interoperability

Answer 5

providing the mechanisms for multiple systems to process data

Question 6

goals of integration and interoperability

Answer 6

• consolidate the data and make available
• lower the cost and complexity of managing solutions
• identify meaningful events and support business analytics

Question 7

four common use case of integration and interoperability

Answer 7

1. INTEGRATION of data between data stores
2. CONSOLIDATION of data stores, including application consolidation, data hub management, mergers and aquisitions.
3. DISTRUBUTING data across data store and data centres.
4. Moving data into ARCHIVES, and updating data from one archive technology to another to enable future use

Question 8

RAID

Answer 8

redundant array of inexpensive discs

Question 9

Styles of integration and interoperability approaches

Answer 9

point to point
hub distrubution
message synchronisation
Bus distrubution
ETL/ELT/CDC
Abstraction / Virtual Consolidation (API)

Question 10

point to point integration approaches

Answer 10

device linked to device with communications each way between

Question 11

Point to point advantages

Answer 11

• fast
• good when small number of devices

Question 12

point to point disadvantages

Answer 12

• lots of detailed code (takes a long time to code, support may be difficult when people leave)
• run time issues with many systems

Question 13

hub distrubution interoperability approach

Answer 13

changes are submitted to a central hub and routes it to the people who are authorised to recieve it

Question 14

Messaging Bus interoperability approach

Answer 14

application makes a change and then a bus pushes the data into a central service which then pushes it to systems that are authorised to recieve it

Question 15

Service Oriented Architechture (SOA)

Answer 15

based on bus distrubition

Question 16

Hub compared to bus model

Answer 16

Bus is more scalable

Question 17

Concerns of hub and bus model

Answer 17

single point of failure

Question 18

Integration is…

Answer 18

database to database

Question 19

ETL acronym

Answer 19

extract transform load

Question 20

CDC acronym

Answer 20

change data capture (drip)

Question 21

ETL, ELT

Answer 21

Batch distrubution for the mass movement of data collected over time from source data structure

Question 22

CDC

Answer 22

event driven distrubution

Question 23

ETL vs ELT

Answer 23

ETL - higher quality longer time
ELT - lower quality, quicker time (good for data scientists etc, bad because it might get forgotten about)

Question 24

Message Synchronisation and propagation integration approach

Answer 24

put code in for application to application integration
event driven

Question 25

Tight coupling

Answer 25

both applications know of each other (direct communication)

Question 26

Loose coupling

Answer 26

applications remain anonymous, communicate via and API (indirect)

Question 27

Integration vs interoperability

Answer 27

integration is data to data interoperability is application to application

Question 28

EII

Answer 28

Enterprise Information Integration (data to appplication, virtualisarion)

Question 29

Virtualisation approach

Answer 29

transforms on the fly to present the data to the consuming application as though it were native to its own application

Question 30

3 major components of virtualisation

Answer 30

- access layer - transformation layer - virtualisation layer

Question 31

Canonical data model

Answer 31

data model that aims to present data entities and relationships in the simplest possible form to integrate processes across various systems and databases.

Question 32

Mapping requirement and rules for moving data from source to target enables

Answer 32

transformation

Question 33

When integrating two data stores using batch or real-time synchronous approaches the result is

Answer 33

latency

Question 34

If two data stores are able to be inconsistent during normal operations then the integration approach is

Answer 34

asynchonous

Question 35

A content distrubution network supporting a multi national website is like to use

Answer 35

a replication solution

Question 36

Functions of the enterprise service bus (ESB)

Answer 36

Support near real time data integration Act as an intermediary passing messages between systems Continuously “polling” applications connected, looking for new data they're subscribed to Allow data integration solutions to execute more frequently than batch processing otherwise allows

Question 37

Why combine data?

Answer 37

consolidate data from multiple sources to make it easier to understand and analyse

Question 38

ETL

Answer 38

extract transform load

Question 39

Change data capture

Answer 39

filters out only the data that changed, saving resources

Question 40

point to point model

Answer 40

efficiently directly connect to exchange data. get complicated when multiple systems are involved.

Question 41

hub and spoke model

Answer 41

centralises data in the hub, and systems can access from here. reduces the number of interfaces.

Question 42

publish and subscribe model

Answer 42

systems that push out data and others subscribing to receive it (consistent delivery)

Question 43

Enterprise service bus

Answer 43

act as an intermediary, connecting systems and passing messages enabling loosely coupled and flexible data sharing

Question 44

Service oriented architechtures

Answer 44

uses well-defined service calls between applications promoting application independence and the ability to replace systems with minimal disruption

Question 45

ESB vs ETL

Answer 45

ETL is bulk data ESB is smaller real time communications (application integration)

Question 46

Managing the availability of data throughout the data lifecycle is...

Answer 46

not a goal of data integration and interoperability

Question 47

In an ETL process, Lookups and Mappings are part of which step?

Answer 47

Transform

Question 48

Activities part of the planning and analysing stage if data integration processing

Answer 48

- Define data integration and lifecycle requirements - Perform data discovery - perform data profiling - documenting data lineages