[2024] Get Top-Rated Kinaxis KX3-003 Exam Dumps Now [Q29-Q49]

QUESTION 29

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?

Country > Country_Customers > CustomerPrices

ProductFamily > ProductFamily_ProductGroups > ProductGroup_ProductNumbers > ProductNumber_Parts > CustomerPartPrices

CustomerPartPrices > ProductNumber_Parts > ProductGroup_ProductNumbers > ProductFamily_ProductGroups > ProductFamily

CustomerPrices > Country_Customers > Country

QUESTION 30

A part has demands on 06-01, 06-04, and 06-05 as shown in the exhibit. The part source has this configuration:
* OrderGenerationRule = ‘AfterPTF’
* LeadTime = 2 days
* PTFRule = Lead
* PlanningTimeFence = 2
Referring to the graphic, which table shows the resulting planned orders?

I

II

III

IV

QUESTION 31

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?

Country > Country_Customers > CustomerPrices

ProductFamily > ProductFamily_ProductGroups > ProductGroup_ProductNumbers > ProductNumber_Parts > CustomerPartPrices

CustomerPartPrices > ProductNumber_Parts > ProductGroup_ProductNumbers > ProductFamily_ProductGroups > ProductFamily

CustomerPrices > Country_Customers > Country

QUESTION 32
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

var executeResult = cmdDeleteData.execute();

var removeResult = wbOrderChng.remove(wsOrderChng.getData());

var removeResult = wsOrderChng.remove(dataArray);

var importResult = wsOrderChng.importData(dataArray);

QUESTION 33

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

QUESTION 34

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?

I

II

III

IV

QUESTION 35

The tables shown in the graphic are from an SQL database. Shaded fields indicate key fields in SQL.
Which three actions should you take to design this data model in RapidResponse? (Choose three.) Choose 3 answers

In the ItemDetail table, make Name plus Site into a reference to the Item table.

In the TransactionHeader table, make ID, Owner, and Type into a reference to the TransactionDetail table.

In the TransactionDetail table make ID, Owner, and Type into a reference to the TransactionHeader table.

In the Item table, make Name plus Site into a reference to the ItemDetail table.

In the TransactionDetail table, make ItemName plus ItemSite into a reference to the Item table.

QUESTION 36
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

Remove the unmapped columns from the editing worksheet.

Add a column to the spreading worksheet to map the bucket dates.

Select the “Allow editing only if all buckets are the same size” check box.

Select the “Use same spreading worksheet values for all edits” check box.

QUESTION 37

The Bill of Material structure is shown in the graphic. The quantity per for each component is shown in parentheses. Independent demand for 100 units of item AAA has been received. There are no ScheduledReceipt or OnHand records for any of the items; PartSource.OrderPolicy.OrderGenerationRule = Anytime.
What is the correct PegPart, DriverPart, and NeedQuantity found in the WhereConsumed table for item DDD?

PegPart is assigned BBB
DriverPart is assigned AAA
NeedQuantity = 1600

PegPart is assigned AAA
DriverPart is assigned BBB
NeedQuantity = 1600

PegPart is assigned DDD
DriverPart is assigned BBB
NeedQuantity = 400

PegPart is assigned BBB
DriverPart is assigned AAA
NeedQuantity = 400

QUESTION 38

Which two violations of Kinaxis best practice are shown in the graphic? (Choose two.) Choose 2 answers

The key field contains the table name.

The Line should be a number field.

The deployment name prefix is included in the OrderId field.

OnTimeQty should specify the data type in the field name.

QUESTION 39

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.

QUESTION 40
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

QUESTION 41
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?

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

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

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

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.

QUESTION 42
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?

DATEVALUE(EffectiveUnitPrice)

CONVERTONDATE(EffectiveUnitPrice, $ConversionDate)

DATETIMEVALUE(EffectiveUnitPrice)

ASSOCIATEDDATE(EffectiveUnitPrice)

QUESTION 43

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.

QUESTION 44
You are creating a resource that is designed to evaluate the impact of converting planned orders to scheduled receipts. After the evaluation is complete, you want to provide users the opportunity to push their changes to the parent scenario. Users will be using their scenarios to consider changes to lead time, constraint available, and other planning parameters. The company policy stipulates that lead times cannot be adjusted in any shared scenarios.
What should you do to accomplish this task?

Restrict the user to view only access to the parent scenario.

Develop a cross scenario data change.

Apply a perspective when creating your scenario.

Export your changes to a .tab file and import to a scenario.

QUESTION 45

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?

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

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.

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

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.

QUESTION 46

A part has several demands due in a particular week. All demands are the same priority. Available supplies are shown in the graphic. The control table settings for the OrderPriority.AllocationRule is FairShare and PlanningCalendars.AllocationCalendar is Week.
How much of the supply quantity on Thursday will be allocated to the Wednesday demand?

20

25

30

40

QUESTION 47
You have a worksheet based on the IndependentDemand table that includes columns for key fields plus multi-scenario columns for Quantity and EffectiveDemand. You want to highlight the Quantity fields where the value in the comparison scenario is different from the corresponding value in the workbook’s baseline scenario. You want your worksheet to be able to highlight differences in several scenarios.
How would you achieve this highlighting?

Define the Quantity column to show Difference, select the scenario comparison filtering option to show Only records with different comparison values, then define conditional formatting for the Quantity column when the respective value is not equal to 0.

Add a hidden multi-scenario column, RecordID, as show Differences; then define conditional formatting for the Quantity column where RecordID is not equal to 0.

Define the Quantity column to show Actual value, and define an additional hidden column, Quantity0, as !Quantity#0 using “Calculate using grouped results in the previous row or other results”; then define conditional formatting where the Quantity column is not equal to Quantity0.

Define the Quantity column to show Actual value; add a hidden multi-scenario column, QuantityDelta, to show Difference; then define conditional formatting for the Quantity column when their QuantityDelta field is not 0.

QUESTION 48

Referring to the Supply and Demands shown in the graphic, and taking priorities into consideration, which scheduled receipts (SR) will be allotted to Demand 2?

SR1 (Qty 200) and SR2 (Qty 100)

SR2 (Qty 200) and SR1 (Qty 100)

SR2 (Qty 200) and SR3 (Qty 100)

SR3 (Qty 200) and SR2 (Qty 100)

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