Weekend Sale - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 65percent

Welcome To DumpsPedia

KX3-003 Sample Questions Answers

Questions 4

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

Options:

A.

Multiple Delivery Routes can reference a carrier.

B.

Each carrier can have multiple Transit Calendars.

C.

Multiple Shipments can reference a carrier.

D.

Several carriers can share the same Default Transportation Mode.

E.

A carrier must only have one Source.

Buy Now
Questions 5

You want to enable data caching on the worksheet shown in the graphic.

Which two actions will accomplish this task? (Choose two.)

Choose 2 answers

Options:

A.

Remove the bucketing by DueDate.

B.

Remove the hierarchy column.

C.

Remove the currency column.

D.

Disable the Use As Reference checkbox on the Part column.

Buy Now
Questions 6

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

Options:

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 "Allow editing only if all buckets are the same size" check box.

D.

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

Buy Now
Questions 7

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?

Options:

A.

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.

B.

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.

C.

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.

D.

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.

Buy Now
Questions 8

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?

Options:

A.

I

B.

II

C.

III

D.

IV

Buy Now
Questions 9

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?

Options:

A.

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.

B.

Ensure that the sort order and sort direction used in both worksheets are the same.

C.

Instead of using Part.Name and Part.Site, use Part as a reference in both worksheets.

D.

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.

Buy Now
Questions 10

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?

Options:

A.

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.

B.

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.

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.

D.

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.

Buy Now
Questions 11

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?

Options:

A.

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

B.

Develop a cross scenario data change.

C.

Apply a perspective when creating your scenario.

D.

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

Buy Now
Questions 12

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?

Options:

A.

'A', 'B', 'C'

B.

'A, B, C'

C.

A\, B\, C

D.

A, B, C

Buy Now
Questions 13

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?

Options:

A.

20

B.

25

C.

30

D.

40

Buy Now
Questions 14

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?

Options:

A.

DATEVALUE(EffectiveUnitPrice)

B.

CONVERTONDATE(EffectiveUnitPrice, $ConversionDate)

C.

DATETIMEVALUE(EffectiveUnitPrice)

D.

ASSOCIATEDDATE(EffectiveUnitPrice)

Buy Now
Questions 15

You want to track the date of the most recent order placed by each Customer. You also want to make the most efficient use of memory, and query and algorithm performance.

Considering Kinaxis best practices, which data model design would you use?

Options:

A.

Add an input field, DateOrdered, to IndependentDemand and use a set operation from Customer to Order to IndependentDemand to find the maximum DateOrdered.

B.

Add an input field, MostRecentOrderDate, to the Customer table.

C.

Add an input field, MostRecentOrderDate, to the PartCustomer table.

D.

Add an input table with a single key reference to Customer, containing a MostRecentOrderDate.

Buy Now
Questions 16

You need to create an expression that displays the number of the calendar week from the beginning of the year, for example, 01 January 2017 to 07 January 2017 = week 1. The calendar is based on a January to December fiscal year. The Calendar table has the values shown in the graphic.

Which expression would display the number of the calendar week?

Options:

A.

(today - (today + 0 Year) Week)

B.

(today - (today + 0 Year) Week) +1

C.

(today + 0 Week)

D.

(today + 0 Week) + 1

Buy Now
Questions 17

You are creating a metric worksheet to calculate the number of late orders for a specified time period. The metric worksheet will be based on the IndependentDemand table and it has two columns: DueDate and Count. The expression for Count is 1. The worksheet's filter expression is: DaysLate > 0 and Order.Type = 'Actual'.

In this situation, what is the column sequence and grouping properties for the metric worksheet?

Options:

A.

Column sequence:

Count

DueDate

Grouping Function:

Count = Group By

DueDate = Min

B.

Column sequence:

DueDate

Count

Grouping Function:

DueDate = Group By

Count = Sum

C.

Column sequence:

DueDate

Count

Grouping Function:

DueDate = Group By

Count = Group By

D.

Column sequence:

DueDate

Count

Grouping Function:

DueDate = Group By

Count = Associate

Buy Now
Questions 18

A user wants to build a crosstab worksheet that shows historical data in daily buckets for the last two years. Currently, historical data is stored in days.

What are two ways to accomplish this task? (Choose two.)

Choose 2 answers

Options:

A.

Enable the Bucket data by date checkbox, then select Day in the Bucket Size and 730 (365*2) in the Number of Buckets.

B.

Enable Advanced Bucketing, select Day in the Bucket Size and 365 in the Number of Buckets, and then adjust the Anchor date by 1 Year.

C.

Create calendar interval, start date, and end date variables using the CalendarDate table, and then reference these variables in the worksheet that displays historical data.

D.

Clear the Bucket data by date checkbox and then filter the worksheet for the last 2 years as Date >= MRPDate - 730 and Date <= MRPDate

Buy Now
Exam Code: KX3-003
Exam Name: Certified RapidResponse Author Level 3 Exam
Last Update: Oct 4, 2024
Questions: 60
$56  $159.99
$42  $119.99
$35  $99.99
buy now KX3-003