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