KX3-003 Certified RapidResponse Author Level 3 Free Demo Questions – Try Before You Buy

Question 1

You are asked to restrict a worksheet so that users can only see data for the demand of the countries

that they should have permission to see. A field has been added to the IndependentDemand table, which

is a reference to a custom table called Country. Each user may have permission to see the demands

from one or more countries, and each country can be seen by one or more users. They should be able to
see data from multiple countries in the worksheet at the same time.
In this scenario, what should you do to enable this capability?

A

Create a $DmdCountry list workbook variable with a query generated list of values based on the

in the column properties conditionally hide the column using the $DmdCountry = False expression.

Country table. Add the expression UserInGroup ($User, 'DemandPlanners') to the variable filter and then

B

Create a $DmdCountry text workbook variable with the expression UserInGroup ($User,

'DemandPlanners'). Add the $DmdPlanners = TRUE expression to the worksheet. C

Build a Responsibility definition based on the Country table and assign the users to all of the countries

that they should have permission to see. Add a responsibility column to the worksheet so users can
select their country.

D

Create a $DmdCountry profile variable and assign the country names to each user. Add the

expression IF ($DmdCountry = "'*'", TRUE, User::DmdCountry IN eval($DmdCountry)) to the worksheet
filter.

Correct Answer: D

Explanation:

This setup allows for flexible data visibility based on user permissions. By creating a profile variable that

contains the allowed countries for each user, you can then apply a filter expression to the worksheet that
evaluates this variable. If a user is permitted to see all countries (indicated by an asterisk '*'), the
expression returns TRUE, otherwise, it checks if the demand's country is in the user's permitted list.
References:
Kinaxis RapidResponse documentation on configuring data visibility through profile variables and
worksheet filters.
Kinaxis training materials on setting up user permissions and responsibility definitions.

Question 2

You are creating an insert definition to insert records using a crosstab worksheet, which contains weekly buckets that begin on Monday. You want the inserted records to be due on Friday of that week but if Friday is a non-workday, you want the inserted record to be due on Thursday.

In this situation, how would you set the bucket date in the insert definition?

A

Use the first date in the bucket.

B

Use the first date in the bucket adjusted by three workdays.

C

Use the last workday in the bucket.

D

Use the MRPDate.

Correct Answer: C

Explanation:

When setting the bucket date in an insert definition, if the requirement is to have the record due on the last workday of the week (which is Friday or Thursday if Friday is a non-workday), then the correct approach is to configure the insert definition to use the last workday in the bucket. This will ensure that the due date falls on the correct day according to the specified requirement.
References The Kinaxis Rapid Response documentation details how to use bucket dates and adjust them according to workdays in the insert definition setup for crosstab worksheets.

Question 3

Given the worksheet properties shown in the exhibit, which console output would exist for the following script?
var dataForInsert = [['1','BBy-LCD37','DC-Europe','DCRequest','LCD-3735','DC-Europe','06-01-20',147]];
var wbOrderChng = rapidResponse.workbooks.get({name:'Change Orders',scope:'Private'}, {scenarios: [scenario], filter: {name: 'All Parts', scope: 'Public'}, siteGroup: {name: site, scope: 'Public'}});
var wsOrderChng = wbOrderChng.worksheets.get('ChangeOrders');
var importResult = wsOrderChng.importData(dataForInsert); rapidResponse.console.writeLine(JSON.stringify(importResult));

A

{"deleted":0,"modified":0,"inserted":1}

B

1 record(s) inserted

C

error 455: "importData failed. Delete modify not permitted"

D

{"deleted":-1,"modified":-1,"inserted":1}

Correct Answer: A

Explanation:

The script is performing a data import operation into a worksheet that is configured to allow importing data for the purpose of inserting records, as shown in the worksheet properties exhibit. The JSON object in the console output would reflect the result of this import operation. The object details the number of records deleted, modified, and inserted. Since the worksheet is set up only to allow insertion, and the script is importing data for insertion, the "inserted" key would have a value of 1, and "deleted" and "modified" would have a value of 0, indicating a successful insert without any deletions or modifications.
References Kinaxis Rapid Response documentation for data importing and console operations would support this behavior, outlining how the import Data method interacts with worksheet configurations.

Demo Kinaxis KX3-003 Exam Questions

You are asked to restrict a worksheet so that users can only see data for the demand of the countries

that they should have permission to see. A field has been added to the IndependentDemand table, which

is a reference to a custom table called Country. Each user may have permission to see the demands

from one or more countries, and each country can be seen by one or more users. They should be able to
see data from multiple countries in the worksheet at the same time.
In this scenario, what should you do to enable this capability?

Create a $DmdCountry list workbook variable with a query generated list of values based on the

Country table. Add the expression UserInGroup ($User, 'DemandPlanners') to the variable filter and then

Create a $DmdCountry text workbook variable with the expression UserInGroup ($User,

Build a Responsibility definition based on the Country table and assign the users to all of the countries

Create a $DmdCountry profile variable and assign the country names to each user. Add the

Correct Answer: D

This setup allows for flexible data visibility based on user permissions. By creating a profile variable that

You are creating an insert definition to insert records using a crosstab worksheet, which contains weekly buckets that begin on Monday. You want the inserted records to be due on Friday of that week but if Friday is a non-workday, you want the inserted record to be due on Thursday.

In this situation, how would you set the bucket date in the insert definition?

Use the first date in the bucket.

Use the first date in the bucket adjusted by three workdays.

Use the last workday in the bucket.

Use the MRPDate.

Correct Answer: C

{"deleted":0,"modified":0,"inserted":1}

1 record(s) inserted

error 455: "importData failed. Delete modify not permitted"

{"deleted":-1,"modified":-1,"inserted":1}

Correct Answer: A

Demo Practice Mode

Demo Kinaxis KX3-003 Exam Questions

You are asked to restrict a worksheet so that users can only see data for the demand of the countries

that they should have permission to see. A field has been added to the IndependentDemand table, which

is a reference to a custom table called Country. Each user may have permission to see the demands

from one or more countries, and each country can be seen by one or more users. They should be able tosee data from multiple countries in the worksheet at the same time.In this scenario, what should you do to enable this capability?

Create a $DmdCountry list workbook variable with a query generated list of values based on the

Country table. Add the expression UserInGroup ($User, 'DemandPlanners') to the variable filter and then

Create a $DmdCountry text workbook variable with the expression UserInGroup ($User,

Build a Responsibility definition based on the Country table and assign the users to all of the countries

Create a $DmdCountry profile variable and assign the country names to each user. Add the

Correct Answer: D

This setup allows for flexible data visibility based on user permissions. By creating a profile variable that

You are creating an insert definition to insert records using a crosstab worksheet, which contains weekly buckets that begin on Monday. You want the inserted records to be due on Friday of that week but if Friday is a non-workday, you want the inserted record to be due on Thursday.

In this situation, how would you set the bucket date in the insert definition?

Use the first date in the bucket.

Use the first date in the bucket adjusted by three workdays.

Use the last workday in the bucket.

Use the MRPDate.

Correct Answer: C

{"deleted":0,"modified":0,"inserted":1}

1 record(s) inserted

error 455: "importData failed. Delete modify not permitted"

{"deleted":-1,"modified":-1,"inserted":1}

Correct Answer: A

Demo Practice Mode

from one or more countries, and each country can be seen by one or more users. They should be able to
see data from multiple countries in the worksheet at the same time.
In this scenario, what should you do to enable this capability?