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?

Discuss Salesforce ADX-211 Exam Topic 10 Question 64

Marguerita

5 months ago

Update won't add new records, so it's not the right choice here.

upvoted 0 times

...

Kris

5 months ago

Definitely not Export or Insert, those won't work for this.

upvoted 0 times

...

Michell

5 months ago

Wait, can Upsert really do both? Sounds too good to be true!

upvoted 0 times

...

Pearly

5 months ago

I agree, Upsert handles both updates and inserts perfectly.

upvoted 0 times

...

Verlene

6 months ago

Upsert is the way to go for matching and adding records!

upvoted 0 times

...

Irving

6 months ago

I'm a bit confused; could we just use Insert for new records? But then how would we update the existing ones?

upvoted 0 times

...

Kenda

6 months ago

I practiced a similar question, and I believe Upsert is the best option here since we have both existing and new records to handle.

upvoted 0 times

...

Stevie

6 months ago

I'm not entirely sure, but I remember something about needing to update the Status field specifically, so maybe Update is the right choice?

upvoted 0 times

...

Tennie

6 months ago

I think we need to use Upsert because it allows us to update existing records and insert new ones at the same time.

upvoted 0 times

...

Okay, I think I've got a plan. I'll start by exporting the data to review the fields and structure. Then I'll use the Upsert option in Data Loader to match existing records and add any new ones. Feels like the safest approach to handle this requirement.

upvoted 0 times

...

Robt

6 months ago

I'm a bit confused on the difference between Update and Upsert. I'll need to double-check the documentation to make sure I understand the implications of each option before making a decision.

upvoted 0 times

...

Hyun

6 months ago

Upsert sounds like the way to go here. That way I can update existing records and insert new ones in a single operation. I just need to make sure I have the right External Id field mapped correctly.

upvoted 0 times

...

Nohemi

6 months ago

Hmm, this one seems a bit tricky. I'll need to carefully review the data and the options to make sure I choose the right approach. Maybe I'll start by exporting the data to get a better understanding of the fields and records.

upvoted 0 times

...

Kati

7 months ago

I think the key here is to match existing records and add new ones. The question mentions using Data Loader, so I'll probably go with the Upsert option to handle both scenarios.

upvoted 0 times

...