Kinaxis Certified RapidResponse Author Level 3 Sample Questions:

1.
You want to define a custom data structure connecting BuyerCode to additional information: Manager, Department, and Floor. A manager might be responsible for more than one department. You expect that users will want to filter this information on combinations of each of those data elements.
Referring to the graphic, which data model structure should you use?

A) IV
B) I
C) II
D) III

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 MRPDate.
C) Use the last workday in the bucket.
D) Use the first date in the bucket adjusted by three workdays.

3. You are building a worksheet for supplier collaboration and you want to assign a profile variable, Suppliers, so each user can see data for their own list of suppliers.
You include an expression in your sheet reporting the ScheduledReceipt table:
Order.Supplier IN ListAsSet($Suppliers)
Which string would you enter for the Suppliers profile variable for a user that should see data for suppliers A, B and C?

A) 'A', 'B', 'C'
B) A, B, C
C) 'A, B, C'
D) A\, B\, C

4. You are creating a resource that is designed to evaluate the impact of converting planned orders to scheduled receipts. After the evaluation is complete, you want to provide users the opportunity to push their changes to the parent scenario. Users will be using their scenarios to consider changes to lead time, constraint available, and other planning parameters. The company policy stipulates that lead times cannot be adjusted in any shared scenarios.
What should you do to accomplish this task?

A) Apply a perspective when creating your scenario.
B) Export your changes to a .tab file and import to a scenario.
C) Restrict the user to view only access to the parent scenario.
D) Develop a cross scenario data change.

5. You are asked to report data based on the ScheduledReceipt table that also displays information from a custom table, WorkOrderInfo. There will be at most one WorkOrderInfo record for any ScheduledReceipt record and WorkOrderInfo will be used often in worksheets reporting ScheduledReceipt data.
Following Kinaxis best practices, what should you do to accomplish this task?

A) 1. Create a composite worksheet using two component worksheets, ScheduledReceipt and WorkOrderInfo.
2. Use left join and grouping to align the two sets of data.
B) 1. Create a reference field on the WorkOrderInfo table to the ScheduledReceipt table.
2. Display relevant work order data in worksheets based on the WorkOrderInfo table and the referenced ScheduledReceipt table.
C) 1. Create two worksheets: one based on ScheduledReceipts and one based on WorkOrderInfo.
2. Create a column in the ScheduledReceipts worksheet to lookup values in the WorkOrderInfo worksheet.
D) 1. Create a reference field on the ScheduledReceipt table to the WorkOrderInfo table.
2. Display relevant work order data in worksheets based on the ScheduledReceipt table and the referenced WorkOrderInfo table.

Solutions: