Halloween Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: clap70

KX3-003 Certified RapidResponse Author Level 3 Exam Questions and Answers

Questions 4

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 5

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 6

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 7

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 8

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?

Options:

A.

A = 30, B = 20, C = 20

B.

A = 30, B = 15, C = 15

C.

A = 30, B = 15, C = 10

D.

A = 25, B = 15, C = 15

Buy Now
Questions 9

You want to provide a worksheet based on the CRPOperation table to report destination location. There is only one valid stock location per operation. A secondary requirement is to view all valid work centers that feed a given stock location.

Which approach should you use to optimize performance?

Options:

A.

Create a reference field on the Location table to the CRPOperation table.

B.

Create a reference field on the CRPOperation table to the Location table.

C.

Create a lookup worksheet based on the OnHand table that returns a set of locations.

D.

Create a new table with references to the Location and CRPOperation tables.

Buy Now
Questions 10

You have defined a new namespace, TRM. You now want to define a new table that has a key reference field to the Mfg::ABCCode table. However, in the Add Input Field dialog,ABCCode does not appear.

What should you do to create the ABCCode key reference?

Options:

A.

Add the TRM namespace as a dependency for the Mfg namespace.

B.

Enable the Allow null reference checkbox.

C.

Enable the Allow automatic record creation checkbox.

D.

Add the Mfg namespace as a dependency for the TRM namespace.

Buy Now
Questions 11

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?

Options:

A.

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.

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

Buy Now
Questions 12

Forecasts are being received on a monthly basis and you are asked to spread these forecasts into weekly intervals. The month has four weeks, and you are using the spreading profile shown in the graphic where the first week is on the left. The monthly forecast is for a quantity of 500. The PlanningCalendars.ForecastCalendar=Month and PlanningCalendars.SecondCalendar=Week.

Referring to the graphic, what will the weekly forecast quantities be?

Options:

A.

100, 100, 125, 175

B.

100, 100, 135, 165

C.

100, 100, 140, 160

D.

125, 125, 125, 125

Buy Now
Questions 13

The Bill of Material structure is shown in the graphic. The quantity per for each component is shown in parentheses. Independent demand for 100 units of item AAA has been received. There are no ScheduledReceipt or OnHand records for any of the items; PartSource.OrderPolicy.OrderGenerationRule = Anytime.

What is the correct PegPart, DriverPart, and NeedQuantity found in the WhereConsumed table for item DDD?

Options:

A.

PegPart is assigned BBB

DriverPart is assigned AAA

NeedQuantity = 1600

B.

PegPart is assigned AAA

DriverPart is assigned BBB

NeedQuantity = 1600

C.

PegPart is assigned DDD

DriverPart is assigned BBB

NeedQuantity = 400

D.

PegPart is assigned BBB

DriverPart is assigned AAA

NeedQuantity = 400

Buy Now
Questions 14

You are creating a new script that must insert a new customer record, archive that record weekly in a new scenario, and then commit the child scenario to a parent scenario. You already have a script that commits child scenarios.

Referring to the graphic, which code will call the script that commits child scenarios in your new script?

Options:

A.

I

B.

II

C.

III

D.

IV

Buy Now
Questions 15

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 16

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?

Options:

A.

Supplier.Id = "ACME"

B.

(Part.PlannerCode.Value IN "CM", "TJ")

C.

Type = $Type

D.

OnTimeQuantity > 0

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

You are asked to restrict a worksheet so that users can only see data for the demand of the countries that they should have permission to see. A field has been added to the IndependentDemand table, which is a reference to a custom table called Country. Each user may have permission to see the demands from one or more countries, and each country can be seen by one or more users. They should be able to see data from multiple countries in the worksheet at the same time.

In this scenario, what should you do to enable this capability?

Options:

A.

Create a $DmdCountry list workbook variable with a query generated list of values based on the Country table. Add the expression UserInGroup ($User, 'DemandPlanners') to the variable filter and then in the column properties conditionally hide the column using the $DmdCountry = False expression.

B.

Create a $DmdCountry text workbook variable with the expression UserInGroup ($User, 'DemandPlanners'). Add the $DmdPlanners = TRUE expression to the worksheet.

C.

Build a Responsibility definition based on the Country table and assign the users to all of the countries that they should have permission to see. Add a responsibility column to the worksheet so users can select their country.

D.

Create a $DmdCountry profile variable and assign the country names to each user. Add the expression IF ($DmdCountry = "'*'", TRUE, User::DmdCountry IN eval($DmdCountry)) to the worksheet filter.

Buy Now
Exam Code: KX3-003
Exam Name: Certified RapidResponse Author Level 3 Exam
Last Update: Nov 2, 2024
Questions: 60
KX3-003 pdf

KX3-003 PDF

$24  $80
KX3-003 Engine

KX3-003 Testing Engine

$28.5  $95
KX3-003 PDF + Engine

KX3-003 PDF + Testing Engine

$39  $130