ICM | Incentive Compensation Management Test

INCENTIVE COMPENSATION MANAGEMENT TEST

Progress

1.

Xactly Incent is an ICM Product.

TRUE
FALSE

2.

Which type of Compensation does not increase the Sales Productivity?

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

3.

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

Base Plus commission
Tiered Commission
Straight Commission
None of the above

4.

In Which form of commission the payee does not get any payout when no sales are made?

100% Commission
Straight Commission
Revenue Commission
Attainment based Commission

5.

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

Data
Structural
Custom
View

6.

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

TRUE
FALSE

7.

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

8.

Which table is associated with the Calendar?

Custom Table
View Table
Data Table
Structural Table

9.

The table name will not allow space.

TRUE
FALSE

10.

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

Data
Hierarchy
Custom
View

11.

Connections can be searched in Navigation.

TRUE
FALSE

12.

Pick Lists cannot be picked from (choose two)

Hierarchical Tables
Data Tables
Structural Tables
Custom Tables

13.

Data table must contain at least one

Date field
Pick List field
Numeric field
Text Box field

14.

Which table is a System Table?

Currency Table
Payee Table
Quota Table
Salesforce transactions Table

15.

Which table type should be used to store transactional information?

View
Data
Custom
Structural

16.

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

System table
Data Table
Structural Table
View Table

17.

The table creation wizard can be found in ___

Palette
Navigation
Calendar
Audit

18.

Pick Lists can be picked from (Choose two.)

Hierarchical Tables
Data Tables
Structural Tables
Custom Tables

19.

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

20.

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

URL
Comment
String
Text

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.

Which two objects are associated with a calendar?

View
Data Table
Custom Table
Calculation

23.

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

24.

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

25.

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.

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.

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

10
12
7
3

28.

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

Sort
Time Shift
User defined
Category

29.

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

User-Defined
Category
Sort
Time Shift

30.

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

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.

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

TRUE
FALSE

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.

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

35.

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

36.

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

User Defined
Sort
Time Shift
Category

37.

The calculation can be created with one or more formulae.

TRUE
FALSE

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

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

TRUE
FALSE

42.

Choose the appropriate option to perform the following.

Computed Column
Computed Row
Transpose
Aggregate Transformation

43.

Which types of values are available on presenter reports

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

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

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.

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

3
1
5
8

48.

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

49.

Layout tables are not presentation components in the Presenter report.

TRUE
FALSE

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.

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.

Custom colors cannot be used in charts.

TRUE
FALSE

53.

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

54.

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

55.

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

YES
NO

56.

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

YES
NO

57.

How many nodes are available in the workflow manager?

3
4
5
2

58.

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

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.

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

Presenter Report
Document
View
External URL

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