DemandTools V Certification – Modify

In the Specified Value action in Step 2, values entered in the Replacement Value section are case sensitive.

Modify is capable of modifying multiple fields in one process.

The preview screen is able to be exported before publishing changes.

Why might a user want to use the Touch Records action?

Where can the batch size be updated for the Modify module?

Users can update Account fields when the Contact is selected as the Object to Modify.

Which actions are done in Step 1 of Modify? (Select all that apply)

Records can be deleted in Modify.

Using Record Selection Criteria is optional in Modify.

When creating a Modify scenario that uses a country standardization formula, users can apply a fuzzy algorithm to the formula.

The ProperCaseName formula can be customized to ignore certain words within a field.

What can the state standardization formulas do? (Select all that apply)

What is the best way to exclude a record from being processed?

The NAPhoneFix formula can be customized to standardize phone numbers outside of the United States and Canada.

Modify can count how many Case records are on each account.

Conditions can be used in the Record Count and Field Aggregate actions to specify which child object records are included in the count or aggregate results.

At minimum, how many Fields to Show on Preview must be selected in Step 1?

It is possible to set a field value equal to another field’s value.

It is possible to set a field value equal to a child object’s field value.

Using the “Left( {billingpostalcode} , 5)” with a Salesforce Postal Code field value of 80108-7890, what value is returned?

Saved Modify scenarios cannot be scheduled in DemandTools V.

Modify scenarios cannot be saved.

Custom Salesforce objects are not able to be updated using the Modify module.

It is possible to update the Contact Phone field to equal that of the Account Phone.

When using the Field Aggregate action, it is possible to sum text fields.

How can a new value be added to a picklist field when using the Specified Value action?

Modify is capable of the following functions. (Select all that apply)

Modify provides a restore file.

To add a blank field value into Salesforce and overwrite a populated field value using Specified Value, what must be true?

What are the six available Actions used to make changes?

After choosing Account as the Object to Modify, it is possible to obtain a count of Opportunities associated to all Accounts.

Which Action option can copy a field value from an Account record and paste it into a field on a related Contact record?

What is the default Batch Size Setting for Modify?

What is the maximum Batch Size for Modify when using the default API?

What is the minimum Batch Size for Modify when using the default API?

What is the maximum batch size when using the Bulk API?

With Bulk API enabled, which setting guarantees batches are processed one at a time?

When using the Modify module, which API can be used?

Users can undo actions performed in Modify from the Run History section.

Users can filter the preview screen to only show records that will be modified.

Jill needs to populate a new field in Salesforce with just the area code from the phone number field. Which Modify formula would help her accomplish this task?

The ABC Company’s data directive indicates that all countries should be in long form (e.g. United States, Canada). Which formula can be used to accomplish this?

Carol is the new Salesforce administrator at ABC Company.  She has the following 3 number fields on the Account:

• Number of Full Time Employees {FullTimeEmployee__c}
• Number of Part Time Employees {PartTimeEmployee__c}
• Total Number of Employees {TotalEmployee__c}

She needs to update the Total Number of Employees field by adding together the Full Time Employee Field and the Part Time Employee field.  Can she use Modify to do this?  If so, which formula would she use?

If this formula, StringReplaceCS(${name}, “Dr.”, “”),  is applied to a field value of “Dr. John Smith”, what is the result?

Where are Modify restore files located by default?

Jill wants to copy the value from the Mailing City field to the Shipping City field. What Action should she use to complete this task?

Ashley created a custom field called Alternate Phone on the Contact Object and she wants to ensure a value is populated directly from existing Account Phone field. What action should she use to complete this task?

Felicia’s Salesforce environment recently had a large import from a third party. The full name of the contacts were imported into a custom field. She needs the put the first name, last name, and suffix in the corresponding standard Salesforce field. What three formulas would help her with this?

Esmeralda would like to copy the domain of email addresses on Contact records and place them in the website field on Accounts. She wants to be sure to include anything after the “@” symbol. Which formula could help her with this?

Frank wants to sum the number of active Contacts under an Account record and display that number in a custom field. What Action should he use to complete this task?

Kayla’s boss tasked her with putting the sum of the Annual Revenue field from the Opportunity object on all Account records. She wants to ensure that she is only accounting for revenue that was associated with Closed Won Opportunities. What replacement action should she use?

What Action can be used to update a record’s Last Modified Date and trigger any active flows in Salesforce if no other changes are being made?

What signifies that an update will be made to a field within the preview screen? (Select all that apply)

For an action to be undone from the Run History section, the scenario must have been run within the last 15 days.

Users cannot choose multiple actions from different categories and combine them into a single scenario.

Selecting View Modified Only will display only the records with changes that will be made via a Modify action, with the exception of Touch Records.

When viewing the preview screen, what signifies that an error would occur during an update? (Select all that apply)