Try Kinaxis : KX3-003 valid & accurate questions and answers

Kinaxis KX3-003 Exam Overview:

Kinaxis KX3-003 Exam Syllabus Topics:

Kinaxis Certified RapidResponse Author Level 3 Sample Questions:

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 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.
B) Create a $DmdCountry text workbook variable with the expression UserInGroup ($User,
'DemandPlanners'). Add the $DmdPlanners = TRUE expression to the worksheet.
C) 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 in the column properties conditionally hide the column using the $DmdCountry = False expression.
D) 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.

2.
The tables shown in the graphic are from an SQL database. Shaded fields indicate key fields in SQL.
Which three actions should you take to design this data model in RapidResponse? (Choose three.) Choose 3 answers

A) In the Item table, make Name plus Site into a reference to the ItemDetail table.
B) In the ItemDetail table, make Name plus Site into a reference to the Item table.
C) In the TransactionDetail table make ID, Owner, and Type into a reference to the TransactionHeader table.
D) In the TransactionHeader table, make ID, Owner, and Type into a reference to the TransactionDetail table.
E) In the TransactionDetail table, make ItemName plus ItemSite into a reference to the Item table.

3.
You need to create an expression that displays the number of the calendar week from the beginning of the year, for example, 01 January 2017 to 07 January 2017 = week 1. The calendar is based on a January to December fiscal year. The Calendar table has the values shown in the graphic.
Which expression would display the number of the calendar week?

A) (today + 0 Week)
B) (today + 0 Week) + 1
C) (today - (today + 0 Year) Week)
D) (today - (today + 0 Year) Week) +1

4. You have a worksheet based on the IndependentDemand table that includes columns for key fields plus multi-scenario columns for Quantity and EffectiveDemand. You want to highlight the Quantity fields where the value in the comparison scenario is different from the corresponding value in the workbook's baseline scenario. You want your worksheet to be able to highlight differences in several scenarios.
How would you achieve this highlighting?

A) Define the Quantity column to show Actual value; add a hidden multi-scenario column, QuantityDelta, to show Difference; then define conditional formatting for the Quantity column when their QuantityDelta field is not 0.
B) Define the Quantity column to show Difference, select the scenario comparison filtering option to show Only records with different comparison values, then define conditional formatting for the Quantity column when the respective value is not equal to 0.
C) Define the Quantity column to show Actual value, and define an additional hidden column, Quantity0, as !Quantity#0 using "Calculate using grouped results in the previous row or other results"; then define conditional formatting where the Quantity column is not equal to Quantity0.
D) Add a hidden multi-scenario column, RecordID, as show Differences; then define conditional formatting for the Quantity column where RecordID is not equal to 0.

5. You want to provide a worksheet based on the CRPOperation table to report destination location. There is only one valid stock location per operation. A secondary requirement is to view all valid work centers that feed a given stock location.
Which approach should you use to optimize performance?

A) Create a new table with references to the Location and CRPOperation tables.
B) Create a lookup worksheet based on the OnHand table that returns a set of locations.
C) Create a reference field on the CRPOperation table to the Location table.
D) Create a reference field on the Location table to the CRPOperation table.

Solutions: