EMT Practice Test

1. Question Content...

---

Question1:
You want to improve performance by enabling caching on the worksheet shown in the exhibit. The worksheet is based on the CTPActivity table.
Which expression must you migrate to the secondary filter expression box to accomplish this task?

Question2:
You want to enable data caching on the worksheet shown in the graphic.
Which two actions will accomplish this task? (Choose two.)
Choose 2 answers

Question3:
The graphic shows a path to generate a list of customer prices with record counts for each table in the path.
Given the following filter expression:
Part.ProductNumber.ProductGroup.ProductFamily In ('bikes','trikes')
AND Customer.Country IN ("US", "CA")
In this situation, what is the chosen line of descent from the query engine?

Question4:
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?

Question5: You have a worksheet based on the IndependentDemand table that includes columns for key fields plus multi-scenario columns for Quantity and EffectiveDemand. You want to highlight the Quantity fields where the value in the comparison scenario is different from the corresponding value in the workbook's baseline scenario. You want your worksheet to be able to highlight differences in several scenarios.
How would you achieve this highlighting?

Question6:
You have a new demand for 800 units of a product. SourceRule.AllotmentRule for this part is set to OnGoing.
Referring to the graphic, which planned order results will be created to satisfy this demand?

Question7:
A part has several demands due in a particular week. All demands are the same priority. Available supplies are shown in the graphic. The control table settings for the OrderPriority.AllocationRule is FairShare and PlanningCalendars.AllocationCalendar is Week.
How much of the supply quantity on Thursday will be allocated to the Wednesday demand?

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

Question9: You are asked to restrict a worksheet so that users can only see data for the demand of the countries that they should have permission to see. A field has been added to the IndependentDemand table, which is a reference to a custom table called Country. Each user may have permission to see the demands from one or more countries, and each country can be seen by one or more users. They should be able to see data from multiple countries in the worksheet at the same time.
In this scenario, what should you do to enable this capability?

Question10:
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?

Question11: After the most recent planning cycle, a planner asks you why there were no new records in the HistoricalPartKPI table. They expected these records to be written as part of a scheduled automation chain.
You must determine if the automation chain has been disabled, but you are not familiar with which automation chain should perform this action. As the first step in identifying the automation chain, you need to search for any of its associated resources.
In this situation, which process would guarantee that you have the correct associated resources of the automation chain?

Question12:
Referring to the Supply and Demands shown in the graphic, and taking priorities into consideration, which scheduled receipts (SR) will be allotted to Demand 2?

Question13:
You need to create an expression that displays the number of the calendar week from the beginning of the year, for example, 01 January 2017 to 07 January 2017 = week 1. The calendar is based on a January to December fiscal year. The Calendar table has the values shown in the graphic.
Which expression would display the number of the calendar week?

Question14: You want to track the date of the most recent order placed by each Customer. You also want to make the most efficient use of memory, and query and algorithm performance.
Considering Kinaxis best practices, which data model design would you use?

Question15: 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?

Question16: You have a crosstab, bucketed worksheet that shows forecast records. There are forecast records on the first workday of every month for 18 months from the Planning Date. The bucket settings are set for 52 Weeks from the Planning Date. You want to improve performance for this worksheet, but still display it as a crosstab worksheet. You also want to display one year's worth of forecast records.
How would you accomplish this task?

Question17:
Given the worksheet properties shown in the exhibit, which console output would exist for the following script?
var dataForInsert = [['1','BBy-LCD37','DC-Europe','DCRequest','LCD-3735','DC-Europe','06-01-20',147]]; var wbOrderChng = rapidResponse.workbooks.get({name:'Change Orders',scope:'Private'}, {scenarios:
[scenario], filter: {name: 'All Parts', scope: 'Public'}, siteGroup: {name: site, scope: 'Public'}}); var wsOrderChng = wbOrderChng.worksheets.get('ChangeOrders'); var importResult = wsOrderChng.importData(dataForInsert); rapidResponse.console.writeLine(JSON.stringify(importResult));

Question18: 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?

Question19: You are asked to improve the performance of a worksheet based on the WhereConsumedForDemand table.
You notice there is no filter control selected.
Which type of filter will improve performance?

Question20: A client wants to provide their sales staff the ability to add forecasts for the global total of demand across all SKUs by each customer by month. The client wants to use their historical demand to allocate from a monthly forecast to a weekly forecast.
Which three actions would accomplish this task? (Choose three.)
Choose 3 answers

Question21: 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

Question22: You are required to troubleshoot a workbook designed to spread values across a specified time horizon. The start and end bucket dates are mapped to variables used in the spreading worksheet. The bucket field is not mapped to a column in the editing worksheet.
Which two actions would solve this issue? (Choose two.)
Choose 2 answers

Question23: 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?

Question24:
You want to create a workbook command that will modify the existing records on the worksheet shown in the graphic. You want the records to copy the date value in New Due Date to the DueDate field in each record.
What should you change in the worksheet to create the modify command?

Question25: 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