Exam Certified Platform Developer II topic 1 question 50 discussion

Actual exam question from Salesforce's Certified Platform Developer II

Question #: 50
Topic #: 1

[All Certified Platform Developer II Questions]

A company has a custom object, Order__c, that has a required, unique, external ID field called Order_Number__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?

A. upsert orders;
B. upsert orders Order_Number__c;
C. merge orders Order_Number__c;
D. merge orders;

Show Suggested Answer

Suggested Answer: B 🗳️

by karappo at Feb. 15, 2023, 9:11 a.m.

Comments

Submit Cancel

MetaLojiqTee

11 months ago

Selected Answer: B

If you don't specify the external Id Order_Number__c as the matching field, many records may be inserted with the same Order_Number__c (but different Salesforce Ids), introducing duplicates

upvoted 2 times

...

santo_aj

1 year, 1 month ago

Selected Answer: B

B is de correct answer. https://developer.salesforce.com/docs/atlas.en-us.apexref.meta/apexref/apex_dml_section.htm?q=upsert

upvoted 2 times

...

santo_aj

1 year, 2 months ago

Correct answer is B. This next example performs an upsert of a list of accounts using a foreign key for matching existing records, if any. List<Account> acctList = new List<Account>(); // Fill the accounts list with some accounts try { // Upsert using an external ID field upsert acctList myExtIDField__c; } catch (DmlException e) { ... }

upvoted 1 times

...

bungie

1 year, 2 months ago

Shouldn't the answer be A, do we need to specify the field?

upvoted 1 times

YNWA_A1

11 months, 2 weeks ago

if you dont specifiy the field, it will take the standard id fiel

upvoted 1 times

...

karappo

1 year, 4 months ago

https://developer.salesforce.com/docs/atlas.en-us.apexref.meta/apexref/apex_dml_section.htm?q=upsert

upvoted 1 times

...