Gainsight Admin Exam – UPDATED Questions with 100% Verified
Answers
Gainsight Admin Exam
Study Questions and Answers
Q1 all objects are displayed on....
A data management page
Q2 an object is like a ...
A database table and columns
Q3 object fields character limit
A 250 characters
Q4 3 types of objects
A standard objects, custom objects, system objects
Q5 multi select dropdown is used when a user wants to store....
A multiple values for one record
Q6 object activity log allows you to see...
A all changes made to an object
Q7 dependencies are when objects are....
A referenced in a different part of the application
Q8 with what types of data can you build a calculated field?
A string date number make sure data type of the custom field is the same as the return type of the formula function.
Q9 string functions: substring
A lets you extract part of the original string. provide character position for where to start.
Q10 string functions: length
Gainsight Admin Exam 1
, A returns number of characters in string, including blank spaces & special characters
Q11 string functions: to lowercase/to uppercase
A returns string with all characters converted to lowercase or uppercase
Q12 string functions: string position
A returns position of first character of substring in main string
Q13 string functions: left string/right string
A extracts substring from main string, must supply # of characters to be included starting from the left or right
Q14 string functions: concat. how many arguments are allowed?
A adds two strings together, provide delimeter between two (comma, hypen or space) 10 arguments are allowed
Q15 date functions: date diff
A subtracts one date from another in certain interval. can be days, months, quarters, weeks, years. negative number
result if applicable.
Q16 date functions: date add/sub dynamic fields?
A 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.
Q17 date functions: First Day of Week/Last Day of Week
A accepts date and returns date on which the week started/ended. monday considered start of week, sunday
considered end of week.
Q18 date functions: Last Day of Quarter
A accepts date and returns date on which the quarter ended (last date of quarter)
Q19 date functions: Month Num
A returns number of month to which date belongs (april = 4)
Q20 date functions: Month Name
A returns name of the month for a given date. can selected format. April, Apr etc
Gainsight Admin Exam 2
, Q21 date functions: Week Num
A returns number of week in year for a given date.
Q22 date functions: Week in Month
A returns number of week in a month for a given date
Q23 date functions: Year Num
A returns the year to which a date belongs
Q24 date functions: Day Of
A returns day of the week for a certain date
Q25 date functions: First or Last Day Of Month/Quarter/Year
A returns date on which month/quarter/year began or ended for a certain date
Q26 object graphs show....
A joins between two objects. pictorial representation of what would happen if a record is deleted.
Q27 4 data store types in MDA
A AWS Redshift, MongoDB, Postgres, Redis
Q28 What is stored in AWS Redshift
A primary bulk data store, holds all actual data valued stored in MDA
Q29 What is stored in MongoDB
A stores scheme/metadata for tables in Redshift
Q30 what is stored in postgres
A transactional type data - used in scorecards, programs
Q31 what is stored in redis
A cache session data
Q32 mda joins can be done on what types of object combinations?
Gainsight Admin Exam 3
, A 2 standard, 2 custom, standard to custom and vice versa
Q33 what does a join accomplish?
A allows you to join data from 2 objects to generate reports or create rules on these objects
Q34 what 3 conditions must be applied to create a join?
A 1) in data management page, objects should have "joins allowed" as true 2) lookup relation between objects can
only be defined on GSID, string and email email data type fields 3) must be one field that is an external identifier to
your company data in GS that will allow you to tie together external & GS data
Q35 when you apply lookup relation, what is the default?
A LEFT OUTER JOIN, performed on base collection (whichever one is selected at data source)
Q36 what is the max number of sublevels for look up relations in reporting? max number of sublevels available
when creating in rules engine
A 2. For example, Case Data > Company > Active User, where Case Data has a lookup relation on Company, and
Company has a lookup relation on Active User. You cannot have an Gainsight Object containing lookup relation at
the 3rd sub-level such as Active User cannot have a lookup relation to any other Gainsight object. 3 sublevels
Q37 what data fields can mda joins be performed on?
A GSID, string, email
Q38 what is a GSID?
A 36 digit unique identification code assigned to every record in every Gainsight object. GSIDs are generated
automatically when the corresponding records are inserted into the object.
Q39 what are the two types of lookups?
A 1) direct (when ingesting data, admins lookup to another standard object using common fields, fetch GSIDs from
lookup object) 2) self (lookup to SAME standard object and fetch GSID of another record to target field, used to
create user - manager hierarchies) *make sure self lookup is enabled on target field*
Q40 maximum fields you can in a lookup
A 6 fields
Q41 what types of data fields can be matched in data import lookup functionality?
A company ID, GSID, string, email, dropdown list
Gainsight Admin Exam 4
Answers
Gainsight Admin Exam
Study Questions and Answers
Q1 all objects are displayed on....
A data management page
Q2 an object is like a ...
A database table and columns
Q3 object fields character limit
A 250 characters
Q4 3 types of objects
A standard objects, custom objects, system objects
Q5 multi select dropdown is used when a user wants to store....
A multiple values for one record
Q6 object activity log allows you to see...
A all changes made to an object
Q7 dependencies are when objects are....
A referenced in a different part of the application
Q8 with what types of data can you build a calculated field?
A string date number make sure data type of the custom field is the same as the return type of the formula function.
Q9 string functions: substring
A lets you extract part of the original string. provide character position for where to start.
Q10 string functions: length
Gainsight Admin Exam 1
, A returns number of characters in string, including blank spaces & special characters
Q11 string functions: to lowercase/to uppercase
A returns string with all characters converted to lowercase or uppercase
Q12 string functions: string position
A returns position of first character of substring in main string
Q13 string functions: left string/right string
A extracts substring from main string, must supply # of characters to be included starting from the left or right
Q14 string functions: concat. how many arguments are allowed?
A adds two strings together, provide delimeter between two (comma, hypen or space) 10 arguments are allowed
Q15 date functions: date diff
A subtracts one date from another in certain interval. can be days, months, quarters, weeks, years. negative number
result if applicable.
Q16 date functions: date add/sub dynamic fields?
A 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.
Q17 date functions: First Day of Week/Last Day of Week
A accepts date and returns date on which the week started/ended. monday considered start of week, sunday
considered end of week.
Q18 date functions: Last Day of Quarter
A accepts date and returns date on which the quarter ended (last date of quarter)
Q19 date functions: Month Num
A returns number of month to which date belongs (april = 4)
Q20 date functions: Month Name
A returns name of the month for a given date. can selected format. April, Apr etc
Gainsight Admin Exam 2
, Q21 date functions: Week Num
A returns number of week in year for a given date.
Q22 date functions: Week in Month
A returns number of week in a month for a given date
Q23 date functions: Year Num
A returns the year to which a date belongs
Q24 date functions: Day Of
A returns day of the week for a certain date
Q25 date functions: First or Last Day Of Month/Quarter/Year
A returns date on which month/quarter/year began or ended for a certain date
Q26 object graphs show....
A joins between two objects. pictorial representation of what would happen if a record is deleted.
Q27 4 data store types in MDA
A AWS Redshift, MongoDB, Postgres, Redis
Q28 What is stored in AWS Redshift
A primary bulk data store, holds all actual data valued stored in MDA
Q29 What is stored in MongoDB
A stores scheme/metadata for tables in Redshift
Q30 what is stored in postgres
A transactional type data - used in scorecards, programs
Q31 what is stored in redis
A cache session data
Q32 mda joins can be done on what types of object combinations?
Gainsight Admin Exam 3
, A 2 standard, 2 custom, standard to custom and vice versa
Q33 what does a join accomplish?
A allows you to join data from 2 objects to generate reports or create rules on these objects
Q34 what 3 conditions must be applied to create a join?
A 1) in data management page, objects should have "joins allowed" as true 2) lookup relation between objects can
only be defined on GSID, string and email email data type fields 3) must be one field that is an external identifier to
your company data in GS that will allow you to tie together external & GS data
Q35 when you apply lookup relation, what is the default?
A LEFT OUTER JOIN, performed on base collection (whichever one is selected at data source)
Q36 what is the max number of sublevels for look up relations in reporting? max number of sublevels available
when creating in rules engine
A 2. For example, Case Data > Company > Active User, where Case Data has a lookup relation on Company, and
Company has a lookup relation on Active User. You cannot have an Gainsight Object containing lookup relation at
the 3rd sub-level such as Active User cannot have a lookup relation to any other Gainsight object. 3 sublevels
Q37 what data fields can mda joins be performed on?
A GSID, string, email
Q38 what is a GSID?
A 36 digit unique identification code assigned to every record in every Gainsight object. GSIDs are generated
automatically when the corresponding records are inserted into the object.
Q39 what are the two types of lookups?
A 1) direct (when ingesting data, admins lookup to another standard object using common fields, fetch GSIDs from
lookup object) 2) self (lookup to SAME standard object and fetch GSID of another record to target field, used to
create user - manager hierarchies) *make sure self lookup is enabled on target field*
Q40 maximum fields you can in a lookup
A 6 fields
Q41 what types of data fields can be matched in data import lookup functionality?
A company ID, GSID, string, email, dropdown list
Gainsight Admin Exam 4
