ADVANCED-ADMINISTRATOR practice question 3 of 30

An administrator needs to Import a large amount of historical data (more than 100,000 records) from another system. how should the administrator import the data?

Full set: 222 questions
Answer options
A: SOAP based API with Developer console
B: Data Loader with Bulk API Enabled Correct answer
C: An AppExchange package
D: Import Wizard with Add Only
Correct Answer:
B. Data Loader with Bulk API Enabled
Explanation

For importing large data volumes, specifically over 50,000 records, the recommended Salesforce tool is Data Loader. Enabling the "Use Bulk API" setting within Data Loader leverages the Bulk API, which is optimized for processing large sets of data asynchronously. This method is more efficient and reliable for handling 100,000+ records compared to other standard tools, as it breaks the data into batches and processes them in the background, avoiding potential timeouts and performance issues associated with synchronous processing.

Why Incorrect

A. SOAP based API with Developer console: The Developer Console is an integrated development environment for coding and debugging, not a tool designed for bulk data migration. This method would be highly impractical and inefficient.
C. An AppExchange package: While a third-party package might exist, it is not the standard, out-of-the-box solution. The question implies using a native Salesforce tool or platform capability.
D. Import Wizard with Add Only: The Data Import Wizard is limited to importing a maximum of 50,000 records per job. This makes it unsuitable for the requirement of importing over 100,000 records in a single operation.

References

1. Salesforce Help Documentation, "Data Loader": "Data Loader is a client application for the bulk import or export of data. Use it to insert, update, delete, or export Salesforce records. ... If you need to load 50,000 to 5,000,000 records, we recommend you use Data Loader." This source directly supports using Data Loader for the specified volume.

2. Salesforce Help Documentation, "When to Use an External Data Integration Tool": This document compares data loading tools and states, "For more complex import jobs that are less than 50,000 records, use the Data Import Wizard... For loads of 50,000 records or more, use Data Loader." This explicitly disqualifies the Import Wizard (Option D).

3. Salesforce Developer Documentation, "Bulk API Developer Guide", Introduction to Bulk API: "Bulk API is based on REST principles and is optimized for loading or deleting large sets of data. You can use it to query, queryAll, insert, update, upsert, or delete a large number of records asynchronously by submitting batches." This explains why enabling Bulk API in Data Loader (Option B) is the optimal choice for performance with large data sets.

4. Salesforce Help Documentation, "Configure Data Loader": This page details the settings available in Data Loader, including the "Use Bulk API" checkbox. It notes, "Select this option to use Bulk API to insert, update, upsert, delete, and hard-delete records. Bulk API is optimized to process large sets of data." This confirms the mechanism for implementing the correct answer.

Scroll to Top