Data and Analytics Management

Question 1

Data can be imported and exported in what type of file?

Answer 1

Delimited text format (.csv)

Question 2

Tool that lets you import up to 50,000 records at a time

Answer 2

Data Import Wizard (Setup)

Question 3

Client application that can import up to 5 million records at time

Answer 3

Data Loader (Setup) - you must install separately

Question 4

Allows you to export data manually or automatically once every 7 days (weekly report) or 29 days (monthly report)

Answer 4

Data Export Service (Setup)

Question 5

What specifies the matching criteria to identify duplicate records?

Answer 5

Duplicate Rule (Setup)

Question 6

Where do you create custom reports?

Answer 6

Setup - Report Types

Question 7

Where can the Report Builder be found?

Answer 7

Reports Tab/App Launcher

Question 8

Determines which fields and records are available for use when creating a report

Answer 8

Report Type (Setup)

Question 9

Determines which records the report type includes

Answer 9

Primary object relationship

Question 10

You can have up to ___ related objects

Answer 10

4

Question 11

Use a ___ to quickly categorize report records without creating a formula or custom field

Answer 11

Bucket column

Question 12

Filter reports by show me, date field and date range

Answer 12

Standard Filters

Question 13

____ uses operators to determine when and how filters are applied to a report

Answer 13

Filter Logic

Question 14

Which filter do you use to filter a report by child objects using With or Without conditions

Answer 14

Cross Filter

Question 15

Select maximum rows, sort by and sort order of a report

Answer 15

Row Limit

Question 16

List report format

Answer 16

Tabular

Question 17

What report format do you use to group and summarize?

Answer 17

Summary

Question 18

Group and summarize, by row and column report format

Answer 18

Matrix

Question 19

Allow you to place a single chart right at the top of your report

Answer 19

Report Charts

Question 20

Visual display of key metrics and trends for records within the org

Answer 20

Dashboard (stored in public, hidden or shared folder)

Question 21

This type of Dashboard runs as the logged-in user, seeing the data according to their own access level

Answer 21

Dynamic Dashboard

Question 22

What tool do you use to build dashboards from reports?

Answer 22

Dashboard Builder

Question 23

What dashboard component do you use when you want to show data graphically?

Answer 23

Chart

Question 24

Use a ____ when you have a single value that you want to show within a range of custom values

Answer 24

Gauge (Dashboard Component)

Question 25

Use a ___ when you have one key value to display

Answer 25

Metric (Dashboard Component)

Question 26

What dashboard component do you use to show a set of report data in column form?

Answer 26

Table

Question 27

What can you add to a report to calculate additional totals based on the numerical values?

Answer 27

Summary Formulas

Question 28

True or False: Export report details in .csv or .xls formats from the report tab

Answer 28

True

Question 29

Tool that allows you to bulk import, export, insert, update, delete, upsert records for both standard and custom objects

Answer 29

Data Loader

Question 30

Filter logic doesn’t apply to ___ filters

Answer 30

Cross filters