Question 1 of 20
You're planning a one-time Lead import of about 48,500 rows. The object is supported by Data Import Wizard, mappings are straightforward, and the business wants duplicate matching without building an unattended process. How would you choose between Data Import Wizard and Data Loader, and what would make you switch tools?
Strong Interview Answer
Use Data Import Wizard here because the load is within its common supported range, the object is supported, mappings are simple, and no unattended/repeatable API process is required. I would switch to Data Loader for larger volumes, repeatable/automated jobs, broader operations such as export/delete/upsert, or when I need durable success/error files and API-oriented execution.
What to Listen For
- Data Import Wizard fit
- under-50,000 clue
- supported object
- duplicate/matching options
- Data Loader for scale/automation
- tool selection from requirements
Caution
Push for reasoning, trade-offs, and the Salesforce configuration boundary rather than a memorized product name.