Examkin

Question

Difficulty: HardData Import Wizard and Data Loader Utilities

A Salesforce Administrator at an enterprise software company is evaluating data administration tools for several bulk data operations. Which two statements accurately describe the capabilities or limitations of the Data Import Wizard and Data Loader? (Select 2 options)

  1. Data Loader must be selected to hard delete 12,000 custom object records to permanently purge them from the org without sending them to the Recycle Bin.Answer
  2. Data Loader must be used instead of the Data Import Wizard when importing 25,000 Opportunity records because the Data Import Wizard does not support importing Opportunities.Answer
  3. C
    The Data Import Wizard should be chosen to schedule automated nightly exports of Account records because of its built-in automated scheduling utility.
  4. D
    The Data Import Wizard should be selected when importing 75,000 Contact records because it can process up to 100,000 records in a single batch operation.

Answer

The correct statements are that Data Loader must be selected to hard delete custom object records permanently without moving them to the Recycle Bin, and Data Loader must be used when importing Opportunity records because the Data Import Wizard does not support the Opportunity object.
Data Loader is required for hard deleting records (which permanently purges them without sending them to the Recycle Bin) as well as importing Opportunity records, since the Data Import Wizard does not support the Opportunity object or deletion operations.

Step-by-Step Solution

1
Evaluate object support for the Data Import Wizard
The Data Import Wizard supports Accounts, Contacts, Leads, Solutions, Campaign Members, Person Accounts, and custom objects. It does not support Opportunities.
Opportunity records must be imported using Data Loader regardless of batch size.
2
Evaluate record volume limits for both tools
The Data Import Wizard caps imports at 50,000 records per session, while Data Loader can handle up to 5,000,000 records.
Importing 75,000 records exceeds the Data Import Wizard threshold and requires Data Loader.
3
Analyze operation types supported by each tool
Data Import Wizard only supports insert, update, and upsert operations. Data Loader supports insert, update, upsert, delete, hard delete, export, and export all.
Hard deletion (bypassing the Recycle Bin) and exporting data are capabilities exclusive to Data Loader.

Key Concept

Data Import Wizard vs Data Loader Capabilities and Selection Criteria
Rate this question

Topics

Data Import Wizard and Data Loader Utilities

More questions from this topic