In an Upsert scenario for updating an Account, where are the Upsert keys configured?

In an Upsert scenario for updating an Account, where are the Upsert keys configured?

• A. Check the Upsert key checkbox on the Account Status field
• B. Check the Upset key and is required for Upsert checkboxes on the Account id field
• C. Populate the Lookup object and Lookup fields
• D. Check Overwrite Target for all Null input checkbox on the Account id field

Answer: (B)

Upsert needs a field that uniquely identifies the record to update. For an Account, using the Account Id as the key is the right approach, and you do this by enabling the Upsert key on that field and marking it as required for Upsert. This pair tells the system how to locate the existing record: it uses the Id to find a match and update it; if no match is found, it can insert a new record. Other options don’t establish the identifying key—choosing a status field wouldn’t reliably identify a single Account, Lookups relate to related data rather than the Upsert match key, and Overwrite Target controls behavior for null inputs, not record matching.

Upsert needs a field that uniquely identifies the record to update. For an Account, using the Account Id as the key is the right approach, and you do this by enabling the Upsert key on that field and marking it as required for Upsert. This pair tells the system how to locate the existing record: it uses the Id to find a match and update it; if no match is found, it can insert a new record. Other options don’t establish the identifying key—choosing a status field wouldn’t reliably identify a single Account, Lookups relate to related data rather than the Upsert match key, and Overwrite Target controls behavior for null inputs, not record matching.