Salesforce Certified Platform App Builder — Question 412
Ursa Major Solar (UMS) has a custom object where they track Galactic Vendors. The object has four custom fields for the Galactic Vendors's location:
• Street
• City
• Planet
• Galaxy
The UMS's leadership wants these fields to be concatenated into a single formula field on two lines.
Which formula fulfills this requirement?
Answer options
- A. Street__c & BR() & City__c & ", " & Planet__c & " " & Galaxy__c
- B. Street &(& City & ", " & Planet & " " & Galaxy)
- C. Street & BR() & City & ", " & Planet & " " & Galaxy
- D. Street__r & BR() & City__r & ", " & Planet__r & " " & Galaxy__r
Correct answer: A
Explanation
Option A is correct because it properly concatenates the fields with the appropriate line break using BR() and includes all required fields. Option B is incorrect due to the use of '&(' which is not valid syntax. Option C is close but lacks the '__c' suffix that specifies the custom fields in Salesforce. Option D incorrectly uses '__r' suffixes, which are meant for relationships, not for the custom fields being referenced.