CDP Data Integration and Interoperability 2

Question 1

What is the purpose of a canonical data model in an enterprise integration architecture?

Accepted Answer

To define a common data format that reduces point-to-point mapping between systems

Answer

To enforce database security roles and access permissions across systems

Answer

To compress data for more efficient storage in the data warehouse

Answer

To provide audit trails required for regulatory compliance reporting

Question 2

What is Change Data Capture (CDC) in the context of data integration?

Accepted Answer

A technique that identifies and captures only the data that has changed since the last extraction

Answer

A governance policy framework for documenting data changes

Answer

A process for archiving full historical snapshots on a schedule

Answer

A method for encrypting sensitive data columns before transfer

Question 3

Which integration architecture pattern uses a centralized hub through which all application messages are routed, mediated, and transformed?

Accepted Answer

Enterprise Service Bus (ESB)

Answer

Point-to-point integration

Answer

Direct database linking via shared schemas

Answer

Flat file exchange over SFTP

Question 4

What does 'idempotency' mean in the design of data integration pipelines?

Accepted Answer

Ensuring that executing the same integration process multiple times produces the same result without creating duplicates

Answer

The ability to process multiple data streams simultaneously without conflicts

Answer

The capacity for the pipeline to auto-scale based on incoming data volume

Answer

Automatic detection and parsing of schemas from unstructured data sources

Question 5

In a data integration ETL process, what is the purpose of a 'lookup' transformation?

Accepted Answer

Retrieving matching values from a reference table to enrich or validate records being processed

Answer

Sorting records by a specified key column before loading

Answer

Removing exact duplicate records from the incoming dataset

Answer

Splitting a single incoming source stream into multiple target output streams

Question 6

What is a primary benefit of API-led connectivity in modern enterprise integration architectures?

Accepted Answer

It promotes reusable integration assets organized into System, Process, and Experience API layers

Answer

It completely eliminates the need for any ETL or data transformation processing

Answer

It restricts integrations exclusively to cloud-native SaaS applications

Answer

It automatically replaces and decommissions all legacy on-premise systems

Question 7

What primary challenge does data heterogeneity create in enterprise integration projects?

Accepted Answer

Different data formats, schemas, and semantic meanings across sources require complex reconciliation work

Answer

It dramatically increases the physical storage requirements of the target data warehouse

Answer

It legally prevents data from being transferred across different geographic regions

Answer

It makes applying encryption to data impossible during the transfer process