MDA is organized into 3 types of objects, what are they? - answer Standard, system, custom
MDA is made up of 4 data store types. They are: - answer AWS Redshift, Mongo DB, Postgres, and Redis
AWS Redshift - answer Primary, holds all actual data values stored in MDA
Mongo DB - answer Stores all schema for tables in Redshift
Postgres - answer Stores transactional data, used in Scorecards 2.0, Programs (JO)
Redis - answer Cache session data
Polyglot persistence technology - answer What the MDA uses to allow it to handle many types of databases used to handle different storage requests
MDA is hosted on a cloud infrastructure. What 5 pieces is that infrastructure made of? - answer Columnar DB, In-memory DB, Elastic File System, Document DB, Graph DB
MDA joins can take place between which two types of objects? - answer Standard and custom, and you link these by creating a lookup. There will be a child and master object.
MDA Joins - what fields can lookup relation be defined on? - answer GSID, string, and email data
type fields What type of join happens by default when applying a lookup relation? - answer Left outer join
How many sun levels of lookups can be created on objects? - answer 2 sub levels only Case Data looks up to Company which looks up to Active User (2 sub levels)
GSID - answer 36 digit unique ID code assigned to every before in every Gainsight object, generated automatically
What are the two types of lookups? - answer Direct and self Direct: lookup to another GS standard object and fetch GSIDs of the records from lookup object
Self: lookup to same standard object and fetch GSID of another record to target field
Data Operations - answer View, edit, or delete existing records in Gainsight
What does the logs tab of Data Operations store? - answer Audit logs which captures all activities performed on los volume custom objects only When you delete records in this section, no way of recovering them.
Mass delete - answer Used to delete records in bulk
Old records (created earlier) are deleted first, then newer records (created more recently) are deleted