Examkin

Question

Difficulty: HardData Import Wizard and Data Loader Utilities

A Salesforce administrator at a telecommunications firm is tasked with configuring an automated nightly process to archive operational data. The process must export 150,000 Case records to an external repository and subsequently execute a hard delete on those records to free up organization storage. Which tool should the administrator select to fulfill these operational requirements?

  1. Data Loader, because it supports command-line automation, hard deletion capabilities, and processing volumes greater than 50,000 records for the Case object.Answer
  2. B
    Data Import Wizard, because it provides built-in automated scheduling for nightly exports and native hard delete capabilities for standard objects.
  3. C
    Data Import Wizard, because standard objects like Case can be exported in bulk up to 250,000 records when using scheduled background tasks.
  4. D
    Data Loader for the hard delete action, but Data Import Wizard for the automated scheduled export of Case records.

Answer

Data Loader, because it supports command-line automation, hard deletion capabilities, and processing volumes greater than 50,000 records for the Case object.
Data Loader is the appropriate tool for this scenario because it can process up to 5,000,000 records per operation, supports data exports as well as hard deletes (bypassing the Recycle Bin), supports all standard objects including Cases, and can be automated on a nightly schedule using its command-line interface (CLI).

Step-by-Step Solution

1
Evaluate record volume requirements.
The requirement specifies 150,000 records, which exceeds the Data Import Wizard maximum cap of 50,000 records.
Data Loader supports up to 5,000,000 records per bulk operation, whereas Data Import Wizard fails above 50,000 records.
2
Evaluate object type support.
The target object is Cases (a standard service object).
Data Import Wizard only supports specific standard objects (Accounts, Contacts, Leads, Solutions, Campaign Members) and Custom Objects. Cases are not supported by the Data Import Wizard.
3
Evaluate operation types and automation requirements.
The process requires automated export, command-line scheduling, and hard deletion.
Data Import Wizard does not perform data exports, does not support hard deletion (purging records from the Recycle Bin), and cannot run headlessly via command line/CLI scripts.

Key Concept

Selecting data administration utilities based on record volume, object support, operation type (export/hard delete), and automation capability.
Estimated Time:2m 0s
Rate this question

Topics

Data Import Wizard and Data Loader Utilities

More questions from this topic