Salesforce DEV401 - Reports & Dashboards Flashcards

Salesforce Dev 401 Certification

1
Q

When you delete an analytic snapshot, the source report and target object are also deleted.
A. True
B. False

A

B. False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Folders are used in Salesforce.com to store
A. Reports, Dashboards, Documents and Email templates
B. Reports, Dashboards and Documents
C. Dashboards, Documents and Email templates
D. Reports and Dashboards

A

A. Reports, Dashboards, Documents and Email templates

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Standard report parameters (available fields, criteria, time frame) can be changed and saved in a Standard Report
A. True
B. False

A

B. False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

After creating a custom report type, can the user change the Primary object associated with that report type?
A. Yes
B. No
C. Depends on the Profile Permissions
D. No concept of Primary Object in Custom Report Type

A

B. No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Does the Access granted to reports through Folders rollup via the Role Hierarchy?
A. Yes
B. No

A

B. No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Can Dashboard Components be retrieved from Recycle Bin on deletion?
A. Yes
B. No

A

B. No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Can Dynamic Dashboards have a Scheduled Refresh?
A. True
B. False

A

B. False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q
How many Dynamic Dashboards are allowed for an Organization?
A. 3
B. 5
C. 7
D. 10
A

A. 3

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q
Which feature is used to Report on Historical Data?
A. Reports
B. Dashboards
C. Analytical Snapshot
D. Mobile Lite
E. Entitlements
A

C. Analytical Snapshot

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

For to which reasons would an analytical snapshot fail?
A. Source report has been deleted
B. Running user is inactive
C. Report has been changed to Matrix report
D. All of the above

A

D. All of the above

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Which is the first step when creating a report?
A. Select type of report
B. Select object on which report needs to be generated
C. Select columns to be displayed
D. Select report name
E. Select the fields which need to be summarized

A

B. Select object on which report needs to be generated

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q
Which one the following Boolean functions is NOT used in the advanced filter conditions in Reporting?
A. AND
B. OR
C. NOT
D. All three are used
A

D. All three are used

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

If the Time Zone field on your Organization is IST and the Time Zone field on your user record is set to Pacific Standard Time (PST), and you schedule a report to run every day at 2:00 PM then
A. The report runs every day at between 2:00 PM and 2:29 PM IST
B. The report runs every day at between 2:00 PM and 2:29 PM PST
C. The report runs every day at between 2:00 PM and 2:29 PM for the Time Zone of Administrator
D. Both A & B

A

B. The report runs every day at between 2:00 PM and 2:29 PM PST

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q
What should the Advanced Filter Conditions be to meet the requirement “Find all the opportunities over $1 million that are closing in the next 60 days as well as opportunities over $5 million that are closing in the next 120 days using these definitions?:   1) Amount greater than 1000000  2) Close Date equals Next 60 Days   3) Amount greater than 5000000 4) Close Date equals Next 120 Days
A. (1 OR 2 OR 3) AND 4
B. (4 AND (2 OR 3)) OR 1
C. (1 AND 2) OR (3 AND 4)
D. (1 AND (2 OR 3)) OR 4
A

C. (1 AND 2) OR (3 AND 4)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q
If you want a list of Positions which Dashboard components would you use?
A. Table
B. Chart
C. Gauge
D. Scatter
E. Metric
A

A. Table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

A sales manager would like to view a dashboard from the perspective of different users and switch between users without editing the dashboard. How would an administrator enable this? (2 answers)
A. Create the dashboard as a dynamic dashboard.
B. Grant the sales manager the “Manage Dynamic Dashboards” permission.
C. Grant the sales manager the “Drag-and-Drop Dashboard Builder” permission.
D. Grant the sales manager the “View My Team’s Dashboards” permission.

A

A. Create the dashboard as a dynamic dashboard.
D. Grant the sales manager the “View My Team’s Dashboards” permission.

To enable choosing a different running user for the dashboard: “View My Team’s Dashboards” OR “View All Data”.

  • Users with “View My Team’s Dashboards” can view the dashboard as any user below them in the role hierarchy.
  • Users with “View All Data” can view the dashboard as any user in their organization.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What can users do when Chatter feed tracking is enabled for dashboards? (2 answers)
A. Follow files and links for a dashboard.
B. Follow posts and comments for a dashboard.
C. Auto-follow dashboards created by the user.
D. Follow posts and comments for the dashboard source reports.

A

A. Follow files and links for a dashboard.

B. Follow posts and comments for a dashboard.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q
Which combination of objects is available when creating a custom report type for Chatter reports? (2 answers)
A. Chatter Groups, Members
B. Opportunities, Followers, User Feed
C. Users, User Feed, Comments
D. Accounts, User Feed, Comments
A

A. Chatter Groups, Members

C. Users, User Feed, Comments

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q
Which functions are available in the report builder interface, prior to running the report? (2 answers)
A. Printable view
B. Schedule future runs
C. Save
D. Export details
E. Show/hide details
A

C. Save

E. Show/hide details

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Which is a consideration when creating a drill-to-detail dashboard component?
A. Drill-to-detail must be enabled on the custom report type.
B. The dashboard component type must be a gauge.
C. The source report must be grouped by record name, record owner, or feed post.
D. The source report must be stored in the drill-to-detail folder.

A

C. The source report must be grouped by record name, record owner, or feed post.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

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

A

C. Schedule the dashboard for daily refresh and email distribution

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q
What can be used to gather historical data for trending reports?
A. Reports
B. Analytic Snapshots
C. Roll-Up Summary
D. Report Types
E. Audit History Records
A

B. Analytic Snapshots

23
Q

What can cause an analytic snapshot run to fail? (4 answers)
A. The source report has been deleted.
B. The target object has a [an insert] trigger on it.
C. The running user has been inactivated.
D. The target object is a custom object.
E. The source report is saved as Matrix report

A

A. The source report has been deleted.
B. The target object has a [an insert] trigger on it.
C. The running user has been inactivated.
E. The source report is saved as Matrix report

24
Q
How would you highlight totals in a report?
A. Roll-up Summary Field
B. Formula Field
C. Custom Summary Field
D. Summary Totals
A

D. Summary Totals

25
Q

Select the features that are available through custom report types. (2 answers)
A. Define object relationships and fields for reports
B. Define up to 4 object relationships
C. Define anti-join relationships
D. Create analytic snapshot reports

A

A. Define object relationships and fields for reports

B. Define up to 4 object relationships

26
Q
If you want a list of Positions, what dashboard component would you use?
A. Metric
B. Table
C. Chart
D. Gauge
A

B. Table

27
Q
What is the best type of dashboard component to display a list of your top 10 customers?
A. Metric
B. Table
C. Gauge
D. Chart
A

B. Table

28
Q
How can a manager in an organization share specific fields to his subordinates that only he has access to? (2 answers)
A. Run As on dashboards
B. Folder Permission on a Report
C. Run As on scheduled reports
D. Folder Permission on a Dashboard
A

A. Run As on dashboards

B. Folder Permission on a Report

29
Q

An application was designed without considering requirements for reports or dashboard. Which of the following statements is true?
A. The data model will support all the requirements of the application including reports and dashboards
B. Reports are part of the application, so application design will take care of it
C. No special considerations for reports or dashboard are required, as Salesforce can natively take care of the requirements.
D. The data model and the application may or may not support the required reports and dashboards.

A

D. The data model and the application may or may not support the required reports and dashboards.

30
Q

What can be done with report summary totals? (2 answers)
A. Calculate values from a previous report
B. Calculations based on report summary totals
C. Highlight outliers
D. Historical analysis

A

B. Calculations based on report summary totals

C. Highlight outliers

31
Q
Which of these is not a valid report type.
A. Summary 
B. Matrix 
C. Tabular 
D. Detailed
A

D. Detailed

32
Q
Which report type is used to group rows of data and show their subtotals?
A.	Summary 
B.	Matrix 
C.	Tabular 
D.	Detailed
A

A. Summary

Summary reports return your data with subtotals and other summary-level information. Summary reports are great for showing average dollar values for closed won opportunities by salesperson or number of cases by status by support representative.

33
Q
Which report type does NOT support analytic snapshots?
A.	Summary 
B.	Matrix 
C.	Tabular 
D.	Detailed
A

B. Matrix

Matrix reports show data summaries against both horizontal and vertical criteria.

34
Q
A customer has requested a user interface where list view of four objects can be accessed together with frequent navigation across them. Which feature of Force.com platform can be used to support this requirement?
A.	Console 
B.	Dashboards 
C.	Analytical Snapshot 
D.	Packages 
E.	Layout template
A

A. Console

35
Q
In a recruitment application, a dashboard component needs to be built that will display total number of Positions. Which dashboard component can be used to implement this feature?
A.	Gauge 
B.	Metric 
C.	Table 
D.	Chart 
E.	VisualForce page
A

B. Metric

36
Q
Universal Recruiters would like to hire ten employees in two months. In a recruitment application, a dashboard component needs to be built that will display progress towards achieving this goal. Which dashboard component can be used to implement this feature?
A.	Gauge 
B.	Metric 
C.	Table 
D.	Chart 
E.	VisualForce page
A

A. Gauge

37
Q
Universal Recruiters uses an external system for keeping track of exits from the organization. The CEO of the organization would like to view information about exits in the Salesforce application that Universal Recruiters uses. Which dashboard component can be used to implement this feature?
A.	Gauge 
B.	Metric 
C.	Table 
D.	Chart 
E.	VisualForce page
A

E. VisualForce page

38
Q
Universal Recruiters uses Force.com as its recruitment platform. The Sales VP of Universal Recruiters would like a report that will display progress in recruitment across six months. Which reporting component can be used to implement this feature? 
A.	Summary 
B.	Matrix 
C.	Tabular 
D.	Analytic Snapshot
A

D. Analytic Snapshot

39
Q

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. Create a Workflow rule that sends a link to the dashboard in an email
B. Schedule the dashboard for daily refresh and email distribution
C. The users’ home page layouts to include a dashboard
D. Create a series of daily recurring events providing the dashboard link

A

B. Schedule the dashboard for daily refresh and email distribution

40
Q
The Recruiting application has a Position object that contains location, department and other information.  What report type should be used to group by department but not by location?
A. Summary Report
B. Tabular Report
C. Matrix Report
D. A report using visual force
A

A. Summary Report

Summary reports return your data with subtotals and other summary-level information.

41
Q

In a data model, object A is related to B, B is related to C. How can a report be created to include fields from A and C?
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

A

B. Create a Custom Report type with A, B and C, and use it in the report.

42
Q

If you schedule a report to run on the 31st day of every month, then the report runs on
A. Last Day of Every Month
B. Last Day of those Months which have 31 Days
C. Last Day of those Months which have 31 Days for rest of the months Report is scheduled on 1st
D. No such criteria is available for Scheduling

A

B. Last Day of those Months which have 31 Days

43
Q

Is formatting of report maintained when exported via Export Details?
A. True
B. False

A

B. False

44
Q

If a lead with a single marketing campaign is converted, the campaign information will map to the newly created contact and opportunity record and will be available for reporting.
A. True
B. False

A

A. True

45
Q
Which report type does not allow generation of charts?
A.	Summary 
B.	Matrix 
C.	Tabular 
D.	Detailed
A

C. Tabular

Tabular reports CAN’T be used to create dashboard components

46
Q
Which report type is used to group rows and columns of data and show their subtotals?
A.	Summary 
B.	Matrix 
C.	Tabular 
D.	Detailed
A

B. Matrix

Matrix reports show data summaries against both horizontal and vertical criteria; for example, total sales per sales rep per year by quarter.

47
Q
What is the number of components that can be added to a dashboard?   
A.	20 
B.	25 
C.	50 
D.	100
A

A. 20

48
Q

Report charts are included in emailed reports.
A. True
B. False

A

B. False

49
Q

For dynamic dashboards, can the running user be set as the logged-in user?
A. True
B. False

A

A. True

50
Q
What are the components of the dashboard that use grand totals? (2 answers)
A. Chart
B. Metrics
C. Table
D. Gauge
A

B. Metrics

D. Gauge

51
Q

With combination charts, you can :
A. Add a line to an existing line, vertical column, grouped vertical column, or stacked vertical column chart
B. Add a cumulative line to an existing line cumulative chart
C. Add up to three columns to a vertical column chart
D. Add up to three bars to a horizontal bar chart
E. All of the Above

A

E. All of the Above

52
Q
Combination chart cannot be made for which type of reports?
A. Tabular
B. Summary
C. Matrix
D. None of the above
A

A. Tabular Reports

Tabular reports CAN’T be used to create dashboard components

53
Q
Which permissions are needed to create, edit and delete a report? (2 answers)
A. Run Reports
B. Create and Customize Reports
C. Report Builder
D. Schedule Reports
A

B. Create and Customize Reports

C. Report Builder

54
Q

What source reports can be added to a Dashboard?
A. Charts, gauges, tables and metrics
B. Charts, gauges, tables, metrics, and Visualforce pages
C. Charts, gauges, tables, metrics, and summary
D. Charts, gauges, tables, matrix, and summary

A

B. Charts, gauges, tables, metrics, and Visualforce pages