Free Online Kinaxis KX3-003 Practice Test

var dataArray = [[line, orderNo, site, orderType, partName, site, dueDate, quantity]];

var dataSettings = {scenarios: [scenario], filter: fAllParts, siteGroup: sgSite}

var wbOrderChng = rapidResponse.workbooks.get({name:'Change Orders', scope:'Private'}, dataSettings);

var cmdDeleteData= wbOrderChng.commands.get('DeleteData');

var wsOrderChng = wbOrderChng.worksheets.get('ChangeOrders')

Which two lines of code would potentially delete records in a table if they appeared after the code shown in

the exhibit? (Choose two.)

Choose 2 answers

You are creating a metric worksheet to calculate the number of late orders for a specified time period. The metric worksheet will be based on the IndependentDemand table and it has two columns: DueDate and Count. The expression for Count is 1. The worksheet's filter expression is: DaysLate > 0 and Order.Type = 'Actual'. In this situation, what is the column sequence and grouping properties for the metric worksheet?

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?

You want to create a composite worksheet using two component worksheets. The group by columns in both worksheets are Part.Name, Part.Site, Order.ID, Order.Site, Order.Type, Order.Type.ControlSet, and Line. How would you improve performance of the composite worksheet?

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?