CDP Data Integration and Interoperability 1 — Questions and Answers
Question 1: What does ETL stand for in the context of data integration?
- Extract, Transfer, Link
- Encode, Transform, Load
- Extract, Transform, Load (Correct answer)
- Extract, Transfer, Load
Correct 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.
Question 2: Which data integration approach provides a virtual unified view of data across multiple sources without physically moving or copying the data?
- Data replication
- Data consolidation
- Data migration
- Data federation (Correct answer)
Correct 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.
Question 3: What is the primary role of a message broker in a data integration architecture?
- Permanently storing integrated data for analytics
- Encrypting all data in transit between systems
- Routing messages between producers and consumers while decoupling them (Correct answer)
- Generating business intelligence reports from integrated data
Correct 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.
Question 4: Which data integration pattern is best suited for near-real-time data movement requirements?
- Monthly batch file transfers via SFTP
- Event-driven streaming integration (Correct answer)
- Quarterly data migration projects
- Manual CSV imports by data stewards
Correct 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.
Question 5: What is a key advantage of ELT over traditional ETL in a cloud data warehouse environment?
- ELT requires significantly less storage space in the cloud
- ELT eliminates the need for any data quality checks
- ELT only supports structured relational data sources
- ELT leverages the target system's massively parallel processing power for transformations (Correct answer)
Correct 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.
Question 6: In data integration, what does 'data latency' refer to?
- The encryption strength applied during data transfer
- The number of transformation steps applied to data
- The delay between when source data changes and when it becomes available in the target system (Correct answer)
- The volume of data processed per hour by the integration pipeline
Correct 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.
Question 7: Which messaging standard is most commonly used to ensure interoperability between healthcare information systems?
- FIX Protocol
- SWIFT MT messages
- HL7 (Correct answer)
- ISO 20022
Correct answer: HL7
HL7 (Health Level 7) is the dominant standard for exchanging clinical and administrative data between healthcare applications and systems.
CDP Data Integration and Interoperability 1
What does ETL stand for in the context of data integration?