Data Integration and Interoperability Flashcards
7 cards from real CDP practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Data Integration and Interoperability flashcards as text
What does ETL stand for in the context of data integration?
Answer: Extract, Transform, Load
ETL stands for Extract, Transform, Load — the core three-step process of moving data from source systems to a target system.
Which data integration approach provides a virtual unified view of data across multiple sources without physically moving or copying the data?
Answer: Data federation
Data federation creates a virtual unified view by querying source systems on demand, leaving the data in place rather than copying it to a central repository.
What is the primary role of a message broker in a data integration architecture?
Answer: Routing messages between producers and consumers while decoupling them
A message broker decouples producers and consumers by receiving messages from producers and routing them to the appropriate consumers, enabling asynchronous communication.
Which data integration pattern is best suited for near-real-time data movement requirements?
Answer: Event-driven streaming integration
Event-driven streaming integration processes and delivers data as events occur, making it ideal for near-real-time requirements where low latency is critical.
What is a key advantage of ELT over traditional ETL in a cloud data warehouse environment?
Answer: ELT leverages the target system's massively parallel processing power for transformations
ELT loads raw data first, then uses the cloud data warehouse's powerful parallel processing to perform transformations, taking advantage of scalable compute resources.
In data integration, what does 'data latency' refer to?
Answer: The delay between when source data changes and when it becomes available in the target system
Data latency is the time delay between a change occurring in the source system and that change being reflected and available in the destination system.
Which messaging standard is most commonly used to ensure interoperability between healthcare information systems?
Answer: HL7
HL7 (Health Level 7) is the dominant standard for exchanging clinical and administrative data between healthcare applications and systems.
How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- iccp.org — Test delivery, passing score, retake policy, score release, score validity, time limit, renewal, fees, eligibility · verified Oct 2026