Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Kinaxis KX3-003 - Certified RapidResponse Author Level 3 Exam

Page: 1 / 2
Total 60 questions

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:Sum}

B.

COUNT IndependentDemands {Order.Customer:By}

C.

COUNT IndependentDemands {Order.Customer<>''}

D.

SUM IndependentDemands{Order.Customer:Sum}

At a customer site, there are multiple TimePhasedSafety records that are duplicated in the Baseline scenario. This is caused by the cross-scenario update from a child scenario.

What are two Kinaxis best practices for cross-scenario updates to prevent this situation? (Choose two.)

Choose 2 answers

A.

Include all key fields and all reference fields in the update to help the database clearly identify matching records.

B.

Identify fields that should be used to match records by making them read-only.

C.

List the identifying fields ahead of the other columns.

D.

Delete all records in Baseline before the update to allow the database to re-link records that have a corrupted version chain.

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 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.

B.

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.

C.

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.

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.

You are asked to create a worksheet that shows which process orchestration activity performers are late and how much they are late for each activity. There could be more than one performer per activity.

How would you accomplish this task?

A.

Create a worksheet based on the Assignment table in the ProcOrch namespace.

B.

Create a worksheet based on the Activity table in the ProcOrch namespace.

C.

Create a worksheet based on the ProcessInstance table in the Mfg namespace.

D.

Create a worksheet on the Activity table in the Mfg namespace.

You want to enable data caching on the worksheet shown in the graphic.

Which two actions will accomplish this task? (Choose two.)

Choose 2 answers

A.

Remove the bucketing by DueDate.

B.

Remove the hierarchy column.

C.

Remove the currency column.

D.

Disable the Use As Reference checkbox on the Part column.

You have a crosstab, bucketed worksheet that shows forecast records. There are forecast records on the first workday of every month for 18 months from the Planning Date. The bucket settings are set for 52 Weeks from the Planning Date. You want to improve performance for this worksheet, but still display it as a crosstab worksheet. You also want to display one year's worth of forecast records.

How would you accomplish this task?

A.

Change the bucket settings to display 365 Everyday from the Planning Date.

B.

Turn off the bucket settings for this worksheet and add an expression to filter out records that are beyond the one year horizon.

C.

Turn off grouping settings for this worksheet and add an expression to filter out records that are beyond the one year horizon.

D.

Change the bucket settings to display 18 Months from the Planning Date and add an expression to filter out records that are beyond the one year horizon.

You want to control how available dates are calculated for your vendor managed parts' supplies and demands.

In this situation, which control table would you need to configure?

A.

AvailableRule

B.

DemandType

C.

OrderPolicy

D.

SupplyType

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.

( Lookup({Part.Name,Part.Site.Value, DueDate}, LKPScheduledReceipt!, “N”, LKPScheduledReceipt!Exists) = “N” )

B.

NOT {Part, DueDate} IN LKPScheduledReceipt!

C.

NOT IsNull ( Lookup ({Part.Name, Part.Site.Value, DueDate}, LKPScheduledReceipt!, Null(Mfg::ScheduledReceipt), Exact, LKPScheduledReceipt!Self ))

D.

NOT {Part.Name, Part.Site.Value, DueDate} IN LKPScheduledReceipt!

You want to identify the buyer responsible for the component part in a worksheet based on the BillofMaterial table. Additionally, you want to have the option of inviting that buyer to a collaboration, messaging that buyer, and sharing a scenario with them.

Which set of column expressions and configuration changes will enable this capability?

A.

Create a column with an expression of Responsibility($Role_Buyers, Component). On the Column Formatting tab, Check the "Display as user name" checkbox.

B.

Create a column with an expression of Responsibility($Role_Buyers, Component). On the Column Formatting tab, Check the "Display as image" checkbox and select an appropriate image.

C.

Create a column with an expression of Responsibility($Role_Buyers, Component.Name). On the Column Formatting tab, Check the "Display as user name" checkbox.

D.

Create a column with an expression of Responsibility($Role_Buyers, Component.Name). On the Column Formatting tab, Check the "Display as image" checkbox and select an appropriate image.

Given the following order policies:

    MultipleQty: 10

    MinimumQty: 15

    MultipleUsage: Use

    MinimumUsage: Use

Referring to the graphic, what are the sizes of the three planned orders A, B, and C?

A.

A = 30, B = 20, C = 20

B.

A = 30, B = 15, C = 15

C.

A = 30, B = 15, C = 10

D.

A = 25, B = 15, C = 15