SFDC Dev 401-I

1) Using API Data Loader which of following things are considered ?(choose 2)

* Validiation Rules
* Required fields in sharing settings
* Apex Trigger
* Required fields on Page layout.

3)Object B has lookup field to object A,object C has lookup field to object B,then how to access A records with c in reports.

* using Standard Report types.
* Creating custom Report type.
* creating normal report
* None of above.

4)View Encrypted field is enable for which profile (choose 1)

* Standard user Profile
* System Admin
* Read only
* None of Above

5)External id allowed for which field types.(choose two)

*Text
*Number
*Text Area
*Date

6)Create object Tab, what effects it has on home page Sidebar layout.(choose 2)

*Recent Items
*Search Layout
*Create new
*Tags

7) Which options are related to data Base?(choose 3)

*custom Objects
*Custom Tabs
*Page Layout
*Master-Detail Relationship

*Custom Fields.

8)If Approval Process is modified, how user will know changes has made or not? (choose 2)

*In Debug log
*Set up Audit Trial
*Modified by Field
*one more option

11)If Analytical snapshot is scheduled for a run. Which of following changes will not allow it to run.(choose 2)

* changing target object
* changing source object report to matrix
* creating trigger on source object
* creating Approval process on target object.

 12) User X & user Y should able to see candidate records. But user Y should not able to see Address field. What should be done?

* Set candidate object to R/O & use manual sharing.
* use Fields level security
* using page layout
* one more option

13)Which of things is possible using Import Wizard.
*Import,Export,Update and Delete for all custom objects
*De-Duplication of records
*Schedule Import
*Only Importing Records.

14)Formula Field return types.

15)If object B has lookup field to Object A, then which thing is true about cross object formula?

*Access object A fields, Object B fields on Object A.
*Only Access Object B fields on object B.
*Access Object B fields, Object A fields, User fields on object B.
*None of the Above.

16)Using Data Loader, we want to load Data for Account, Contacts, User. What order we should follow?

*Account, contact,user
*user, contact, Account
*Any order
*User, Account, contact.

17)If we need to update records using Data loader which things are to be considered?

*Name Field
*Records Id’s
*created by,Modified By fields
*Owner Id’s

18)Roll up Summary on formula fields?
*Not Allowed.
*Depends on formula return types .
*All formula fields.

19)On Position Object we have one field department. So we want to see position records group by department. How is it possible?
*using Tabular report
*using Summary Report
*Using Matrix report
*None of above (442)

Salesforce Data Management Questions and Answers

1. Data loader import fails. Select two choices:
a) encrypted field setting
b) username and password is wrong
c) endpoint is wrong
d) Custom Field settings

2. The OWD setting for account is private. A manager resides above a team in the role hierarchy. The manager wants to share some of the account data with the team. Which feature can extend the viewing privileges for team to see other data? Select two choice
a) report running user
b) report folder setting
c) dashboard running user
d) dashboard folder setting

3. Automate data load from SFDC at 2:00 AM. How?
a) Schedule manager of Import Wizard.
b) CLI of Data Loader.
c) Use Export Scheduler of Data Loader GUI.
d) Use Data Export Service

4. Which are true in Import Wizard?
a) It can de-duplicate record
b) Can Import, update, delete and export data.
c) Perform Matching based on record id only
d) It can provide success and error files in csv.

5. When would a developer use upsert and external IDs? Choose two answers.
a) To integrate with an external system
b) To migrate customizations from sandbox to production
c) To load related records without knowing Salesforce record IDs
d) To use the Force.com API to query for data

6. If you have to import 65000 records into your organization then you must use
a) Data Loader
b) Import Wizard
c) Both
d) None

7. Data loader can be run from Command line
a) True
b) False

8. Using Import Wizard can we delete the records?
a) Yes
b) No

9. Will import wizard give you the success and error log file
a) Yes
b) No

10. When you insert a record using API, which are the things need to consider
a) Universally required are respected
b) Validation rules are respected
c) Both
d) None

11. When you are doing an update, CSV file must contain
a) Salesforce Record Id
b) External ID
c) Both
d) None (303)

Salesforce Business Logic Scenario Based Questions and Answers

1. In the Positions object user is entering the city and zip code values, we need to validate the city and zip code values with my custom object. Please select any one option?
a. Validation Rule with VLookup function
b. Validation Rule with Cross-Object Formula
c. Workflow Rule
d. Formula field with VLookup function

2. If the amount is less than 10000USD then no need of any approval or else it has to be approved from VP. How do you achieve this in force.com?
a. By Creating a parallel approval process
b. By Creating a dynamic approval process
c. By Creating Validation Rule
d. Create Approval Process

3. Whenever the job application status is approved then the salary has to be entered, how do you achieve this?
a. Create a validation rule if the status is approved and salary is null
b. Create a formula if the status is approved and salary is null
c. Make Salary Field as Required in Job Application object Page layout
d. Make Salary Field as Required in Salary object Page layout

4. Time-dependent workflow will not work when workflow evaluation criteria is
a. Only when a Record is created
b. Every time a record is created or edited
c. Every kind of workflow evaluation criteria
d. When a Record is edited and it did not previously meet the rule criteria

5. How to test time dependent workflow functionality is properly running or not? Select 2 Answers:
a. Activate History Related List
b. Bug History Related List
c. Debug Log
d. Time Based WF queue

6. In a custom recruiting application, position & candidate are stored in separate custom object. When looking at the detail of position object record, a hiring manager needs to see a list of recommended candidate instead of all candidates, based on matching job skills. How a developer could meet this requirement.

a. Lookup
b. Dashboard
c. candidate related list
d. Inline VF

7. In a recruiting application a custom job application object has a lookup to custom object. These candidate object stores personal candidate information, including name, email about the individual applying for the job. The recruiting organization would like to see the candidate, name and email information on each related job application record. How a developer could meet this requirement.
a. Cross object formula
b. Validation Rule
c. Workflow Rule
d. None

8. In a recruiting application, there is an approval process on position. First manager is supposed to approve, then somebody else has to approve in the next step and finally the VP has to approve. Which features of force.com you would like to use?

a. normal approval process
b. dynamic approval process
c. validation rule
d. WF

9. Interviewer and Job Applications are detail objects of the Master object Position. We want certain set of users NOT to have access to the Interviewer Records which was not created by them. What needs to be done to achieve it?

a. Set all the CRUD access Unchecked for those particular users
b. Set OWD for Interviewer as private
c. Remove those users from the Role Hierarchy
d. None of the above

10. In a workflow based on Job Application, while defining the Rule Criteria, what forces you to choose “formula evaluates to true” option instead of the “criteria are met”?

a. Check if the Job Application Status is equal to “Selected”
b. Check if the status has changed
c. Check if the current User Profile is “System Admin”
d. Check if the status field in the Position is “Open”

11. How can we traverse using formula fields?

a. We can bring values Only from parent to child
b. We can bring values Only from Child to Parent
c. Both
d. None of the above (467)

Salesforce Business Logic Questions

1. Formula field data type cannot be?
a. Radio button
b. Text
c. Date
d. Date/time
e. Currency
f. Number
g. Percent

2. Where will you use the Process Visualizer in Force.com?
a. To view the Approval Process
b. To View the Page Layout
c. To View Field Level Security
d. To View Records

3. How do you find that the Approval Process is edited, select two choices:
a. Last Modified By
b. Audit trail or History Record on Approval page layout
c. Debug Log
d. System Log

4. Which field is available in translation work bench?
a. Error
b. Encrypted Field
c. description
d. Formula

5. There is a custom date field on a particular object. How will you validate the field so that the date you entered belongs to the current year?
a. Using Validation rules
b. Using Formula Fields
c. Using Rollup Summary Fields
d. Dependent Pick lists

6. What does out of the box Salesforce give you?
a. Approval process
b. Workflow Rule
c. Validation Rule
d. Assignment Rule

7. Within an approval process what can be used to configure the list of initial submitter? Select 2 choices:

a. Public group
b. Role and subordinates
c. System Admin
d. Queues

8. Which aspect of an application is addressed in the logic layer? Select two answers,

a. customized UI,
b. extensible data model
c. Data entry validation
d. process automation (214)

1. Which action is not necessary when using the declarative capabilities of the force.com to build custom application? Select 3 choices
a) compile code
b) write SOQL queries
c) configure application server
d) Configure an application using clicks not code

2. Which of these can be done in SFDC application? Select 2 choices
a) internationalize and localize apps
b) run report on configurationally changes done
c) application can be done by click n not code
d) something else

3. What is true regarding a Custom App?
a) They can have a custom logo
b) They can have a separate tab style
c) If it is restricted in profiles, then those users can no way access the object added to that application via Salesforce.com User Interface
d) You can create your own Custom App by selecting Create New App present in the select box in the top right corner of the page.

4. What can be done in Force.com platform? Select 3 choices
a) Data-warehousing
b) Applications with clicks & not code
c) Applications can be upgraded without loss of customization
d) Bug Tracking Application

5. What layer of model-view-controller paradigm does standard or custom objects associated with? Choose the Right answer
a) View
b) Model
c) Controller
d) View and Controller

6. Select the salesforce.com edition that is NOT available today, Choose the Right answer
a) Professional
b) Unlimited
c) Enterprise
d) Premium

7. Can we log a Case using My Cases Tab in Help?
a) Yes
b) No

8. Default time zone is changed by an administrator from “A” to “B”. How will it affect the organization?
a) Will affect users with time zone A
b) Will affect user’s with time zone B
c) None
d) Both

9. Which field is available as a part of Translation workbench?
a) Formula
b) Descriptor
c) Rule Criteria
d) Error Message

10. Force.com domain name, can be your company name.
a) True
b) False

11. In which sales force instances would there be identical record IDs? Choose the Right answer
a) Production; Full Sandbox
b) Production; Full Sandbox; Apex Sandbox
c) Production; Full Sandbox; Configure Only Sandbox; Apex Sandbox;
d) Salesforce.com never repeats record IDs (229

User Interface Scenario Questions

1. Recruiting application has a Position object that contains location, department and other information relating to a position. A report needs to customize that is grouped by department but not on locations. What is the best type of report would a developer choose? Choose the Right answer
a) Summary Report
b) Tabular Report
c) Matrix Report
d) A report using visual force

2. In a data model object A is related to B, B is related to C. How will a developer create a report to include fields of A and C. Choose the Right Answer.
a) Create lookup relationships between A,B and C
b) Create a Custom Report type with A, B and C, and use it in the report
c) Create a custom report with A and C fields as relationships already exist
d) Report cannot be created
3. Yes or No – Assume the Organization Wide default sharing is set to private for
all objects and no sharing rules have been created. You have two users in the
Sales Rep Role, can they view each other’s data?
a) Yes
b) No
4. Manager is above the role hierarchy and wants to share some of the account records with his team mates/sub-ordinates. What do you do to achieve this functionality? Select 2 choices:
a) Update dashboard folder.
b) Update dashboard running user.
c) Update report folder.
d) Update report running user.

5. There is a position object and candidate’s custom objects. The user wants to see the top 10 positions with the largest number of candidates/job applications associated with it. Which type of dashboard would you use
a) Metric
b) Gauge
c) Table
d) Chart

6. There is a position object and a salary component object. Sensitive information will be entered in the salary object. All users should be able to see all the positions but only few users should be able to see the salary details. How would you achieve this
a) Give positions as public read only and salary as private
b) Give positions as public read only and salary as public read only
c) Give positions as private and salary as public read only
d) Give positions as private and salary as private

7. In a data model object A is related to B, B is related to C. How will a developer create a report to include fields of A and C. Choose the Right Answer?
a) Create lookup relationships between A,B and C
b) Create a Custom Report type with A, B and C, and use it in the report
c) Create a custom report with A and C fields as relationships already exist
d) Report cannot be created

8. Universal Containers tracks interview scores in Review object. Review score is tracked in numerical format and are restricted to 1-5 and displayed as Radio buttons. How developer must meet this requirement?
a) Create VF component to display interview score as a set of radio button
b) Create a formula field that displays interview score as radio buttons
c) Create interview score as picklist and display them as radio buttons on page layout
d) Create interview score field with data type of radio button

9. A person, who does not have “View Encrypted Data” permission, will see the field with masked characters. Assuming the field is in the page layout, what happens if he clicks Edit button & tries to edit the value?
a) The field will not appear in the Edit Layout
b) The user will see only masked characters, but can enter a new value and save it.
c) It will throw an error on changing that field & when he saves
d) He can see the original value & he can save it.
10. In a custom recruiting application, position & candidate are stored in separate custom object. When looking at the detail of position record, a hiring manager needs to see a list of recommended candidate based on matching job skills, instead of all candidates. How a developer could meet this requirement.
a) Lookup
b) Dashboard
c) candidate related list
d) Inline VF

11. Visual Mechanism for determining review scores in reports. Score range from 1 – 10.
Records having scores that are greater than 8 — Highlight them in green
Records having scores that are less than 4 – Highlight them in red
How a developer meet this requirement?
a) Use Chart
b) Use Custom Summary formula
c) Use Matrix Report
d) Use Conditional Highlighting

12. A group of executives has requested a convenient way to see daily metrics without having to log in to Salesforce. How would a developer accomplish this goal?

a) The users’ home page layouts to include a dashboard.
b) Create a Workflow rule that sends a link to the dashboard in an email.
c) Schedule the dashboard for daily refresh and email distribution.
d) Create a series of daily recurring events providing the dashboard link

13. There is a email field on positions object, User A should be able to see Email field but User B should not able to see the email field
a) For User B made the field as visible using profiles
b) For User B made the field as invisible using FLS
c) For User B made the field as visible using Validation Rules
d) For User B made the field as visible using OWD (213)