Analytics, Reports and Dashboards (10%)

Question 1

How can you ensure that a dashboard is not accessed by someone not authorized?

Answer 1

Store the dashboard in a folder that is accessible only by the authorized users.

Question 2

What are the different formats of reports?

Answer 2

Tabular, summary, matrix and joined.

Question 3

What impact does the sharing model have when running reports?

Answer 3

Security and sharing model settings are applied when running a report so users will only see data they have access to.

Question 4

In a private sharing model, which records will be returned to a user in a report not owned by that user?

Answer 4

Records owned by that user and users below them in the role hierarchy.

Question 5

What customization options are available in reports?

Answer 5

Add grouping, define filters, define filter logic, define and name ranges in ‘bucket’ fields, summarize number and currency fields, conditional highlighting of summarized values, custom summary formulas.

Question 6

What data will a dashboard display?

Answer 6

A dashboard will display data a user has access to if defined as ‘dynamic’, or run as ‘running user’ to display data that the user has access to.

Question 7

When are dashboards refreshed?

Answer 7

Manually or scheduled to refresh daily, weekly or monthly.

Question 8

Why would a custom report type be created?

Answer 8

To specify the types of related records included(with or without) and add additional fields, e.g., fields related to a lookup.

Question 9

How many levels can a custom report type have?

Answer 9

4 Levels - A primary object and 3 related objects

Question 10

Are Standard Report Types defined as ‘with’ or ‘without’ related records?

Answer 10

‘With’ related records.

Question 11

In what form can dashboard components be?

Answer 11

Chart, gauge, metric, legacy table, lightning table, or visualforce page.

Question 12

Where is data dashboards extracted from?

Answer 12

Reports.

Question 13

Which data can you highlight in a report when using conditional highlighting?

Answer 13

Grand totals, summarized totals, grouped by field names.

Question 14

Which two chart types can display summary values from two levels of grouping in a report?

Answer 14

Stacked bar chart and grouped lined chart.

Question 15

When would you need to create a custom report type?

Answer 15

When you want to show a relationship other than ‘with’ between related objects.

Question 16

Which features are available when applying a filter to a date field in the lightning report builder?

Answer 16

Custom date ranges can accept manually entered values and be open-ended.

Question 17

In lightning experience, what are the different ways of adding columns to a report?

Answer 17

Using the ‘add column…’ picklist or dragging columns from the ‘fields’ pane on the left onto the report.

Question 18

What must be true to add a chart to a report in lightning experience?

Answer 18

The report must have at least one group.

Question 19

What must be true to use a joined report as the data source for a dashboard component

Answer 19

The joined report should have a report chart.

Question 20

What are some of the options available for a joined report run page in lightning experience?

Answer 20

Adding a chart, editing filters, sorting columns and groups, and adding the report to a dashboard.

Question 21

What can be used to quickly find reports from the reports tab in lightning experience?

Answer 21

Quick search.