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.

SPM stands for

Software Process Model
Software Project Management
Sales Performance Management
Statistical Parametric Mapping

3.

Choose the main lever/levers of SPM

Resource Management
Process Management
Incentive Compensation Management
All the above

4.

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

5.

Table clearing cannot be undone.

TRUE
FALSE

6.

Can we add records for the locked period in the data table?

YES
NO

7.

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

Microsoft Excel files
Salesforce.com
Database Import
All the above

8.

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

YES
NO

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.

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.

Field names cannot be changed after the table is created.

TRUE
FALSE

12.

The table name will not allow space.

TRUE
FALSE

13.

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

Data
Structural
Custom
View

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.

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

16.

Which table property can be changed after it is created?

Name
Description
Primary key
Type

17.

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

YES
NO

18.

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

19.

Pick Lists can be picked from (Choose two.)

Hierarchical Tables
Data Tables
Structural Tables
Custom Tables

20.

The table creation wizard can be found in ___

Palette
Navigation
Calendar
Audit

21.

Which hierarchy table cannot be viewed as a table in Composer?

Payee
Time
Accounts
Currency

22.

Which two objects are associated with a calendar?

View
Data Table
Custom Table
Calculation

23.

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

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.

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

26.

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.

27.

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

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.

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

User-Defined
Category
Sort
Time Shift

30.

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

TRUE
FALSE

31.

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

TRUE
FALSE

32.

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

Sort
Time Shift
User Defined
Category

33.

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

34.

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

User Defined
Sort
Time Shift
Category

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.

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

Pick List
Numeric
Date
Text

37.

What are the options available while locking the calendar?

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

38.

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

Sources
Partitions
Formula
Calendar

39.

Layout tables are not presentation components in the Presenter report.

TRUE
FALSE

40.

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

41.

Which types of values are available on presenter reports

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

42.

Look into the below screen,

What type of formatting applied for the highlighted row?

Row Formatting
Column Formatting
Conditional Formatting
Formula

43.

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

Row form Sources
Controls
Sources
Charts

44.

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

Connection
Calculation
Table
None of the above

45.

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

TRUE
FALSE

46.

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

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.

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.

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

3
1
5
8

50.

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

51.

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

52.

Layout tables help you to organize your report.

TRUE
FALSE

53.

Which alignment option cannot be performed on a Column in the Grid?

Right
Center
Left
Top Right

54.

Which option is not available in charts?

Decimal Separator
Thousand Separator
Round
Number Scaling

55.

Custom colors cannot be used in charts.

TRUE
FALSE

56.

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

57.

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

YES
NO

58.

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

59.

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

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

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'