GAINSIGHT ADMIN EXAM WITH GUARANTEED ACCURATE ANSWERS |VERIFIED
12 views 0 purchase
Course
GAINSIGHT ADMIN
Institution
GAINSIGHT ADMIN
GAINSIGHT ADMIN EXAM
GAINSIGHT ADMIN EXAM WITH GUARANTEED ACCURATE ANSWERS |VERIFIED
All objects are displayed on.... - accurate answers data management page
An object is like a ... - accurate answers database table and columns
Object fields character limit - accurate answers 250 char...
GAINSIGHT ADMIN EXAM
GAINSIGHT ADMIN EXAM WITH GUARANTEED ACCURATE ANSWERS |VERIFIED
All objects are displayed on.... - accurate answers✔✔ data management page
An object is like a ... - accurate answers✔✔ database table and columns
Object fields character limit - accurate answers✔✔ 250 characters
3 types of objects - accurate answers✔✔ standard objects, custom objects, system
objects
Multi select dropdown is used when a user wants to store.... - accurate answers✔✔
multiple values for one record
Object activity log allows you to see... - accurate answers✔✔ all changes made to
an object
,Dependencies are when objects are.... - accurate answers✔✔ referenced in a
different part of the application
With what types of data can you build a calculated field? - accurate answers✔✔
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 - accurate answers✔✔ lets you extract part of the
original string. Provide character position for where to start.
String functions: length - accurate answers✔✔ returns number of characters in
string, including blank spaces & special characters
String functions: to lowercase/to uppercase - accurate answers✔✔ returns string
with all characters converted to lowercase or uppercase
String functions: string position - accurate answers✔✔ returns position of first
character of substring in main string
String functions: left string/right string - accurate answers✔✔ 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? - accurate answers✔✔ adds two strings
together, provide delimeter between two (comma, hypen or space)
10 arguments are allowed
Date functions: date diff - accurate answers✔✔ 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? - accurate answers✔✔ 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 - accurate answers✔✔ 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 - accurate answers✔✔ accepts date and returns
date on which the quarter ended (last date of quarter)
Date functions: month num - accurate answers✔✔ returns number of month to
which date belongs (april = 4)
, Date functions: month name - accurate answers✔✔ returns name of the month for
a given date. Can selected format. April, apr etc
Date functions: week num - accurate answers✔✔ returns number of week in year
for a given date.
Date functions: week in month - accurate answers✔✔ returns number of week in a
month for a given date
Date functions: year num - accurate answers✔✔ returns the year to which a date
belongs
Date functions: day of - accurate answers✔✔ returns day of the week for a certain
date
Date functions: first or last day of month/quarter/year - accurate answers✔✔
returns date on which month/quarter/year began or ended for a certain date
Object graphs show.... - accurate answers✔✔ joins between two objects. Pictorial
representation of what would happen if a record is deleted.
4 data store types in mda - accurate answers✔✔ aws redshift, mongodb, postgres,
redis
What is stored in aws redshift - accurate answers✔✔ primary bulk data store,
holds all actual data valued stored in mda
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 GRADEUNITS. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.99. You're not tied to anything after your purchase.
