2
Gainsight Admin Exam with precise detailed solutions || || || || || ||
all objects are displayed on.... - correct answer✔✔data management page
|| || || || || || || || ||
an object is like a ... - correct answer✔✔database table and columns
|| || || || || || || || || || ||
object fields character limit - correct answer✔✔250 characters
|| || || || || || ||
3 types of objects - correct answer✔✔standard objects, custom objects, system objects
|| || || || || || || || || || ||
multi select dropdown is used when a user wants to store.... - correct answer✔✔multiple
|| || || || || || || || || || || || || ||
values for one record || || ||
object activity log allows you to see... - correct answer✔✔all changes made to an object
|| || || || || || || || || || || || || ||
dependencies are when objects are.... - correct answer✔✔referenced in a different part of
|| || || || || || || || || || || || ||
the application
||
with what types of data can you build a calculated field? - correct answer✔✔string
|| || || || || || || || || || || || ||
date
number
make sure data type of the custom field is the same as the return type of the formula
|| || || || || || || || || || || || || || || || || ||
function.
,2
string functions: substring - correct answer✔✔lets you extract part of the original string.
|| || || || || || || || || || || || ||
provide character position for where to start.
|| || || || || ||
string functions: length - correct answer✔✔returns number of characters in string,
|| || || || || || || || || || ||
including blank spaces & special characters|| || || || ||
string functions: to lowercase/to uppercase - correct answer✔✔returns string with all
|| || || || || || || || || || ||
characters converted to lowercase or uppercase || || || || ||
string functions: string position - correct answer✔✔returns position of first character of
|| || || || || || || || || || || ||
substring in main string || || ||
string functions: left string/right string - correct 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? - correct answer✔✔adds two strings together, provide
|| || || || || || || || || || || ||
delimeter between two (comma, hypen or space)
|| || || || || ||
10 arguments are allowed
|| || ||
date functions: date diff - correct 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? - correct answer✔✔adds/subtracts # of days, weeks, months, or quarters to
|| || || || || || || || || || || || ||
given date. provide: date, #, interval for number (day, quarter, month, week)
|| || || || || || || || || || ||
,2
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✔✔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✔✔accepts date and returns date on
|| || || || || || || || || || || || || ||
which the quarter ended (last date of quarter)
|| || || || || || ||
date functions: Month Num - correct answer✔✔returns number of month to which date
|| || || || || || || || || || || || ||
belongs (april = 4) || || ||
date functions: Month Name - correct answer✔✔returns name of the month for a given
|| || || || || || || || || || || || || ||
date. can selected format. April, Apr etc
|| || || || || ||
date functions: Week Num - correct answer✔✔returns number of week in year for a given
|| || || || || || || || || || || || || || ||
date.
date functions: Week in Month - correct answer✔✔returns number of week in a month for
|| || || || || || || || || || || || || || ||
a given date
|| ||
date functions: Year Num - correct answer✔✔returns the year to which a date belongs
|| || || || || || || || || || || || ||
date functions: Day Of - correct answer✔✔returns day of the week for a certain date
|| || || || || || || || || || || || || ||
, 2
date functions: First or Last Day Of Month/Quarter/Year - correct answer✔✔returns date
|| || || || || || || || || || || ||
on which month/quarter/year began or ended for a certain date
|| || || || || || || || ||
object graphs show.... - correct answer✔✔joins between two objects. pictorial representation
|| || || || || || || || || ||
of what would happen if a record is deleted.
|| || || || || || || || ||
4 data store types in MDA - correct answer✔✔AWS Redshift, MongoDB, Postgres, Redis
|| || || || || || || || || || || ||
What is stored in AWS Redshift - correct answer✔✔primary bulk data store, holds all actual
|| || || || || || || || || || || || || ||
data valued stored in MDA
|| || || || ||
What is stored in MongoDB - correct answer✔✔stores scheme/metadata for tables in
|| || || || || || || || || || || ||
Redshift
what is stored in postgres - correct answer✔✔transactional type data - used in scorecards,
|| || || || || || || || || || || || || ||
programs
what is stored in redis - correct answer✔✔cache session data
|| || || || || || || || ||
mda joins can be done on what types of object combinations? - correct answer✔✔2
|| || || || || || || || || || || || || ||
standard, 2 custom, standard to custom and vice versa || || || || || || || ||
what does a join accomplish? - correct answer✔✔allows you to join data from 2 objects to
|| || || || || || || || || || || || || || || ||
generate reports or create rules on these objects || || || || || || ||
what 3 conditions must be applied to create a join? - correct answer✔✔1) in data
|| || || || || || || || || || || || || || ||
management page, objects should have "joins allowed" as true || || || || || || || ||
Gainsight Admin Exam with precise detailed solutions || || || || || ||
all objects are displayed on.... - correct answer✔✔data management page
|| || || || || || || || ||
an object is like a ... - correct answer✔✔database table and columns
|| || || || || || || || || || ||
object fields character limit - correct answer✔✔250 characters
|| || || || || || ||
3 types of objects - correct answer✔✔standard objects, custom objects, system objects
|| || || || || || || || || || ||
multi select dropdown is used when a user wants to store.... - correct answer✔✔multiple
|| || || || || || || || || || || || || ||
values for one record || || ||
object activity log allows you to see... - correct answer✔✔all changes made to an object
|| || || || || || || || || || || || || ||
dependencies are when objects are.... - correct answer✔✔referenced in a different part of
|| || || || || || || || || || || || ||
the application
||
with what types of data can you build a calculated field? - correct answer✔✔string
|| || || || || || || || || || || || ||
date
number
make sure data type of the custom field is the same as the return type of the formula
|| || || || || || || || || || || || || || || || || ||
function.
,2
string functions: substring - correct answer✔✔lets you extract part of the original string.
|| || || || || || || || || || || || ||
provide character position for where to start.
|| || || || || ||
string functions: length - correct answer✔✔returns number of characters in string,
|| || || || || || || || || || ||
including blank spaces & special characters|| || || || ||
string functions: to lowercase/to uppercase - correct answer✔✔returns string with all
|| || || || || || || || || || ||
characters converted to lowercase or uppercase || || || || ||
string functions: string position - correct answer✔✔returns position of first character of
|| || || || || || || || || || || ||
substring in main string || || ||
string functions: left string/right string - correct 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? - correct answer✔✔adds two strings together, provide
|| || || || || || || || || || || ||
delimeter between two (comma, hypen or space)
|| || || || || ||
10 arguments are allowed
|| || ||
date functions: date diff - correct 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? - correct answer✔✔adds/subtracts # of days, weeks, months, or quarters to
|| || || || || || || || || || || || ||
given date. provide: date, #, interval for number (day, quarter, month, week)
|| || || || || || || || || || ||
,2
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✔✔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✔✔accepts date and returns date on
|| || || || || || || || || || || || || ||
which the quarter ended (last date of quarter)
|| || || || || || ||
date functions: Month Num - correct answer✔✔returns number of month to which date
|| || || || || || || || || || || || ||
belongs (april = 4) || || ||
date functions: Month Name - correct answer✔✔returns name of the month for a given
|| || || || || || || || || || || || || ||
date. can selected format. April, Apr etc
|| || || || || ||
date functions: Week Num - correct answer✔✔returns number of week in year for a given
|| || || || || || || || || || || || || || ||
date.
date functions: Week in Month - correct answer✔✔returns number of week in a month for
|| || || || || || || || || || || || || || ||
a given date
|| ||
date functions: Year Num - correct answer✔✔returns the year to which a date belongs
|| || || || || || || || || || || || ||
date functions: Day Of - correct answer✔✔returns day of the week for a certain date
|| || || || || || || || || || || || || ||
, 2
date functions: First or Last Day Of Month/Quarter/Year - correct answer✔✔returns date
|| || || || || || || || || || || ||
on which month/quarter/year began or ended for a certain date
|| || || || || || || || ||
object graphs show.... - correct answer✔✔joins between two objects. pictorial representation
|| || || || || || || || || ||
of what would happen if a record is deleted.
|| || || || || || || || ||
4 data store types in MDA - correct answer✔✔AWS Redshift, MongoDB, Postgres, Redis
|| || || || || || || || || || || ||
What is stored in AWS Redshift - correct answer✔✔primary bulk data store, holds all actual
|| || || || || || || || || || || || || ||
data valued stored in MDA
|| || || || ||
What is stored in MongoDB - correct answer✔✔stores scheme/metadata for tables in
|| || || || || || || || || || || ||
Redshift
what is stored in postgres - correct answer✔✔transactional type data - used in scorecards,
|| || || || || || || || || || || || || ||
programs
what is stored in redis - correct answer✔✔cache session data
|| || || || || || || || ||
mda joins can be done on what types of object combinations? - correct answer✔✔2
|| || || || || || || || || || || || || ||
standard, 2 custom, standard to custom and vice versa || || || || || || || ||
what does a join accomplish? - correct answer✔✔allows you to join data from 2 objects to
|| || || || || || || || || || || || || || || ||
generate reports or create rules on these objects || || || || || || ||
what 3 conditions must be applied to create a join? - correct answer✔✔1) in data
|| || || || || || || || || || || || || || ||
management page, objects should have "joins allowed" as true || || || || || || || ||
