GAINSIGHT ADMIN EXAM QUESTIONS AND CORRECT ANSWERS 2024 GRADED A+. 2 / 35 1. all objects are displayed on....: data management page 2. an object is like a ...: database table and columns 3. object fields character limit: 250 characters 4. 3 types of objects: standard objects, custom objects, system...
GAINSIGHT ADMIN EXAM QUESTIONS AND
CORRECT ANSWERS 2024 GRADED A+
,GAINSIGHT ADMIN EXAM QUESTIONS AND
CORRECT ANSWERS 2024 GRADED A+
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
,GAINSIGHT ADMIN EXAM QUESTIONS AND
CORRECT ANSWERS 2024 GRADED A+
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)
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
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 MasterGrade. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $19.48. You're not tied to anything after your purchase.
