What feature enables you to allocate values from a year column into months on a standard sheet?
Correct Answer: D
In Workday Adaptive Planning, Breakback is the feature that enables users to enter a value at a higher time stratum (such as a year column) and have the system automatically distribute that value proportionally across the lower-level time periods (months) within that year. When a user enters a value in the annual total column and triggers Breakback, Adaptive Planning allocates the annual amount to the individual months based on a defined distribution method - such as equal distribution, weighted by existing values, or following a seasonal pattern. This is the reverse of the standard bottom-up aggregation (where monthly values roll up to the year). Splits is used to distribute values across dimension values or account line items, not time periods. Copy Forward replicates values from one period to subsequent periods. Adjust applies a percentage or absolute change to existing values. Breakback is the specific, official term for top-down time period allocation in Adaptive Planning. Reference: Workday Adaptive Planning - Breakback, Standard Sheet Data Entry, Time Period Allocation.
Question 2
Within a modeled sheet where users can select from different Benefit Elections stored as dimension values, what can you create to drive different rates in formula calculations based on the Benefit Election dimension value selected?
Correct Answer: A
In Workday Adaptive Planning, a single value lookup table for the Benefit Election dimension is the correct design to drive different calculation rates based on which benefit election a user selects in a modeled sheet. A value lookup table maps each dimension value (e.g., Single, Family, Employee+Spouse) to a corresponding rate value, enabling the modeled sheet formula to dynamically look up the appropriate rate for whichever benefit election is selected on each row. This architecture is efficient, maintainable, and requires only one lookup object rather than separate tables per dimension value. Creating a separate value lookup table for each dimension value (Option C) is unnecessarily complex and duplicates data structures. A cube sheet (Option B) could store rate assumptions but requires a more complex reference architecture than a simple value lookup. A Rate dimension attribute (Option D) stores static metadata on dimension values and cannot drive time-sensitive rate lookups in calculations. The single value lookup table per dimension is the official, recommended pattern in Adaptive Planning's modeled sheet design. Reference: Workday Adaptive Planning - Value Lookup Tables, Modeled Sheets, Dimension-Driven Calculations.
Question 3
A financial plan requires an estimate for the Consulting Expenses account using the average consulting expense from last year multiplied by the forecasted inflation rate. What formula is most suitable?
Correct Answer: B
The requirement specifies using the average monthly consulting expense from last year (total prior year divided by 12) then multiplying by (1 + inflation rate). The formula div(ACCT.ConsultingExpenses[time=this.year-1],12)*(1+ASSUM.Global_Inflation_Rate) correctly captures this: [time=this.year-1] retrieves the full prior year total, div(...,12) divides by 12 to calculate the average monthly value, and *(1+ASSUM.Global_Inflation_Rate) applies the inflation adjustment. Option A [time=this-12] references the same month from one year ago - a specific month's value, not an annual average. Option C omits the prior year time reference, using the current account value rather than last year's data. Option D retrieves the full prior year total without dividing by 12, which would apply inflation to an annual total rather than a monthly average. The combination of the annual prior year reference, division by 12, and the inflation multiplier makes Option B the precise implementation of the described estimation strategy. Reference: Workday Adaptive Planning - Time Modifiers, div() Function, Inflation Formula Patterns.
Question 4
You need to create a formula that divides the bonus input by 12 and then multiplies it by the partial headcount. What is the recommended syntax?
Correct Answer: A
In Workday Adaptive Planning, the recommended best practice for division operations in formulas is to use the built-in div() function rather than the forward slash (/) operator. The div() function provides division with safe handling of zero denominators - if the denominator is zero, div() returns zero instead of throwing an error, which prevents formula errors from propagating through the model. The correct formula div(ROW.BonusInput, 12)*(ROW.PartialHeadcount) first divides the bonus input by 12 using the safe div() function, then multiplies the result by the partial headcount using standard multiplication. Option B incorrectly places the multiplication inside the div() function, changing the order of operations. Option C uses the division operator (/) which is not recommended as it lacks zero-denominator protection. Option D incorrectly prefixes ROW accounts with ACCT., which is the wrong prefix for personnel sheet row references - ROW. is the correct prefix. Using div() with proper ROW. references is the authoritative Adaptive Planning formula pattern for this calculation. Reference: Workday Adaptive Planning - Formula Syntax, div() Function, Personnel Sheet ROW Reference.
Question 5
How do you set up a task so that it is associated with a particular version and level?
Correct Answer: B
In Workday Adaptive Planning's Process Tracker (Workflow), a Level workflow task is specifically designed to associate a task with a particular level and version combination. When creating a Level workflow task, the administrator specifies both the version (e.g., FY2025 Budget) and the level (e.g., 310-01 Sales-USA) to which the task applies. This creates a direct link between the planning task, the relevant organizational unit, and the planning version, enabling the workflow engine to route tasks to the correct users and track completion at the appropriate level and version intersection. A Sheet workflow task links to a specific planning sheet rather than a level-version combination. Assigning the task to a user defines responsibility but does not establish the version-level association. A Standard task is a general-purpose task that does not inherently carry version and level associations. Level workflow tasks are the mechanism for coordinating level-specific, version-bound planning activities in Adaptive Planning's workflow module. Reference: Workday Adaptive Planning - Process Tracker, Level Workflow Tasks, Version Association, Workflow Configuration.