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 questionsThe 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.
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.
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.
Keep practicing
Take the free DEX-403 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DEX-403 practice questions
- Question 1Which two solutions prevent a formula field from being referenced by a Roll-Up Summary Fi…
- Question 2Accounts at Universal Containers are currently readable by all users but editable only by…
- Question 3Universal Container wants customers to be able to open cases from a public-facing website…
- Question 4Properly installing managed packages helps prevent conflicts with customizations made by …
- Question 5Universal Containers (UC) has large data volumes and is nearing data storage limits. The …
- Question 6Cloud Kicks's management team frequently travels and wants to approve requests from their…
