KX3-003 Practice Exam Questions and Answers

A.  

From Tools > Search Resources: search for resources based on the table "HistoricalPartKPI".

B.  

From Tools > Search Resources: search for resources containing the text "HistoricalPartKPI".

C.  

From Administration > Automation Log: search for "HistoricalPartKPI" in Automation Task Log.

D.  

From Administration > Administration Log: search for "HistoricalPartKPI" in Input Records and Scenarios.

A.  

'A', 'B', 'C'

B.  

'A, B, C'

C.  

A\, B\, C

D.  

A, B, C

A.  

COUNT IndependentDemands {Order.Customer:Sum}

B.  

COUNT IndependentDemands {Order.Customer:By}

C.  

COUNT IndependentDemands {Order.Customer<>''}

D.  

SUM IndependentDemands{Order.Customer:Sum}

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.

A.  

( Lookup({Part.Name,Part.Site.Value, DueDate}, LKPScheduledReceipt!, “N”, LKPScheduledReceipt!Exists) = “N” )

B.  

NOT {Part, DueDate} IN LKPScheduledReceipt!

C.  

NOT IsNull ( Lookup ({Part.Name, Part.Site.Value, DueDate}, LKPScheduledReceipt!, Null(Mfg::ScheduledReceipt), Exact, LKPScheduledReceipt!Self ))

D.  

NOT {Part.Name, Part.Site.Value, DueDate} IN LKPScheduledReceipt!

A.  

Restrict the user to view only access to the parent scenario.

B.  

Develop a cross scenario data change.

C.  

Apply a perspective when creating your scenario.

D.  

Export your changes to a .tab file and import to a scenario.

A.  

1. Create two worksheets: one based on ScheduledReceipts and one based on WorkOrderInfo.

2. Create a column in the ScheduledReceipts worksheet to lookup values in the WorkOrderInfo worksheet.

B.  

1. Create a composite worksheet using two component worksheets, ScheduledReceipt and WorkOrderInfo.

2. Use left join and grouping to align the two sets of data.

C.  

1. Create a reference field on the WorkOrderInfo table to the ScheduledReceipt table.

2. Display relevant work order data in worksheets based on the WorkOrderInfo table and the referenced ScheduledReceipt table.

D.  

1. Create a reference field on the ScheduledReceipt table to the WorkOrderInfo table.

2. Display relevant work order data in worksheets based on the ScheduledReceipt table and the referenced WorkOrderInfo table.

A.  

Close the workbook and reopen it.

B.  

Close the workbook and also close any library workbooks it uses, then reopen the workbook.

C.  

Edit the Description field for OnHandType.

D.  

Edit the Description field for the selected parts.

A.  

Two planned orders will be created; one due on day 1 (first Monday) for a quantity of 80 and another on day 6 (second Monday) for a quantity of 75.

B.  

Two planned orders will be created; one due on day 2 (first Tuesday) for a quantity of 80 and another on day 6 (second Monday) for a quantity of 75.

C.  

A single planned order will be created due on day 2 (first Tuesday) for a quantity of 155.

D.  

A single planned order will be created due on day 1 (first Monday) for a quantity of 155.

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