Gainsight Admin UPDATED Actual Exam Questions and CORRECT Answers
3 views 0 purchase
Course
Gainsight admin
Institution
Gainsight Admin
Gainsight Admin UPDATED Actual Exam
Questions and CORRECT Answers
all objects are displayed on.... - CORRECT ANSWER- data management page
an object is like a ... - CORRECT ANSWER- database table and columns
object fields character limit - CORRECT ANSWER- 250 characters
3 types of objects - CO...
Gainsight Admin UPDATED Actual Exam
Questions and CORRECT Answers
all objects are displayed on.... - CORRECT ANSWER✔✔- data management page
an object is like a ... - CORRECT ANSWER✔✔- database table and columns
object fields character limit - CORRECT ANSWER✔✔- 250 characters
3 types of objects - CORRECT ANSWER✔✔- standard objects, custom objects, system
objects
multi select dropdown is used when a user wants to store.... - CORRECT ANSWER✔✔-
multiple values for one record
object activity log allows you to see... - CORRECT ANSWER✔✔- all changes made to an
object
dependencies are when objects are.... - CORRECT ANSWER✔✔- referenced in a different
part of the application
with what types of data can you build a calculated field? - CORRECT 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 - CORRECT ANSWER✔✔- lets you extract part of the original
string. provide character position for where to start.
string functions: length - CORRECT ANSWER✔✔- returns number of characters in string,
including blank spaces & special characters
,string functions: to lowercase/to uppercase - CORRECT ANSWER✔✔- returns string with
all characters converted to lowercase or uppercase
string functions: string position - CORRECT ANSWER✔✔- returns position of first
character of substring in main string
string functions: left string/right string - CORRECT 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? - CORRECT ANSWER✔✔- adds two strings together,
provide delimeter between two (comma, hypen or space)
10 arguments are allowed
date functions: date diff - CORRECT 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? - CORRECT 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 - CORRECT 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 - CORRECT ANSWER✔✔- accepts date and returns
date on which the quarter ended (last date of quarter)
date functions: Month Num - CORRECT ANSWER✔✔- returns number of month to which
date belongs (april = 4)
date functions: Month Name - CORRECT ANSWER✔✔- returns name of the month for a
given date. can selected format. April, Apr etc
date functions: Week Num - CORRECT ANSWER✔✔- returns number of week in year for a
given date.
date functions: Week in Month - CORRECT ANSWER✔✔- returns number of week in a
month for a given date
date functions: Year Num - CORRECT ANSWER✔✔- returns the year to which a date
belongs
date functions: Day Of - CORRECT ANSWER✔✔- returns day of the week for a certain date
date functions: First or Last Day Of Month/Quarter/Year - CORRECT ANSWER✔✔- returns
date on which month/quarter/year began or ended for a certain date
object graphs show.... - CORRECT ANSWER✔✔- joins between two objects. pictorial
representation of what would happen if a record is deleted.
4 data store types in MDA - CORRECT ANSWER✔✔- AWS Redshift, MongoDB, Postgres,
Redis
What is stored in AWS Redshift - CORRECT ANSWER✔✔- primary bulk data store, holds
all actual data valued stored in MDA
, What is stored in MongoDB - CORRECT ANSWER✔✔- stores scheme/metadata for tables
in Redshift
what is stored in postgres - CORRECT ANSWER✔✔- transactional type data - used in
scorecards, programs
what is stored in redis - CORRECT ANSWER✔✔- cache session data
mda joins can be done on what types of object combinations? - CORRECT ANSWER✔✔- 2
standard, 2 custom, standard to custom and vice versa
what does a join accomplish? - CORRECT 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? - CORRECT 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? - CORRECT ANSWER✔✔- LEFT
OUTER JOIN, performed on base collection (whichever one is selected at data source)
what is the max number of sublevels for look up relations in reporting?
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller MGRADES. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
