Salesforce Certified Platform Administrator II free question 1 / 10 · Domain 1: Security and Access
An org has Contacts to Multiple Accounts turned on. The contact Jordan Lee has an indirect relationship with Account B in addition to the primary account, but that relationship was really with Account C. An admin plans to fix it in Data Loader by changing the AccountId of the AccountContactRelation record to C. Which statement matches the Object Reference (Summer ’22)?
- Updating AccountId to C moves the relationship to C, but Roles is reset to empty
- Updating AccountId to C moves the relationship to C and keeps the Roles and start date
- AccountId can't be changed in an ordinary update, but it can be changed by an upsert that uses an external ID
- AccountId can't be changed on an existing record, so delete the link with B and create a new one with C
Show the answer and explanation
Answer: D
Why this is correct
For AccountContactRelation, the Object Reference says AccountId can't be modified when updating existing account-contact relationship records. The same is true of ContactId. The field's properties don't include Update, so a value can be set only at Create. The object supports create() and delete(), so the fix is to delete the relationship with B and create a new one with C.
Why the other options are wrong
"Updating AccountId to C moves the relationship to C and keeps the Roles and start date" … AccountId can't be modified when updating an existing record, so no update can move a relationship to another account while keeping its Roles and start date. To change the account, you re-create the relationship.
"Updating AccountId to C moves the relationship to C, but Roles is reset to empty" … Since AccountId can't be modified on an existing record, the update never moves the relationship at all, so Roles being reset isn't an outcome either. Roles is a field you can set on both create and update.
"AccountId can't be changed in an ordinary update, but it can be changed by an upsert that uses an external ID" … An upsert acts as an update on a record it matches by external ID, and AccountId can't be modified in an update. Upsert gives no way around it.
Key point
AccountContactRelation is available from API version 37.0 and supports person accounts. IsDirect indicates whether the account is the contact's primary account, is set by default at creation, and can't be set directly on create or update. StartDate and EndDate keep the history of a relationship, IsActive says whether it is active, and Roles is a multi-select picklist.