ICM | Incentive Compensation Management Test

INCENTIVE COMPENSATION MANAGEMENT TEST

Progress

1.

ICM stands for

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

2.

Commissions cannot be classified as a direct monetary benefit.

TRUE
FALSE

3.

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

4.

SPM stands for

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

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.

The table name will not allow space.

TRUE
FALSE

7.

Which table type should be used to store transactional information?

View
Data
Custom
Structural

8.

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

9.

Which table has the information regarding the calendar period in the model?

Time
Currency
Payee
Calendar

10.

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

11.

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

YES
NO

12.

Which table property can be changed after it is created?

Name
Description
Primary key
Type

13.

Which table does not belong to the Hierarchy table type?

Payee
Account
Title
Time

14.

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

Microsoft Excel files
Salesforce.com
Database Import
All the above

15.

Connections can be searched in Navigation.

TRUE
FALSE

16.

Data table must contain at least one

Date field
Pick List field
Numeric field
Text Box field

17.

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

18.

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

Payee
Time
Accounts
Currency

19.

Which data type is designed for longer text input?

Textbox
Pick List
URL
Comment

20.

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

Connection
Calculation
View Table
Calendar

21.

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.

22.

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

TRUE
FALSE

23.

Which two objects cannot be used as a source in creating a calculation?

Data Store
Views
Tables
Connection

24.

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

TRUE
FALSE

25.

Which two objects are associated with a calendar?

View
Data Table
Custom Table
Calculation

26.

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

Sort
Ascending
Dense
Descending

27.

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

28.

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

29.

When joining these two tables using payeeid, how many rows will be returned?

4
2
3
5

30.

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

User-Defined
Category
Sort
Time Shift

31.

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

32.

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

Sort
Time Shift
User Defined
Category

33.

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

34.

What are the options available while locking the calendar?

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

35.

Payee ID Amount

10001 150000

10002 275000

10003 312000

10004 363000

Your formula is Sum(Data. Value) and no display column is defined in the calculation. What is the output?

System will not allow to create the calculation.
150000
1100000
No values will be displayed

36.

The calculation can be created with one or more formulae.

TRUE
FALSE

37.

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

User Defined
Sort
Time Shift
Category

38.

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

Pick List
Numeric
Date
Text

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.

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”

41.

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

TRUE
FALSE

42.

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

43.

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.

44.

Choose the appropriate option to perform the following.

Computed Column
Computed Row
Transpose
Aggregate Transformation

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.

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

Aggregate Transformation
Computed Column
Transpose
All the above

47.

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

TRUE
FALSE

48.

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

49.

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

Row form Sources
Controls
Sources
Charts

50.

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

3
1
5
8

51.

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

52.

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

Right
Center
Left
Top Right

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.

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

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.

Node specific errors can be tracked only in Workflow Manager.

TRUE
FALSE

58.

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

Presenter Report
Document
View
External URL

59.

Which of the following option is not true?

Groups created in Portal Access group can be maintained in Task Manager
Group members can see results for others in the same group.
Only Admin can access the Portal Access
All the above

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'