1
GAINSIGHT ADMIN EXAM QUESTIONS AND
CORRECT ANSWERS 2025 GRADED A+.
all objects are displayed on.... - (answers)data management page
an object is like a ... - (answers)database table and columns
object fields character limit - (answers)250 characters
3 types of objects - (answers)standard objects, custom objects, system objects
multi select dropdown is used when a user wants to store.... - (answers)multiple
values for one record
object activity log allows you to see... - (answers)all changes made to an object
dependencies are when objects are.... - (answers)referenced in a different part of
the application
with what types of data can you build a calculated field? - (answers)string
date
number
, 2
make sure data type of the custom field is the same as the return type of the
formula function.
string functions: substring - (answers)lets you extract part of the original string.
provide character position for where to start.
string functions: length - (answers)returns number of characters in string,
including blank spaces & special characters
string functions: to lowercase/to uppercase - (answers)returns string with all
characters converted to lowercase or uppercase
string functions: string position - (answers)returns position of first character of
substring in main string
string functions: left string/right string - (answers)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? - (answers)adds two strings together, provide
delimeter between two (comma, hypen or space)
10 arguments are allowed
, 3
date functions: date diff - (answers)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? - (answers)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 - (answers)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 - (answers)accepts date and returns date on
which the quarter ended (last date of quarter)
date functions: Month Num - (answers)returns number of month to which date
belongs (april = 4)
date functions: Month Name - (answers)returns name of the month for a given
date. can selected format. April, Apr etc
, 4
date functions: Week Num - (answers)returns number of week in year for a given
date.
date functions: Week in Month - (answers)returns number of week in a month for
a given date
date functions: Year Num - (answers)returns the year to which a date belongs
date functions: Day Of - (answers)returns day of the week for a certain date
date functions: First or Last Day Of Month/Quarter/Year - (answers)returns date
on which month/quarter/year began or ended for a certain date
object graphs show.... - (answers)joins between two objects. pictorial
representation of what would happen if a record is deleted.
4 data store types in MDA - (answers)AWS Redshift, MongoDB, Postgres, Redis
What is stored in AWS Redshift - (answers)primary bulk data store, holds all actual
data valued stored in MDA
What is stored in MongoDB - (answers)stores scheme/metadata for tables in
Redshift
GAINSIGHT ADMIN EXAM QUESTIONS AND
CORRECT ANSWERS 2025 GRADED A+.
all objects are displayed on.... - (answers)data management page
an object is like a ... - (answers)database table and columns
object fields character limit - (answers)250 characters
3 types of objects - (answers)standard objects, custom objects, system objects
multi select dropdown is used when a user wants to store.... - (answers)multiple
values for one record
object activity log allows you to see... - (answers)all changes made to an object
dependencies are when objects are.... - (answers)referenced in a different part of
the application
with what types of data can you build a calculated field? - (answers)string
date
number
, 2
make sure data type of the custom field is the same as the return type of the
formula function.
string functions: substring - (answers)lets you extract part of the original string.
provide character position for where to start.
string functions: length - (answers)returns number of characters in string,
including blank spaces & special characters
string functions: to lowercase/to uppercase - (answers)returns string with all
characters converted to lowercase or uppercase
string functions: string position - (answers)returns position of first character of
substring in main string
string functions: left string/right string - (answers)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? - (answers)adds two strings together, provide
delimeter between two (comma, hypen or space)
10 arguments are allowed
, 3
date functions: date diff - (answers)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? - (answers)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 - (answers)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 - (answers)accepts date and returns date on
which the quarter ended (last date of quarter)
date functions: Month Num - (answers)returns number of month to which date
belongs (april = 4)
date functions: Month Name - (answers)returns name of the month for a given
date. can selected format. April, Apr etc
, 4
date functions: Week Num - (answers)returns number of week in year for a given
date.
date functions: Week in Month - (answers)returns number of week in a month for
a given date
date functions: Year Num - (answers)returns the year to which a date belongs
date functions: Day Of - (answers)returns day of the week for a certain date
date functions: First or Last Day Of Month/Quarter/Year - (answers)returns date
on which month/quarter/year began or ended for a certain date
object graphs show.... - (answers)joins between two objects. pictorial
representation of what would happen if a record is deleted.
4 data store types in MDA - (answers)AWS Redshift, MongoDB, Postgres, Redis
What is stored in AWS Redshift - (answers)primary bulk data store, holds all actual
data valued stored in MDA
What is stored in MongoDB - (answers)stores scheme/metadata for tables in
Redshift
