Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

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?

A.

Country > Country_Customers > CustomerPrices

B.

ProductFamily > ProductFamily_ProductGroups > ProductGroup_ProductNumbers > ProductNumber_Parts > CustomerPartPrices

C.

CustomerPartPrices > ProductNumber_Parts > ProductGroup_ProductNumbers > ProductFamily_ProductGroups > ProductFamily

D.

CustomerPrices > Country_Customers > Country

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?

A.

20

B.

25

C.

30

D.

40

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?

A.

COUNT IndependentDemands {Order.Customer:Sum}

B.

COUNT IndependentDemands {Order.Customer:By}

C.

COUNT IndependentDemands {Order.Customer<>''}

D.

SUM IndependentDemands{Order.Customer:Sum}

You have a report based on an InventoryTransfer table. Due to currency fluctuation, you are asked to report the difference between the future EffectiveUnitTransferCost and the cost to transfer it today.

Which expression will accomplish this task?

A.

EffectiveUnitTransferCost - (CONVERTONDATE(TransferCost, ShipDate) / Quantity)

B.

CONVERTONDATE(EffectiveUnitTransferCost, today) - (TransferCost / Quantity)

C.

EffectiveUnitTransferCost - (TransferCost / Quantity)

D.

EffectiveUnitTransferCost - (CONVERTONDATE(TransferCost, today) / Quantity)

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 be based on the HistoricalDemandActual table.

B.

The worksheet with the automation settings to run the command must not have any worksheet filtering set.

C.

The command must be run as part of an Automation Chain.

D.

You must create a Scheduled Task to run this command once a week.

You are creating a metric worksheet to calculate the number of late orders for a specified time period. The metric worksheet will be based on the IndependentDemand table and it has two columns: DueDate and Count. The expression for Count is 1. The worksheet's filter expression is: DaysLate > 0 and Order.Type = 'Actual'.

In this situation, what is the column sequence and grouping properties for the metric worksheet?

A.

Column sequence:

Count

DueDate

Grouping Function:

Count = Group By

DueDate = Min

B.

Column sequence:

DueDate

Count

Grouping Function:

DueDate = Group By

Count = Sum

C.

Column sequence:

DueDate

Count

Grouping Function:

DueDate = Group By

Count = Group By

D.

Column sequence:

DueDate

Count

Grouping Function:

DueDate = Group By

Count = Associate

Given this information and referring to the graphic:

      Number of Days of Supply: 2

      DaysSupplyRule: ByPeriod

      PeriodSupplyInterval:  Week

      PeriodSupplyDueCalendar: Week

Which statement about the planned order(s) that are created is true?

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.

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?

A.

Change the table that the spreading worksheet is based on, from Part to IndependentDemand.

B.

Map the column id Name to Part.Name in the Forecast worksheet.

C.

Map the column id Site to Part.Site in the Forecast worksheet.

D.

Add a Date column to the spreading worksheet.

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

A.

Create a worksheet based on the HistoricalDemandActual table.

B.

Create workbook variables for Start Date and End Date.

C.

Create a workbook variable for Calendar with a value of Month.

D.

Define a custom Insert Definition.

E.

Include only columns for Part, Site, and Customer from the HistoricalDemandActual table.

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

A.

Remove the bucketing by DueDate.

B.

Remove the hierarchy column.

C.

Remove the currency column.

D.

Disable the Use As Reference checkbox on the Part column.