Examkin

Question

Difficulty: HardData Import Wizard and Data Loader Utilities

A system administrator needs to set up an automated nightly process to upsert 40,000 Account and Contact records into Salesforce from an external system using a custom External ID field. The process must execute on a scheduled basis without requiring manual interaction in the browser interface. Which utility should the administrator select to meet these requirements?

  1. Data Loader executed via the Command Line Interface (CLI), because it supports automated batch processes and upsert operations using External IDs.Answer
  2. B
    Data Import Wizard, because it natively supports automated nightly scheduling and record volumes up to 50,000 records from the Setup menu.
  3. C
    Data Import Wizard, because Data Loader only supports Salesforce record IDs and cannot perform upsert operations using custom External IDs.
  4. D
    Data Loader, because the Data Import Wizard is limited to a maximum of 10,000 records per operation and does not support standard objects like Accounts and Contacts.

Answer

Data Loader executed via the Command Line Interface (CLI) should be selected because it supports automated batch operations, scheduled execution without manual intervention, and upserts based on External IDs.
Selecting Data Loader executed via the Command Line Interface (CLI) is correct because Data Loader provides a CLI component that can be integrated with OS schedulers to automatically perform batch data operations, such as upserts matching on External IDs, without user intervention.

Step-by-Step Solution

1
Analyze the operational requirements
Identified key constraints: automated nightly execution (no manual UI steps), upsert capability using External IDs, and record volume of 40,000 records across Accounts and Contacts.
Tool selection requires evaluating automation capabilities alongside record volume and object support.
2
Evaluate Data Import Wizard against requirements
Data Import Wizard supports 40,000 records and Accounts/Contacts with External IDs, but it is purely browser-based and cannot be run headlessly via scheduled automation script.
Automated nightly jobs require CLI or API automation.
3
Evaluate Data Loader against requirements
Data Loader can be run via CLI using batch configuration files and scheduled tasks (e.g., Windows Task Scheduler or cron jobs) to perform automated upserts via External ID.
Data Loader CLI is designed specifically for automated unattended data loading operations.

Key Concept

Data Loader CLI vs Data Import Wizard Automation
Estimated Time:2m 0s
Rate this question

Topics

Data Import Wizard and Data Loader Utilities

More questions from this topic