Kinaxis Certified RapidResponse Author Level 3 : KX3-003 Exam Questions

You are developing a worksheet that will be used to run a script through a form. For the script to work properly, you will need to pass information from two columns as script arguments.
Which two actions will accomplish this task? (Choose two.)
Choose 2 answers

• A. Select the columns when setting an Open Form Command.
• B. Match the script arguments names with the Form controls ID.
• C. Select the columns when mapping drill links to forms.
• D. Map the Form controls to Script arguments.

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

• A. Delete all records in Baseline before the update to allow the database to re-link records that have a corrupted version chain.
• B. List the identifying fields ahead of the other columns.
• C. Identify fields that should be used to match records by making them read-only.
• D. Include all key fields and all reference fields in the update to help the database clearly identify matching records.

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?

• A. Country > Country_Customers > CustomerPrices
• B. CustomerPartPrices > ProductNumber_Parts > ProductGroup_ProductNumbers > ProductFamily_ProductGroups > ProductFamily
• C. ProductFamily > ProductFamily_ProductGroups > ProductGroup_ProductNumbers > ProductNumber_Parts > CustomerPartPrices
• D. CustomerPrices > Country_Customers > Country

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?

• A. 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.
• B. Turn off grouping settings for this worksheet and add an expression to filter out records that are beyond the one year horizon.
• C. Change the bucket settings to display 365 Everyday from the Planning Date.
• D. Turn off the bucket settings for this worksheet and add an expression to filter out records that are beyond the one year horizon.

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