GAINSIGHT ADMIN CERTIFICATE
UPDATED EXAM QUESTIONS AND
CORRECT ANSWERS
●● an object is like a ...
Answer: database table and columns
●● object fields character limit
Answer: 250 characters
●● 3 types of objects
Answer: standard objects, custom objects, system objects
●● multi select dropdown is used when a user wants to store....
Answer: multiple values for one record
●● object activity log allows you to see...
Answer: all changes made to an object
●● dependencies are when objects are....
Answer: referenced in a different part of the application
,●● with what types of data can you build a calculated field?
Answer: string
date
number
make sure data type of the custom field is the same as the return type of
the formula function.
●● string functions: substring
Answer: lets you extract part of the original string. provide character
position for where to start.
●● string functions: length
Answer: returns number of characters in string, including blank spaces
& special characters
●● string functions: to lowercase/to uppercase
Answer: returns string with all characters converted to lowercase or
uppercase
●● string functions: string position
Answer: returns position of first character of substring in main string
,●● string functions: left string/right string
Answer: extracts substring from main string, must supply # of characters
to be included starting from the left or right
●● string functions: concat.
how many arguments are allowed?
Answer: adds two strings together, provide delimeter between two
(comma, hypen or space)
10 arguments are allowed
●● date functions: date diff
Answer: subtracts one date from another in certain interval. can be days,
months, quarters, weeks, years. negative number result if applicable.
●● date functions: date add/sub
dynamic fields?
Answer: adds/subtracts # of days, weeks, months, or quarters to given
date. provide: date, #, interval for number (day, quarter, month, week)
, accepts dynamic fields. The number of days you add to or subtract from
a date dynamically changes with the value of the selected field.
●● date functions: First Day of Week/Last Day of Week
Answer: accepts date and returns date on which the week started/ended.
monday considered start of week, sunday considered end of week.
●● date functions: Last Day of Quarter
Answer: accepts date and returns date on which the quarter ended (last
date of quarter)
●● date functions: Month Num
Answer: returns number of month to which date belongs (april = 4)
●● date functions: Month Name
Answer: returns name of the month for a given date. can selected format.
April, Apr etc
●● date functions: Week Num
Answer: returns number of week in year for a given date.
●● date functions: Week in Month
Answer: returns number of week in a month for a given date
UPDATED EXAM QUESTIONS AND
CORRECT ANSWERS
●● an object is like a ...
Answer: database table and columns
●● object fields character limit
Answer: 250 characters
●● 3 types of objects
Answer: standard objects, custom objects, system objects
●● multi select dropdown is used when a user wants to store....
Answer: multiple values for one record
●● object activity log allows you to see...
Answer: all changes made to an object
●● dependencies are when objects are....
Answer: referenced in a different part of the application
,●● with what types of data can you build a calculated field?
Answer: string
date
number
make sure data type of the custom field is the same as the return type of
the formula function.
●● string functions: substring
Answer: lets you extract part of the original string. provide character
position for where to start.
●● string functions: length
Answer: returns number of characters in string, including blank spaces
& special characters
●● string functions: to lowercase/to uppercase
Answer: returns string with all characters converted to lowercase or
uppercase
●● string functions: string position
Answer: returns position of first character of substring in main string
,●● string functions: left string/right string
Answer: extracts substring from main string, must supply # of characters
to be included starting from the left or right
●● string functions: concat.
how many arguments are allowed?
Answer: adds two strings together, provide delimeter between two
(comma, hypen or space)
10 arguments are allowed
●● date functions: date diff
Answer: subtracts one date from another in certain interval. can be days,
months, quarters, weeks, years. negative number result if applicable.
●● date functions: date add/sub
dynamic fields?
Answer: adds/subtracts # of days, weeks, months, or quarters to given
date. provide: date, #, interval for number (day, quarter, month, week)
, accepts dynamic fields. The number of days you add to or subtract from
a date dynamically changes with the value of the selected field.
●● date functions: First Day of Week/Last Day of Week
Answer: accepts date and returns date on which the week started/ended.
monday considered start of week, sunday considered end of week.
●● date functions: Last Day of Quarter
Answer: accepts date and returns date on which the quarter ended (last
date of quarter)
●● date functions: Month Num
Answer: returns number of month to which date belongs (april = 4)
●● date functions: Month Name
Answer: returns name of the month for a given date. can selected format.
April, Apr etc
●● date functions: Week Num
Answer: returns number of week in year for a given date.
●● date functions: Week in Month
Answer: returns number of week in a month for a given date
