Kinaxis KX3-003 actual dump : Certified RapidResponse Author Level 3 Exam

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, 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.
• B. 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.
• 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. 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.

You want to improve performance by enabling caching on the worksheet shown in the exhibit. The worksheet is based on the CTPActivity table.
Which expression must you migrate to the secondary filter expression box to accomplish this task?

• A. (Part.PlannerCode.Value IN "CM", "TJ")
• B. OnTimeQuantity > 0
• C. Supplier.Id = "ACME"
• D. Type = $Type

You want to identify the buyer responsible for the component part in a worksheet based on the BillofMaterial table. Additionally, you want to have the option of inviting that buyer to a collaboration, messaging that buyer, and sharing a scenario with them.
Which set of column expressions and configuration changes will enable this capability?

• A. Create a column with an expression of Responsibility($Role_Buyers, Component.Name). On the Column Formatting tab, Check the "Display as user name" checkbox.
• B. Create a column with an expression of Responsibility($Role_Buyers, Component). On the Column Formatting tab, Check the "Display as user name" checkbox.
• C. Create a column with an expression of Responsibility($Role_Buyers, Component.Name). On the Column Formatting tab, Check the "Display as image" checkbox and select an appropriate image.
• D. Create a column with an expression of Responsibility($Role_Buyers, Component). On the Column Formatting tab, Check the "Display as image" checkbox and select an appropriate image.

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?

• A. Create a Profile Variable called CustomerView where the user group is equal to the Customer Name. In the worksheet visible to the customer, create a worksheet filter with the Order.Customer.Name =
  $CustomerView expression.
• B. Create a Profile Variable called CustomerView where the data value and user group is equal to the Customer Name. In the worksheet visible to the customer, create a worksheet filter with the Order.Customer.ID = $CustomerView expression.
• C. Create a Profile Variable called CustomerView where the data value and user group is equal to the Customer Name. In the worksheet visible to the customer, create a worksheet filter with the Order.Customer.Name = $CustomerView expression.
• D. Create a Profile Variable called CustomerView where the data value is equal to the Customer Name. In the worksheet visible to the customer, create a worksheet filter with the Order.Customer.Name =
  $CustomerView expression.

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