2024 KX3-003 exam torrent KX3-003 Study Guide [Q35-Q49]

QUESTION 35
You have a report based on an InventoryTransfer table. Due to currency fluctuation, you are asked to report the difference between the future EffectiveUnitTransferCost and the cost to transfer it today.
Which expression will accomplish this task?

EffectiveUnitTransferCost – (CONVERTONDATE(TransferCost, ShipDate) / Quantity)

CONVERTONDATE(EffectiveUnitTransferCost, today) – (TransferCost / Quantity)

EffectiveUnitTransferCost – (TransferCost / Quantity)

EffectiveUnitTransferCost – (CONVERTONDATE(TransferCost, today) / Quantity)

QUESTION 36
A client wants to provide their sales staff the ability to add forecasts for the global total of demand across all SKUs by each customer by month. The client wants to use their historical demand to allocate from a monthly forecast to a weekly forecast.
Which three actions would accomplish this task? (Choose three.)
Choose 3 answers

Create a worksheet based on the HistoricalDemandActual table.

Create workbook variables for Start Date and End Date.

Create a workbook variable for Calendar with a value of Month.

Define a custom Insert Definition.

Include only columns for Part, Site, and Customer from the HistoricalDemandActual table.

QUESTION 37
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 38

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 39

Given the following order policies:
* MultipleQty: 10
* MinimumQty: 15
* MultipleUsage: Use
* MinimumUsage: Use
Referring to the graphic, what are the sizes of the three planned orders A, B, and C?

A = 30, B = 20, C = 20

A = 30, B = 15, C = 15

A = 30, B = 15, C = 10

A = 25, B = 15, C = 15

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

Referring to the graphic, the TV Family represents an MPSConfig planning BOM. No supply is available.
What will be the quantity of the planned order created for the TV family?

200

600

800

1000

QUESTION 42

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?

Supplier1: quantity 250
Supplier2: quantity 750

Supplier1: quantity 750
Supplier2: quantity 250

Supplier1: quantity 1000

Supplier2: quantity 1000

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

QUESTION 44

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

QUESTION 45
At a customer site, there are multiple TimePhasedSafety records that are duplicated in the Baseline scenario.
This is caused by the cross-scenario update from a child scenario.
What are two Kinaxis best practices for cross-scenario updates to prevent this situation? (Choose two.) Choose 2 answers

Include all key fields and all reference fields in the update to help the database clearly identify matching records.

Identify fields that should be used to match records by making them read-only.

List the identifying fields ahead of the other columns.

Delete all records in Baseline before the update to allow the database to re-link records that have a corrupted version chain.

QUESTION 46

Given this information and referring to the graphic:
* Number of Days of Supply: 2
* DaysSupplyRule: ByPeriod
* PeriodSupplyInterval: Week
* PeriodSupplyDueCalendar: Week
Which statement about the planned order(s) that are created is true?

Two planned orders will be created; one due on day 1 (first Monday) for a quantity of 80 and another on day 6 (second Monday) for a quantity of 75.

Two planned orders will be created; one due on day 2 (first Tuesday) for a quantity of 80 and another on day 6 (second Monday) for a quantity of 75.

A single planned order will be created due on day 2 (first Tuesday) for a quantity of 155.

A single planned order will be created due on day 1 (first Monday) for a quantity of 155.

QUESTION 47

Forecasts are being received on a monthly basis and you are asked to spread these forecasts into weekly intervals. The month has four weeks, and you are using the spreading profile shown in the graphic where the first week is on the left. The monthly forecast is for a quantity of 500. The PlanningCalendars.ForecastCalendar=Month and PlanningCalendars.SecondCalendar=Week.
Referring to the graphic, what will the weekly forecast quantities be?

100, 100, 125, 175

100, 100, 135, 165

100, 100, 140, 160

125, 125, 125, 125

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

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.

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

QUESTION 49
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 take? (Choose two.)
Choose 2 answers

Ensure a Hierarchy is available for users to select regional distribution sites.

Disable the default Site filter.

Select Part as the basis for workbook filtering.

Enable the Include hierarchy columns option.

2024 KX3-003 exam torrent KX3-003 Study Guide [Q35-Q49]

admin

Leave a Reply Cancel reply