Examkin

Question

Difficulty: Very hardData Import Wizard and Data Loader Utilities

A Salesforce administrator is evaluating native data utilities to satisfy four specific administrative requirements for an enterprise organization:

1. Importing 65,000 custom object records using an External ID for upsert operations.
2. Importing 35,000 Lead records while applying existing duplicate rules to prevent creating duplicate records.
3. Executing an automated, nightly scheduled upsert of Opportunity records.
4. Performing a hard delete of 150,000 inactive custom object records to immediately bypass the Recycle Bin.

Which two utility configurations should the administrator implement to successfully fulfill these requirements? (Choose 2 options)

  1. Use Data Import Wizard to process the 35,000 Lead records because it natively supports Lead imports under 50,000 records and allows matching against lead deduplication criteria.Answer
  2. Use Data Loader via command-line interface (CLI) to execute both the automated nightly Opportunity upserts and the bulk hard deletion of custom object records.Answer
  3. C
    Use Data Import Wizard to perform the upsert of 65,000 custom object records because it handles custom objects faster via browser session controls.
  4. D
    Use Data Loader to import the Lead records because Data Import Wizard does not support standard objects like Leads or Campaign Members.

Answer

The administrator should use Data Import Wizard for the 35,000 Lead import to enforce duplicate prevention rules, and Data Loader (via CLI) for the 65,000 custom object upsert, the automated nightly Opportunity upsert, and the hard delete operation.
Data Import Wizard is optimal for importing under 50,000 Lead records with duplicate detection. Data Loader is required for automated CLI tasks, Opportunity operations, data loads exceeding 50,000 records, and hard deletion of records.

Step-by-Step Solution

1
Evaluate record volume limits for the data operations.
The 65,000 custom object record import exceeds the 50,000 record ceiling of the Data Import Wizard, requiring Data Loader.
Data Import Wizard cannot process data loads exceeding 50,000 total records in a single job.
2
Evaluate object type support and feature capabilities.
Lead import (35,000 records) fits within the Data Import Wizard limits and benefits from native duplicate matching rules. Opportunity operations are unsupported by Data Import Wizard.
Data Import Wizard supports Accounts, Contacts, Leads, Solutions, and Campaign Members, but does not support Opportunities or automated background CLI schedules.
3
Assess automation and deletion requirements.
Nightly scheduled upserts and Hard Delete operations require Data Loader.
Hard Delete (bypassing Recycle Bin) and scheduled unattended execution via command-line interface are features exclusive to Data Loader.

Key Concept

Selecting between Data Import Wizard and Data Loader based on record volume limits, object support, duplicate prevention capabilities, and command-line automation.
Rate this question

Topics

Data Import Wizard and Data Loader Utilities

More questions from this topic