Question 1

You want to control how available dates are calculated for your vendor managed parts' supplies and demands. In this situation, which control table would you need to configure?

Options :

A : AvailableRule

B : DemandType

C : OrderPolicy

D : SupplyType

Answer: A

Question 2

var dataArray = [[line, orderNo, site, orderType, partName, site, dueDate, quantity]];var dataSettings = {scenarios: [scenario], filter: fAllParts, siteGroup: sgSite}var wbOrderChng = rapidResponse.workbooks.get({name:'Change Orders', scope:'Private'}, dataSettings);var cmdDeleteData= wbOrderChng.commands.get('DeleteData');var wsOrderChng = wbOrderChng.worksheets.get('ChangeOrders')Which two lines of code would potentially delete records in a table if they appeared after the code shown inthe exhibit? (Choose two.)Choose 2 answers

Options :

A : var executeResult = cmdDeleteData.execute();

B : var removeResult = wbOrderChng.remove(wsOrderChng.getData());

C : var removeResult = wsOrderChng.remove(dataArray);

D : var importResult = wsOrderChng.importData(dataArray);

Answer: A,C

Question 3

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:CountDueDateGrouping Function:Count = Group ByDueDate = Min

B : Column sequence:DueDateCountGrouping Function:DueDate = Group ByCount = Sum

C : Column sequence: DueDateCountGrouping Function:DueDate = Group ByCount = Group By

D : Column sequence:DueDateCountGrouping Function:DueDate = Group ByCount = Associate

Answer: B

Question 4

You want to create a composite worksheet using two component worksheets. The group by columns in both worksheets are Part.Name, Part.Site, Order.ID, Order.Site, Order.Type, Order.Type.ControlSet, and Line. How would you improve performance of the composite worksheet?

Options :

A : Group the component worksheets by Part.Name, Part.Site and Order.ID. In the composite worksheet group by Order.Type, Order.Type.ControlSet and Line

B : Ensure that the sort order and sort direction used in both worksheets are the same.

C : Instead of using Part.Name and Part.Site, use Part as a reference in both worksheets.

D : Instead of using Order.ID, Order.Site, Order.Type, and Line replace them with a column that concatenates those values and use it as a group by column.

Answer: B

Question 5

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?

Options :

A : Use the first date in the bucket.

B : Use the first date in the bucket adjusted by three workdays.

C : Use the last workday in the bucket.

D : Use the MRPDate.

Answer: C

Confidently Practice Online with Free KX3-003 Exam Cram

Buying Options: