Data & Analytics Management Flashcards

1
Q

What is the Salesforce ID?

A

A globally unique ID assigned to each record when created; 15 digit case sensitive when displayed in the UI / reports and 18 digit case insensitive from API / Data Loader

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What happens to deleted records?

A

Deleted records go to the recycle bin. After 15 days or if the bin limit is exceeded, they are permanently deleted. While in the recycle bin, deleted records can be restored.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

How does storage work in Salesforce?

A

Storage is categorized into data and file storage. Data storage is used by storing records (usually 2KB each). File storage is used by attachments, files and documents.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

When would an External ID be used?

A

When an identifier from an external system has to be used to import or update data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What are the options for importing and exporting data?

A

Data Import Wizard, Data Loader, 3rd Party Tools for Integration, Export from Reports, Data Export Service

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

How can Knowledge articles be imported to Salesforce?

A

Import Articles tool from the Setup menu allows articles and any translations to be imported into Salesforce Knowledge.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What are the main tools for data import?

A

Data Import Wizard and Data Loader

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Up to how many records can Data Import Wizard and Data Loader import?

A

Data Import Wizard can import up to 50,000 records, while Data Loader can import up to 5 million records.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

In what format is data imported, exported or deleted?

A

CSV format

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are the steps to import data?

A

Data selection, mapping, and import

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Which of the data import tools can only be used by admins?

A

Data Loader

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which of the data management tools cannot export data?

A

Data Import Wizard

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

How can data be mass deleted?

A

The Mass Delete tool allows mass deletion of Accounts, Leads, Activities, Contacts, Cases, Solutions, Products and Reports. Criterion can be set to find selected records to delete.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What can be done with the Mass Transfer tool?

A

Accounts, Leads and Custom objects and some related data can be transferred from one owner to another.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

When are dashboards refreshed?

A

Manually or scheduled to refresh daily, weekly or monthly

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

How do validation rules work?

A

A formula expression is defined on an object and checked before a record is created or edited and saved. If the formula returns true, an error message is displayed and the record is not saved.

17
Q

How can data be automatically exported?

A

The Data Export service can be used to export all or selected data weekly or monthly. An email is sent with a link to a downloadable zip file.

18
Q

What is the difference between a matching rule and a duplicate rule?

A

Matching rule is used to identify duplicates. Duplicate rule defines what happens to duplicates – allow or block.

19
Q

What actions can be taken by the administrator to ensure the data quality of an org?

A

Establish organization data standards and naming conventions, import clean data, remove duplicate records, and use validation rules.

20
Q

When are validation rules enforced?

A

Enforced immediately on record save, prior to Workflows or Process Builders

21
Q

How can system validation be used?

A

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

22
Q

When are custom validation rules used?

A

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

23
Q

What are the implications of validation rules?

A

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

24
Q

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

A

Those records fail to load.

25
Q

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

A

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

26
Q

How does the unique field requirement differ from duplication rules?

A

The unique field requirement 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.

27
Q

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

A

RegEx

28
Q

What are the formats available for exporting reports?

A

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

29
Q

How does the Data Export service work?

A

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.

30
Q

What are the options for exporting data?

A

Data Loader, Export from Reports, Data Export Service

31
Q

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

A

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

32
Q

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

A

Duplicate Jobs and Duplicate Record Sets

33
Q

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

A

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

34
Q

What are the different formats of reports?

A

Tabular, summary, matrix and joined

35
Q

What impact does the sharing model have when running reports?

A

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

36
Q

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

A

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

37
Q

What customization options are available in reports?

A

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

38
Q

What data will a dashboard display?

A

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

39
Q

Why would a custom report type be created?

A

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