17.46Interview answer

“I'd first identify whether duplicate prevention is enforced atomically at the Salesforce boundary. I'd look for query-then-create patterns, nonunique or unstable external IDs, retries around Create, concurrent consumers, and source identity problems. My preferred design is usually a stable unique External ID plus Upsert, because an application-side existence check alone races under concurrency.”

Excellent.