Question

Difficulty: MediumData Import Wizard and Data Loader Utilities

A Salesforce administrator at a healthcare company needs to import 12,000 new Lead records gathered from a recent medical conference. The administrative requirements specify that the import process must automatically execute active Lead assignment rules and prevent creating duplicate records based on email address matching. Which data tool should the administrator select to fulfill this requirement?

  1. Data Import Wizard, because it supports Lead imports under 50,000 records and natively provides options to trigger lead assignment rules and detect duplicates.Answer
  2. B
    Data Loader, because Data Import Wizard is limited to custom objects and cannot import standard Lead records.
  3. C
    Data Loader using Bulk API, because Data Import Wizard cannot process imports exceeding 10,000 records in a single batch.
  4. D
    Data Loader command-line interface, because only desktop utilities can evaluate lead assignment rules during data insertion.

Answer

Data Import Wizard, because it supports Lead imports under 50,000 records and natively provides options to trigger lead assignment rules and detect duplicates.
The Data Import Wizard is the optimal utility because the dataset size (12,000 records) is well within its 50,000 record capacity limit, the target object (Leads) is supported by the wizard, and it natively includes functionality to run lead assignment rules and match existing records to prevent duplicates during import.

Step-by-Step Solution

1
Evaluate record volume requirement
12,000 records is below the 50,000 record threshold for Data Import Wizard.
Data Import Wizard supports up to 50,000 records per operation, whereas Data Loader supports up to 5,000,000 records.
2
Evaluate target object support
Leads are supported by Data Import Wizard.
Data Import Wizard supports Accounts, Contacts, Leads, Solutions, Campaign Members, Person Accounts, and all Custom Objects.
3
Evaluate operational feature requirements (assignment rules and duplicate matching)
Data Import Wizard natively provides checkboxes to trigger Lead assignment rules and match duplicates by fields such as Email.
Data Loader does not offer built-in duplicate matching UI or lead assignment rule triggers during normal wizard operations.

Key Concept

Selecting between Data Import Wizard and Data Loader based on record volume, object support, assignment rule execution, and native duplicate prevention.
Rate this question