Gainsight Admin Exam || || ||
Questions With Answers || || ||
all objects are displayed on.... - CORRECT
|| || || || || || ||
ANSWER(S)✔✔data management page || ||
an object is like a ... - CORRECT ANSWER(S)✔✔database
|| || || || || || || ||
table and columns
|| || ||
object fields character limit - CORRECT
|| || || || || ||
ANSWER(S)✔✔250 characters ||
3 types of objects - CORRECT ANSWER(S)✔✔standard
|| || || || || || ||
objects, custom objects, system objects
|| || || ||
multi select dropdown is used when a user wants to
|| || || || || || || || || ||
store.... - CORRECT ANSWER(S)✔✔multiple values for
|| || || || || ||
one record ||
object activity log allows you to see... - CORRECT
|| || || || || || || || ||
ANSWER(S)✔✔all changes made to an object || || || || ||
,dependencies are when objects are.... - CORRECT || || || || || || ||
ANSWER(S)✔✔referenced in a different part of the || || || || || || ||
application
with what types of data can you build a calculated field? -
|| || || || || || || || || || ||
CORRECT ANSWER(S)✔✔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 - CORRECT
|| || || || ||
ANSWER(S)✔✔lets you extract part of the original || || || || || || ||
string. provide character position for where to start.
|| || || || || || ||
string functions: length - CORRECT
|| || || || ||
ANSWER(S)✔✔returns number of characters in string, || || || || || ||
including blank spaces & special characters
|| || || || ||
string functions: to lowercase/to uppercase - CORRECT
|| || || || || || ||
ANSWER(S)✔✔returns string with all characters || || || || ||
converted to lowercase or uppercase|| || || ||
,string functions: string position - CORRECT
|| || || || || ||
ANSWER(S)✔✔returns position of first character of || || || || || ||
substring in main string || || ||
string functions: left string/right string - CORRECT
|| || || || || || ||
ANSWER(S)✔✔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? - CORRECT
|| || || || || || ||
ANSWER(S)✔✔adds two strings together, provide || || || || ||
delimeter between two (comma, hypen or space)
|| || || || || ||
10 arguments are allowed
|| || ||
date functions: date diff - CORRECT
|| || || || || ||
ANSWER(S)✔✔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? - CORRECT || || || ||
ANSWER(S)✔✔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 -
|| || || || || || || || || ||
CORRECT ANSWER(S)✔✔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 - CORRECT
|| || || || || || || ||
ANSWER(S)✔✔accepts date and returns date on which || || || || || || ||
the quarter ended (last date of quarter)
|| || || || || ||
date functions: Month Num - CORRECT
|| || || || || ||
ANSWER(S)✔✔returns number of month to which date || || || || || || ||
belongs (april = 4) || || ||
date functions: Month Name - CORRECT
|| || || || || ||
ANSWER(S)✔✔returns name of the month for a given || || || || || || || ||
date. can selected format. April, Apr etc
|| || || || || ||
Questions With Answers || || ||
all objects are displayed on.... - CORRECT
|| || || || || || ||
ANSWER(S)✔✔data management page || ||
an object is like a ... - CORRECT ANSWER(S)✔✔database
|| || || || || || || ||
table and columns
|| || ||
object fields character limit - CORRECT
|| || || || || ||
ANSWER(S)✔✔250 characters ||
3 types of objects - CORRECT ANSWER(S)✔✔standard
|| || || || || || ||
objects, custom objects, system objects
|| || || ||
multi select dropdown is used when a user wants to
|| || || || || || || || || ||
store.... - CORRECT ANSWER(S)✔✔multiple values for
|| || || || || ||
one record ||
object activity log allows you to see... - CORRECT
|| || || || || || || || ||
ANSWER(S)✔✔all changes made to an object || || || || ||
,dependencies are when objects are.... - CORRECT || || || || || || ||
ANSWER(S)✔✔referenced in a different part of the || || || || || || ||
application
with what types of data can you build a calculated field? -
|| || || || || || || || || || ||
CORRECT ANSWER(S)✔✔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 - CORRECT
|| || || || ||
ANSWER(S)✔✔lets you extract part of the original || || || || || || ||
string. provide character position for where to start.
|| || || || || || ||
string functions: length - CORRECT
|| || || || ||
ANSWER(S)✔✔returns number of characters in string, || || || || || ||
including blank spaces & special characters
|| || || || ||
string functions: to lowercase/to uppercase - CORRECT
|| || || || || || ||
ANSWER(S)✔✔returns string with all characters || || || || ||
converted to lowercase or uppercase|| || || ||
,string functions: string position - CORRECT
|| || || || || ||
ANSWER(S)✔✔returns position of first character of || || || || || ||
substring in main string || || ||
string functions: left string/right string - CORRECT
|| || || || || || ||
ANSWER(S)✔✔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? - CORRECT
|| || || || || || ||
ANSWER(S)✔✔adds two strings together, provide || || || || ||
delimeter between two (comma, hypen or space)
|| || || || || ||
10 arguments are allowed
|| || ||
date functions: date diff - CORRECT
|| || || || || ||
ANSWER(S)✔✔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? - CORRECT || || || ||
ANSWER(S)✔✔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 -
|| || || || || || || || || ||
CORRECT ANSWER(S)✔✔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 - CORRECT
|| || || || || || || ||
ANSWER(S)✔✔accepts date and returns date on which || || || || || || ||
the quarter ended (last date of quarter)
|| || || || || ||
date functions: Month Num - CORRECT
|| || || || || ||
ANSWER(S)✔✔returns number of month to which date || || || || || || ||
belongs (april = 4) || || ||
date functions: Month Name - CORRECT
|| || || || || ||
ANSWER(S)✔✔returns name of the month for a given || || || || || || || ||
date. can selected format. April, Apr etc
|| || || || || ||
