The PowerGrid module is designed to allow users to mass update records using an easy to view grid. Users will have 70 minutes and up to 5 attempts to pass this 50 question test. Upon successful completion, the MassImpact Certificate will be earned. 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 PowerGrid Certificate
To prepare for the PowerGrid Certificate, we recommend reviewing the Help Center documentation for PowerGrid by following the link below:
0 of 50 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 PowerGrid 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.
What field will always be returned in the grid, even if it is not selected in the fields to show in the results grid section?
When analyzing data on the Contact object, which option is not available when a user right clicks on a row?
What color indicates a change will be made to a field?
PowerGrid scenarios can be scheduled.
What actions will process immediately without clicking Post Data?
(Select all that apply)
Joe wants to add information at the beginning of his Services long text area field.
Some records already have data in this field.
Using PowerGrid, can he add text to the beginning of the Services field?
John needs to add an additional value to a pick list without overwriting what is currently populated in that field.
What option will allow him to do so?
In the grid, how is a value found and replaced with a new value?
(Select all that apply)
Only fields displayed in the grid for the primary table will be available for update.
Which of the following is NOT possible?
PowerGrid can only be used to update standard objects.
Clicking the Salesforce ID link  ___________.
The Get More Fields option allows a user to:
Post Data –> Exit processes records and then closes DemandTools.
Italicized data in the grid:
(Select all that apply)
Regarding scenarios, what is possible?
(Select all that apply)
Restore files are provided for field level updates.
Setting a condition with Get Data is required.
Which right click formula is not available?
Jill created a grid of Account records where the Account Type = Prospect
After the grid is built, she realizes she also needs to include Account records where the Account Type = Competitor
What functionality will allow Jill to add the records where the Account Type = Competitor to her existing grid?
To sort columns, click the column header to sort by either ascending or descending parameters.
Columns can be resized by dragging the column separator to the right of a column header.
How can a modified field be restored to its original value before processing the change?
Assume a multi-select pick list field already has selected values.
How is a value(s) added to the existing values without overwriting them?
The restore file will always be in which file type, regardless of the Default Restore File Extension setting in DemandTools options?
For Leads, how are the convert functions accessed?
When converting leads, the restore file is stored in the default DemandToolsData Restore folder.
What is the purpose of Filters?
What setting determines which formulas are available in the grid right click menu?
Choose the definition of Selection Sets.
Which objects can be merged?
(Select all that apply)
Joe is viewing Account records and notices some duplicates.
He would like to merge these directly in PowerGrid.
How can this be accomplished?
Which objects can be linked to an existing Salesforce Campaign?
(Select all that apply)
What are the two ways to load data into the grid?
How can you limit the grid results to only show rows with at least one proposed change?
What are the 2 ways to modify the contents of a single cell?
Leads can have the following actions applied.
(Select all that apply)
Jill inserted a list of contacts under the wrong account.
What field needs to be updated to make this change?
How can a subset of changed records in the grid have their changes posted to Salesforce?
Which operations are possible?
(Select all that apply)
A filter can be created to find all records in the grid with 5+ consonants in a row.
Jill wants to look for invalid zip codes on her US addresses.
What functionality will help Jill find them?
The Filters and Scoring feature works in conjunction with which other feature to apply color coding?
What is the recommended number of records to work with in the grid?
Which feature allows the grid data to be sorted by up to 3 levels/fields?
Grid data can be exported to a formatted xls file.
When choosing the Delete Record Now option, a restore file will be created.
PowerGrid has all the capabilities of an Excel spreadsheet.
After a cell of data has been modified, how can the original value be viewed without undoing the change?
When saving a scenario, the conditions specified with Get Data and Get More Data are saved.