MassImpact

In the Set Value to area in Step 2, values entered in the Value tab are case sensitive.

Jill needs to populate a new field in Salesforce with just the area code from the phone number field.

Which MassImpact formula would help her accomplish this task?

The grouping feature in MassImpact’s results grid provides counts for each group and sub-group.

Is MassImpact capable of modifying multiple fields in one process?

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?

Is the results grid able to be exported?

Why might a user want to use the Update Unchanged Records feature (assume a batch size of 100)?

(Select the 2 best answers)

Where is the batch size set for MassImpact?  (Using the SOAP API)

How many objects can be updated at one time?

Which actions are done in Step 1?

(Select all that apply)

Records can be deleted in MassImpact.

Using query conditions is optional in MassImpact.

When scheduling a MassImpact scenario that uses a country standardization formula, it is best practice to set the UseFuzzy option to true.

The Proper Case formula can be customized.

What can the state standardization formulas do? (Using the default StateMatchOverRides file)

(Select all that apply)

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

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

Jill has two notes fields on her Account page layout called Field A & Field B.

She wants to scale down to one, new Notes field (Field C) and retain the detail from both current Notes fields separating the data from Field A and Field B with a semi-colon.

Which formula will she use to accomplish this task?

MassImpact can count how many Asset records are on each account.

Conditions can be used in the Object Count and Field Sum tabs to specify which sub-object records are included in the count or sum results.

Jill is the new Salesforce administrator at ABC Company.  The previous Administrator created fields of type text to count employees on the Account.  She has the following 3 text 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 + Part Time Employee field.  Can she use MassImpact to do this?  If so, which formula would she use?

Which formula concatenates the values of two text fields where the values are numbers?

Example:
FieldA = 1
FieldB = 2
Result = 12

Which combination of actions will initiate Lead Assignment Rules to be executed?

(Select all that apply)

What does the Show Groups checkbox do?

Under the Information box in Step 3, what does Records Found represent?

At minimum, how many fields to show must be selected in Step 1?

Which Set Value to tab is used to hard code a value into a field?

Is it possible to set a field value equal to another field’s value?

Is it possible to set a field value equal to a sub-object’s field value?

Joe works in the New England territory and every time he gives his Salesforce Admin a spreadsheet of new data to load, the leading zero on the postal code is removed.

Which formula can Joe’s admin run to automatically place the missing leading zero back onto the postal code?

Using this formula: Left( {billingpostalcode} , 5), and a Salesforce Postal Code field value of 80108-7890, what is returned?

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

John would like to sum the Amount field on all Closed/Won Opportunities in his organization.

What must be done in order to accomplish this task?

(Select all that apply)

What is the function of the View button on the results grid?

How are records grouped in the results grid?

In Step 3, what does the Information box contain?

(Select all that apply)

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

Saved scenarios can be scheduled in JobBuilder.

MassImpact scenarios cannot be saved.

To which file types can the results grid be exported?

(Select all that apply)

Standard & Custom Salesforce objects are able to be updated.

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

Where are MassImpact restore files located by default?

Select the correct syntax for the State Match Long formula when being applied to the standard Billing State field.

(Select all that apply)

It is possible to count the number of Opportunities associated with a Contact using the Object Count tab.

When using the Field Sum tab, it is possible to sum text fields.

How can a value be added to a pick list field when creating query conditions, or in the Value tab?

MassImpact is capable of the following functions.

(Select all that apply)

MassImpact provides a restore file.

To process a blank field value into Salesforce and overwrite a populated field value, what two things must be true?

Joe needs to change the last modified date of a large number of accounts in his organization in order to kick off workflows, but he doesn’t want to do it manually one by one.

What setting in Step 3 would allow him to accomplish this for all records in his dataset?

What are the five options used to make changes?

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

The Limit by Where Condition check box is available in the following Set Value To tabs.

(Select all that apply)

Which Set Value To tab can copy a field value from a Contact record and paste it into a field on a related Account record?