Question

Difficulty: MediumData Export, Backup Services, and Mass Operations

An administrator needs to clean up 45,000 obsolete custom object records named Audit Log (Audit_Log__c) from a Salesforce org. The administrator wants to select the most appropriate tool to perform this bulk removal. Which tool should the administrator use to complete this mass deletion?

  1. Data Loader using a Delete operation with a CSV file containing the record IDs.Answer
  2. B
    The native Mass Delete Records tool accessible within Salesforce Setup.
  3. C
    The Data Import Wizard configured with the Delete records action.
  4. D
    The Data Export Service by selecting the Purge Exported Custom Data checkbox.

Answer

Data Loader using a Delete operation with a CSV file containing the record IDs.
Data Loader is the appropriate tool because it supports DML Delete and Hard Delete operations for both standard and custom objects, handling large volumes up to 5,000,000 records.

Step-by-Step Solution

1
Identify the target records and extract their unique Salesforce Record IDs into a CSV file.
A CSV file containing the 18-character IDs of the 45,000 Audit Log custom object records.
Bulk deletion operations require record IDs to locate and delete records in Salesforce.
2
Evaluate tool capabilities for deleting custom object records at scale.
Determine that the native Mass Delete Records wizard and Data Import Wizard cannot delete custom objects.
The Mass Delete Records tool is limited to standard objects, and the Data Import Wizard does not perform deletion.
3
Execute the Delete operation using Data Loader.
The 45,000 custom object records are deleted and sent to the Recycle Bin.
Data Loader handles up to 5 million records and fully supports DML delete operations on custom objects.

Key Concept

Mass Deletion and Bulk Data Operations for Custom Objects
Estimated Time:1m 30s
Rate this question