CRT-403 practice question 9 of 35

Universal Containers wants to match Opportunity data from Salesforce to the records in a financial database. What is required to configure an indirect lookup relationship in Salesforce between the Salesforce Opportunity records and those in a financial database?

Full set: 291 questions
Answer options
A: Salesforce Record ID
B: TEXT(Id)
C: External ID Correct answer
D: CASESAFE(Id)
Correct Answer:
C. External ID
Explanation

An indirect lookup relationship links a child standard or custom object (in this case, Opportunity) to a parent external object. This relationship functions by matching a value in a specified field on the child object to a value in a field on the parent external object. For this matching to occur, the custom field on the child object (Opportunity) must have the External ID attribute. This field will hold the identifier from the external system, allowing Salesforce to dynamically query and link to the corresponding record in the financial database without using Salesforce Record IDs.

Why Incorrect

A. Salesforce Record ID: This is used for standard lookup relationships between two native Salesforce objects, not for linking a Salesforce object to an external one via an indirect lookup.
B. TEXT(Id): This is a formula function used to convert a Salesforce ID to a text string. It is not a field attribute required to configure an indirect lookup relationship.
D. CASESAFE(Id): This formula function converts a 15-character ID to a case-safe 18-character ID. It is irrelevant to the configuration of relationships with external objects. ---

References

1. Salesforce Help Documentation, "Object Relationships Overview": Under the "Indirect Lookup Relationship" section, it states, "An indirect lookup relationship links a child standard or custom object to a parent external object. It uses the specified field on the child object and the External ID field on the parent object to match and associate the records." This highlights the necessity of the External ID field.

2. Salesforce Help Documentation, "Set Up Salesforce Connect to Access External Data": In the section on creating relationship fields, it specifies for indirect lookups: "An indirect lookup relationship links a child standard or custom object to a parent external object via a custom field on the child object. This field has the External ID attribute and holds an external ID value from the parent object." (See section: "Create Relationship Fields").

3. Salesforce Connect Trailhead Module, "Set Up Salesforce Connect": The unit "Create External Objects and Relationships" explains that for an indirect lookup, you create a custom field on the standard or custom object (the child) and select the "External ID" checkbox. This field is then used to match against the external object's ID.

Scroll to Top