Data and Analytics Management III-IV-V

Question 1

A “____” determines which records and fields are available in a report.

Answer 1

report type

Question 2

“_____“can be used to report on historical data.

Answer 2

`Reporting snapshots

Question 3

Combine up to “__” blocks in one report with joined reports

Answer 3

5

Question 4

Fields cannot be hidden and will always be available to users when using this report type

Answer 4

standard report type

Question 5

Fields can be hidden to prevent the field from being used when using this report type

Answer 5

Custom report type

Question 6

Users can create “____” types if none of the standard or pre-made custom report types meet the report requirements.

Answer 6

custom report

Question 7

“___” reports is just a list of records displaying their fields

Answer 7

Tabular

Question 8

Data in a “___“report contain grouped records and subtotals.

Answer 8

summary

Question 9

Data in a “____” report involve records that are grouped or summarized by rows and columns.

Answer 9

matrix

Question 10

“___” reports are used for analyzing Salesforce data across multiple report types or getting multiple simultaneous views of an object.

Answer 10

Joined

Question 11

“__” fields can be used for grouping, filtering, and categorizing report values based on defined criteria.

Answer 11

Bucket

Question 12

“____” fields can be used to find the sum, average, highest, or lowest value of a numeric column in a report.

Answer 12

Summary

Question 13

Four (4) types of summary can be used for a custom summary formula: They are

Answer 13

SUM, AVG, MAX and MIN.

Question 14

Custom summary formulas can be created for these 3 grouping type reports At least one grouping is required.

Answer 14

summary, matrix and joined reports.

Question 15

“___” Filters can be used to display records based on whether or not they have child records of a particular type.

Answer 15

Cross

Question 16

“___” can be added to combine filters in a report with AND, OR, and NOT conditions as well as parentheses for condition priority

Answer 16

Filter logic

Question 17

When report filtering on a picklist field, “____” can be selected to limit results to records that are blank or contain ‘null’ values.

Answer 17

‘No Selection’

Question 18

Several “____” are available for displaying report data in the form of bars, columns, lines, shapes, or other elements.

Answer 18

chart types

Question 19

chart types can be created on these three report types

Answer 19

summary, matrix and joined reports.

Question 20

Charts provide a “___” of the information in the report.

Answer 20

visual display

Question 21

“____“charts show changes in value over time, e.g., monthly leads by month. can move up diagonally if the hoizontal and vertical value is steadily rising

Answer 21

Line

Question 22

“____“Chart displays report data in the form of a donut that consists of wedges where each wedge represents a grouping.

Answer 22

Donut

Question 23

A “____” chart can be used when there are multiple groupings in an ordered set to show proportions among the set.

Answer 23

Funnel

Question 24

A reporting snapshot can be configured to run on what 3 time intervals

Answer 24

daily, weekly, or monthly.

Question 25

T/F

Users can subscribe to report to directly receive report updates through email.

Answer 25

True

Question 26

The “____” permission is required in order to specify a running user other than himself/herself.

Answer 26

View All Data

Question 27

T/F

Reports will only show records the user has access to.

Answer 27

True, This means that if two different users with different record access run a report, the report will show different data depending on what records they have access to.

Question 28

T/F
Page layouts have no impact on record visibility in reports. A field can be viewed even if it is not visible on a page layout.

Answer 28

True

Question 29

“_____“determines access to folders in which reports are stored as user access to the folder is required.

Answer 29

Folder sharing

Question 30

Public folders can be shared to these three places

Answer 30

public groups, roles, users

Question 31

If the sharing model is “___” or “____“for an object, all users will see the same records in the report.

Answer 31

Public Read/Write, Public Read Only

Question 32

If the sharing model is “____” for an object, the user will only see the records they have access to.

Answer 32

Private

Question 33

“____” are visual representations of data from reports which are very useful in analyzing data,

Answer 33

Dashboards

Question 34

Data can be visually displayed on a dashboard using “____” such as chart, gauge, metric, or table.

Answer 34

dashboard components

Question 35

Dashboards can be manually refreshed, or it can automatically refresh “___” “____” or “_____” depending on the schedule set.

Answer 35

daily, weekly, or monthly

Question 36

A “___” is a visual representation of information displayed through components which retrieve data from source reports, and provides filters to narrow the results.

Answer 36

dashboard

Question 37

A dashboard component is the visualrepresentation of sourcereport data and can be in the form of one of these 4 components

Answer 37

a chart, gauge, metric, or table.

Question 38

Dashboards components can be resized to as small as”___” (1x1) components.

Answer 38

one row by one column