An order database commits successfully, but a network outage prevents publication of its fulfillment message. Which pattern most directly prevents this lost-publication gap?

Choose the single best answer.

A.Wrap any SQL write inside a Service Bus transaction and assume distributed atomicity
B.Use a longer message TTL without recording pending publication
C.Commit the order and an outgoing-message record together, then dispatch the record reliably
D.Send the message first and assume the later SQL insert cannot fail

Show the answer and explanation

✓ Correct answer

Commit the order and an outgoing-message record together, then dispatch the record reliably

A transactional outbox atomically records business state and publication intent in the database, enabling later retries. Sending first can publish an order that never commits, broker transactions do not automatically include arbitrary SQL, and TTL does not preserve missing publication intent. Source guide: PDF page(s) 51.

Read the source reference

This item is flagged for content review.

Read and review here, or open the app to practise and save your results on this device.

Practise in the app

Unofficial study aid; not affiliated with or endorsed by Microsoft. Original practice questions are not real examination questions and do not guarantee an exam result.