Single Table Dedupe

When deduping records using DemandTools, what is the recommended order for standard objects?

Which objects can be deduped?

DupeBlocker potential duplicates can be merged.

What is the best strategy, for any object, for finding duplicates?

After the merge is complete, can merges be reversed?

How is it specified to only evaluate a subset of the object’s records for a merge?

Which option in Field Rules should be selected to keep the true value for a boolean field?

Using a Field Rule, which option is used to keep a blank value on the Master record after the merge?

Saving scenarios will save the following:

(Select all that apply)

Which options can keep all field values from the Master Record except for one field?

(Select all that apply)

What does the Field Rule Update If Master Empty Scoring do?

(Select all that apply)

Joe is merging Opportunities and keeping the oldest record as the master.

His manager is concerned about data accuracy and wants to keep the largest number for the amount field, sum a custom number field that tracks hours worked on the opportunity and average a custom number field that tracks time spent on calls.

How can Joe accomplish this?

If there are 2 records with different phone numbers in a duplicate group, which field rule will allow retention of both phone numbers?

Jill has set a master rule on accounts that sets the oldest record as her master, but she needs to make sure that the active record owner is kept.

How can she accomplish this?

What is the purpose of field rules?

The Account Cleaning List is automatically shared with ALL DemandTools users.

Matching on Account Name ONLY, which mapping type would consider the following values matching data:

• XYZ Automobile Manufacturing – Medford Plant
• XYZ Automobile Mfg

When matching on the Billing Street field using Relaxed Address Match, which address would NOT be seen as matching data?

Which mapping type would allow the following data to be matching data?

• certification.validity.com
• crmfusion.com
• certification.validity.com/support

Jill is merging Contact records and wonders if there is a mapping type that will find duplicate phone entries that look like this:

(800) 555-4500 EXT 100

555-4500

Which mapping type can Jill use to match these values?

It is a recommended best practice to always apply the Fuzzy, Transpose, and Alpha Clean matching algorithms.

Which mapping type will match these values:

• Intertel, Inc
• Intertel, Co

(Select all that apply)

Which mapping type would match these two addresses?

• 2030 E Fountain St
• 2030 East Fountain Street, Apartment 4

Choose the 2 best definitions for the Fuzzy engine.

The Cleaned Account Name mapping type:

(Select all that apply)

What does the First Name mapping type do?

Which is NOT a constraint when creating a Master Rule for Accounts?

When using a score delta on a master rule, if two records receive the same score, DemandTools will automatically select the first record in the group as the master.

Jill created a master rule on an Account scenario to score records 50 points if the Type = Customer.

She has a duplicate group of 2 accounts and both are customers, which one gets 50 points?

What does Use Score Delta do?

(Select all that apply)

Select the 3 ways a master record can be selected.

What is the first action to take in Step 1?

When deduping contacts, how can partner/customer portal or community users be highlighted in the results grid?

Scenarios must be loaded from the default file path.

When using the Select Master/Non-Master records from file tab, which two fields must the input file contain?

What options are there to load or create a scenario?

(Select all that apply)

What does the Run Scenario button do?

Matches found by Salesforce’s Duplicate Management can be merged in Single Table Dedupe.

What is the purpose of the Match Blank Values option?

How are conditions OR’d in the Select Records to Search tab?

It is possible to return matches where one field value is populated and one is blank by selecting the Match Blank check box next to the mapping.

Jill has a Lead scenario that requires that Last Name and Email fields match.

Which of the following will be returned as matches?

What is the best way to sort the results grid?

How is a Master Record manually selected?

How is a group of duplicate records selected for a custom merge?

For records to be processed in a merge, which two things must be done?

Which option will stop the non-master record from being deleted after a merge is executed?

How can additional fields be shown in the results grid in Step 3 if they were not selected in Step 1?

In the results grid in Step 3, is it possible to only show the groups that are not checked?

How can a Master Rule be applied to only a specific group of records?

(Select all that apply)

When exporting the results grid, which file formats are available?

(Select all that apply)

Which fields of information are contained in the MergeRecord file?

(Select all that apply)

Can additional fields be added to the MergeRecord file?

What is the maximum batch size?

What does a green highlight on an owner field indicate?

What does the binoculars button do on the grid display?

Which fields are in the Master/Non-Master file export?

By default, blank fields on the master record will be populated from the subordinate record?

When merging custom objects, is it always best to use the Salesforce merge call?

What is the easiest way to find a specific record on the results grid?

The Combine Field Values option works with which field types?

(Select all that apply)

The Update Fields Where Master Empty option:

(Select all that apply)

Which files are created after a merge process is executed?

(Select all that apply)

If a merge group has more than 2 records, there is no way to exclude a record in the group from the merge.

Fields on the results grid can be edited and result in real time changes in Salesforce.

You must always use conditions.

The Filter Match Results option can only be used when also using Conditions.

Which filtering option should be used to only show results where at least one record in the duplicate group has an owner equal to Juan.

John has a colleague that inserted accounts yesterday without first checking to see if they already exist.

He needs to run a deduplication process, but only wants to view the duplicates where one of the records was created yesterday.

How does he accomplish this?

Acronym Mapping type will match:

(Select all that apply)

Which mapping type would match the following phone numbers:

• (614) 664-8547
• (658) 664-8547 Ext 5

(Select the BEST answer)

The Fuzzy engine will match the following:

(Select all that apply)

How can fields be rearranged to show on found duplicates in Step 1?

(Select all that apply)

What are the capabilities of the Alpha Clean engine?

(Select all that apply)

Transpose will match the following Account Names (assumes exact mapping type is selected):

(Select all that apply)