NO.28 Your suppliers need to receive a report listing their outstanding purchase orders. Each supplier should receive the report in the same format but it should only display the purchase orders associated with their supplier ID.
Based on this situation, which two actions will be required to support this requirement? (Choose two.) Choose 2 answers

NO.29 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?

NO.30 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?

NO.31

You shared your scheduled task, shown in the graphic, with a set of users who do not have access to all the resources used in the task.
In this situation, which statement is true?

NO.32

You want to enter a forecast for 6000 units of part 89-Prod0966 in the June 8 bucket. You expect that three records will be inserted into the IndependentDemand table (equal quantities of 2000 at each of the three sites); however, you get an error.
Which action would solve the error?

NO.33 You have a worksheet based on the Part table. You want to know the total number of unique customers that have orders for each part.
Which expression accomplishes this task?

NO.34

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?

NO.35 You are building a worksheet for supplier collaboration and you want to assign a profile variable, Suppliers, so each user can see data for their own list of suppliers.
You include an expression in your sheet reporting the ScheduledReceipt table:
Order.Supplier IN ListAsSet($Suppliers)
Which string would you enter for the Suppliers profile variable for a user that should see data for suppliers A, B and C?

NO.36 You are asked to report data based on the ScheduledReceipt table that also displays information from a custom table, WorkOrderInfo. There will be at most one WorkOrderInfo record for any ScheduledReceipt record and WorkOrderInfo will be used often in worksheets reporting ScheduledReceipt data.
Following Kinaxis best practices, what should you do to accomplish this task?

NO.37

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

NO.38 You are asked to transform PlannedOrder data into new ScheduledReceipt records, assuming just one PartSource per part and no maximum quantity. You need to filter the PlannedOrder records to ensure you do not try to create any ScheduledReceipt records which already exist. The workbook includes a worksheet, LKPScheduledReceipt, on existing converted ScheduledReceipts and follows Kinaxis best practices.
In this situation, which filter expression will follow KInaixs best practices and provide the best performance to include PlannedOrder records that do not match existing ScheduledReceipt records?

NO.39 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?

NO.40

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?

NO.41

You are asked to create a worksheet that contains fields from four tables.
Referring to the graphic, which table should your worksheet be based on to optimize performance?

NO.42 You have a hierarchy called PartFamily that is based on the PartCustomer table. There is a second hierarchy in use, also based on the PartCustomer table called PartPlanner. When the PartFamily hierarchy is used, performance is noticeably worse than when the PartPlanner hierarchy is used.
In this situation, which design issue would contribute most to poor performance?