DEX-403 practice question 24 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: 291 questions
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 most appropriate tool for inserting over 60,000 records is the Data Loader. The Data Import Wizard, while user-friendly, is limited to processing a maximum of 50,000 records per job. Since the requirement is to load more than 60,000 Accounts, the Data Loader is the correct choice as it is a client application designed for bulk data operations and can handle up to 5 million records. It is the standard Salesforce tool for large-scale data migration tasks like the one described.

Why Incorrect

B. A Lightning Object Creator: This tool is used to create new custom objects from a spreadsheet's structure, not to load data records into an existing standard object like Account.
C. Import Wizard: This tool is not suitable because its maximum capacity is 50,000 records per import job, which is less than the required 60,000+ records.
D. Schema Builder: This is a metadata tool used for visualizing and modifying the data model (objects, fields, and relationships), not for importing or manipulating data records.

References

1. Salesforce Help, "When to Use Data Loader": "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, "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 limitation that makes the Import Wizard unsuitable for this scenario.

3. Salesforce Help, "Create Custom Objects from Spreadsheets with a Few Clicks": "The Lightning Object Creator is a new platform tool that boosts productivity by allowing you to create a custom object by uploading a spreadsheet." This clarifies that its purpose is metadata creation, not data loading into existing objects.

4. Salesforce Help, "Work with Schema Builder": "Schema Builder is a tool that lets you visualize and edit your data model... It’s useful for designing and understanding the schema in your org." This defines Schema Builder as a data model management tool, not a data import tool.

Scroll to Top