18.32Scenario 31 — Bulk design

Prompt:

“Sketch code for importing 500,000 customers.”

Don't attempt to hand-write huge XML.

Whiteboard:

Scheduler
 ↓
read delta records
 ↓
Batch Job

    Step 1:
    validate

    Step 2:
    DataWeave transform

    Step 3:
    Batch Aggregator
    ↓
    Salesforce Bulk API v2 Upsert

On Complete:
metrics + failed-record report

Then mention:

External ID
streaming
partial failures
reconciliation

That is enough.