Gainsight Admin Certification Exam (2023/ 2024 Update) Questions and Verified Answers| 100% Correct

Gainsight Admin Certification Exam (2023/ 2024 Update) Questions and Verified Answers| 100% Correct Q: object graphs show.... Answer: joins between two objects. pictorial representation of what would happen if a record is deleted. Q: 4 data store types in MDA Answer: AWS Redshift, MongoDB, Postgres, Redis Q: What is stored in AWS Redshift Answer: primary bulk data store, holds all actual data valued stored in MDA Q: What is stored in MongoDB Answer: stores scheme/metadata for tables in Redshift Q: what is stored in postgres Answer: transactional type data - used in scorecards, programs Q: what is stored in redis Answer: cache session data Q: mda joins can be done on what types of object combinations? Answer: 2 standard, 2 custom, standard to custom and vice versa Q: what does a join accomplish? Answer: allows you to join data from 2 objects to generate reports or create rules on these objects Q: 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 Q: when you apply lookup relation, what is the default? Answer: LEFT OUTER JOIN, performed on base collection (whichever one is selected at data source) Q: what is the max number of sublevels for look up relations in reporting? max number of sublevels available when creating in rules engine Answer: 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 Q: what data fields can mda joins be performed on? Answer: GSID, string, email Q: what is a GSID? Answer: 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. Q: what are the two types of lookups? Answer: 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** Q: maximum fields you can match in a lookup Answer: 6 fields Q: what types of data fields can be matched in data import lookup functionality? Answer: company ID, GSID, string, email, dropdown list Q: when ingesting data into target field using data import lookup, what data type must the target field be? Answer: GSID Q: what can you do to company & relationship standard objects on data operations page? Answer: - add, view, edit & delete records - insert or update data