Kinaxis KX3-003 問題集

質問 1：
You are required to troubleshoot a workbook designed to spread values across a specified time horizon. The start and end bucket dates are mapped to variables used in the spreading worksheet. The bucket field is not mapped to a column in the editing worksheet.
Which two actions would solve this issue? (Choose two.)
Choose 2 answers
A. Remove the unmapped columns from the editing worksheet.
B. Add a column to the spreading worksheet to map the bucket dates.
C. Select the "Use same spreading worksheet values for all edits" check box.
D. Select the "Allow editing only if all buckets are the same size" check box.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
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 referenced by the DemandOrder table.
B. Create a new Salesperson table referenced by the IndependentDemand table.
C. Create a new Salesperson table referenced by the Customer table.
D. Add a Salesperson string field on the DemandOrder table.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You have a hierarchy called PartFamily that is based on the PartCustomer table. There is a second hierarchy in use, also based on the PartCustomer table called PartPlanner. When the PartFamily hierarchy is used, performance is noticeably worse than when the PartPlanner hierarchy is used.
In this situation, which design issue would contribute most to poor performance?
A. A level in the PartFamily hierarchy uses the Part.Name + " (" + Part.Description +")" expression.
B. A level in the PartFamily hierarchy uses the Part.ProductFamily.Value expression.
C. A level in the PartFamily hierarchy uses the expression Part.AGCP::NameAndDescription.
NameAndDescription is a calculated field in the AGCP namespace. The calculation is Name + " (" + Description + ")".
D. A level in the PartFamily hierarchy uses the Part.Solutions::PartClass.Value expression.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
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 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.
B. 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.
C. 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.
D. 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
解説: (Topexam メンバーにのみ表示されます)

質問 5：

You have a new demand for 800 units of a product. SourceRule.AllotmentRule for this part is set to OnGoing.
Referring to the graphic, which planned order results will be created to satisfy this demand?
A. Supplier1: quantity 250
Supplier2: quantity 750
B. Supplier1: quantity 1000
C. Supplier1: quantity 750
Supplier2: quantity 250
D. Supplier2: quantity 1000
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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. Instead of using Order.ID, Order.Site, Order.Type, and Line replace them with a column that concatenates those values and use it as a group by column.
B. Group the component worksheets by Part.Name, Part.Site and Order.ID. In the composite worksheet group by Order.Type, Order.Type.ControlSet and Line.
C. Ensure that the sort order and sort direction used in both worksheets are the same.
D. Instead of using Part.Name and Part.Site, use Part as a reference in both worksheets.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 7：

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. I
B. III
C. II
D. IV
正解：C
解説: (Topexam メンバーにのみ表示されます)