ICM | Incentive Compensation Management Test

INCENTIVE COMPENSATION MANAGEMENT TEST

Progress

1.

Which key terms is related to sales?

Product or Service
Customer Retention Rate
Seller
All the above

2.

ICM stands for

Incentive Customer Management
Incentive Compensation Management
Integrated Compensation Management
Integrated Customer Management

3.

In Which type of commission the commission rate is proportional to the sales done by the payee?

Flat Commission
Tiered Commission
Straight Commission
None of the above

4.

Which commission can be paid as a percentage of sales only?

Base Plus commission
Tiered Commission
Straight Commission
None of the above

5.

Which table is associated with the Calendar?

Custom Table
View Table
Data Table
Structural Table

6.

Which table does not belong to the Hierarchy table type?

Payee
Account
Title
Time

7.

Which table type cannot be used as a data source for a calculation and can't be made into a global table?

System tables
Data Tables
View Tables
Structural Tables

8.

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

TRUE
FALSE

9.

Which table is a System Table?

Currency Table
Payee Table
Quota Table
Salesforce transactions Table

10.

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

Data
Structural
Custom
View

11.

Which two statements apply to Data tables? (Choose two.)

Data tables must contain a date-type column
Data tables must have a primary-key that consists of only one column
Data tables can have pick-listed columns
Data tables can be locked on two date columns

12.

Which table property can be changed after it is created?

Name
Description
Primary key
Type

13.

Connections can be searched in Navigation.

TRUE
FALSE

14.

The table name will not allow space.

TRUE
FALSE

15.

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

YES
NO

16.

Which table type should be used to store transactional information?

View
Data
Custom
Structural

17.

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

18.

What is the purpose of the global table? (Pick two)

Works similar to Connections.
Visible across the model.
Visibly different from table with Globe Icon.
Data cannot be imported into global table.

19.

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

YES
NO

20.

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

Payee
Time
Accounts
Currency

21.

Which two statements about Structural tables are true? (Choose two.)

They can only be generated when the model is created
Pick lists can pick from Structural tables
The primary key can be a date column
Structural tables always have a single-column primary key

22.

When joining these two tables using payeeid, how many rows will be returned?

4
2
3
5

23.

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

TRUE
FALSE

24.

What is the purpose of the “Anchor” tag while adding sources in Data Sources in Calculations?

Union
Outer Join
Left Outer Join
Join

25.

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

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

26.

Unions can be used when sources have a different number of columns.

TRUE
FALSE

27.

How the results of a calculation can be accessed from another component?

Using Global Option
Using Connections
Using Transform
Using Used by

28.

You cannot divide your calculated results into sub results based on columns that are selected from the data source

TRUE
FALSE

29.

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

30.

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

31.

Pick the type of rank that can be used in the Sort calculation.

Sort
Ascending
Dense
Descending

32.

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

33.

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.

34.

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

35.

The calculation can be created with one or more formulae.

TRUE
FALSE

36.

Which of the following action cannot be performed with Locked Calculation?

It will not allow us to edit the calculation source
It will not allow us to edit the restriction
It will allow us to edit the type of calculation and the partition of the calculation
All the above

37.

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

38.

Once a non-accumulating calculation is locked, which two aspects of the calculation can be changed? (Select two)

Sources
Partitions
Formula
Calendar

39.

What are the primary uses of Parameters in the Presenter Report? (Choose two).

To place restrictions or rules on the results.
To format the reports.
To share the reports with the Payees.
To make sure that report results are displayed only if the parameter condition is true.

40.

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

41.

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

42.

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

43.

Which of the following Transformations are available in the presenter report?

Aggregate Transformation
Computed Column
Transpose
All the above

44.

We can add Connection (Inbound/Outbound) as a data source in Data Store

TRUE
FALSE

45.

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

3
1
5
8

46.

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

Data Stores
Draw
Tailored Report
PLCM

47.

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

TRUE
FALSE

48.

Choose the appropriate option to perform the following.

Computed Column
Computed Row
Transpose
Aggregate Transformation

49.

Look into the below screen,

What type of formatting applied for the highlighted row?

Row Formatting
Column Formatting
Conditional Formatting
Formula

50.

What is the recommended action to be taken to make sure the payee has no access to modify a data store and the report in the model?

Remove him/her from payee table
Disable web access
Limit his access to view only
Remove him/her from Manage Users Option available in menu bar

51.

Custom colors cannot be used in charts.

TRUE
FALSE

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.

Which one is not true related to the single series chart?

It is used to display the results from one source.
It is used to display the results from multiple sources.
Legend option is available.
Link can be created in the chart.

54.

Identify the below incorrect statement.

Toggle editable - You can allow web users to edit existing data in Composer tables through Presenter data grids
You can enable a feature that allows web users to show or hide data grid columns
A column name can be renamed within the data grid
It is not necessary that the source should have at-least ONE ID key column for the sources to be transposed as desired

55.

Which statement is/are NOT correct regarding Layout Tables/Grid in Presenter?

Number of columns and rows can be changed at any time after it is defined
Every cell in report does not necessarily have an object rendered in it
Two different grids can have same name
A report can contain pictorial objects such as Image and Chart, etc...

56.

Workflow errors can be viewed only in the Audit Log.

TRUE
FALSE

57.

An employee is terminated from the Sales Reps group and you are asked to disable Web access for this employee. Which statement is true?

Sales Reps group is maintained in Manage Users
The rep needs to be deleted from the Payee table
Manage Web access for Sales Reps group in Portal Access
Disable Web access for the rep in Workflow Manager

58.

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

Action Node
Alert Node
Process Node
All the above

59.

Which of the following option is not true?

Groups created in Portal Access group can be maintained in Task Manager
Group members can see results for others in the same group.
Only Admin can access the Portal Access
All the above

60.

Which two types of Workflows would you create in Varicent? (Choose two.)

Admin-initiated
System-initiated
User-initiated
Auto-initiated

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