Examkin

Question

Difficulty: HardData Import Wizard and Data Loader Utilities

A Salesforce administrator at a subscription management company needs to import 4200042{}000 custom Subscription__cSubscription\_\_c records. The operation requires preventing duplicate records during import by matching on an External ID field, opting out of triggering active Workflow Rules during record creation, and executing the job via a browser-based UI without downloading desktop software. Which administration tool meets all of these requirements?

  1. Data Import Wizard, because it supports up to 5000050{}000 records, operates in a browser, allows workflow rule suppression, and matches on External ID for custom objects.Answer
  2. B
    Data Loader, because Data Import Wizard cannot match records based on External ID fields during an upsert or insert operation.
  3. C
    Data Loader, because Data Import Wizard is limited to a maximum volume of 1000010{}000 records per import batch for custom objects.
  4. D
    Data Import Wizard, but workflow rules will automatically trigger because workflow suppression is only supported when using Data Loader.

Answer

Data Import Wizard, because it supports up to 5000050{}000 records, operates in a browser, allows workflow rule suppression, and matches on External ID for custom objects.
The correct answer identifies the Data Import Wizard as the appropriate tool because the record volume (4200042{}000) is under the 5000050{}000 wizard limit, it runs entirely within the web browser without installing desktop software, it supports deduplication using External IDs for custom objects, and it provides a setting to suppress workflow rules during data creation.

Step-by-Step Solution

1
Evaluate record volume requirement
The target volume is 4200042{}000 records, which is under the 5000050{}000 record limit of the Data Import Wizard.
Data Import Wizard handles up to 5000050{}000 records, whereas Data Loader handles up to 50000005{}000{}000 records.
2
Evaluate application architecture and user interface constraint
The requirement specifies using a browser-based UI without installing desktop applications.
Data Import Wizard is natively built into the Salesforce web application setup, while Data Loader requires a client desktop application download.
3
Evaluate workflow suppression and duplicate matching criteria
Data Import Wizard allows matching custom object records by External ID and explicitly provides a checkbox to suppress workflow rules and processes.
Data Loader automatically fires active workflows and processes without an native option to suppress them in the client interface.

Key Concept

Data Import Wizard vs Data Loader Capabilities and Tool Selection
Rate this question

Topics

Data Import Wizard and Data Loader Utilities

More questions from this topic