nerdexam
Salesforce

ADM-201 · Question #99

Northern Trail Outfitters held an event for hikers to blaze the trail for the new year. Their marketing team collected over a million new lead records to upload into Salesforce. What is the…

The correct answer is D. Data Loader. For uploading a large volume of data like over a million lead records, the Data Loader is the recommended tool due to its ability to handle large datasets efficiently.

Submitted by mateo_ar· Apr 18, 2026Data and Analytics Management

Question

Northern Trail Outfitters held an event for hikers to blaze the trail for the new year. Their marketing team collected over a million new lead records to upload into Salesforce. What is the recommended method for uploading this data?

Options

  • ALightning Sync
  • BAppExchange app
  • CData Import Wizard
  • DData Loader

How the community answered

(29 responses)
  • A
    7% (2)
  • B
    7% (2)
  • C
    17% (5)
  • D
    69% (20)

Why each option

For uploading a large volume of data like over a million lead records, the Data Loader is the recommended tool due to its ability to handle large datasets efficiently.

ALightning Sync

Lightning Sync is used for syncing contacts, events, and tasks between Salesforce and Microsoft® Exchange or Google, not for mass data uploads of lead records.

BAppExchange app

While an AppExchange app could potentially handle large data uploads, Data Loader is Salesforce's native, built-in solution for such tasks and is generally preferred for direct bulk operations.

CData Import Wizard

The Data Import Wizard is suitable for importing up to 50,000 records at a time and provides a user-friendly interface, but it is not designed for the volume of 'over a million' records mentioned.

DData LoaderCorrect

Data Loader is a powerful client application designed for inserting, updating, upserting, deleting, or exporting large amounts of data (up to 5 million records) in a single operation. Its capacity to handle over a million records makes it the ideal choice for this scenario.

Concept tested: Data import tools for large datasets

Source: https://help.salesforce.com/s/articleView?id=sf.data_loader.htm&type=5

Topics

#Data Loading#Large Data Volume#AppExchange#Lead Management

Community Discussion

No community discussion yet for this question.

Full ADM-201 Practice