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 questionsFor 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.
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.
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.
Keep practicing
Take the free ADVANCED-ADMINISTRATOR practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other ADVANCED-ADMINISTRATOR practice questions
- Question 1An administrator is using the Dev Console Log Inspector to troubleshoot a Process Builder…
- Question 2The sales agents at DreamHouse Realty have a profile that allows them to import records f…
- Question 4Administrator has been tasked with creating a new custom field on the Account object call…
- Question 5Cloud Kicks (CK) wants the forecast numbers to be shown by territory regardless of who ow…
- Question 6The administrator at Cloud Kicks created a flow in a sandbox that walks service agents th…
- Question 7Cloud Kicks has Service end Soles Manager roles that need to be able to see a I Accounts.…
