Custom Field Types - Subscriber Preferences

Question 1

The media team at Prestige Worldwide uses a custom object called “subscriptions” in Salesforce to manage prestiges various content offerings. Prestige offers magazines, newspapers, books, and e-books. Subscribers can be subscribed to none or any of the above offerings. What custom field type would be best to capture the subscriber preferences in Salesforce? Choose 1

A. Text field
B. Picklist field
C. Formula field
D. Multi select picklist fields

Answer 1

D.

A multi select pick list field allows users to select more than one picklist value from a list. A multi-select picklist field also allows a user to select no pick list values if a subscriber cancels their subscription.

Question 2

What is each value in the multi select picklist separated by in a standard view or when exporting data?

Answer 2

Semi-colon (;)

Magazine;Book

Question 3

How does a Formula field get populated?

Answer 3

Formula field value is automatically calculated based on other values or functions in Salesforce. A formula field is read-only and does not appear on the record edit page.

Question 4

What is the difference between formula field in a validation rule in Salesforce?

Answer 4

Any change in the formula is automatically reflected in the value of the formula field.

Validation rules verify that the user entered data meets the specified standards in a record before the record can be saved by the user.

Question 5

Sally is thinking of using the ISCHANGED function? When does it return true and when does it return false?

Answer 5

ISCHANGED(field)
Compares the value of a field to the previous value and returns true if the values are different. If the values are the same, this function returns false.

Question 6

What function should Sally use to determine if a field has a value?

Answer 6

ISBLANK(field)

Determines if an expression has a value and returns true if it does not. If it does contain a value this function returns false.

A field is not considered empty if it contains a character, blank space, or zero.

Question 7

What function should Sally use to determine if a value in the pick list field is equal to a specific value she wants to check?

Answer 7

ISPICKVAL(picklist, value)

Determines if the value of a pick list field is equal to a text literal you specify.

Question 8

What function do you do you use to reverse a logical expression?

Answer 8

NOT(logical)

Returns false or true and true or false

Question 9

What does the function PRIORVALUE() do?

Answer 9

Returns to previous value of a field

Question 10

Sally wants to return the current date without the date. Which function should she use?

A. NOW()
B. TIMENOW()
C. TODAY()

Answer 10

B.

Returns of value representing the current time without the date.

Question 11

Sally wants to return the current day, month, year without the time. Which function should she use?

A. NOW()
B. TIMENOW()
C. TODAY()

Answer 11

C.

Returns the current day, month, year as a date data type.

Question 12

What does the Now() function return?

Answer 12

Returns the date/time value of the current moment. It’s useful when you are concerned with specific times of day as well as the date.

Question 13

Sally wants to write a formula to send an email 10 days from the close date, which of the following would accomplish this?

A. Today() - TargetCloseDate =10
B. TargetCloseDate - Today() =10
C. Today() - TargetCloseDate >=10
D. TargetCloseDate - Today() >=10

Answer 13

B

Since the Target close date is in the future we will subtract that from today’s date and when that value equals 10, send the email.

Always subtract the greater number from the Lesser number