Salesforce ADM201 Exam Question and Answers

1) where can you export the record in excel format
Ans :- in export report option or in print view
2) Type of headers for email
Ans:- HTML,visual force,text
3) custom fiscal year report
Ans :- custom fiscal forecasting
4)when to enable Territory management
Ans :- custom fiscal forecasting
5)when you enable Advance Currency Management what we happen
Ans :- current base rate will be set
6)what are standard object (choose 3)
7)if time zone is changed by sys admin , will it affect the user time zone
Ans:- it won’t affect the timezone of the user
8)primary object report used for which report
Ans:- to select the report type
9)who can import leads and add it to campaign
Ans:- marketing user
10)for finding grand total which dashboard is used
Ans:- Gauge and metric
11)if a user refresh a dashboard what will happen
Ans:- it will refresh the user who refresh the dashboard
12)which is control and dependent field
Ans:- Custom picklist
13)Installing app exchange application admin can do ?
Ans:-security , first hands on
14)custom object relationship are (choose two)
Ans:-master detail and lookup
15)what will happen if a user login time period is over
Ans:- user is logged out and data is lost
16)In managed package what can be done
Ans:- Up gradation
17)can we refer custom summary formula field to another summary formula field-level
Ans:-NO
18)In user record which field is not available without using custom field
Ans:- Hire
19)Difference between workflow and approval process
Ans:- criteria and time dependent is workflow , record submit for approval is approval process
20)what are business process object
Ans:- case ,lead,opportunities, solutions
21)what are the things available in company profile? (choose 2)
Ans:-language , timezone , locale , license
22)what needs to be selected to view user opportunities and other user opportunities
Ans:- my team opportunities for hierarchy , view all data for viewing all user dashboards
23)Information available on user record
Ans:- user license , storage, email ( default sales and a/c team is not the available in the record)
24)what can be transferred in the account EXCEPT
Ans:-closed activities
25)what is required for custom tab in application
Ans:- select custom object and style
26)what can be used to create email templates
Ans:- HTML,Text,Visualforce
27)what can be stored in folder
Ans:- email template,reports and dashboards,documents
28)if a user is login in with salesforce UI , what is checked in by salesforce
Ans:-login hours , trusted ip and ip restricted
29)Recent tags can be viewed using
Ans:- Side bar widget
30)Changing default locale will affect?
Ans:-user default locale with override org default
31)Presentation assembly is used for ?
Ans:- searching for and previewing slides, then easily assembling them in whatever sequence you choose using a simple drag-and drop assembly tool.
32)what object details can be viewed in mini console view
Ans:-contact , account , cases
33)If there is a error in web-to-lead , the error message is sent to
Ans:-error will be notified to customer
34)which is workflow task and not workflow alert ?
Ans:-
35)if a approver leave the organization then the system admin can perform (choose 2)
Ans: mass transfer approve , change approval process
36)Report has to email to the user what should admin do
Ans: running user and frequency schedule
37)when case is deleted which item are also deleted
Ans:- events,comments
38)what is external id
Ans:- it is a external application field id
39)public group must be used to do all the following EXCEPT
Ans:-
40)what will a user be able to do with a record that has manually shared with read/write access
Ans:- edit
41)What are the opportunity defaults when converting a lead to an opportunity?
Ans:-Stage Defaults to first option in the picklist, close date defaults to the last
42)Manufacture ford, GM and model alitis,s500
Ans:-controller pick-list manufacture , dependent pick-list model
43)When can u enable Territory management
Ans:- Enable custom forecasting
44)how can u upload 65,000 account record
Ans:-Data Loader
45)formula field to select the current year
Ans:-my_date__c<>Year(today)
46)if a user refresh a dashboard it will affect
Ans: It will affect that particular user alone
47)what is affected when u change locale(choose two)
Ans:-Date format , number format,
48)what are the custom object relationship
Ans:-lookup and master detail
49)when upload the data in the org what will happen to storage
Ans: storage space will be immediately updated
50)recycle bin is not full and you delete a data how long the data will be there in recycle
Ans:- 30 Days
51)if a record submitted for approval and is locked who can edit that record
Ans:- Administrator and Approver
52)under user record which fields can be modified by the user
Ans:- email,sales team,accounts team

Difference between LookUp relationship and Master - Detail relationship in SFDC

Lookup relationship is an example of loosely coupled relationship whereas Master-Detail is an example of Tightly coupled relationship.

• In tightly coupled (M-D relation) when we delete the parent record, all child records are also deleted but nothing of this sort happens in loosely coupled (Lookup relation). Sure shot ADM 201,CON 201, DEV 401 question.
  
• In M-D relation, a person who can view the master can see all the detail records of that master as the their is no owner on the detail side records and detail side gets its access properties from the master. Nothing of this sort happens in the Lookup relation as both objects have owners.
  
• Roll up summary field can be made on Master Detail relation but not on the Lookup relationship.
  
• One detail side record can have maximum 2 masters but no limit on the Lookup fields. DEV 401 certification question.
  
• Standard objects can never be on the detail side of the master detail relationship but no such thing in a Lookup relation. (ADM 201)

SFDC Reports

SFDC Reports (Diff b/w Tabualr, Summary, Matrix Reports)

There are 3 kinds of reports in salesforce.com

1) Tabular Reports
2) Summary Reports
3) Matrix Reports

Tabular Reports:- These kind of reports are used when the requirement is just to view the data.
Some of the examples are:-

• Show me all Open Opportunities
• Show me List of all Accounts which do not have any closed opportunity
• Show me top 10 Opportunities by revenue

Dashboards can not be created on Tabular Reports :- Salesforce ADM 201 certification question

Summary Reports:- These reports are used when the requirement is to summarize only X Axis. In short if you need to do the sum or calculate the average on even one parameter then summary report is the answer.
Some of the examples are:-

• Show sum of all Open Opportunities
• Show opportunities sub total bu my Team

Matrix Reports:- These reports are used when the requirement is to summarize both the Axis i.e. when requirement is to group both Rows as well as Columns.
Some of the examples are:-

• Show Accounts grouped as Customer or Prospect depending on the opportunity stage
• Show monthly performance of salesteam on closing opportunity by Geography for current year

Note:- Charts can not be made on Tabular Reports as no grouping of data is available

SFDC External ID Limitation

Salesforce.com has put some silly restrictions and one of those is limit on No. of Unique fields per object. It allows only 3 External ID fields per object and considers Unique fields as type of external Id's only.

So, you can create maximum 3 Unique fields per object but can get this limit extended by requesting the salesforce via raising a Case.

ADM 201 Question:- Only 3 External ID Fields can be created on an Object.
ADM 201 Question:- Only Text, Email, Number fields can be made External Id fields.

Note:- You can not make a field unique if it contains data which is not unique.