Data Loads / Data Maps
Which four are use cases for data maps? (Choose four.)
A. To integrate data between custom plan types and planning modules
B. To create a replicated partition between cubes
C. To push data from a planning cube to a reporting cube
D. To allow users to drill back to the data in a different cube
E. To integrate data between the planning modules
A. To integrate data between custom plan types and planning modules
B. To create a replicated partition between cubes
C. To push data from a planning cube to a reporting cube
E. To integrate data between the planning modules
What three actions can you perform on the data displayed in the Data Integration Workbench? (Choose three.)
A. Apply a filter using Equal and a specific value
B. Re-register or modify the data source system
C. Apply a filter using Contains and a specific value
D. Open loaded data in Microsoft Excel
E. Drill-through to source from specified data cells
A. Apply a filter using Equal and a specific value
C. Apply a filter using Contains and a specific value
E. Drill-through to source from specified data cells
** SURPRISE Strategic Modelling Questions **
What is the difference between Financials and Strategic Modeling? (Choose the best answer.)
A. There is not a technical difference, both do essentially the same thing
B. Ownership Contributions and Consolidations are out of the box in Financials
C. Strategic Modeling is broader in focus and used for long range planning
D. Financials is more summarized than Strategic Modeling
C. Strategic Modeling is broader in focus and used for long range planning
Which describes Strategic Modeling? Choose the best answer.
A. Used primarily for balance sheet planning
B. Used to develop plans and forecasts and generate core financial statements
C. Used to evaluate financial scenarios and perform financial impact analysis.
D. Used to evaluate how assets and resources related to corporate initiatives are allocated
C. Used to evaluate financial scenarios and perform financial impact analysis.
** Session 2: Security **
Which option is true when implementing security in Enterprise Planning and Budgeting Cloud (EPBCS)? (Choose one option.)
A. The member that is set to read that has a parent with write access to all descendants will result in an access level of read
B. EPBCS roles can be assigned to members in all dimensions
C. A user that is assigned read and write access to a member will result in write access
D. Users are restricted from applications by removing application/module security
A. The member that is set to read that has a parent with write access to all descendants will result in an access level of read
Which data maps are used to move data from OEP_WFP to OEP_REP? (Choose three).
A. Headcount Data for Reporting
B. FTE Data for Reporting
C. Compensation Data for Reporting
D. Non Compensation Data for Reporting
A. Headcount Data for Reporting
C. Compensation Data for Reporting
D. Non Compensation Data for Reporting
An organization adds a dimension to their Enterprise Planning and Budgeting Cloud (EPBCS) planning application. Assuming that Data Management is being utilized, which step would need to be executed?
A. Navigate to the Target Application screen in Data Management, and select the EPBCS application. Run the “Refresh Metadata” action to update dimensions.
B. Navigate to the Import Format screen in Data Management. Select the Import Format for the EPBCS application. Run the “Refresh Members and Metadata” action to update dimensions.
C. Navigate to the Target Application screen in Data Management, and select the EPBCS application. Run the “Refresh Members and Metadata” action to update dimensions.
D. Navigate to the Application Dimensions screen in Data Management. Refresh dimensions using “Update Application” action.
A. Navigate to the Target Application screen in Data Management, and select the EPBCS application. Run the “Refresh Metadata” action to update dimensions.
Which three are traits of the Sandboxes feature?
A. Planners can have multiple sandboxes
B. Planners can immediately see the effect of their changes
C. Sandboxes can be enabled at the application level only
D. When working in a sandbox, planners can add members
E. Sandboxes can be enabled for BSO and ASO cubes
A. Planners can have multiple sandboxes
B. Planners can immediately see the effect of their changes
D. When working in a sandbox, planners can add members
In Strategic Modeling Simulations, which probability distribution describes many phenomena such as returns on equity or assets, inflation rates, or currency fluctuations? (Choose the best answer.)
A. BetaPERT
B. Lognormal
C. Triangular
D. Normal
E. Uniform
D. Normal
** Session 1: Admin Tasks **
Which two Jobs in Planning and Budgeting Cloud (PBCS) can be scheduled? (Choose two.)
A. Executing Data Maps
B. Import Data
C. Executing a Data Management process
D. Restarting the PBCS instance
A. Executing Data Maps
B. Import Data
When loading flat file data from external systems into the Enterprise Planning and Budgeting Cloud (EPBCS) business process frameworks, which three are recommended methods? (Choose three.)
A. Data Maps
B. XREF member formulas
C. Data Management
D. Import Data option with framework templates
E. DATAEXPORT command in Calculation Manager business rules
F. Financial Data Quality Management Enterprise Edition (FDMEE) (Essentially Data Management)
C. Data Management
D. Import Data option with framework templates
F. Financial Data Quality Management Enterprise Edition (FDMEE) (Essentially Data Management)
In Data Management, what are the steps you need to perform to synchronize the application metadata in the target application? (Choose the best answer.)
A. In Data Management, navigate to Application Dimensions and click Refresh Dimensions.
B. In Data Management, navigate to Target Application and select your Planning application. Click Refresh Members.
C. In Data Management, navigate to Import Format and select your Planning application. Click Refresh Dimensions.
D. In Data Management, navigate to Target Application and select your Planning application. Click Refresh Metadata.
B. In Data Management, navigate to Target Application and select your Planning application. Click Refresh Members.
** SURPRISE Strategic Modelling Questions **
Which two roles can be set for Strategic Modeling? Choose two.
A. Forecaster
B. Analyst
C. Modeler
D. Planner
B. Analyst
C. Modeler
In Strategic Modeling Simulations, what are the three guidelines for selecting the appropriate probability distribution? (Choose three.)
A. Randomly generate a range of values for assumptions and enter best guess estimates one cell at a time.
B. Review the descriptions of the probability distributions.
C. Select the distribution where the conditions of the distribution match those of the input.
D. Evaluate the input in question, and list the conditions surrounding this input.
E. Use the Monte Carlo method to best guess your probability distribution options based on a range of assumptions.
B. Review the descriptions of the probability distributions.
C. Select the distribution where the conditions of the distribution match those of the input.
D. Evaluate the input in question, and list the conditions surrounding this input.
** Session 2: Configuration **
After enabling the Financials framework, which three are recommended configuration tasks? (Choose three.)
A. Setting up exchange rates (for multicurrency applications)
B. Adding custom dimensions
C. Completing Planning and Forecast Preparation
D. Adding custom expense driver categories
E. Removing custom dimensions
A. Setting up exchange rates (for multicurrency applications)
C. Completing Planning and Forecast Preparation
D. Adding custom expense driver categories
Which three functions does the Enterprise Planning and Budgeting Cloud (EPBCS) data load templates allow?
A. Allow for a single Excel template to load data to all frameworks without custom modifications
B. Load data directly into Data Management without the need for mappings
C. Import business process data into a specific framework cube
D. Customize the data import process to your application’s unique requirements
E. Use the EPBCS Import Data feature
C. Import business process data into a specific framework cube
D. Customize the data import process to your application’s unique requirements
E. Use the EPBCS Import Data feature
** SURPRISE Strategic Modeling Questions **
What three time period management tasks can you perform in Strategic Modeling? (Choose three.)
A. Select and combine periods of years, halves, quarters, months, and weeks for the beginning balance year.
B. Combine periods of years, halves, quarters, months, and weeks for historical forecast data.
C. Enable the input option for upper level time periods when you add time detail.
D. Configure time periods to reflect the detail required by financial models, such as different levels of granularity for different years.
E. Create period-to-date, trailing periods, deal periods, and sub periods to record transactions.
B. Combine periods of years, halves, quarters, months, and weeks for historical forecast data.
D. Configure time periods to reflect the detail required by financial models, such as different levels of granularity for different years.
E. Create period-to-date, trailing periods, deal periods, and sub periods to record transactions.
Which three statements are TRUE for Sandboxes? (Choose three.)
A. After you enable sandboxes for a cube, you can't later disable that option.
B. If you enable sandboxes for a cube, Version members have the Enable Sandboxes option.
C. You can enable sandboxes only in Planning cubes and for custom cubes created in module-based Planning, not for Reporting cubes.
D. After you enable sandboxes for a cube, you can later disable that option.
E. You can enable sandboxes for all Planning cubes and Reporting cubes.
A. After you enable sandboxes for a cube, you can't later disable that option.
B. If you enable sandboxes for a cube, Version members have the Enable Sandboxes option.
C. You can enable sandboxes only in Planning cubes and for custom cubes created in module-based Planning, not for Reporting cubes.
Which two are supported funding methods in Strategic Modeling? (Choose two.)
A. Standard funding method
B. Proposed Projects funding method
C. Target Capital Structure funding method
D. Employee-based funding method
A. Standard funding method
C. Target Capital Structure funding method
** Session 2: Valid Intersections **
Which three describe what you can do with Valid Intersections? (Choose three.)
A. Restrict cells containing invalid data, setting them to a read-only state within forms.
B. Specify that certain programs are valid only for some periods or departments.
C. Filter cell intersections to users when they enter data or select runtime prompts
D. Allow all users to select from a non-filtered list of members on the form's point of view
E. Prevent the user from executing any type of Calculation Manager rule that uses runtime prompts
A. Restrict cells containing invalid data, setting them to a read-only state within forms.
B. Specify that certain programs are valid only for some periods or departments.
C. Filter cell intersections to users when they enter data or select runtime prompts