You want to create a workbook command that deletes records in theHistoricalDemandActual table that are more than a year old. You want to perform this action automatically once a week, without having to manually run the command.
In this situation, which two statements are true? (Choose two.)

• A. The worksheet with the automation settings to run the command must not have any worksheet filtering set.
• B. The worksheet with the automation settings to run the command must be based on the HistoricalDemandActual table.
• C. You must create a Scheduled Task to run this command once a week.
• D. The command must be run as part of an Automation Chain.

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?

• A. 'A, B, C'
• B. A\, B\, C
• C. A, B, C
• D. 'A', 'B', 'C'

You are asked to create a worksheet that shows which process orchestration activity performers are late and how much they are late for each activity. There could be more than one performer per activity.
How would you accomplish this task?

• A. Create a worksheet on the Activity table in the Mfg namespace.
• B. Create a worksheet based on the ProcessInstance table in the Mfg namespace.
• C. Create a worksheet based on the Assignment table in the ProcOrch namespace.
• D. Create a worksheet based on the Activity table in the ProcOrch namespace.

Which two violations of Kinaxis best practice are shown in the graphic? (Choose two.) Choose 2 answers

• A. OnTimeQty should specify the data type in the field name.
• B. The key field contains the table name.
• C. The deployment name prefix is included in the OrderId field.
• D. The Line should be a number field.

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 last workday in the bucket.
• B. Use the MRPDate.
• C. Use the first date in the bucket adjusted by three workdays.
• D. Use the first date in the bucket.