Question

Difficulty: MediumData Import Wizard and Data Loader Utilities

A Salesforce administrator at a telecommunications provider needs to load 65,000 Opportunity records from an external billing system into Salesforce. Which tool should the administrator use to perform this operation?

  1. Data Loader, because Opportunities are not supported by the Data Import Wizard and the record volume exceeds 50,000.Answer
  2. B
    Data Import Wizard, because it supports loading up to 100,000 records for standard objects.
  3. C
    Data Import Wizard, because it can import Opportunities if custom matching rules are enabled.
  4. D
    Data Loader, because the Data Import Wizard can only be used to import custom objects.

Answer

Data Loader should be used because Opportunities are not supported by the Data Import Wizard and the record volume exceeds 50,000.
Data Loader is required because the Data Import Wizard cannot import Opportunity records and has a maximum limit of 50,000 records per job, whereas 65,000 records are being loaded.

Step-by-Step Solution

1
Evaluate record volume requirements
The requirement specifies 65,000 records. Data Import Wizard is limited to 50,000 records, whereas Data Loader supports up to 5,000,000 records.
Record volume dictates tool selection boundaries in Salesforce data management.
2
Evaluate object support requirements
The requirement specifies the Opportunity object. Data Import Wizard supports Accounts, Contacts, Leads, Solutions, Campaign Members, and custom objects, but does NOT support Opportunities.
Object compatibility is a primary criterion when choosing between Data Import Wizard and Data Loader.
3
Select the correct data utility tool
Data Loader satisfies both the object requirement (Opportunities) and the volume requirement (65,000 records).
Only Data Loader meets both criteria for this administrative task.

Key Concept

Data Import Wizard vs Data Loader selection criteria based on record volume and object support.
Estimated Time:1m 0s
Rate this question