A worker inserts an order, then crashes before completing its Service Bus message. Duplicate detection is enabled on the queue. Which change closes the remaining duplicate-order risk?

Choose the single best answer.

A.Assume message completion and the SQL insert already form a distributed transaction
B.Increase only the send-side duplicate-detection window
C.Use a new MessageId for each receive attempt
D.Enforce a stable business order ID with a database uniqueness constraint or transactional processed-message record

Show the answer and explanation

✓ Correct answer

Enforce a stable business order ID with a database uniqueness constraint or transactional processed-message record

Database-enforced business idempotency handles redelivery after a successful write and lost completion. Broker duplicate detection primarily suppresses duplicate sends within its window, a new ID does not recognize the existing effect, and arbitrary SQL plus message completion is not automatically one distributed transaction. Source guide: PDF page(s) 50.

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.