Purchase Kinaxis : KX3-003 Exam Materials and then pass exam easily

Kinaxis KX3-003 Exam Overview:

Kinaxis KX3-003 Exam Syllabus Topics:

Kinaxis Certified RapidResponse Author Level 3 Sample Questions:

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

A) EffectiveUnitTransferCost - (CONVERTONDATE(TransferCost, today) / Quantity)
B) CONVERTONDATE(EffectiveUnitTransferCost, today) - (TransferCost / Quantity)
C) EffectiveUnitTransferCost - (CONVERTONDATE(TransferCost, ShipDate) / Quantity)
D) EffectiveUnitTransferCost - (TransferCost / Quantity)

2. You are asked to populate the PartSource BaseKey to ensure unique key values.
In this situation, which expression would create uniqueness while saving memory?

A) Part.Name + ':' + Source.Supplier.ID
B) Part.Site.Value + ':' + TEXT(EffectiveInDate)
C) TEXT(EffectiveInDate)
D) Source.Id

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

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

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

A) Use the first date in the bucket adjusted by three workdays.
B) Use the MRPDate.
C) Use the last workday in the bucket.
D) Use the first date in the bucket.

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

A) 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.
B) Enable the Bucket data by date checkbox, then select Day in the Bucket Size and 730 (365*2) in the Number of Buckets.
C) 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.
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

Solutions: