Kinaxis Certified RapidResponse Author Level 3 Sample Questions:

1. You are asked to transform PlannedOrder data into new ScheduledReceipt records, assuming just one PartSource per part and no maximum quantity. You need to filter the PlannedOrder records to ensure you do not try to create any ScheduledReceipt records which already exist. The workbook includes a worksheet, LKPScheduledReceipt, on existing converted ScheduledReceipts and follows Kinaxis best practices.
In this situation, which filter expression will follow KInaixs best practices and provide the best performance to include PlannedOrder records that do not match existing ScheduledReceipt records?

A) NOT IsNull ( Lookup ({Part.Name, Part.Site.Value, DueDate}, LKPScheduledReceipt!, Null(Mfg::ScheduledReceipt), Exact, LKPScheduledReceipt!Self ))
B) ( Lookup({Part.Name,Part.Site.Value, DueDate}, LKPScheduledReceipt!, "N", LKPScheduledReceipt!Exists) = "N" )
C) NOT {Part, DueDate} IN LKPScheduledReceipt!
D) NOT {Part.Name, Part.Site.Value, DueDate} IN LKPScheduledReceipt!

2. You want to create a workbook command that deletes records in theHistoricalDemandActual table that are more than a year old. You want to perform this action automatically once a week, without having to manually run the command.
In this situation, which two statements are true? (Choose two.)

A) The worksheet with the automation settings to run the command must be based on the HistoricalDemandActual table.
B) The worksheet with the automation settings to run the command must not have any worksheet filtering set.
C) You must create a Scheduled Task to run this command once a week.
D) The command must be run as part of an Automation Chain.

3. You are developing a worksheet that will be used to run a script through a form. For the script to work properly, you will need to pass information from two columns as script arguments.
Which two actions will accomplish this task? (Choose two.)
Choose 2 answers

A) Map the Form controls to Script arguments.
B) Select the columns when mapping drill links to forms.
C) Match the script arguments names with the Form controls ID.
D) Select the columns when setting an Open Form Command.

4. You have a worksheet based on the Part table. You want to know the total number of unique customers that have orders for each part.
Which expression accomplishes this task?

A) COUNT IndependentDemands {Order.Customer<>''}
B) COUNT IndependentDemands {Order.Customer:By}
C) COUNT IndependentDemands {Order.Customer:Sum}
D) SUM IndependentDemands{Order.Customer:Sum}

5.
Which two violations of Kinaxis best practice are shown in the graphic? (Choose two.) Choose 2 answers

A) The key field contains the table name.
B) The deployment name prefix is included in the OrderId field.
C) The Line should be a number field.
D) OnTimeQty should specify the data type in the field name.

Solutions: