Salesforce DEV 401 Dump

Change the interviewer’s profile to Read-only for the review object

Remove the delete button from the job application page layout

Use workflow to change the page layout to Read-only

Use a validation rule in conjunction with a roll-up summary field

Create a master-details relationship between Position and Salary; set organization-wide defaults to Public Read-Only for Position and Private for Salary

Create a lookup relationship between Position and Salary; set organization-wide defaults Private for Position and for Salary

Create a lookup relationship between Position and Salary; set organization-wide defaults to Public Read-Only for Position and Private for Salary

Create a master-detail relationship between Position and Salary; set organization-wide defaults Private for Position and for Salary

Controller

Model

View

View and controller

Tabular

Pivot

Summary

Analytic Snapshot

Production and Full Copy Sandbox only

Production and Full Copy Sandbox, and Developer Sandbox

Force.com record IDs are never identical

Production and Developer Sandbox only

Create parallel workflow rules, requiring at least one executive team member to complete their assigned task

Create multiple approval processes, one for each executive team member and utilize parallel submission

Create an approval process with a step for each executive team member, allowing approval steps to be skipped

Create an approval process which utilizes parallel approvers, but does not require unanimous approval

Use multiple Visualforce pages

Use workflow to change the field-level security

Use workflow to change the record type

Use validation rules to expose the field

Text, Number or Formula fields only

Custom field of any type

Text, Email. or Number fields only

Phone number, Email. URL and Text-based fields

A standard object with two master-detail relationships

A standard object with a master-detail relationship

A custom object with a master-detail relationship

A custom object with two master-detail relationships

Record Types

Workflows

Validation Rules

Assignment Rules

using custom auto number field

using custom master-detail field

using custom read only field

using lookup relationship field

Execute the approval process by clicking on the Submit for Approval button on the record’s detail page layout

Create a workflow rule that will evaluate salary amount and trigger the approval process if the salary is greater than 100,000 USD

Create a workflow rule that evaluate salary amount and send a notification to the vice president if the salary is greater than 100,000 USD

Save the record so it will automatically be entered into the approval process

Create a formula field that displays the interview score as a set of radio buttons

Create a visualforce component to display the interview score as a set of radio buttons

Create the Interview Score field with a data type of radio button

Create the interview score field as a picklist, displayed as a radio button on the pane layout

The profile names of the record owners

The created time and date of the records

The Force.com record ID values of the records

The logical names of the records

Customize the search filter fields layout for that object

Enable Advanced Search on the object’s related list

Create a Visualforce page to replace die object detail view

Configure the object’s related list to add a filter

It can import, upsert, update, delete and export data

It can perform matching based on record ID only

It can provide success and error files in .csv format

It can prevent the import of duplicate records

Support processes

Sales processes

Approval processes

Workflow Rule

Use field-level security to make the email address visible to user X but not user Y

Use a sharing rule to make the email address only visible to user X

Use a custom visualforce page to make the email address visible to user X but not user Y

Use page layouts to make the email address visible to user X but not user Y

The dashboard will not be visible to management users

The data model may not support the required reports/ required security controls

The data model may not support the required business logic

The developer will not be able to load application data

Users are only granted read access to data owned by users above them in the role hierarchy

Users are granted access to data accessible by users below them in the role hierarchy

Users are granted access to data accessible to users in the same role in the role hierarchy

Users are only granted access to data owned by users below them in the role hierarchy

Create a validation rule to make actual salary required each time the offer record is saved

Create a field dependency between the salary amount and status of accepted

Create a workflow field update to set the property of the actual salary field to required

Create a validation rule to make sure that the actual salary is not null whenever an offer is accepted

Validation errors

Description

Rule Criteria

Formula

Default landing tab

Data warehouse

Custom tab

Custom object

Parent object records only

Other records of the same object

Both parent and child object records

Child object records only

Create a summary report with a custom summary formula summarizing by A, then B, then C

Create a custom report type that includes A with B with C

Create a matrix report with A and B records as column headings and C records as row headings

Run a report using the standard report type: A with B with C

A validation rule with the VLOOKUP function

A validation rule with the REGEX function

A formula field with the IF function

A formula field with the VALIDATE function

Solution manager profile

System administrator profile

No profile has the permission active by default

Standard user pro file

Create a workflow action to clone the position, assigned to the owner of the position record, that is due 14 days after record creation

Create a validation rule that compares today’s date and the record’s creation date to determine if the difference is greater than 14 days

Create a time-dependant workflow action that sends an email to the recruiter if the position is still open 14 days after record creation

Create a time-dependant workflow action that updates the position status to closed 14 days after record creation

Child records are not deleted

A subset of the child records is deleted

Parent record deletion fails

Child records are deleted

Use custom summary formulas

Use matrix reports

Use conditional highlighting

Use charts

Use the Export Scheduler of the Data Loader’s GUI

Use the Command-line interface of the Data Loader

Use the Data Export service to perform a nightly extract

Use the Schedule Manager of the import wizard

Custom summary formulas

Dashboards

Analytic snapshots

Custom report types

Remove the Delete Access for positions from all user roles

Remove the Delete Permission for positions from all profiles

Set the Organization wide default for positions to Read-Only

Assign the Read-Only profile to all users

Create a roll-up summary field on Object X but that retrieves the value from Y

Create a cross-object formula field on Object X that retrieves the value from Y

Create a text field on Object X and use Apex to populate the value

Create a text field on Object X and use a workflow rule to fill in the value upon the creation of X

Load Accounts, then Contacts, then Users

The order does not matter

Load Contacts, then Accounts, then Users

Load Users, then Accounts, then Contacts

True

False

10

20

25

40

True

False

Read all data

View all data

Modify all data

Administrator permissions

Managed Packages

Unmanaged Packages

You can’t upgrade the Apps once published

Installed Packages

Set the organization wide default for candidates to Edit some fields

Set the organization wide defaults for candidates to Read-Only

Remove the Edit permission on candidate from the interviewer’s profile

Use field-level security to control access to the Address and Birth Date fields

There will be no effect on X

X will inherit the look and feel of the primary master object

ma are limited to the primary relationship

The primary relationship cannot be deleted

Use a sharing rule to make the email address only visible to user X

Use field-level security to make the email address visible to user X but not user Y

Use page layouts to make the email address visible to user X but not user Y

Use a custom Visualforce page to make the email address visible to user X but not user Y

Workflow

Parallel Approvers

Dynamic Approval Routing

Approval Processes

As a user saves a new order (a custom object), the quantity and products on the order are checked against stock (a custom object), then the warehouse that the product will ship from on the order record is populates.

When a user creates a new Time Off Request record ( a custom object) and clicks Submit for Approval

When a user enters a State and Zip Code into custom fields on a Candidate custom object, it must be check custom object to ensure that the Zip Code entered does exist in the State entered

When a user saves a New Hire record (a custom object), an outbound message is automatically sent with information to an external HR system

Enable the setting in the sidebar for each user

Create s new sidebar component

Edit the sidebar component to display Object Y

Add Y’s tab to the user’s displayed tabs

Create a recruiting managers group, set approvals to private and create a sharing exception for recruiting manager

Create a workflow rule whereby only users with the recruiting manager profile are allowed to submit positions for approval

Create a validation rule that check whether a user with the recruiting manager profile is saving the new positions for approval

Create an approval process whereby only users with the recruiting manager role are allowed to submit position

Man-to-many

Master-detail

Parent-child

Hierarchical

2

1

4

3

Create a dependency on the Address field that ensures only valid cities are selected for a given state

Create a Formula field on the address object that looks up the state for the entered city

Create a validation rule that checks the city entered against an object to validate the state for the entered city

Create a Workflow outbound message that sends city and state information to an external global database of known states

It is not possible for a developer to meet this requirement

Use a validation rule to copy the name and email from the candidate record to the job application record

Use a cross-object formula field to display the name and email from the candidate record to the job application record

Use a cross-object assignment rule and field update action to copy the name and email from the candidate record to the job application record

Hierarchical

Self

Master-detail

Many-to-many

Add a dashboard to the position page layout

Add the candidates related list to the Position page layout

Add a look up relationship to the Candidate object

Add an inline Visualforce page on the Position page layout

Locking the record from being edited

Sending an email to the record owner

Sending the record to the recycle bin

Creating a task for the record owner

Chart

Metric

Table

Gauge

Records are locked by default on submission; no action required

Set an action to lock the record upon submission

Create a Workflow field update action to make the page layout Read-only

Develop a sharing rule that sets the record to Read-only

Analytic Snapshot

Field History

Summary Report

Matrix Report

Set the user’s home page layouts to include a dashboard

Create a workflow rule that sends a link to the dashboard in an email

Schedule a dashboard for daily refresh and email distribution

Create a series of daily recurring events providing the dashboard link

Checking if the current user’s profile is System Administrator

Checking if the value in a field has changed

Checking if the record was modified today

Checking if the status of a record is new

When a developer adds the Sharing button to the page layout

When the organization wide default for the object is set to pubic read/write

When a developer grants the users the Share Records permission

When the organization wide defaults for the object is set to private or read-only

Data model may not be support the business logic

Dashboard may not be visible to management users

Developer will not be able to load data

Data model may not support the required reports

Junction object

Parent object

Lookup object

Standard object

An error is reported

Duplicate records will be created with matching external Ids

The upsert operation fails

Only the first matching record will be updated

The record owner, a user shared to the record, any user above the record owner in the role hierarchy administrator profile

The record owner, a user above the record owner in the role hierarchy, and a user with the system

Only the record owner and a user with the System Administrator profile

The record owner, a user with the System Administrator profile, and a user shared to the record

Set the organization wide default for positions to public Read/Write and use a Sharing Rule to rest

Set the organization wide default for positions to public Read/Write and remove user X from the role

Set the organization wide default for positions to public Read-Only and remove user X from the role

Set the organization wide default for positions to public Read-Only and use a Sharing Rule to all users except user X

Workflow rules

Assignment rules

Approval processes

Validation rules

All of the above

Force.com API

Force.com Single Sign-on API

Force.com Metadata API

AJAX toolkit for Force.com

Ability to insert account records setting the IsDeleted field of each record

Ability to insert account records settings the $MarkSync field of each record

Ability to insert account records settings the CreatedDate field of each record

Ability to insert account records settings the SystemModStamp field of each record

The import wizards cannot import data from CSV files

The import wizards do not support the User object

The import wizards do not support custom object

The import wizards do not import files to specify record owner

Child records are not deleted

A subset of the child records is deleted

Child records are deleted

Parent record deletion fails

Tags can be enabled by enabling Tags permission for the Organization

Tags can be accessed from the Sidebar component

Tags can be added on the Records

Tags can be enabled by enabling Tags permission for the Profiles

25%

50%

75%

100%

A cross-object formula field is not available for a Master-Detail relationship

You can create a cross-object formula field on both the parent and child object

You can only create a cross-object formula field on the child object

You can only create a cross-object formula field on the parent object

1

2

4

10

Users

Custom objects

Leads

Accounts and Contacts

Create a custom report type with A, B and C, and use it in the report

Report cannot be created

Create a custom report with A and C fields as relationships already exist

Create lookup relationships between A,B and C

Master-Detail

Many-to-many

Hierarchically

Self

Premium edition

Unlimited edition

Enterprise edition

Developer edition

Summary totals

Custom summary field

Formula field

Roll-up summary field

Visualforce

SQL

SOSL

SOQL

Custom Controller

Controller Extension

Standard Controller

Specific Controller

Formula

E-mail

Lookup

URL

Summary

Matrix

Detailed

Tabular

All child records are deleted

Exception occurs

Parent and child record will not be deleted

Parent record alone gets deleted

5 MB

10 MB

15 MB

There is no such limit

Solution Manager

Contract Manager

Read only

Developer

$User.FirstName

{!User.FirstName}

{User.FirstName}

{!$User.FirstName}

Mini view

Mini page layout

Profile

Page layout

500

800

1000

Unlimited

CreatedDate

IsDeleted

SysModStamp

UpdatedDate

It can only be included in one application

It can be included in as many applications as desired

It can only be included in standard applications

It can only be included in custom applications

Set the users’ home page layouts to include a dashboard

Create a Workflow rule that sends a link to the dashboard in an email

Create a series of daily recurring events providing the dashboard link

Schedule the dashboard for daily refresh and email distribution

Flash

JavaScript

HTML

Java

Many-to-many

Master-detail

Lookup

Master-to-master

VF

apex

<c>

s

The child record is deleted

Nothing

The parent record cannot be deleted

The child record cannot be deleted

1

2

7

3

id field is not mandatory

The field length is customizable

This depends on the version of Salesforce

18

Control the tab access

Set the CRUD permissions

Give access to records by modifying the record types

Control password settings

Formula

Lookup

E-mail

URL

You can only create a cross-object formula field on the parent object

You can only create a cross-object formula field on the child object

You can create a cross-object formula field on both the parent and child object

A cross-object formula field is not available for a Master-Detail relationship

Cross-object formula field

Workflow rule

Validation rule

Assignment rule

Field level security

Remove the field from the page layout

Remove the field from the user profile

Change my display under personal settings

Summary report

Tabular report

Matrix report

A report using Visualforce

Reports

Dashboards

Analytical Snapshot

Mobile Lite

Entitlements

Reports, Dashboards, Documents and Email templates

Reports, Dashboards and Documents

Dashboards, Documents and Email templates

Reports and Dashboards

The data model will support all the requirements of the application, including reports and dashboards

Reports are part of the application and application design will take care of it

No special considerations for reports or dashboards are required as Salesforce can natively take care of the requirements

The data model and the application will not cater for reports and dashboards

Creating the custom object to serve as the junction object between the two master objects

Creating two Master-Detail relationships

Customizing the related lists on the page layouts of the two master objects

Creating two lookup relationships

Many to Many Relationship

One to One Relationship

Master-Detail Relationship

Lookup Relationship

TODAY() – DATEVALUE(CreatedDate)

NOW() – DATEVALUE(CreatedDate)

TODAY() – CreatedDate

CreatedDate – TODAY()

Ability to insert account records setting the CreatedDate field of each record

Ability to insert account records setting theSystemModStamp field of each record

Ability to insert account records setting the isDeleted field of each record

Ability to insert account records setting the $MarkSync field of each record

SQL

Apex

SOSL

SOQL

The location on the storage pod

The serial number in the data center

The Object type

The storage field identifier

Roll-up summary fields are read only

Roll-up summary can be used to compute SUM,MIN,MAX,AVG over a set of records

The results of the roll-up summary is displayed on the child in a master-detail relationship

Roll-up summary can only be set on the parent of a Master-Detail or Lookup relationship

Deleting an object deletes its children

Parent is not a required field and may be omitted

Roll-up summary field can be used to perform basic operations over all children of a parent record

Security access of the child record is dependent upon the parent record

CASE Statement

Beings

IF Statement

Contains