Gainsight Admin Exam Questions and Correct Answers

Gainsight Admin Exam Questions and Correct Answers 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 to create a join? - Answer-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 when you apply lookup relation, what is the default? - Answer-LEFT OUTER JOIN, performed on base collection (whichever one is selected at data source)