A Salesforce administrator at a global logistics company is selecting data administration tools for four distinct enterprise data tasks. Match each operational data requirement to the most appropriate Salesforce tool or tool configuration.
- Importing 35,000 Lead records from a logistics summit while executing active Lead Assignment Rules and applying duplicate matching rules.Data Import Wizard
- Upserting 95,000 Opportunity records from an external ERP system using a custom External ID field to map parent Account relationships.Data Loader (Desktop GUI)
- Permanently purging 18,000 obsolete custom compliance logs (`Audit_Log__c`) directly from the database to bypass the Recycle Bin.Data Loader (Bulk API with Hard Delete)
- Automating an unattended, scheduled nightly export of 250,000 Case records using scriptable execution.Data Loader Command Line Interface (CLI)
Answer
The 35,000 Lead import with assignment rules matches Data Import Wizard; the 95,000 Opportunity upsert matches Data Loader (Desktop GUI); the permanent compliance log purge matches Data Loader (Bulk API with Hard Delete); and the automated nightly export matches Data Loader Command Line Interface (CLI).
Each requirement aligns directly with specific utility capabilities: Data Import Wizard processes under 50,000 Leads while firing assignment rules; Data Loader Desktop GUI handles unsupported objects like Opportunities over 50,000 records; Data Loader with Bulk API enables hard delete; and Data Loader CLI supports script automation for scheduled tasks.
Step-by-Step Solution
Key Concept
Selecting between Data Import Wizard and Data Loader utilities based on object support, volume limits, operational requirements (hard delete, workflow triggers), and automation capabilities.