ICM | Incentive Compensation Management Test

INCENTIVE COMPENSATION MANAGEMENT TEST

Progress

1.

Gross Margin Commission model is profitable to the organization.

TRUE
FALSE

2.

Xactly Incent is an ICM Product.

TRUE
FALSE

3.

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

4.

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

Base Plus commission
Tiered Commission
Straight Commission
None of the above

5.

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

TRUE
FALSE

6.

A Primary Key uniquely identifies each row in a table.

TRUE
FALSE

7.

The table name will not allow space.

TRUE
FALSE

8.

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

System table
Data Table
Structural Table
View Table

9.

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

10.

Field names cannot be changed after the table is created.

TRUE
FALSE

11.

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

12.

Which table property can be changed after it is created?

Name
Description
Primary key
Type

13.

Which table is a System Table?

Currency Table
Payee Table
Quota Table
Salesforce transactions Table

14.

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

15.

Which table is associated with the Calendar?

Custom Table
View Table
Data Table
Structural Table

16.

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

Microsoft Excel files
Salesforce.com
Database Import
All the above

17.

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

18.

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

URL
Comment
String
Text

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

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

Sort
Time Shift
User defined
Category

24.

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

25.

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

Sort
Ascending
Dense
Descending

26.

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

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.

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)

29.

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

TRUE
FALSE

30.

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

Union
Outer Join
Left Outer Join
Join

31.

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

Using Global Option
Using Connections
Using Transform
Using Used by

32.

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

TRUE
FALSE

33.

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

User-Defined
Category
Sort
Time Shift

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.

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

User Defined
Sort
Time Shift
Category

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.

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

Pick List
Numeric
Date
Text

38.

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

Sources
Partitions
Formula
Calendar

39.

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

40.

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

41.

Look into the below screen,

What type of formatting applied for the highlighted row?

Row Formatting
Column Formatting
Conditional Formatting
Formula

42.

Which types of values are available on presenter reports

Data, Numeric, Text
Variable, Stored, Constant
Stored, Calculated, Constant
Link, Constants, Picklist

43.

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

44.

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

3
1
5
8

45.

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

46.

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

TRUE
FALSE

47.

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

Aggregate Transformation
Computed Column
Transpose
All the above

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.

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.

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

51.

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

52.

Which option is not available in charts?

Decimal Separator
Thousand Separator
Round
Number Scaling

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.

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 workflow prevents the users from submitting additional data until the original submission is completed?

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

57.

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

Work Flow
Presenter Report
Portal Access
All the above

58.

Workflow can be copied.

True
False

59.

Can the Task Manager module be used to add the payees to your Portal Access groups?

YES
NO

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'