[May-2024] Kinaxis KX3-003 Exam Basic Questions With Answers [Q28-Q42]

NO.28 Your suppliers need to receive a report listing their outstanding purchase orders. Each supplier should receive the report in the same format but it should only display the purchase orders associated with their supplier ID.
Based on this situation, which two actions will be required to support this requirement? (Choose two.) Choose 2 answers

Define a profile variable to assign the supplier ID to the supplier’s user group. Add the profile variable to the filter expression in the workbook.

Define a list workbook variable to provide a selector for the supplier list. Add the workbook variable to the filter expression in the workbook.

Assign a master Supplier group in the Advanced properties of the Alert properties window.

Add the supplier’s user group in the Notify tab of the Alert properties window.

NO.29 You want to provide a worksheet based on the CRPOperation table to report destination location. There is only one valid stock location per operation. A secondary requirement is to view all valid work centers that feed a given stock location.
Which approach should you use to optimize performance?

Create a reference field on the Location table to the CRPOperation table.

Create a reference field on the CRPOperation table to the Location table.

Create a lookup worksheet based on the OnHand table that returns a set of locations.

Create a new table with references to the Location and CRPOperation tables.

NO.30 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?

AvailableRule

DemandType

OrderPolicy

SupplyType

NO.31

You shared your scheduled task, shown in the graphic, with a set of users who do not have access to all the resources used in the task.
In this situation, which statement is true?

The users can run the task using your resource access.

The users cannot run or schedule the task.

The required resources are shared along with the task.

The users can specify their own resources for the task.

NO.32

You want to enter a forecast for 6000 units of part 89-Prod0966 in the June 8 bucket. You expect that three records will be inserted into the IndependentDemand table (equal quantities of 2000 at each of the three sites); however, you get an error.
Which action would solve the error?

Change the table that the spreading worksheet is based on, from Part to IndependentDemand.

Map the column id Name to Part.Name in the Forecast worksheet.

Map the column id Site to Part.Site in the Forecast worksheet.

Add a Date column to the spreading worksheet.

NO.33 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?

COUNT IndependentDemands {Order.Customer:Sum}

COUNT IndependentDemands {Order.Customer:By}

COUNT IndependentDemands {Order.Customer<>”}

SUM IndependentDemands{Order.Customer:Sum}

NO.34

You are creating a new script that must insert a new customer record, archive that record weekly in a new scenario, and then commit the child scenario to a parent scenario. You already have a script that commits child scenarios.
Referring to the graphic, which code will call the script that commits child scenarios in your new script?

I

II

III

IV

NO.35 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’, ‘B’, ‘C’

‘A, B, C’

A, B, C

NO.36 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?

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.

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.

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.

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.

NO.37

The graphic shows the Carrier table view in the data model dialog.
Which three statements about this table are true? (Choose three.)
Choose 3 answers

Multiple Delivery Routes can reference a carrier.

Each carrier can have multiple Transit Calendars.

Multiple Shipments can reference a carrier.

Several carriers can share the same Default Transportation Mode.

A carrier must only have one Source.

NO.38 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?

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

NOT {Part, DueDate} IN LKPScheduledReceipt!

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

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

NO.39 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?

Use the first date in the bucket.

Use the first date in the bucket adjusted by three workdays.

Use the last workday in the bucket.

Use the MRPDate.

NO.40

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?

I

II

III

IV

NO.41

You are asked to create a worksheet that contains fields from four tables.
Referring to the graphic, which table should your worksheet be based on to optimize performance?

Table 1

Table 2

Table 3

Table 4

NO.42 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 level in the PartFamily hierarchy uses the Part.Solutions::PartClass.Value expression.

A level in the PartFamily hierarchy uses the Part.ProductFamily.Value expression.

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 + “)”.

A level in the PartFamily hierarchy uses the Part.Name + ” (” + Part.Description +”)” expression.