KX3-003 exam

Which two violations of Kinaxis best practice are shown in the graphic? (Choose two.) A. The key field contains the table name. B. The Line should be a number field. C. The deployment name prefix is included in the OrderId field. D. OnTimeQty should specify the data type in the...

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 graphic shows a path to generate a list of customer prices with record counts for each table in the path. Given the following filter expression: Part.ProductNumber.ProductGroup.ProductFamily In ('bikes','trikes') AND Customer.Country IN ("US", "CA") In this situation, what is the chosen line of descent from the query engine?A . Country...

You have a worksheet showing work orders. You are asked to report the date used to convert the calculated field EffectiveUnitPrice. Which expression will accomplish this task?A . DATEVALUE(EffectiveUnitPrice)B . CONVERTONDATE(EffectiveUnitPrice, $ConversionDate)C . DATETIMEVALUE(EffectiveUnitPrice)D . ASSOCIATEDDATE(EffectiveUnitPrice)View AnswerAnswer: B Explanation: To report the date used to convert the calculated field EffectiveUnitPrice,...

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

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?A . Group the component worksheets by Part.Name, Part.Site and Order.ID. In the composite worksheet...

You want to compare the performance of two similar worksheets in a private scenario, but you need to ensure that neither worksheet takes advantage of cached results. In this situation, before capturing the performance results, how would you accomplish this task?A . Close the workbook and reopen it.B . Close...

You are asked to create a workbook that identifies the change in IndependentDemandAvailableDate in workdays from a child scenario to its parent. Which worksheet properties shown in the graphic identifies the correct configuration and expression?A . IB . IIC . IIID . IVView AnswerAnswer: B Explanation: The worksheet properties shown...

You need to create a workbook to allow users to manage their demand forecast by product, customer region, and distribution site. You also want to simplify user controls and use hierarchies to allow each user to make several selections in the same hierarchy. In this situation, which two actions should...

You need to create a new custom field to be used for record filtering that will be populated with the salesperson's name. Each order will have a single associated salesperson's name. Following database design principles and Kinaxis best practices, which action accomplishes this task?A . Create a new Salesperson table...