Data and Analytics Management 2

Question 1

How can system validation be used?

Answer 1

To enforce data type, data length, Required fields or unique entries

Question 2

When are custom validation rules used?

Answer 2

Used for custom complex validation rules that can involve one or more fields (standard or custom)

Question 3

What are the implications of validation rules?

Answer 3

Validates data type, filed length, enforces required fields and enforces unique setting

Question 4

What happens when loading records through a Data Import tool and the required fields are blank or not matched?

Answer 4

Those records fail to load.

Question 5

What happens when a formula in a validation rule returns a result “True”?

Answer 5

The record is not created or saved and an error message is displayed.

Question 6

How does the unique field requirements differ from duplication rules?

Answer 6

The unique field requirements looks at specific fields and ensures there is no other record with that entry. Duplication rules are used for the record as a whole when only one record should exist.

Question 7

What formula function is used to ensure the correct formatting of a field entry?

Answer 7

RegEx

Question 8

What are the formats available for exporting reports?>

Answer 8

CSV files, Excel (.XSL or .XLSX) files.

Question 9

How does the Data Export service work?

Answer 9

All or selected data is exported weekly, monthly or on demand (maximum once every 7 days). An email is sent with a link to a downloadable zip file which becomes an inactive link after 48 hrs.

Question 10

What are the options for exporting data?

Answer 10

Data Loader, Exports from Reports, Data Exports Service

Question 11

In which case would a user run into issues with exporting data?

Answer 11

Accessing export download link 3 days after link was sent; exporting data from a Sandbox environment

Question 12

Which Salesforce features for Lightning Experience allow finding duplicates across the org and merging them?

Answer 12

Duplicate Jobs and Duplicate Record Sets

Question 13

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

Answer 13

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

Question 14

What are the different formats of reports?

Answer 14

Tabular, summary, matrix and joined

Question 15

What impacts does the sharing model have when running reports?

Answer 15

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

Question 16

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

Answer 16

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

Question 17

What customization options are available in reports?

Answer 17

Add grouping, define filters, define filter logic, define and name ranges in ‘Bucket’ fields, summarize number and currency fields, conditional highlighting of summarized values, customer summery formulas

Question 18

What data will a dashboard display?

Answer 18

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

Question 19

When are dashboards refreshed?

Answer 19

Manually or schedule to refresh daily, weekly or monthly

Question 20

Why would a custom report type be created?

Answer 20

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