Salesforce App Builder Practice Exam

The chosen formula is valid because it correctly implements the syntax and requirements for a text formula field in Salesforce. In particular, the CASE function is used to evaluate the value of Account.Rating and return a corresponding text value based on its case. The proper syntax for the CASE function requires that string values be enclosed in quotation marks.

In this scenario, by using quotation marks around each rating value—"Hot", "Warm", and "Cold"—the formula accurately matches against the possible values of Account.Rating. If the account's rating is "Hot", the function returns "Hot"; similarly for "Warm" and "Cold". If none of these match, it defaults to "Not Rated". This direct and precise matching makes this formula suitable for working within the text formula context on the contact record.

Other options do not meet the criteria effectively. For instance, simply referencing Account.Rating would return the raw value directly without any conversion or case handling, which does not fulfill the requirement of displaying an appropriate text value. The use of the TEXT function is also not necessary in this context, as the CASE function already deals with text outputs.

Thus, the use of the CASE function with the properly formatted string values makes the selected formula the correct choice