Examkin

Question

Difficulty: MediumData Import Wizard and Data Loader Utilities

A Salesforce administrator at a subscription services company needs to import 3000030{}000 records into a custom object named Subscription__c. The operation requires preventing duplicate records by matching on an External ID field. Company IT security policies restrict the installation of desktop client software on administrative workstations. Which data management tool should the administrator select to fulfill these requirements?

  1. Data Import Wizard, because it operates via the web browser, supports up to 5000050{}000 custom object records, and enables matching by External ID.Answer
  2. B
    Data Loader desktop client, because the Data Import Wizard cannot perform record matching or deduplication using External ID fields.
  3. C
    Data Loader web application, because the Data Import Wizard is restricted exclusively to importing standard objects such as Accounts and Contacts.
  4. D
    Data Import Wizard, because it allows automated bulk background exports up to 50000005{}000{}000 records without user session management.

Answer

Data Import Wizard, because it operates via the web browser, supports up to 5000050{}000 custom object records, and enables matching by External ID.
The correct answer specifies Data Import Wizard because it is entirely web-based (satisfying the constraint against installing desktop software), natively supports up to 5000050{}000 records for all custom objects, and provides built-in matching using External ID fields to prevent duplicates.

Step-by-Step Solution

1
Evaluate record volume and environment constraints.
The requirement involves 3000030{}000 records (within the 5000050{}000 limit of Data Import Wizard) and specifies that no desktop software can be installed.
Data Loader requires installing a desktop client application, whereas Data Import Wizard is accessible directly through the Salesforce setup browser UI.
2
Verify object support for the target entity.
The target object is a custom object (Subscription__c). Data Import Wizard fully supports all custom objects.
Custom objects are supported up to 5000050{}000 records in Data Import Wizard.
3
Confirm duplicate handling capability.
Data Import Wizard natively supports matching existing records by External ID to perform upsert operations and prevent duplicates.
External ID matching is a standard feature when mapping fields in the Data Import Wizard.

Key Concept

Selecting between Data Import Wizard and Data Loader based on client installation requirements, record volume limits (5000050{}000), object type support, and External ID matching capabilities.
Rate this question

Topics

Data Import Wizard and Data Loader Utilities

More questions from this topic