Gainsight Admin Exam Study Guide 2026 - A+ Rated Study Resource

Gainsight Admin Exam Study Guide 2026 - A+ Rated Study Resource all objects are displayed on.... - answer - data management page 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 date functions: Year Num - answer - returns the year to which a date belongs date functions: Day Of - answer - returns day of the week for a certain date date functions: First or Last Day Of Month/Quarter/Year - answer - returns date on which month/quarter/year began or ended for a certain date object graphs show.... - answer - joins between two objects. pictorial representation of what would happen if a record is deleted. 4 data store types in MDA - answer - AWS Redshift, MongoDB, Postgres, Redis What is stored in AWS Redshift - answer - primary bulk data store, holds all actual data valued stored in MDA What is stored in MongoDB - answer - stores scheme/metadata for tables in Redshift what is stored in postgres - answer - transactional type data - used in scorecards, programs what is stored in redis - answer - cache session data mda joins can be done on what types of object combinations? - answer - 2 standard, 2 custom, standard to custom and vice versa what does a join accomplish? - answer - allows you to join data from 2 objects to generate reports or create rules on these objects what 3 conditions must be applied