An administrator is given a .csv file of 5,000 leads with External Id and Status fields. They need to match existing and add new records with Data Loader. What action should be taken to populate the…

The correct answer is D. Upsert. Upsert is an operation that can either update existing records or insert new records based on the External Id field. This way, the administrator can match existing leads and add new ones with

Data Management

Question

An administrator is given a .csv file of 5,000 leads with External Id and Status fields. They need to match existing and add new records with Data Loader. What action should be taken to populate the Status field on the records and add new records?

Options

AExport
BUpdate
CInsert
DUpsert

How the community answered

(33 responses)

A
3% (1)
B
12% (4)
C
6% (2)
D
79% (26)

Explanation

Upsert is an operation that can either update existing records or insert new records based on the External Id field. This way, the administrator can match existing leads and add new ones with

Topics

#Data Loader#upsert#external ID#data import

Community Discussion

No community discussion yet for this question.

Full CRT-211 Practice