A Salesforce administrator at a medical device company needs to configure a weekly automat… — Salesforce Certified Administrator

A Salesforce administrator at a medical device company needs to configure a weekly automated process to upsert $85{}000$ custom $Equipment\_\_c$ records from an external ERP system into Salesforce using an External ID field. The operation must run via command-line interface (CLI) without manual user intervention. Which utility should the administrator select to fulfill these requirements?

Data LoaderAnswer
B
Data Import Wizard
C
Mass Transfer Records
D
Salesforce Connect

Answer

Data Loader is the appropriate utility because it supports up to 5,000,000 records and offers a command-line interface (CLI) for automated, scheduled operations.

Data Loader is designed to handle up to 5,000,000 records per operation and includes a client-based Command Line Interface (CLI) that enables administrators to automate routine upsert tasks on a scheduled basis using external IDs.

Step-by-Step Solution

Evaluate record volume requirement

The requirement specifies

85{}000

records, which exceeds the

50{}000

record limit of the Data Import Wizard.

Data Import Wizard cannot process files larger than

50{}000

records.

Evaluate operational mode requirement

The operation requires automated command-line execution (CLI) without user intervention.

Only Data Loader provides a command-line interface (CLI) capability for script-driven automated execution.

Select the correct tool based on criteria

Data Loader satisfies both high volume (

85{}000

records) and automated CLI execution criteria.

Data Loader handles up to 5,000,000 records and supports automated CLI tasks.

Key Concept

Selecting data administration utilities based on record volume limits and command-line automation capabilities

Question

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Topics

More questions from this topic