Question

Difficulty: EasyData Import Wizard and Data Loader Utilities

Match each administrative data requirement to the most appropriate Salesforce data utility or capability.

  • Importing 80,000 Contact records in a single operationData Loader (Desktop Client)
  • Importing Lead records while preventing duplicates based on matching criteriaData Import Wizard
  • Scheduling a nightly automated data export via command-line interfaceData Loader Command-Line Interface (CLI)
  • Permanently purging (hard deleting) thousands of obsolete custom object recordsData Loader with 'Use Bulk API' enabled

Answer

Importing 80,000 Contacts matches Data Loader; Importing Leads with duplicate prevention matches Data Import Wizard; Scheduling a nightly export matches Data Loader CLI; Permanently purging records matches Data Loader with Bulk API.
Each feature corresponds to the appropriate tool's unique constraint: Data Loader handles >50,000 records and hard deletes via Bulk API; Data Import Wizard provides native duplicate matching for Leads; Data Loader CLI supports script automation.

Step-by-Step Solution

1
Evaluate record volume and tool limits
80,000 records exceeds the 50,000 limit of Data Import Wizard, requiring Data Loader.
Data Import Wizard capped at 50,000 records per operation.
2
Evaluate duplicate prevention requirements
Data Import Wizard is selected for Lead deduplication.
Data Import Wizard natively supports matching rules and duplicate detection during import.
3
Evaluate automation requirements
Data Loader CLI is selected for automated night schedules.
Data Import Wizard is purely web-UI driven, whereas Data Loader supports CLI automation.
4
Evaluate hard delete capabilities
Data Loader with Bulk API enabled is selected for hard delete.
Hard delete is not supported by Data Import Wizard and requires Bulk API in Data Loader.

Key Concept

Distinguishing feature sets, record limits, and operational capabilities of Data Import Wizard versus Data Loader.
Rate this question