Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Salesforce ADX-211 Exam - Topic 10 Question 64 Discussion

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?
B) Update
A) Export
C) Insert
D) Upsert

Salesforce ADX-211 Exam - Topic 10 Question 64 Discussion

Contribute your Thoughts:

0/2000 characters
Marguerita
9 months ago
Update won't add new records, so it's not the right choice here.
upvoted 0 times
...
Kris
10 months ago
Definitely not Export or Insert, those won't work for this.
upvoted 0 times
...
Michell
10 months ago
Wait, can Upsert really do both? Sounds too good to be true!
upvoted 0 times
...
Pearly
10 months ago
I agree, Upsert handles both updates and inserts perfectly.
upvoted 0 times
...
Verlene
10 months ago
Upsert is the way to go for matching and adding records!
upvoted 0 times
...
Irving
10 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
11 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
11 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
11 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
...
Terina
11 months ago
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
11 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
11 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
11 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
11 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
...
Yong
1 year ago
Upsert? I'd rather be 'up-skirting' my way to the top, if you know what I mean. Just kidding, Upsert is the way to go!
upvoted 0 times
Gary
1 year ago
D) Upsert
upvoted 0 times
...
Carlene
1 year ago
C) Insert
upvoted 0 times
...
Mollie
1 year ago
B) Update
upvoted 0 times
...
Lavonda
1 year ago
A) Export
upvoted 0 times
...
...
Jesusa
1 year ago
Jack
upvoted 0 times
Vilma
1 year ago
D) Upsert to add new records with External Id and Status fields
upvoted 0 times
...
Jesusita
1 year ago
B) Update the Status field on the existing records
upvoted 0 times
...
Tu
1 year ago
A) Export the existing records with External Id and Status fields
upvoted 0 times
...
...
Francoise
1 year ago
Upsert all the way! It's like a one-stop-shop for my data needs. Why bother with anything else?
upvoted 0 times
Brittni
1 year ago
C) Insert
upvoted 0 times
...
Hubert
1 year ago
D) Upsert
upvoted 0 times
...
Giovanna
1 year ago
A) Export
upvoted 0 times
...
...
Shawna
1 year ago
Upsert is definitely the answer. It's like a magical wand that can do it all - update and insert with a single swing!
upvoted 0 times
Lilli
1 year ago
It's a time-saver for sure, no need to export and then update separately.
upvoted 0 times
...
Ronnie
1 year ago
I always use upsert when dealing with new and existing records.
upvoted 0 times
...
Theola
1 year ago
I agree, it's so convenient to update and insert at the same time.
upvoted 0 times
...
Blondell
1 year ago
Upsert is the way to go for sure!
upvoted 0 times
...
...
Han
1 year ago
I'd go with Upsert too. It's the most efficient way to handle both existing and new records in one action.
upvoted 0 times
Jordan
1 year ago
D) Upsert
upvoted 0 times
...
Destiny
1 year ago
A) Export
upvoted 0 times
...
...
Lorean
1 year ago
I'm not sure, but I think C) Insert could also work to add new records.
upvoted 0 times
...
Dominga
1 year ago
Upsert seems like the way to go. It'll update existing records and insert new ones. Can't go wrong with that!
upvoted 0 times
Ashton
1 year ago
D) Upsert
upvoted 0 times
...
Galen
1 year ago
C) Insert
upvoted 0 times
...
Tenesha
1 year ago
B) Update
upvoted 0 times
...
Lou
1 year ago
A) Export
upvoted 0 times
...
...
Ming
1 year ago
I agree with Mattie, Upsert is the best option to populate the Status field and add new records.
upvoted 0 times
...
Mattie
1 year ago
I think the answer is D) Upsert.
upvoted 0 times
...

Save Cancel