nerdexam
Salesforce

PLAT-ADMN-201 · Question #130

Universal Containers regularly imports Accounts from an external order system that has its own ID field for each record. What should the System Administrator do to help prevent duplicates during…

The correct answer is B. Create a unique External ID field on Accounts in Salesforce for matching. To prevent duplicates during data imports from an external system with its own ID, the administrator should create a unique External ID field on Accounts in Salesforce for matching.

Submitted by suresh_in· Apr 18, 2026Data and Analytics Management

Question

Universal Containers regularly imports Accounts from an external order system that has its own ID field for each record. What should the System Administrator do to help prevent duplicates during these imports?

Options

  • AUse VLOOKUP to find matching records in Salesforce.
  • BCreate a unique External ID field on Accounts in Salesforce for matching.
  • CCreate a formula field that identifies matches.
  • DUse the ID from the order system in place of the Salesforce ID.

How the community answered

(38 responses)
  • A
    3% (1)
  • B
    95% (36)
  • D
    3% (1)

Why each option

To prevent duplicates during data imports from an external system with its own ID, the administrator should create a unique External ID field on Accounts in Salesforce for matching.

AUse VLOOKUP to find matching records in Salesforce.

VLOOKUP is a spreadsheet function for finding related data and is not a direct Salesforce mechanism for preventing duplicates during an import process.

BCreate a unique External ID field on Accounts in Salesforce for matching.Correct

Creating a custom field with the 'External ID' attribute on the Account object allows Salesforce's import tools to use the external system's ID for matching, preventing duplicates by updating existing records rather than creating new ones.

CCreate a formula field that identifies matches.

A formula field is read-only and cannot be used as a unique identifier for matching records during an import operation.

DUse the ID from the order system in place of the Salesforce ID.

The Salesforce ID is a system-generated unique identifier and cannot be replaced by an external system's ID; external IDs are used for matching purposes, not as substitutes for Salesforce IDs.

Concept tested: External ID for data import

Source: https://help.salesforce.com/s/articleView?id=sf.overview_external_id.htm&type=5

Topics

#Data Import#External ID#Duplicate Prevention#Account Object

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full PLAT-ADMN-201 Practice