CDP Data Integration and Interoperability

Question 1

What does ETL stand for in the context of data integration?

Accepted Answer

Extract, Transform, Load

Answer

Extract, Transfer, Link

Answer

Encode, Transform, Load

Answer

Extract, Transfer, Load

Question 2

Which data integration approach provides a virtual unified view of data across multiple sources without physically moving or copying the data?

Accepted Answer

Data federation

Answer

Data replication

Answer

Data consolidation

Answer

Data migration

Question 3

What is the primary role of a message broker in a data integration architecture?

Accepted Answer

Routing messages between producers and consumers while decoupling them

Answer

Permanently storing integrated data for analytics

Answer

Encrypting all data in transit between systems

Answer

Generating business intelligence reports from integrated data

Question 4

Which data integration pattern is best suited for near-real-time data movement requirements?

Accepted Answer

Event-driven streaming integration

Answer

Monthly batch file transfers via SFTP

Answer

Quarterly data migration projects

Answer

Manual CSV imports by data stewards

Question 5

What is a key advantage of ELT over traditional ETL in a cloud data warehouse environment?

Accepted Answer

ELT leverages the target system's massively parallel processing power for transformations

Answer

ELT requires significantly less storage space in the cloud

Answer

ELT eliminates the need for any data quality checks

Answer

ELT only supports structured relational data sources

Question 6

In data integration, what does 'data latency' refer to?

Accepted Answer

The delay between when source data changes and when it becomes available in the target system

Answer

The encryption strength applied during data transfer

Answer

The number of transformation steps applied to data

Answer

The volume of data processed per hour by the integration pipeline

Question 7

Which messaging standard is most commonly used to ensure interoperability between healthcare information systems?

Accepted Answer

HL7

Answer

FIX Protocol

Answer

SWIFT MT messages

Answer

ISO 20022