Important Workday-Adaptive-Planning Exam Questions

Answer: C

Explanation:

In Workday Adaptive Planning, the Formula Assistant is the built-in tool designed specifically to help users construct, validate, and test formulas within the system. The Formula Assistant provides an interactive interface for browsing available functions (such as div, divf, if, sum), selecting valid account references, choosing appropriate time modifiers, and reviewing function syntax --- all without requiring the user to memorize formula syntax from scratch. It provides real-time syntax guidance, function descriptions with parameter explanations, and the ability to test formula logic against actual data before committing. This is the primary tool for formula development and validation in Adaptive Planning. Account Details provides metadata about an account's configuration but does not assist in formula construction. Linked Accounts shows accounts that reference each other but is not a formula building tool. Shared Formulas is a method for applying the same formula across multiple levels or accounts but is not an interactive assistance feature. The Formula Assistant is the official, purpose-built formula construction tool in Adaptive Planning. Reference: Workday Adaptive Planning --- Formula Assistant, Formula Development, Account Formula Configuration.

Answer: B

Explanation:

The issue in the original formula is that ACCT.Lookups.Rate[Level=TopLevel(-)] retrieves the rate for all Product dimension values aggregated at the top level, rather than the rate specific to each individual Product dimension value being calculated. When the rate reference does not specify the Product dimension modifier, it pulls the aggregate (summed or unfiltered) rate value, resulting in inflated multiplication results. The corrected formula ACCT.Sales.Units * ACCT.Lookups.Rate[Level=TopLevel(-), Product=this] adds the 'Product=this' modifier, which instructs Adaptive Planning to look up the rate for the same Product dimension value as the current row being calculated. The 'this' keyword is a dynamic reference that matches the current dimension context. Level=TopLevel(-) correctly retrieves the globally-entered assumption rate (entered once at the top level), while Product=this ensures the rate corresponds to the specific product being evaluated. Without the Product=this modifier, the formula aggregates across all product rates, causing inflated results. Reference: Workday Adaptive Planning --- Cube Sheet Formulas, Dimension Modifiers, 'this' Keyword, Level Modifiers.

Answer: C

Explanation:

In Workday Adaptive Planning, when an account is deleted from the model, all associated formulas and data stored in that account are permanently and irreversibly deleted across all versions and all levels. There is no automatic transfer, reassignment, or archiving mechanism. The system does not migrate data to sibling accounts or parent rollups upon deletion. This is a critical and irreversible action --- once the Rent account is removed, its historical actuals, plan data, and any formulas are permanently lost from the model. This behavior underscores the importance of data backup and version control before performing structural changes. Administrators should export or archive data before deleting accounts. The rollup account Total Operating Expenses will continue to function but will now only aggregate the remaining child, Salaries. Any reports or dashboards referencing the deleted Rent account will return errors or blank values. Reference: Workday Adaptive Planning --- Account Management, Account Deletion Behavior, Model Maintenance Best Practices.

Answer: C

Explanation:

The optimal design for this scenario is a separate cube sheet configured with the Job Profile dimension, where salaries are entered once at the Top Level (eliminating level-by-level duplication) at the Year time stratum (since salaries are standardized annually). This architecture achieves minimal inputs by requiring HR managers to enter each job profile salary only once per year at the top level, which is then referenced universally across all levels. Segregated security is achieved by controlling access to this separate salary assumption sheet independently from the plant managers' headcount input sheet --- plant managers only access the headcount cube sheet while HR managers exclusively access the salary cube sheet. Combining salary and headcount input on the same sheet (Option A) eliminates security segregation. A Personnel sheet with calculated averages (Option B) adds complexity without addressing input minimization. Assumption accounts per job profile (Option D) would require separate accounts for potentially dozens of job profiles, creating an unmaintainable account structure. Reference: Workday Adaptive Planning --- Cube Sheet Design, Top Level Entry, Year Stratum, Security Architecture.

Answer: C

Explanation:

In Workday Adaptive Planning, all level-assigned sheets --- including standard sheets, modeled sheets, and cube sheets that have been configured and assigned to specific levels --- are accessible through the Sheets section of the application. The Sheets area serves as the central hub for data entry and planning activities, presenting users with the sheets available to them based on their level access and permission settings. Users navigate to Sheets from the main navigation to find all planning input sheets relevant to their assigned levels. The Assumptions area specifically contains Assumption accounts for global rate and constant entry. Reports is for running and viewing financial and management reports. Modeling is the administrative area for building and configuring the model structure, accounts, and sheets --- but it is not where end users go to view or access their assigned sheets for data entry. The Sheets navigation area is the correct and official location for users to access and interact with level-assigned planning sheets. Reference: Workday Adaptive Planning --- Sheets Navigation, Level-Assigned Sheets, User Interface.