Describe the Capabilities of and Use Cases for Formula Fields. PLATFORM-APP-BUILDER Practice Questions (Page 3)

Questions 11–15

1. 11foundation · easy

   Which of the following is a recognized constraint of formula fields?

   • AThey cannot reference fields on other objects unless using cross-object formulas, which have limitations.
   • BThey can be indexed for faster searching.
   • CThey can be used to update fields on related records.
   • DThey can be used in roll-up summary calculations.
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   Which of the following is a common use case for a formula field?

   • AConcatenating a contact's first and last name into a full name.
   • BStoring a list of related records in a single field.
   • CEncrypting sensitive data in a field.
   • DAutomatically sending an email when a record is created.
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   What is a formula field in Salesforce?

   • AA field that stores a value entered by the user and can be edited at any time.
   • BA read-only field that calculates its value from other fields, expressions, or functions when a record is accessed.
   • CA field that automatically updates when a record is edited, but only if the user manually recalculates it.
   • DA field that stores a static value that never changes after the record is created.
   Reveal Solution Discussion Select an answer first
5. 14application · medium

   A company wants to display a warning message on the Opportunity if the close date is in the past and the stage is not 'Closed Won'. The admin creates a formula field with return type Text. Which formula correctly implements this?

   • AIF(CloseDate < TODAY() && Stage != 'Closed Won', 'Warning: Overdue', '')
   • BIF(OR(CloseDate < TODAY(), Stage != 'Closed Won'), 'Warning: Overdue', '')
   • CIF(AND(CloseDate < TODAY(), Stage != 'Closed Won'), 'Warning: Overdue', '')
   • DIF(CloseDate < TODAY() AND Stage != 'Closed Won', 'Warning: Overdue', '')
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A company wants to display the age of a service ticket in days on the Case record. The admin creates a formula field with return type Number and the formula: TODAY() - CreatedDate. When the formula is saved, what issue will the admin encounter?

   • AThe formula will compile but will return a negative number because CreatedDate is in the future.
   • BThe formula will not compile because TODAY() returns a date and CreatedDate is a datetime, so they cannot be subtracted directly.
   • CThe formula will compile and work correctly because Salesforce automatically converts datetime to date in arithmetic.
   • DThe formula will compile but will always return 0 because TODAY() is evaluated at record creation time.
   Reveal Solution Discussion Select an answer first