Data Management & Integration 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 Management & Integration flashcards as text
A service updates its database and then publishes an event, but sometimes the event is lost if the service crashes in between. Which pattern solves this?
Answer: Transactional outbox
The outbox pattern writes the event to a table in the same transaction as the data change, then a relay publishes it reliably.
Which approach coordinates a business transaction across multiple microservices without a distributed lock, using compensating actions on failure?
Answer: Saga pattern
Sagas break a transaction into local steps, each with a compensating action to undo it if a later step fails.
What is a dead-letter queue (DLQ) used for in message-based integration?
Answer: Holding messages that repeatedly fail processing so they can be inspected without blocking the main queue
A DLQ isolates poison messages so the main flow continues while failures are analyzed and replayed.
Which metric is most useful for detecting that a streaming consumer is falling behind producers?
Answer: Consumer lag
Consumer lag measures the gap between the latest produced offset and the consumer's committed offset.
A team stores large reference datasets used by tests. Why should these be versioned alongside code or with a data versioning tool?
Answer: So test results are reproducible and tied to the exact data used
Versioning data with code ensures any build can be reproduced with the same inputs, aiding debugging and audits.
What is the primary benefit of a point-in-time recovery (PITR) capability for a database?
Answer: Restoring the database to a specific moment, such as just before an accidental deletion
PITR combines base backups with transaction logs to restore to any chosen moment within the retention window.
An API used by many internal consumers needs a breaking change. What is the best DevOps practice for integration stability?
Answer: Version the API and run old and new versions in parallel with a deprecation timeline
API versioning with deprecation periods lets consumers migrate independently without outages.
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
- gsdcouncil.org — Eligibility, fees, exam format, passing score, renewal, retake policy, time limit, score validity, test delivery, score release · verified Oct 2026