MassEffect allows users to insert and manipulate data into Salesforce utilizing multiple file types. The MassEffect test was designed to discern the user’s knowledge of the module in its entirety. Users will have 80 minutes and up to 5 attempts at passing this 60 question test. Upon successful completion, the MassEffect Certificate will be awarded. Users are encouraged to print the certificate for their records upon completion.
Users who complete MassImpact, MassEffect, PowerGrid, Reassign Ownership, BulkBackup and the ReportEdit tests will be awarded the Data Maintenance Badge. The Data Maintenance Badge is a prerequisite for earning the Certified DemandTools Badge.
Preparing for the MassEffect Certificate
To prepare for the MassEffect test, we recommend reviewing the Help Center documentation by following the link below:
0 of 60 Questions completed
Questions:
You have already completed the test before. Hence you can not start it again.
Test is loading…
You must sign in or sign up to start the test.
You must first complete the following:
Your time:
Time has elapsed
Thank you for completing the MassEffect test.
If you see a button to Print Your Certificate, please do so now and save for your records.
Your test results will be sent via email shortly.
The transform option is available for which operations?
(Select all that apply)
What is the max batch size when using the SOAP API?
Deleting records uses the cascading delete as defined by Salesforce.
How does MassEffect know on which line of the input file to start and stop reading data?
If a process completes with errors, where can the errors be viewed?
(Select all that apply)
In an Update operation, which field can be set as the key field?
In an Upsert operation, which field can be set as the key field?
(Select all that apply)
In the Update operation, which right click options are unavailable when using a non-Salesforce ID field as the key field?
(Select all that apply)
MassEffect scenarios can be scheduled with JobBuilder.
Restore files are created for which operations?
(Select all that apply)
Right clicking on a table will show the Export operation.
Select the 2 items needed to export archived activities.
Select the true statement.
When is it recommended to use the Bulk API?
(Select all that apply)
When merging text values on an update, how is it specified that the data from the spreadsheet be prepended vs. appended to the existing value in Salesforce?
Which file is created after an Insert operation not using the Bulk API?
Jill’s data vendor doesn’t follow the same data standards as Jill’s organization and it takes valuable time to reformat the data prior to import.
Which Transform formulas are available to reduce or eliminate the reformatting Jill does manually?
(Select all that apply)
What operations are possible?
(Select all that apply)
With Use Bulk API enabled, which setting guarantees batches are processed one at a time?
Which file types can be used in MassEffect?
Joe added a new field to his Account object.
He then logged into DemandTools to run an update on the field through MassEffect, but he couldn’t find the new field in his field list.
Which action should he take to make the field visible?
What is the maximum batch size when using the Bulk API?
How is an incorrectly mapped field removed?
Are field level meta data attributes able to be viewed?
Jill has an input file of 2300 Accounts to insert into Salesforce.
Her organization has several validation rules and she often experiences errors when attempting to insert new records due to these rules.
Jill would like to insert the first 50 records in her file as a test to ensure her file is set up correctly.
What is the best way to accomplish this?
John is updating a list of records from a Trade Show.
He only wants to update certain fields if they are currently blank in Salesforce to avoid overwriting populated data.
Is this possible?
Only records that exist in the Salesforce Recycle Bin can be undeleted.
Error listings are only shown in the user interface when Use Bulk API is selected.
When inserting records via the SOAP API, what files are created?
(Select all that apply)
Jill is inserting Account records using a .csv file which caused the leading zeros in the zip codes to be lost on the New England account records.
What transform formula will add the leading zero to her zip codes?
All Salesforce tables are able to be viewed in every operation.
When exporting attachments as decoded documents, which additional option must be used?
Jill is upserting a list of Leads.
She loaded her input file and selected upsert in the operation box.
What does she need to do now?
Inserting records does not check for duplicates.
Joe is making some updates to fields on the contact object using MassEffect.
In his spreadsheet, he has no values indicated for his custom favorite color field as he would like this field to be cleared.
Which option must be enabled for blank values in his input file to overwrite populated values in Salesforce?
Which caveats apply when not using the Salesforce ID as the key field?
(Select all that apply)
Which field types can be merged when updating records?
(Select all that apply)
What files are provided after processing an insert?
(Select all that apply)
Which of the following are required when undeleting using MassEffect?
(Select all that apply)
What does the Show Error Listing button do?
Field level right-click options in the update operation include:
(Select all that apply)
MassEffect can be used to edit or insert Salesforce meta data.
(For example, adding a new pick list value for an existing pick list field)
In the Insert or Update operation, which field is used to associate a Contact with an Account?
Which Owner/User field is used to assign records to a specific user?
When counting sub-objects, what must be in the input file?
Jill needs to use MassEffect to insert new Accounts and the related Contacts for these accounts.
How can she accomplish this?
(Select the best answer)
In which operation are History tables shown?
Restore files are provided after deleting records.
The Hard Delete option is available when using the SOAP API.
The Undelete operation is available when using the Bulk API.
What does the term Hard Delete mean in reference to the Delete operation?
Using the Upsert operation, which symbol indicates the field can be used as a key field?
When using an excel file, what additional step(s) must be done in order for the file to load?
Before loading a scenario in every operation except export, what action must be taken?
When exporting records, it is possible to export fields from related tables.
It is possible to select the order in which fields will be exported to a file.
What field will always be included in an export, even if not selected by the user?
What is the function of the Update Newly Added Objects button?
How are the Export and Auto Map functions accessed?
What are the possible reasons a field may not show for a specific object?
(Select all that apply)