Salesforce Exam CRT-450 Topic 9 Question 56 Discussion

Actual exam question for Salesforce's CRT-450 exam

Question #: 56
Topic #: 9

A company has a custom object, Order__c, that has a required, unique external ID field called OrderNumber__c.

Which statement should be used to perform the DML necessary to insert new records and update existing records in a list of order__c records

using the external ID field?

AOption A

BOption B

COption C

DOption D

Show Suggested Answer

Suggested Answer: B

by Carma at Jul 08, 2024, 10:48 PM

Limited Time Offer

25%

Off

Get Premium CRT-450 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Izetta

7 months ago

I'm just glad I don't have to worry about external IDs. That sounds like a headache waiting to happen. *laughs*

upvoted 0 times

...

Ronnie

7 months ago

Option A? Really? Using separate insert() and update() statements is so 2010. Get with the times, people!

upvoted 0 times

Doyle

6 months ago

I think I'll go with Option A for now, thanks for the clarification!

upvoted 0 times

...

Nancey

6 months ago

I see your point, but Option A is still a valid choice for performing DML operations on records with an external ID field.

upvoted 0 times

...

Emile

6 months ago

But wouldn't it be more efficient to use Option C instead? It combines insert and update operations for better performance.

upvoted 0 times

...

Marsha

6 months ago

Yes, Option A is the correct choice. It allows you to perform upsert operation in a single statement.

upvoted 0 times

...

Luis

7 months ago

Option C uses the upsert method which is specifically designed for inserting new records and updating existing records based on an external ID field.

upvoted 0 times

...

Eleni

7 months ago

Why do you think Option C is the correct answer?

upvoted 0 times

...

Luis

7 months ago

I disagree, I believe the correct answer is Option C.

upvoted 0 times

...

Eleni

7 months ago

I think the answer is Option A.

upvoted 0 times

...

Laurene

7 months ago

Hmm, Option D is kind of like the Swiss Army knife of DML statements. It can do everything, but I'm not sure it's the most elegant solution here.

upvoted 0 times

Vince

7 months ago

I agree with you, Option C seems like the safest bet for this scenario.

upvoted 0 times

...

Louann

7 months ago

I see what you mean, but I still think Option D is the most versatile and reliable.

upvoted 0 times

...

Leonor

7 months ago

I think Option C might be the best choice here. It seems more specific to the situation.

upvoted 0 times

...

Alesia

7 months ago

I'm going with Option C. The merge() method is designed specifically for this scenario, and it's more concise than the other options.

upvoted 0 times

Leah

7 months ago

I think Option D might be a better choice, it seems more efficient to me.

upvoted 0 times

...

Kate

7 months ago

I agree with you, Option C is the way to go for this scenario.

upvoted 0 times

...

Alisha

8 months ago

Option B looks like the way to go. The upsert() method seems perfect for handling both inserts and updates using the external ID field.

upvoted 0 times

Mitzie

6 months ago

I've used upsert() before and it worked like a charm for managing records with external IDs.

upvoted 0 times

...

Vernell

6 months ago

It's definitely the most efficient way to handle those operations.

upvoted 0 times

...

Lauran

7 months ago

Yes, upsert() is definitely the way to go for handling inserts and updates with the external ID field.

upvoted 0 times

...

Cammy

7 months ago

Yes, upsert() is the way to go for handling both inserts and updates using the external ID field.

upvoted 0 times

...

Tegan

7 months ago

I agree, Option B with the upsert() method is the best choice.

upvoted 0 times

...

Jacklyn

7 months ago

I agree, Option B with the upsert() method is the best choice.

upvoted 0 times

...