Prepare KX3-003 Exam with Using KX3-003 Dump Questions

1. You want to create a workbook command that will modify the existing records on the worksheet shown in the graphic. You want the records to copy the date value in New Due Date to the DueDate field in each record.





What should you change in the worksheet to create the modify command?

2. Given the worksheet properties shown in the exhibit, which console output would exist for the following script?





var dataForInsert = [['1','BBy-LCD37','DC-Europe','DCRequest','LCD-3735','DC-Europe','06-01-20',147]];

var wbOrderChng = rapidResponse.workbooks.get({name:'Change Orders',scope:'Private'}, {scenarios:

[scenario], filter: {name: 'All Parts', scope: 'Public'}, siteGroup: {name: site, scope: 'Public'}});

var wsOrderChng = wbOrderChng.worksheets.get('ChangeOrders');

var importResult = wsOrderChng.importData(dataForInsert); rapidResponse.console.writeLine(JSON.stringify(importResult));

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

4. You are asked to populate the PartSource BaseKey to ensure unique key values.

In this situation, which expression would create uniqueness while saving memory?

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

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

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

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

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

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

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

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

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

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

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

10. After the most recent planning cycle, a planner asks you why there were no new records in the HistoricalPartKPI table. They expected these records to be written as part of a scheduled automation chain. You must determine if the automation chain has been disabled, but you are not familiar with which automation chain should perform this action. As the first step in identifying the automation chain, you need to search for any of its associated resources.

In this situation, which process would guarantee that you have the correct associated resources of the automation chain?

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

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

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

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

15. Customers sign in to view only their independent demands. The customer's User IDs are in a user group with the name of the customer to which they correspond. You want to create a single worksheet that allows customers to only view their independent demands within RapidResponse.

How would you accomplish this task?

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

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

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

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

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