A Salesforce administrator at a global retail company needs to execute two distinct data management operations:
1. Update or insert 80,000 Contact records based on a unique External ID field.
2. Permanently remove (hard delete) 15,000 inactive custom object records named Archive_Log__c from the organization.
Which two statements specify the correct tool and operation required to satisfy these requirements? (Choose 2 options)
- Data Loader must be used to perform an upsert operation for the 80,000 Contact records using the External ID.Answer
- Data Loader must be used to perform a hard delete operation for the 15,000 Archive_Log__c records.Answer
- CData Import Wizard should be used to perform an upsert operation for the 80,000 Contact records using the External ID.
- DData Import Wizard should be used to perform a hard delete operation for the 15,000 Archive_Log__c records.
Answer
Data Loader must be used for both operations: upserting the 80,000 Contact records using the External ID and performing a hard delete on the 15,000 Archive_Log__c records.
Data Loader is the appropriate tool for both tasks because Data Import Wizard is limited to 50,000 records per job and does not support record deletion or hard deletion. Data Loader easily handles up to 5,000,000 records and includes native support for upserting via External ID as well as hard deleting records.
Step-by-Step Solution
Key Concept
Tool selection criteria between Data Import Wizard and Data Loader based on record volume limits and supported operation types (e.g., hard delete).