PLAT-ADMN-202 practice question 17 of 35

Cloud Kicks (CK) wants to quickly insert a list of over 60,000 net new Accounts. The template based on CK's data model was used to populate the list. Which tool should be used?

Full set: 311 questions

Domain Workflow/Process Automation

Answer options
A: Data Loader Correct answer
B: A Lightning Object Creator
C: Import Wizard
D: Schema Builder
Correct Answer:
A. Data Loader
Explanation

The Data Loader is the appropriate tool for this task because the number of records (over 60,000) exceeds the Data Import Wizard's limit. The Data Loader is a client application designed for bulk data operations and can process between 50,000 and 5 million records per job. It supports all standard and custom objects, including Accounts, making it the correct choice for large-scale data insertion as described in the scenario.

Why Incorrect

B. A Lightning Object Creator: This tool is used to create new custom objects from the structure of a spreadsheet, not to load data into existing standard objects like Account.
C. Import Wizard: The Data Import Wizard is limited to processing a maximum of 50,000 records per job. The requirement to insert over 60,000 records exceeds this limit.
D. Schema Builder: Schema Builder is a visual tool for viewing and modifying your data model (objects, fields, and relationships). It is not used for importing or inserting data records.

References

1. Salesforce Help Documentation, "Data Loader": "Use it when: You need to load 50,000 to 5,000,000 records. Data Loader is supported for loads of up to 5 million records." This directly supports using Data Loader for a 60,000+ record load.

2. Salesforce Help Documentation, "Import Data with the Data Import Wizard": "The Data Import Wizard makes it easy to import data for many standard Salesforce objects... You can import up to 50,000 records at a time." This confirms the Import Wizard is unsuitable due to its record limit.

3. Salesforce Help Documentation, "Create a Custom Object from a Spreadsheet": "With the Lightning Object Creator, you can turn spreadsheets into custom objects... The Lightning Object Creator helps you import the object’s fields and data." This clarifies its purpose is object creation, not data loading into existing objects.

4. Salesforce Trailhead, "Data Management" Module, "Import and Export with Data Management Tools" Unit: "The Data Import Wizard and the Data Loader are two common tools for getting your data into Salesforce... For more complex imports of any size, and for loads of more than 50,000 records, use the Data Loader."

Scroll to Top