Data Quality Flashcards

1
Q

What are the 6 steps toward top data quality?

A
  1. Profile your data
  2. Control your data
  3. Integrate data
  4. Augment your data
  5. Monitor your data
  6. Assign ownership, train users and commit to a data quality process
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which objects can duplicate management manage?

A

Business Accounts

Person Accounts

Contacts

Leads

Custom Object records

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

What is the purpose of matching rules as used by duplicate management?

A

It is matching criteria to identify duplicate records

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

Which 3 standard matching rules exist today

A
  1. Business Accounts
  2. Contacts and leads
  3. Person Accounts
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What do duplicate rules do?

A
Determines actions to take as duplicates are encountered
Can alert (or block) a duplicate from being created
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Which key attributes can affect data quality?

A
  1. Age (when were the records last updated)
  2. Completeness (Make a list of fields required for each business use. Then, run a report that shows the percentage of blanks for these fields)
  3. Accuracy (AppExchanges apps for data quality can be used to help determine accuracy against a trusted source)
  4. Consistency (Reports can show the variations for each true value for a given field)
  5. Duplication
  6. Usage
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What are some of the questions you can ask (or look at) when looking at how age affects data quality?

A

How long you have had it for

Is it up to date

For data migration (for new implementations) or bringing in a department / business unit you look at the data they have and how old it is

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

What to look at when looking at completeness (in terms of data quality)

A

How many fields are you collecting data for

Are certain fields required at certain points

It can help guide thoughts on how you design it

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

What to look at when looking at accuracy of your data (in terms of data quality)

A

Look at the input format (for example phone numbers)

Tools you can use like data.com, onesource, xperian to pull in information on which companies roll up into which records

Contact information that they are accurate and/or correct

You can even get temps to help validate the data

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

What to look at in consistency (in terms of data quality)

A

Making sure that all the systems have the same single record of that customer, same telephone number, date of birth

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

What to look at in duplication (in terms of data quality)

A

Ensure there are no duplicate records :)

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

What to look at in Usage (in terms of data quality)

A

How often is the data used. If it is not used, then what is the point of having (or capturing) it

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

How can you encourage compliance for your data (example Accounts and Contacts)

A

Use exception reports and data-quality dashboards to remind users when their Accounts and Contacts are incorrect or incomplete. Scheduling a Dashboard refresh and sending that information to manages is a great way to encourage compliance.

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

What does a typical Data Management Plan include?

A

Standards for creating, processing and maintaining data

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

Name some data standards that can be included on a Data Management Plan?

A
  1. Naming Conventions (ex suffixes, abbreviations)
  2. Formatting (ex dates / money)
  3. Workflow
  4. Quality (ability to measure/score records)
  5. Roles and Ownership
  6. Security and Permissions
  7. Monitoring
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are some options to do when implementing your Data Management Plan? (hint: some config or other changes to make in Salesforce)

A
Use:
Required Fields
Validation Rules
Workflow Rules
Page Layouts
Dashboards
Data Enrichment Tools
Duplicate Management
Custom Field Types
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What’s true about duplicate records (pick more than one if you think they’re true)

  • Reps can rely on multiple records for the same data
  • They can waste your reps’ time
  • They’re a safety net in case teammates inadvertently update a matching record
  • They negatively affect your company’s reputation
A
  • They can waste your reps’ time

- They negatively affect your company’s reputation

18
Q

How can controlling duplicate records help admins?
- Sales teams trust that you manage your CRM system with their success in mind

  • You don’t worry about sending alerts to duplicate email addresses for your sales reps
  • You don’t run the risk of adding Salesforce users more than one time
A

Sales teams trust that you manage your CRM system with their success in mind

19
Q

Which of the following are true for eliminating duplicate data (You can pick more than one if you feel they’re true)
- Is a manual and time-intensive process

  • Takes the guesswork out of wondering whether a prospect is already a customer
  • Ensures that one rep doesn’t try to qualify a lead that a colleague already owns
A
  • Takes the guesswork out of wondering whether a prospect is already a customer
  • Ensures that one rep doesn’t try to qualify a lead that a colleague already owns
20
Q

Duplicate Management helps sales reps:(You can pick more than one if you feel they’re true)

  • Know when they’re creating a potential duplicate record
  • Add a prospect as both a lead and a contact simultaneously
  • Merge a contact with a case
A

Know when they’re creating a potential duplicate record

21
Q

What is the Data.com Assessment App?

A

The Data.com Assessment App helps customers understand the overall health of their data. The app can be used to analyze Account, Contact, and Lead records in order to gain insights on data completeness and quality.

22
Q

What are the Data Quality Analysis Dashboards?

A

Provided for free by Salesforce Labs via the AppExchange, Data Quality Analysis Dashboards leverage custom formula fields on many standard objects to record data quality and completeness.

The formulas are then depicted via the dashboards to identify deficiencies in the data.

23
Q

What is the first step to improving data quality?

A

Develop a Data Management Plan, which typically includes standards for creating, processing, and maintaining data.

24
Q

For how long is Field History data retained?

A

18 Months

25
Q

With Respect to Field History Tracking, what happens to fields with more than 255 characters?

A

Their changes are tracked as edited, but the old/new values are not recorded

26
Q

Are Tracked fields automatically translated?

A

No

27
Q

In regards to Field History Tracking, what happens if a trigger causes a change on an object that the current user does not have access to edit

A

The change is not tracked because field history honors the permissions of the current user

28
Q

Duplicate Management uses Data.com technology. Because of this, is a Data.com license required?

A

No

29
Q

When defining a Duplicate Rule, what options are available with respect to Record-Level Security?

A
  1. Enforce Sharing Rules

2. Bypass Sharing Rules

30
Q

Does the action you select for your Duplicate Rule apply to both Create and Edit actions?

A

No, you can choose to take a different action for Creates versus Edits.

31
Q

What actions are available for Duplicate Rules?

A
  1. Allow

2. Block

32
Q

When the Allow action is selected for Duplicate Rules, what can you also choose to enable?

A
  1. An Alert

2. Reporting (which includes the record created/edited and all its potential duplicates)

33
Q

When the Block action is selected for Duplicate Rules, what is enabled by default?

A

An Alert

34
Q

Duplicate Rules can be associated to how many matching rules?

A
  1. And they must be different objects
35
Q

How many Duplicate Rules can exist per object

A

5

36
Q

Can you compare matches across objects (for Duplicate Rules)? (Example: Compare Contacts to Leads)

A

Yes

37
Q

When you are matching across objects (for Duplicate Rules), what must be done?

A

Establish field mapping between the two objects

38
Q

Will Duplicate Rules run for all users or all records?

A

It depends on whether or not optional “Conditions” have been defined for the Duplicate Rule

39
Q

When might Duplicate Rules NOT run?

A
  1. When records are created via the Quick Create
  2. On Lead Convert in an org where the “Use Apex Lead Convert” is disabled
  3. Records are restored using the Undelete button
  4. Records are added via Lightning Sync
  5. Records are manually merged
  6. Records are created via the Community Self Registration
  7. A Self-Service User creates a record and the Duplicate Rule contains conditions based on the User object
  8. Duplicate Rule Conditions are set for lookup fields and records with no value for these fields are saved.
40
Q

How do you use Data.com Prospector?

A

Use Data.com Prospector to search valuable company information from Dun & Bradstreet and millions of crowd-sourced contacts. Add these records to Salesforce as new accounts, contacts, and leads, or export them to use in other apps. It’s a great way to get the data you need to plan your sales territories, segment campaigns, find new accounts to engage, and expand your sales network.

41
Q

How do you use Data.com Clean?

A

Use Data.com Clean to keep your Salesforce data current and complete with data from Dun & Bradstreet and crowd-sourced data from Data.com. Using Clean jobs, you can clean all your records regularly. You can also clean a single record or a list of records.