DATA-ARCHITECT practice question 32 of 35
NTO has multiple systems across its enterprise landscape including salesforce, with disparate version the customer records. In salesforce, the…
Full set: 257 questionsThe most efficient and standard method to store a unique identifier from an external system, like an MDM master key, is by using a custom field on the Salesforce object marked as an "External ID". This field type is specifically designed for this purpose. It is indexed by Salesforce, which significantly improves performance for data operations, particularly for "upsert" calls from the integration, which use the external ID to find and update or create the correct record. This approach avoids the overhead of extra objects or platforms.
A. Using Heroku is overly complex and expensive for storing a single key, introducing unnecessary synchronization layers.
B. A custom object adds an extra record and join for what is a one-to-one attribute of the Contact, which is inefficient.
C. An external object is used to access data stored outside of Salesforce, not for storing an external key inside Salesforce.
1. Salesforce Developer Documentation, Custom Field Types. "External ID: A custom field that has the “External ID” attribute, meaning that it contains unique record identifiers from a system outside of Salesforce."
2. Salesforce Architects, Architect's Guide to Record-Level Data, "Record Identifiers" section. This guide discusses using External IDs as a best practice for integrating with external systems and maintaining a stable key for data synchronization.
3. Salesforce Integration Patterns and Practices, Remote Process Invocation—Request and Reply, Page 11. The document discusses using External IDs to simplify integration logic by allowing upsert operations based on a stable identifier from the remote system.
Keep practicing
Take the free DATA-ARCHITECT practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DATA-ARCHITECT practice questions
- Question 1Which three characteristics of a skinny table help improve report and query performance?
- Question 2Universal Containers (UC) has built a custom application on Salesforce to help track ship…
- Question 3Universal Containers (UC) has lead assignment rules to assign leads to owners. Leads not …
- Question 4Universal Container (UC) has accumulated data over years and has never deleted data from …
- Question 5Universals Containers’ system administrators have been complaining that they are not able…
- Question 6Universal Containers is experiencing frequent and persistent group membership locking iss…
