Salesforce DEV401 - Reports & Dashboards Flashcards
Salesforce Dev 401 Certification
When you delete an analytic snapshot, the source report and target object are also deleted.
A. True
B. False
B. False
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. Reports, Dashboards, Documents and Email templates
Standard report parameters (available fields, criteria, time frame) can be changed and saved in a Standard Report
A. True
B. False
B. False
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
B. No
Does the Access granted to reports through Folders rollup via the Role Hierarchy?
A. Yes
B. No
B. No
Can Dashboard Components be retrieved from Recycle Bin on deletion?
A. Yes
B. No
B. No
Can Dynamic Dashboards have a Scheduled Refresh?
A. True
B. False
B. False
How many Dynamic Dashboards are allowed for an Organization? A. 3 B. 5 C. 7 D. 10
A. 3
Which feature is used to Report on Historical Data? A. Reports B. Dashboards C. Analytical Snapshot D. Mobile Lite E. Entitlements
C. Analytical Snapshot
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
D. All of the above
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
B. Select object on which report needs to be generated
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
D. All three are used
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
B. The report runs every day at between 2:00 PM and 2:29 PM PST
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
C. (1 AND 2) OR (3 AND 4)
If you want a list of Positions which Dashboard components would you use? A. Table B. Chart C. Gauge D. Scatter E. Metric
A. Table
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. 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.
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. Follow files and links for a dashboard.
B. Follow posts and comments for a dashboard.
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. Chatter Groups, Members
C. Users, User Feed, Comments
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
C. Save
E. Show/hide details
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.
C. The source report must be grouped by record name, record owner, or feed post.
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
C. Schedule the dashboard for daily refresh and email distribution
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
B. Analytic Snapshots
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. 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
How would you highlight totals in a report? A. Roll-up Summary Field B. Formula Field C. Custom Summary Field D. Summary Totals
D. Summary Totals
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. Define object relationships and fields for reports
B. Define up to 4 object relationships
If you want a list of Positions, what dashboard component would you use? A. Metric B. Table C. Chart D. Gauge
B. Table
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
B. Table
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. Run As on dashboards
B. Folder Permission on a Report
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.
D. The data model and the application may or may not support the required reports and dashboards.
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
B. Calculations based on report summary totals
C. Highlight outliers
Which of these is not a valid report type. A. Summary B. Matrix C. Tabular D. Detailed
D. Detailed
Which report type is used to group rows of data and show their subtotals? A. Summary B. Matrix C. Tabular D. Detailed
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.
Which report type does NOT support analytic snapshots? A. Summary B. Matrix C. Tabular D. Detailed
B. Matrix
Matrix reports show data summaries against both horizontal and vertical criteria.
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. Console
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
B. Metric
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. Gauge
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
E. VisualForce page
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
D. Analytic Snapshot
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
B. Schedule the dashboard for daily refresh and email distribution
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. Summary Report
Summary reports return your data with subtotals and other summary-level information.
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
B. Create a Custom Report type with A, B and C, and use it in the report.
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
B. Last Day of those Months which have 31 Days
Is formatting of report maintained when exported via Export Details?
A. True
B. False
B. False
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. True
Which report type does not allow generation of charts? A. Summary B. Matrix C. Tabular D. Detailed
C. Tabular
Tabular reports CAN’T be used to create dashboard components
Which report type is used to group rows and columns of data and show their subtotals? A. Summary B. Matrix C. Tabular D. Detailed
B. Matrix
Matrix reports show data summaries against both horizontal and vertical criteria; for example, total sales per sales rep per year by quarter.
What is the number of components that can be added to a dashboard? A. 20 B. 25 C. 50 D. 100
A. 20
Report charts are included in emailed reports.
A. True
B. False
B. False
For dynamic dashboards, can the running user be set as the logged-in user?
A. True
B. False
A. True
What are the components of the dashboard that use grand totals? (2 answers) A. Chart B. Metrics C. Table D. Gauge
B. Metrics
D. Gauge
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
E. All of the Above
Combination chart cannot be made for which type of reports? A. Tabular B. Summary C. Matrix D. None of the above
A. Tabular Reports
Tabular reports CAN’T be used to create dashboard components
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
B. Create and Customize Reports
C. Report Builder
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
B. Charts, gauges, tables, metrics, and Visualforce pages