Platform Dev 1 Flashcards
The fundamental technology that clouds use to share IT resources cost-efficiently and securely?
Multi-tenancy
Resources shared by Salesforce Tenants include:
Database and run time engine
Database includes:
Data, Metadata, Indexes, Field Histories, Data Relationships
Unique Identifier
helps Salesforce identify which data belongs to that org
What is related to a governor limit
Run Time Engine
Exceeding a governor limit causes
Exceptions
What ensures each tenant can access and allocate a certain amount of resources
Run Time Engine
Governor limits monitors
Memory, CPU usage, access to database, queries
MVC
Model, View, Controller
Model:
An identity representing data or activity
View
Visualization of the sate of the model
Controller
A facility for changing the state of the model. The middle guy gives data to the view and if data gets changed goes back to the model.
Example of a Model
Custom and Standard Objects
Example of a View
Page layouts
Example of a Controller
Apex class
Customization Options
3 ways to attack a problem: Configure, Buy, Build
Configure
Standard and custom solutions from the Setup Menu. (Declarative: Point and Click)
Characteristics of “Configure” model
No programming experience needed, integrated, updates automatically. SIMPLICITY and SPEED
Buy
Download apps and components from AppExchange. (Install: Packages)
Characteristics of the “Buy” model
Proven and reviewed solutions build for SF. May include support and maintenance. ALREADY BUILT.
Build
Develop new solutions using programmatic tools (Programmatic: Code)
Characteristics of “Build” model
Create apps that can do almost anything you want. Custom code builds on point and click functionality. CONTROL AND FLEXIBILITY (hardest and most time consuming)
What are the declarative automation tools?
Process Builder, Workflow, Flow, Approvals
Which automation tool does not support time based actions?
Approvals
Which automation tools support User Interaction?
Flows and Approvals
Which automation tools support time based actions?
Process builder, Workflow, flow
Which automation tools DO NOT support User Interaction?
Process Builder, Workflow
Which automation tools can call Apex code?
Process Builder, Flow
Which automation tools DO NOT call Apex code?
Workflow, Approvals
Which automation tool can delete a record?
Flow
Which automation tools can NOT delete a record
Process Builder, Workflow, Approvals
Standard fields
Provide a predefined set, to capture common business information in Objects
Custom fields
Created to allow the capture of additional business information in Objects
Custom Relationships
Allows you to link objects together
Validation Rules
Created to verify that the data in one or more fields meets the specified criteria before a record is saved on an Object
Verifies that the data in one or more fields meets the specified criteria before a record is saved
Validation Rules
Page Layouts and Record Types
Define what a user sees when they view or edit a record in an object. Control what a user sees on the screen.
How is Security in Salesforce segmented?
Record, field level, object access
Master Detail Relationship: Sharing for the _____ record is inherited from the _____ record
Detail, Master
Master Detail Relationship: The detail record is _______- when the parent is deleted.
automatically deleted
Master Detail Relationship: The ______ is always required on the ______ record
parent reference, child
Master Detail Relationship: You can add a _______
lookup filter
Master Detail Relationship: You can choose whether or not the ______ can be _______
detail, reparanted
The detail side of a master-detail relationship must be a ______ object
custom
Most important difference between a master-detail and lookup relationship has to do with ________
the record access.
Master-Detail relationship: ____________ is inherited from the master record
Record Access
When an object becomes a detail in a master-detail relationship it…
loses the ability to independently control record access
Master Detail relationship: Record access is inherited from _______
master record
_______ CANNOT be the detail of a master-detail relationship
Standard object
Lookup Relationship: Child record and parent record have ________
independent sharing.
Lookup Relationship; The lookup field on the child record can be ______ or ______
optional, required
“What to do if the lookup record is deleted?”
- Clear the value of the field
- Don’t allow deletion of the lookup record that’s part of a lookup relationship
- Delete this record also.
Lookup relationship: Record access is not inherited from _____________
the parent
Lookup Relationship: You can add a __________
lookup filter
The _______ allows you to view and modify relationships
Schema Builder
You can load data through:
Data Import Wizard and API/Data Loader
Which tools use API Connect
- Data Loader
- Data Loader.io
- Any tool that uses API
Which tool can you use to prevent duplicates when importing new records with unique fields only?
Data Loader
Which tool can you use to prevent duplicates with external unique IDs?
Data Import Wizard
Which import tool allows you to choose whether or not to trigger workflow rules?
Data Import Wizard
Which import tool can not trigger workflow rules?
Data Loader
Which tool allows you to load up to 5,000,000 records
Data Loader
Which tool allows you to load objects such as Products and Opportunities?
Data Loader
Which objects can you load with Data Import Wizard
- Account (Name and Site)
- Contact (Name or Email)
- Lead (Name or Email)
- Solution (Title/ID)
- Campaign Member (ID)
- Custom Objects (Name)
- Salesforce ID
- External Unique ID
Which import tool allows you to prevent workflows from firing?
Data Import Wizard
Which tool allows you to schedule imports?
Data Loader
Which tool allows you to use mappings for later use?
Data Loader
Which tool allows you to export or delete data
Data Loader
A formula field is a ______.
Field that derives its value from other fields, expressions or values
You can create a ________ on a child object to reference data from parent objects, up to 10 relationships away
cross-object formula
You can create a cross-object formula on a ______ to reference data from _______ , up to 10 relationships away
child object
parent objects
You can create a cross-object formula on a child object to reference data from parent objects, up to _______ away
10 relationships
A formula field allows you to __________
write an expression to calculate a value. (From Course to Course Delivery)
Formulas can reference _______
other formulas
You may not create ______ formulas
circular
Formulas have a maximum compile size of
3900 characters
Formulas are calculated when ______-
the record is accessed
Formula values are not _______
persisted in the database
Be careful when using in _______ clauses or report filters
SOQL WHERE
Be careful when using in SQL WHERE _______ or ________
Clauses
Report filters
Formulas are calculated in _________-
System Mode
When using formula fields, users DO NOT need access to the ___________ to see the result
individual formula elements (objects or fields)
User that is viewing formula field, _____ data for a field that they do not have access to.
may see
Roll-up Summary Field is a _______
Field on a master record that summarizes date or numerical data from detail records
Field on a master record that summarizes date or numerical data from detail records
Roll-up summary field
For a Roll-up Summary Field you start by _______
selecting the detail object to summarize
What are the roll-up summary field “types”?
COUNT
SUM
MIN
MAX
Roll up summary field: Which records can be included in the calculation?
- All records
* Only records meeting certain criteria
What field type would you use to summarize date or number data?
Roll-up summary field
3 relationships for roll-up summary field?
- Accounts and Opportunities
- Campaigns and Campaign Members
- Opportunities to Product
Roll-up summary fields are calculated and saved when ________
the detail record is saved (assuming the value changes)
Rollup summary field values, when saved, are persisted in _______
the database
Rollup summary fields, when saved will ________
trigger any automation on the parent record
Rollup summary fields are calculated in _______
System Mode
User ____________ need access to the aggregated numerical or date fields of a Roll up summary
does NOT
Rollup summary field: If detail is updated and makes a change, then the master will be updated and ______________________
perform DML updates on the parent (firing the triggers).
Apex is
SF’s cloud-based, object-oriented programming language.
Apex is specifically designed for ______________
customizing and extending apps on the SF platform
Apex is tailored for _____________
data access and manipulation
Apex works in conjunction with _____________
declarative features
Apex has access to ____________
your org’s metadata
Apex is designed to work _____________ in a multi-tenant environment
effectively and efficiently
Apex is compiled and executed in _____________
salesforce servers
Apex allows you to _______________ data
read, write and delete
When you complete a DML update, your workflows will fire _____________ declarative features
in conjunction with
With Apex code you can access __________
custom objects and fields
The SF platform tracks dependencies between _____ used in Apex and _________
- sObjects
* declarative object definitions
Any metadata referred to in Apex _____________
cannot be changed or deleted
You cannot import anything with _________
Apex
Name the 11 primitive data types
- Blob
- Bloolean
- Date
- Datetime
- Decimal
- Double
- ID
- Integer
- Long
- String
- Time
Apex initializes all variables, regardless of type to, to the special value
null
Constants are declared using the __________ modifiers
static + final
Data is stored in _______ called _______
variables
Data Types
Primitives can contain a ____________
single value
Single values (primitives) can have ___________
methods
If you create a String, the default value will be _________
NULL
Apex has 3 possible values
- True
- False
- Null
List
An ordered, indexed collection of elements
An ordered, indexed collection of elements
List
Order of a List
0, 1, 2 etc
Set
An unordered collection of elements that does not contain duplicates
An unordered collection of elements that does not contain duplicates
Set
Map
Collection of key value pairs where each unique key maps to a single value
Collection of key value pairs where each unique key maps to a single value
Map
4 features of a Set
- Unordered
- No duplicate values
- Can add multiple (unique) values
- Asks if it contains a particular value
Name the 8 Conditionals and Loops
- If
- If-else
- Switch
- While
- Do-while
- For (traditional)
- For (list or set iteration)
- For (iterate over SOQL result)
What is SOQL
Salesforce Object Query Language
SOQL allows developers to _______
- Retrieve data
* Integrate data
SOQL allows developers to retrieve data, using user defined selection criteria, from __________ that reside in the SF database
sObjects
SOQL allows developers to integrate data retrieval into _________________ and ____________
Apex
APIs
SOQL only supports ____________
query statements
SOQL does not support __________
SELECT *
SOQL supports “________” which are written using ________ syntax
relationship queries
parent-child
SOQL supports __________ syntax to traverse object relationships
dot notation
SOQL is multi-tenant aware therefore it is _________
governed by limits
SOQL does not support ______ relationships like SQL
ad hoc
SOQL select syntax
- SELECT
- FROM
- WHERE
Which special character does SOQL not support
*
WHERE Clause operator for: Not equals
!=
WHERE Clause operator for: Greater than or equal to
> =
WHERE Clause operator for: LIKE
%
_
WHERE Clause operator for: IN / NOT IN
Inclusion/Exclusion
WHERE Clause operator for: INCLUDES / EXCLUDES
Inclusion and exclusion for multi-select picklists
WHERE Clause operator for:
AND
OR
Logical AND
Logical OR
WHERE Clause operator for: NOT
Negation
WHERE CLAUSE: Date values should not be enclosed in ________
Quotes
“”
WHERE CLAUSE:
YYYY-MM-DD
DateTime fields in Apex are coordinated in -______
Coordinated Universal Time (UTC)
Make sure to offset values to your local time zone.
Variable dates (date literal) formula
WHERE ClosedDate ! = LAST_N_DAYS:365
Boolean value for WHERE closed clause
WHERE IsClosed = TRUE
SOQL supports the binding operator in the _________ clauses
WHERE and LIMIT
Which variables can be bound in the WHERE clause
:myVar
Expressions, example (aStatus + accountName)
Which special character specifies binding?
:
If you cannot guarantee that a single sObject is returned EACH time the query is run, you should _____
assign the query to an sObject list
You can assign the results of a query to ________
a single sObject
SQL Queries in Apex related to an sObject require_________
you to ensure only one single sObject can be returned. No rows and/or more than 1 row requires assignment to an “sObject list”
How do you write an sObject List?
List
example: List
How are queries within an outer loop retrieve 403 cases?
First 200 cases in the first iteration of the outer loop
Next 200 cases in the second iteration of outer loop
Final 3 cases in third iteration of outer loop
How would a query outside of a loop retrieve 403 cases?
All at once, exceeding the heap size limit
A _____________ can help prevent you from exceeding the heap size limit when working with large volumes of data fetched by a query.
list iteration variable
A list iteration variable can help prevent you from exceeding the __________ when working with large volumes of data fetched by a query.
heap size limit
A list iteration variable can help prevent you from exceeding the heap size limit when working with large volumes of data fetched by a ________.
query
How to identify a Standard relationship Syntax? Example Account-Contact
AccountId
How to identify a Custom relationship Syntax?
FieldName_ _c
_____ relationships are created by Salesforce
Standard
_______ relationships are created by user
Custom
Which type of relationship would you use for a Parent (one) to Child (many) relationship?
Custom
In a custom relationship the Primary Key is the _______
Unique field Id
In a custom relationship the Primary Key will be the _______
Parent ID
In a Standard Relationship the Child key is called the _____ and the parent key is called _____
Foreign Key
Primary Key
In a Standard Relationship the Primary Key is followed with _____
Id
In a Standard Relationship the Primary Key will contain a string of ___________ characters
15-18
In a standard relationship the Child key is called
Foreign Key
In a standard relationship the Parent key is called the
Primary Key
You can access _______ of ancestors from a child using dot notation
5
Apex can go up _______ levels on Standard or Custom relationships
5
How many levels of nested queries are allowed in a SELECT clause?
1
Apex can go down _____ level(s) on Standard or Custom relationships?
1
Only one level of nested queries is allowed in a ________ clause
SELECT
Custom relationships can use _______ when referencing parent-to-child relationships (example:level down)
Plural names
Example: Course_Delivery to Course_Deliveries
SOSL stands for:
Salesforce Object Search Language (think of it like a search tool like Google)
SOSL ( Salesforce Object Search Language) allows developers to search ____________ in multiple objects simultaneously.
text, email, and phone fields
SOSL ( Salesforce Object Search Language) allows developers to search text, email, and phone fields in _________________.
multiple objects simultaneously
When referring to SOSL “ALL FIELDS” refers to:
text, email and phone fields ONLY!!!
How do you write a list of list object to hold search results? (Think SOSL)
List>
How would you write an SOSL statement to find the word Acme?
FIND ‘Acme’
What is the ONLY return data type that SOSL provides?
a List of Lists of sObjects
You can execute SOSL searches inside:
APIs
Apex statements
Apex statements within SOSL can use which character
[ Brackets ]
What two Apex statements allow you to execute SOSL searches?
- Bracket notations [ ]
- Search.query ( )
SOQL or SOSL? You want to count the number of records meeting criteria?
SOQL
SOQL or SOSL? You want data from one object or multiple related objects
SOQL
SOQL or SOSL? You don’t know which object or field the data resides in.
SOSL
SOQL or SOSL? You want to sort requests as part of the query?
SOQL and SOSL
SOQL or SOSL? You want data from number, date, or checkbox fields?
SOQL
______ allows you to persist the creation of, or modifications to, an instance of an sObject
DML
What does DML stand for?
Data Manipulation Language
DML allow you to persist the _____ of, or _______ to and instance of an sObject
creation
modifications
Retrieve into memory a Contact whose lead source is ‘Trade Show’ modify its LeadSource to ‘Other.’ Persist this modification to your org.
Update
Create a new instance of a Contact in memory. Persist this instance to your org.
Insert
Name the DML operations
Insert Delete Merge Undelete Update Upsert
Users were incorrectly entered as Contacts through the UI retrieve those contacts into memory, and use their Id values to remove them from the org.
Delete
Create new contacts in memory. Also modifying existing Contacts that were called into memory using SOQL. Issue a single command to persist new and modified Contacts to the org.
Upsert
Actually, the Contacts removed in Scenario 3 were created correctly. Use SOQL to retrieve those Contacts from the Recycle Bin into memory. Then, restore those Contact records.
Undelete
DML Command: Adds one or more records
Insert
DML Command: Removes one or more records
Delete
DML Command: Combines up to three records of the same type into one of the records, deleting the others, and re-parenting any related records
Merge
DML Command: Restores one or more records from the Recycle Bin
Undelete
DML Command: Modifies one or more existing record
Update
Creates new records and updates existing records (single command)
Upsert
Two ways of writing DML Commands
1) Standalone DML Examples: insert Contacts Insert myAccount, Update myAccounts
2) Database.method(sObject List) Example: Database.insert (contacts), Database.Insert (myAccount), Database.update (myAccounts)
How to process Partial Processing
only when the AllorNone parameter is, FALSE
How can you make sure that a failed commit does not cause an exception
Partial processing
Example:
Database.insert (contacts, FALSE)
All Apex execution is bound by ___________ that the system enforces on operations to ensure resources are available for all tenants
governor limits
If you exceed a __________, your code will terminate with an unhandleable, and hence unrecoverable exception
governor limit
If you exceed a governor limit, your code will terminate with an__________, and hence _______ exception
unhandleable
unrecoverable
Governor limits are not _______
CATCHABLE
A _______ and ________ are implicitly fired by change to data
Trigger
Workflow
______ anonymous explicitly invokes _______
Execute
Method
Execute Anonymous ______ invokes Method
explicitly
A trigger and workflow are _____ fired by change to data
implicitly
Never put a DML operation where?
Within or outside a loop
Where should you put a DML operation?
in the middle of two loops
In Apex, a data type of one class can be cast to and from a data type of another class, but only if the _______________
classes are related through inheritance.
Name the Access Modifier keywords: (4)
Private (default)
Public
Protected
Global
A class can contain 0+ (name 4)
member variables
properties
constructors
methods
