ICM | Incentive Compensation Management Test

INCENTIVE COMPENSATION MANAGEMENT TEST

Progress

1.

ICM stands for

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

2.

In Which type of Compensation the payee gets payout even though no sales are made?

100% Commission
Revenue Commission
Base Salary + Commission
None of the above

3.

Which key terms is related to sales?

Product or Service
Customer Retention Rate
Seller
All 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.

Connections can be searched in Navigation.

TRUE
FALSE

6.

Which table type is automatically created when creating the model in Varicent?

System table
Data Table
Structural Table
View Table

7.

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

YES
NO

8.

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

Data
Structural
Custom
View

9.

The table name will not allow space.

TRUE
FALSE

10.

Table clearing cannot be undone.

TRUE
FALSE

11.

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

12.

Can a primary key be added after the table is created?

YES
NO

13.

Which table does not belong to the Hierarchy table type?

Payee
Account
Title
Time

14.

Pick Lists cannot be picked from (choose two)

Hierarchical Tables
Data Tables
Structural Tables
Custom Tables

15.

Data table must contain at least one

Date field
Pick List field
Numeric field
Text Box field

16.

A Primary Key uniquely identifies each row in a table.

TRUE
FALSE

17.

Which is not a valid data type to create the table in Varicent?

URL
Comment
String
Text

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.

Connections can be created using the global table.

TRUE
FALSE

20.

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

YES
NO

21.

Pick Lists can be picked from (Choose two.)

Hierarchical Tables
Data Tables
Structural Tables
Custom Tables

22.

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

TRUE
FALSE

23.

If you want to display the year-to-date value of transactions for each payee rather than the individual value of each transaction. Which of the following partition can be used?

Regular Partition
Accumulating Partition
Empty Partition
Partition by Payee and Partition by Period

24.

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

4
2
3
5

25.

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

26.

In Which calculation type, the preview option cannot be used?

Sort
Time Shift
User defined
Category

27.

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

28.

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

TRUE
FALSE

29.

You are creating a calculation with the Payment calculation(as shown below) as the source and Period as the only accumulating partition.
What will be the value of the record for Payee '0002' for the Period '2012,
February'?

$2500
$3500
$6000
$7000

30.

Which two objects cannot be used as a source in creating a calculation?

Data Store
Views
Tables
Connection

31.

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.

32.

When joining two data sources in a Data Store, what should you select to ensure that all records of the first data source will return, even if the join does not find matching records in the second data source?

Anchor Source rows
Right Outer Join
Full Outer Join
Include empty Partition

33.

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

34.

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

35.

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

36.

Which two column types should be used in the formula of a calculation? (Choose two.)

Pick List
Numeric
Date
Text

37.

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

38.

The calculation can be created with one or more formulae.

TRUE
FALSE

39.

Layout tables are not presentation components in the Presenter report.

TRUE
FALSE

40.

Choose the appropriate option to perform the following.

Computed Column
Computed Row
Transpose
Aggregate Transformation

41.

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

TRUE
FALSE

42.

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

3
1
5
8

43.

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

44.

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

45.

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.

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.

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

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.

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

TRUE
FALSE

50.

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

Data Stores
Draw
Tailored Report
PLCM

51.

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.

52.

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

53.

Which option is not available in charts?

Decimal Separator
Thousand Separator
Round
Number Scaling

54.

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

YES
NO

55.

The system allows the user to save the presenter when global action is running.

TRUE
FALSE

56.

Which statement is correct when creating a Portal Access tree?

It requires at least two groups to create a tree
It is limited to the complexity level of the hierarchy
It cannot have mutually exclusive hierarchies in one tree
It requires at least one group to create a tree

57.

How many nodes are available in the workflow manager?

3
4
5
2

58.

Node specific errors can be tracked only in Workflow Manager.

TRUE
FALSE

59.

Where can we create and define the inquiries, web tabs, sign off?

Work Flow
Presenter Report
Portal Access
All the above

60.

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

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