Workday Pro Adaptive Planning Certification Workday-Adaptive-Planning Exam Questions

Page: 1 / 14
Total 61 questions
Question 1

The budgeting team would like to incorporate an inflation rate into several different formulas. This inflation rate might be adjusted later on, so the team would like to be mindful of the maintenance effort and store it in one place. What account type allows for data entry at the "Top Level (Only)" to accommodate this?



Answer : C

Assumption accounts in Workday Adaptive Planning are purpose-built for storing global constants --- such as inflation rates, tax rates, or standard multipliers --- that are referenced across multiple formulas and sheets. By design, Assumption accounts allow data entry at the Top Level (Only), meaning a single value is maintained centrally and referenced uniformly throughout the model. This aligns with best practices for model maintainability: rather than hard-coding values into individual formulas, a central Assumption account serves as the single source of truth. When the inflation rate changes, the administrator updates one cell, and all dependent formulas recalculate automatically. This eliminates version drift and ensures consistency across the entire model. Modeled accounts are used for row-based planning; Metric accounts display calculated KPIs but are not editable input stores; Custom accounts have different structural roles. Assumption accounts are foundational in Adaptive Planning's architecture and appear prominently in the Accounts configuration under Model Management. Reference: Workday Adaptive Planning --- Accounts Setup, Assumption Account Configuration, Model Management.


Question 2

In modeled sheets, what is the primary function of a value lookup for dimensions or text selector columns?



Answer : D

In Workday Adaptive Planning modeled sheets, a value lookup for dimensions or text selector columns serves the primary function of associating specific values to dimension or text fields over time, which are then referenced in formula calculations within the modeled sheet. For example, a value lookup might associate a specific benefit election (e.g., 'Family Plan') with a corresponding rate value that changes over time periods --- enabling the modeled sheet formula to look up the appropriate rate based on the selected dimension value and time period. This lookup mechanism is what powers time-sensitive, dimension-driven calculations in complex planning models such as HR, benefits, compensation, and sales planning. It is not used for entering global assumption values (which is done directly in Assumption accounts), nor for general data entry into model columns, nor for time-spreading functions (which is handled by Splits/Breakback). The value lookup is a purpose-built mechanism for dynamic, time-aware dimensional rate association. Reference: Workday Adaptive Planning --- Modeled Sheets, Value Lookups, Dimension Calculations.


Question 3

You are building a model for Travel Expenses. Finance needs to see detailed travel plans, and expenses will be included with corporate reporting. Planners are expected to complete their travel plans for each forecast. What model design should you use?



Answer : A

A modeled sheet is the appropriate design for detailed travel expense planning because it is architected to capture granular, row-level data where each row represents a discrete planning record --- in this case, an individual trip. Modeled sheets support custom columns (accounts) such as destination, travel dates, estimated cost, level assignment, and dimension values, enabling planners to build detailed itinerary-level budgets. The data aggregates upward to summary levels for inclusion in corporate reporting. This meets both requirements: detailed planning visibility for Finance and individual planner completion per forecast cycle. A standard sheet captures aggregate monthly amounts by level but lacks the row-level granularity needed for trip-by-trip detail. A standard sheet with a historical formula is a top-down estimation approach, not a detailed planning model. A cube sheet with assumption-based calculation is a statistical model, not a detailed record-level capture. The modeled sheet's row-based architecture is specifically designed for this class of detailed operational planning. Reference: Workday Adaptive Planning --- Modeled Sheets, Sheet Design Patterns, Travel Planning Use Case.


Question 4

The planning team decided that no user should be able to edit the Office Supplies general ledger account, since the planning team will do the estimates for all levels. What setting in a standard sheet do you use to make an account read-only for all levels?



Answer : B

In Workday Adaptive Planning standard sheets, the Level Availability setting controls whether an account is available for data entry (editable) or restricted to read-only access at each level. To make the Office Supplies account read-only for all levels, the administrator configures the Level Availability for that account to be read-only or unavailable across the entire level hierarchy. This setting overrides any level-specific edit permissions and ensures that regardless of a user's Edit access to a level, they cannot modify the Office Supplies account values on that sheet. Initial View controls the default display state of the sheet (collapsed/expanded). 'Customization for sub-levels' allows different configurations for child levels but does not enforce a universal read-only rule across all levels in a single setting. Account Groups organize accounts into sections within the sheet but do not control editability. Level Availability is the specific, purpose-built setting for controlling account-level read/write access within a standard sheet configuration. Reference: Workday Adaptive Planning --- Standard Sheet Configuration, Level Availability, Read-Only Account Settings.


Question 5

What task must you do before changing the default time stratum?



Answer : C

In Workday Adaptive Planning, before changing the default time stratum of an instance, all standard account data must be deleted. This is a prerequisite enforced by the system because the time stratum fundamentally defines how data is stored and aggregated across time periods. Standard account data is structured according to the current time stratum, and changing the stratum without clearing this data would create structural inconsistencies and orphaned data records that the system cannot reconcile. Once the data is deleted, the administrator can change the default time stratum and rebuild the time structure. This is why changing the default time stratum is considered a significant, typically one-time implementation decision that should be made before data is populated. Setting the stratum to a specific value, deleting the calendar, or appending the calendar are not prerequisites for this change --- the critical precondition is the deletion of existing standard account data. Reference: Workday Adaptive Planning --- Time Configuration, Default Time Stratum, System Setup Prerequisites.


Question 6

Which permissions are required to use OfficeConnect with Adaptive Planning?



Answer : A

To use Workday Adaptive Planning OfficeConnect --- the Microsoft Office integration that allows users to embed live Adaptive Planning data in Excel, Word, and PowerPoint --- users require two specific permissions in their permission set: 'Access Reports' and 'Access OfficeConnect.' Access Reports enables the user to retrieve report data from the Adaptive Planning model, which is the data source for all OfficeConnect content. Access OfficeConnect enables the user to authenticate and use the OfficeConnect add-in to connect their Office application to the Adaptive Planning instance. Without Access Reports, the user cannot pull model data for use in OfficeConnect documents. Without Access OfficeConnect, the integration itself is blocked. Import capabilities and Download to Excel are data management permissions unrelated to OfficeConnect functionality. Upload Files and Admin Access are administrative permissions outside the scope of OfficeConnect. Modify All Reports and Access Dashboards pertain to report administration and dashboard viewing, not OfficeConnect access. The combination of Access Reports and Access OfficeConnect is the definitive permission requirement. Reference: Workday Adaptive Planning --- OfficeConnect, Permission Requirements, Security Configuration.


Question 7

What feature enables you to allocate values from a year column into months on a standard sheet?



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.


Page:    1 / 14   
Total 61 questions