Salesforce App Builder Practice Exam

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards

From $12.50Unlock all

Session length

1 / 20

Which formula is valid in a text formula field on the contact to display the appropriate value for an account's rating?

CASE(Account.Rating, Hot, Hot, Warm, Warm, Cold, Cold, Not Rated)

CASE(Account.Rating, "Hot", "Hot", "Warm", "Warm", "Cold", "Cold", "Not Rated")

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

Account.Rating

Text(Account.Rating)