ICM | Incentive Compensation Management Test

INCENTIVE COMPENSATION MANAGEMENT TEST

Progress

1.

What are the various ICM products available other than Varicent? Choose two.

SAP Commission
Hana
Xactly incent Express
MongoDB

2.

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

Base Plus commission
Tiered Commission
Straight Commission
None of the above

3.

Which type of Compensation does not increase the Sales Productivity?

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

4.

ICM stands for

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

5.

Which two statements are benefits of adding effective-dates to tables? (Choose two.)

They make calculation restrictions easier to define
They provide a better audit trail for the data set
They provide another solution for deleting records
They prevent changes to data overtime

6.

Field names cannot be changed after the table is created.

TRUE
FALSE

7.

Pick Lists cannot be picked from (choose two)

Hierarchical Tables
Data Tables
Structural Tables
Custom Tables

8.

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

YES
NO

9.

Table clearing cannot be undone.

TRUE
FALSE

10.

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

11.

A Primary Key uniquely identifies each row in a table.

TRUE
FALSE

12.

Which table is associated with the Calendar?

Custom Table
View Table
Data Table
Structural Table

13.

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

Microsoft Excel files
Salesforce.com
Database Import
All the above

14.

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

15.

Which table is a System Table?

Currency Table
Payee Table
Quota Table
Salesforce transactions Table

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.

The table creation wizard can be found in ___

Palette
Navigation
Calendar
Audit

19.

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

Connection
Calculation
View Table
Calendar

20.

Connections can be created using the global table.

TRUE
FALSE

21.

Which two statements about Varicent ICM tables are correct? (Choose two.)

Primary keys are optional.
Primary keys in a Structural table must be Text box column
Data tables are associated with a calendar
Other tables can Pick List to a Custom table

22.

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

Using Global Option
Using Connections
Using Transform
Using Used by

23.

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

24.

Which type of calculation will be used to calculate the top performers?

Sort
Time Shift
User Defined
Category

25.

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

User-Defined
Category
Sort
Time Shift

26.

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

27.

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

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

28.

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

29.

You are creating a calculation to output only the results for the last month of
any quarter from the calculation QTD Payment. The Time table is joined twice in the month
and quarter level.

Which additional restriction is required on the second join to the Time table at the
quarter level?

"Time (Month)”. Starting = "Time (Quarter)". Starting
"Time (Month)". Ending = "Time (Quarter)". Ending
"Time (Month)". Name = "Time (Quarter)". Name
"Time (Month)". Parent = "Time (Quarter)". Name

30.

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

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.

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.

33.

You are applying a 5% commission to all transactions, except the transaction value less than $2000, which of the following formula can be used

SUM ((Source1.Value) * 0.05, Not (source1.Value < 2000))
IF (Source 1.value < 2000, Source1.Value * 0.05,0)
AND (Source1.Value < 2000, Source1.Value * 0.05)
Sourec1.value * 0.05

34.

A Compensation Plan that requires the following to be performed, ---------------Total Product sales for the month ---------------Determine the compensation rate based on sale amount and then calculating the compensation payout. How many calculations would you perform to achieve this?

1
2
3
4

35.

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

Sources
Partitions
Formula
Calendar

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.

What are the options available while locking the calendar?

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

38.

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

Pick List
Numeric
Date
Text

39.

What are the data components in the presenter report? (Pick two)

Row form Sources
Controls
Sources
Charts

40.

Look into the below screen,

What type of formatting applied for the highlighted row?

Row Formatting
Column Formatting
Conditional Formatting
Formula

41.

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

42.

Layout tables are not presentation components in the Presenter report.

TRUE
FALSE

43.

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

44.

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

TRUE
FALSE

45.

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

Data Stores
Draw
Tailored Report
PLCM

46.

Choose the appropriate option to perform the following.

Computed Column
Computed Row
Transpose
Aggregate Transformation

47.

An Administrator needs to create multiple computed columns in a Data Grid. What is the maximum number of computed columns that can be created ?

3
5
Unlimited
1

48.

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”

49.

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

50.

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

TRUE
FALSE

51.

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

52.

Which option is not available in charts?

Decimal Separator
Thousand Separator
Round
Number Scaling

53.

A part of a report may be extracted (say for instance, Chart) from it and linked within other reports, in the Newest Version of Varicent. (True/False)

TRUE
FALSE

54.

Custom colors cannot be used in charts.

TRUE
FALSE

55.

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

TRUE
FALSE

56.

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

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

57.

Which two types of source that can be used in creating new web tabs in the portal access?

Presenter Report
Document
View
External URL

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 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.

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

Work Flow
Presenter Report
Portal Access
All the above

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