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 type of Compensation does not increase the Sales Productivity?

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

3.

Which element does not belong to the ICM?

Data Integration
Scale
Payout
Reports

4.

Gross Margin Commission model is profitable to the organization.

TRUE
FALSE

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.

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

System table
Data Table
Structural Table
View Table

7.

Which table type is created by joining one or more tables or calculations together?

Data
Hierarchy
Custom
View

8.

Data table must contain at least one

Date field
Pick List field
Numeric field
Text Box field

9.

In which two situations should Pick Lists to be used in a table? (Choose two.)

When there can be more than a few thousand unique values
To enforce the column to be "not null"
When the data exists in another table
To ensure data integrity

10.

Field names cannot be changed after the table is created.

TRUE
FALSE

11.

Which table property can be changed after it is created?

Name
Description
Primary key
Type

12.

Pick Lists cannot be picked from (choose two)

Hierarchical Tables
Data Tables
Structural Tables
Custom Tables

13.

Which table type should be used to store transactional information?

View
Data
Custom
Structural

14.

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

YES
NO

15.

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

YES
NO

16.

The table name will not allow space.

TRUE
FALSE

17.

Pick Lists can be picked from (Choose two.)

Hierarchical Tables
Data Tables
Structural Tables
Custom Tables

18.

The table creation wizard can be found in ___

Palette
Navigation
Calendar
Audit

19.

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.

20.

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

YES
NO

21.

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

URL
Comment
String
Text

22.

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

Sort
Time Shift
User defined
Category

23.

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

24.

When using an effective dated table as a source for a calculation, which two statements are true for better performance?

Join Start date and end date of the effective dated table to a single date
Join the calendar table to the effective dated table
Join on both effective dates
Join an effective dated table to another effective dated table (not Time)

25.

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

TRUE
FALSE

26.

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

27.

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

28.

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

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

29.

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

Union
Outer Join
Left Outer Join
Join

30.

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

31.

What is the impact of locking Calendar in the calculations?

It affects calculations partitioned by the same calendar
It has no effect on any calculations in the model
It affects every calculation in the model regardless of calendars used
It only affects calculations related to payout

32.

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

33.

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

10
12
7
3

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.

In which calculation, the record per partition option will be available?

User Defined
Sort
Time Shift
Category

36.

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

Pick List
Numeric
Date
Text

37.

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

38.

What are the options available while locking the calendar?

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

39.

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

Connection
Calculation
Table
None of the above

40.

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

TRUE
FALSE

41.

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

3
1
5
8

42.

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

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.

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

45.

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

Row form Sources
Controls
Sources
Charts

46.

Look into the below screen,

What type of formatting applied for the highlighted row?

Row Formatting
Column Formatting
Conditional Formatting
Formula

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.

Layout tables are not presentation components in the Presenter report.

TRUE
FALSE

49.

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

Data Stores
Draw
Tailored Report
PLCM

50.

The user wants the column “Contract Type” to be HIDDEN in the report. How can it be effectively implemented so it can be used in the future?

By selecting and Hiding the column in Grid
By removing the column in Report Data Source
By deleting the column in Data Store in “Display Columns”
By altering the calculation to delete the column

51.

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

YES
NO

52.

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

53.

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

TRUE
FALSE

54.

A report has to be set to exportable to an excel file from Web Client. How can this be achieved?

Enable Enquiry Copy
Paginated
Enable Export to Microsoft excel
Show Section Header

55.

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.

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 two types of Workflows would you create in Varicent? (Choose two.)

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

59.

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

Presenter Report
Document
View
External URL

60.

Workflow errors can be viewed only in the Audit Log.

TRUE
FALSE

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