11.27Normal Connector vs Bulk API
A useful interview heuristic:
Normal Salesforce operation
Use for:
interactive request
small number of records
latency-sensitive transaction
Bulk API
Use for:
large migration
mass sync
ETL
hundreds of thousands/millions of records
Don't quote a magical number like:
“At 10,001 records you must use Bulk API.”
There isn't one universal threshold.
Say:
“I'd base it on volume, latency requirements, API limits, recovery needs, and whether the workload is transactional or data-movement oriented.”
Much better.