CDP Data Integration and Interoperability 2 — Questions and Answers
Question 1: What is the purpose of a canonical data model in an enterprise integration architecture?
- To define a common data format that reduces point-to-point mapping between systems (Correct answer)
- To enforce database security roles and access permissions across systems
- To compress data for more efficient storage in the data warehouse
- To provide audit trails required for regulatory compliance reporting
Correct answer: To define a common data format that reduces point-to-point mapping between systems
A canonical data model defines a shared, standardized format so each system only needs to map to/from the canonical model rather than maintaining a unique mapping to every other system.
Question 2: What is Change Data Capture (CDC) in the context of data integration?
- A governance policy framework for documenting data changes
- A process for archiving full historical snapshots on a schedule
- A technique that identifies and captures only the data that has changed since the last extraction (Correct answer)
- A method for encrypting sensitive data columns before transfer
Correct answer: A technique that identifies and captures only the data that has changed since the last extraction
CDC tracks modifications (inserts, updates, deletes) in source systems and captures only those changed records, enabling efficient incremental data integration.
Question 3: Which integration architecture pattern uses a centralized hub through which all application messages are routed, mediated, and transformed?
- Point-to-point integration
- Direct database linking via shared schemas
- Flat file exchange over SFTP
- Enterprise Service Bus (ESB) (Correct answer)
Correct answer: Enterprise Service Bus (ESB)
An Enterprise Service Bus (ESB) provides a central communication backbone that mediates, routes, and transforms messages between all connected applications.
Question 4: What does 'idempotency' mean in the design of data integration pipelines?
- The ability to process multiple data streams simultaneously without conflicts
- Ensuring that executing the same integration process multiple times produces the same result without creating duplicates (Correct answer)
- The capacity for the pipeline to auto-scale based on incoming data volume
- Automatic detection and parsing of schemas from unstructured data sources
Correct answer: Ensuring that executing the same integration process multiple times produces the same result without creating duplicates
An idempotent pipeline can be safely re-run after failures without creating duplicate records or corrupting data, because repeated execution yields the same outcome as a single execution.
Question 5: In a data integration ETL process, what is the purpose of a 'lookup' transformation?
- Sorting records by a specified key column before loading
- Removing exact duplicate records from the incoming dataset
- Retrieving matching values from a reference table to enrich or validate records being processed (Correct answer)
- Splitting a single incoming source stream into multiple target output streams
Correct answer: Retrieving matching values from a reference table to enrich or validate records being processed
A lookup transformation queries a reference or dimension table to find matching values, enabling records to be enriched with additional attributes or validated against known reference data.
Question 6: What is a primary benefit of API-led connectivity in modern enterprise integration architectures?
- It completely eliminates the need for any ETL or data transformation processing
- It restricts integrations exclusively to cloud-native SaaS applications
- It automatically replaces and decommissions all legacy on-premise systems
- It promotes reusable integration assets organized into System, Process, and Experience API layers (Correct answer)
Correct answer: It promotes reusable integration assets organized into System, Process, and Experience API layers
API-led connectivity organizes APIs into three reusable layers — System (unlock data), Process (orchestrate), and Experience (deliver) — enabling flexible, composable integrations.
Question 7: What primary challenge does data heterogeneity create in enterprise integration projects?
- It dramatically increases the physical storage requirements of the target data warehouse
- Different data formats, schemas, and semantic meanings across sources require complex reconciliation work (Correct answer)
- It legally prevents data from being transferred across different geographic regions
- It makes applying encryption to data impossible during the transfer process
Correct answer: Different data formats, schemas, and semantic meanings across sources require complex reconciliation work
Heterogeneous sources differ in file formats, data types, naming conventions, and the business meaning of fields, requiring significant effort to reconcile and produce consistent integrated data.
CDP Data Integration and Interoperability 2
What is the purpose of a canonical data model in an enterprise integration architecture?