ICM | Incentive Compensation Management Test

INCENTIVE COMPENSATION MANAGEMENT TEST

Progress

1.

Choose the main lever/levers of SPM

Resource Management
Process Management
Incentive Compensation Management
All the above

2.

In Which form of commission the payee does not get any payout when no sales are made?

100% Commission
Straight Commission
Revenue Commission
Attainment based Commission

3.

SPM stands for

Software Process Model
Software Project Management
Sales Performance Management
Statistical Parametric Mapping

4.

Which type of Compensation does not increase the Sales Productivity?

100% Commission
Base Salary only
Revenue Commission
Base Salary + Commission

5.

The following table will not allow you to import data from any external source.

Data
Structural
Custom
View

6.

Connections can be searched in Navigation.

TRUE
FALSE

7.

Can we modify the Primary Key column once the table is created?

YES
NO

8.

The table name will not allow space.

TRUE
FALSE

9.

What are the options available for importing data into the table?

Microsoft Excel files
Salesforce.com
Database Import
All the above

10.

Which table type should be used to store transactional information?

View
Data
Custom
Structural

11.

Which table has the information regarding the calendar period in the model?

Time
Currency
Payee
Calendar

12.

Which table is associated with the Calendar?

Custom Table
View Table
Data Table
Structural Table

13.

Which table property can be changed after it is created?

Name
Description
Primary key
Type

14.

Which table does not belong to the Hierarchy table type?

Payee
Account
Title
Time

15.

Multiple primary key columns can be added to a Custom Table.

TRUE
FALSE

16.

Can we add records for the locked period in the data table?

YES
NO

17.

Which hierarchy table cannot be viewed as a table in Composer?

Payee
Time
Accounts
Currency

18.

Your client assigns monthly quotas for each individual payee separately. In addition to the Payee ID column, which column should be part of the primary key of the quota table?

Quota Start Date
Quota
Quota End Date
Reports To

19.

A table cannot be made global if it has the same name as

Connection
Calculation
View Table
Calendar

20.

Pick Lists can be picked from (Choose two.)

Hierarchical Tables
Data Tables
Structural Tables
Custom Tables

21.

Can two date columns be used to lock the data table?

YES
NO

22.

You are creating a calculation using the below two tables without restriction/join. How many rows will be returned?

10
12
7
3

23.

Your model has two calculations “Revenue” and “Commission” – partitioned by Payee ID, Product Group, Product, and Month.

What must you create to achieve the results that show revenue and commission by Product Group and Month?

Data Store that joins both calculations and select Product Group and Month as detail columns.
Aggregate Transformations in Presenter partitioned by Product Group and Month.
Additional calculations to sum the results partitioned by Product Group and Month.
Calculated Rows in Presenter that sum both values by Product Group and Month.

24.

Which of the following formula operator can be used to perform logical test and provide True or False result?

IF ()
And ()
OR ()
Is Empty ()

25.

What causes an error when attempting to edit or save a calculation? (Choose two)

When a global action/calculation is running
When you are granted view only access to composer
When another user is creating a process list
When another user is modifying a presenter report

26.

Which one of the following to be considered to aggregate the data in time-based calculation?

Time shift calculation
Calendar
Data Table
All the above

27.

What type of calculation can be used to separate a large volume of transactional data into the different groups?

Time Shift Calculation
User Defined
Sort
Category

28.

Restrictions can be defined based on both individual values and calculation sources

TRUE
FALSE

29.

You have the following objects in your model: A calendar named T001, Views, Structural tables, Data tables and two Calculations using T001. Which two elements are impacted when you lock T001? (Choose two.)

Calculations
Data tables
Views
Structural tables

30.

When creating a calculation in the Base Model, how would you partition by a single date?

Drag the date to the partitions window
Choose the date to partition by and set it to calculate and accumulate by Date (Date/Date)
Join the date to the Date String table and partition by the Date column
Join the date to the Date String table and partition by the Date String column

31.

You have two sources in your calculation, your primary data source contains transactional data for each payee and the second source contains compensation rates for each payee applied to sales. How do you associate two types of payee data?

Source1.Title = Source2.Title
Source1.PayeeID = Source2.PayeeID
Source1.CompPlan = Source2.CompPlan
All the above

32.

Which of the following calculation can be used to organize records into different groups?

User-Defined
Category
Sort
Time Shift

33.

Which two objects are associated with a calendar?

View
Data Table
Custom Table
Calculation

34.

After applying formula, and click on the Format formula button, which of the following action can occur? (Choose two)

Functions in formula changes into blue color
Formatting a formula cannot be undone
Formula is separated into new lines and becomes indented
Format formula button will be disabled

35.

Payee ID Amount

10001 150000

10002 275000

10003 312000

10004 363000

Your formula is Sum(Data. Value) and no display column is defined in the calculation. What is the output?

System will not allow to create the calculation.
150000
1100000
No values will be displayed

36.

Which partition can be used to display the year-to-date value in the calculation?

Include Empty partition
Accumulating partition
Normal Partition
None of the above

37.

What are the options available while locking the calendar?

Calculate and lock
Lock only
Both A and B
None of the above

38.

The calculation can be created with one or more formulae.

TRUE
FALSE

39.

What object would you use to join Tables and Calculations to create a large data container or repository?

Data Stores
Draw
Tailored Report
PLCM

40.

Which of the below statements are correct with respect to Data Grid?

The total width of the Data Grid is 100%
You cannot the restrict the values in Data Grid
You can rename the columns in Data Grid
All the above

41.

Choose the appropriate option to perform the following.

Computed Column
Computed Row
Transpose
Aggregate Transformation

42.

Two reports can be connected by a common parameter using the Link option within data grid

TRUE
FALSE

43.

The following object can be used as a source for "Row Form Sources".

Connection
Calculation
Table
None of the above

44.

How many computed row can be added in a data grid in presenter report

3
1
5
8

45.

Which of the following statements about Data Stores are correct? (Choose two)

Multiple calculations can be joined or union in Data Stores
We cannot add more than one data source in Data Stores
Columns names can be changed in Name Columns Tab in Data Store unless it is already used in any of the Reports
The Data Stores that has dependency with report can be edited as and when needed

46.

Look into the below image,

In the Presenter, when preparing data sources for the report shown in the screenshot, which type of source must be created to produce the highlighted result (Subtotal by Payee)?

Computed Row
Computed Column
Aggregate Transformation
Subtotal Source

47.

Look at the below image

How would you sort the above table/grid by the column “Customer Name”?

Arrange - Edit Data Grid > Sort Data > Data Grid Display Options
Edit Data Grid > Sort Data - Drag Column into right pane
Select Column in Grid Display Options and Click Sort
Edit Data Grid > Sort Data > Data Grid Display Options > Sections - Select “Show Section Headers”

48.

Which of the element can be used as a data source in a presenter report across all levels of the composer?

Data Stores
Calculations
Connections
Tables

49.

Look into the below screen,

What type of formatting applied for the highlighted row?

Row Formatting
Column Formatting
Conditional Formatting
Formula

50.

How would you calculate the “Total” column to show the average of “Quarter1”, “Quarter2”, “Quarter3”, “Quarter4” for the below data?

Data Source
Subtotal Source
Aggregate Transformation
Computed Column

51.

Which alignment option cannot be performed on a Column in the Grid?

Right
Center
Left
Top Right

52.

Which of the following statements about the Presenter Report is/are true?

Data Stores can also be feed directly into Report Data Grid
A Data Grid can be created by dragging a source into the report layout
A Data Grid can have more than one Data Source associated with it
A Data Grid can be exported to excel document by checking the "Export to excel" option

53.

Can layout from one report can be reused in multiple reports?

YES
NO

54.

Which option is not available in charts?

Decimal Separator
Thousand Separator
Round
Number Scaling

55.

Layout tables help you to organize your report.

TRUE
FALSE

56.

What are the tabs available in the portal access wizard?

Web tabs, Groups, Task
Web tabs, Trees, Task
Groups, External, Signoff
Assignment, Sign Off, Inquiries

57.

The node that runs the scheduler tasks within the workflow is known as

Action Node
Alert Node
Process Node
All the above

58.

Which workflow prevents the users from submitting additional data until the original submission is completed?

User-initiated
System-initiated
Admin-initiated
None of the above

59.

Which two statements regarding Portal Access Web tabs are true? (Choose two.)

The first tab listed in Portal Access is the first tab that will be displayed on the Web client
You can have a Web tab and a sub-tab for a single Web tab object
You can change the location and order of Web tabs after they have been created
Users that have access to Web tab groups also have access to sub-tabs

60.

Which option can not be used to create the hierarchical structure in the portal access tree?

The group can be selected.
Groups can be edited.
Arrows can be dragged.
Dragged arrows can be placed on another group.

Assessment complete! Thank you for you time.
We are redirecting you to the result page, Please click on 'SUBMIT'