Integration & Interoperability Flashcards
7 cards from real CTP practice questions. Tap to flip, then mark Knew It or Still Learning โ missed cards come back until you master them.
Read the first 7 Integration & Interoperability flashcards as text
A nightly job moves sales data from an operational database into a data warehouse after cleaning it. Which pattern is this?
Answer: ETL (extract, transform, load)
ETL extracts data, transforms it, and loads it into a target store such as a warehouse.
Instead of polling every minute, a SaaS platform calls your URL whenever an order is created. What is this mechanism called?
Answer: Webhook
A webhook is an HTTP callback the source sends to a registered URL when an event happens.
Which technique copies only the rows that changed in a source database to keep a target system in sync in near real time?
Answer: Change data capture (CDC)
CDC reads changes, often from transaction logs, and streams only inserts, updates, and deletes to targets.
A message keeps failing to process after many retries. Where should a queue-based integration send it so it does not block other messages?
Answer: A dead-letter queue
A dead-letter queue holds messages that can't be processed so they can be reviewed without stopping the flow.
Which file transfer protocol encrypts both credentials and data by running over SSH?
Answer: SFTP
SFTP runs over SSH and encrypts the whole session, including credentials and file contents.
Which integration style uses a central bus to route, transform, and orchestrate messages between many enterprise applications?
Answer: Enterprise service bus (ESB)
An ESB is middleware that centralizes routing, transformation, and protocol mediation between applications.
In a distributed integration, why are correlation IDs added to messages and logs?
Answer: To trace a single transaction across multiple systems
A shared correlation ID lets operators follow one request through every service and log.
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Editorial policy