Online Access Free KX3-003 Exam Questions

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?

• A.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.
• B.Ensure that the sort order and sort direction used in both worksheets are the same.
• C.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.
• D.Instead of using Part.Name and Part.Site, use Part as a reference in both worksheets.

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.

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?

• A.Use the MRPDate.
• B.Use the first date in the bucket adjusted by three workdays.
• C.Use the last workday in the bucket.
• D.Use the first date in the bucket.

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.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.
• B.Clear the Bucket data by date checkbox and then filter the worksheet for the last 2 years as Date >= MRPDate - 730 and Date <= MRPDate
• C.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.
• D.Enable the Bucket data by date checkbox, then select Day in the Bucket Size and 730 (365*2) in the Number of Buckets.

You want to compare the performance of two similar worksheets in a private scenario, but you need to ensure that neither worksheet takes advantage of cached results.
In this situation, before capturing the performance results, how would you accomplish this task?

• A.Edit the Description field for OnHandType.
• B.Close the workbook and also close any library workbooks it uses, then reopen the workbook.
• C.Close the workbook and reopen it.
• D.Edit the Description field for the selected parts.