Question 1
Question
When importing data into the Financials framework, which Plan Element dimension member should be selected to help keep track of the cube’s data sources?
Answer
-
OFS_Integration
-
OFS_Calculated
-
OFS_Systems
-
OFS_Load
Question 2
Question
When modifying Employee and Job dimensions, what step is required to synchronize Smart Lists in Data Maps?
Answer
-
Execute the Rollup WFP Business Rule
-
Synchronize Data Maps
-
Execute the Synchronize Components Business Rule
-
Execute the Synchronize Defaults Business Rule
Question 3
Question
What is a navigation flow?
Answer
-
Functionality that enables running multiple business rules in a predetermined sequence
-
The application home page that users will see upon logging into the application
-
A type of report that shows variances by geography
-
A way to promote a plan to your supervisor
Question 4
Question
What Enterprise Planning and Budgeting Cloud (EPBCS) card in the Application cluster was built to navigate administrators through maintenance activities?
Answer
-
Data Maps
-
Overview
-
Settings
-
Valid Intersections
-
Configure
Question 5
Question
Which step is NOT associated with the ‘data load work bench” in Data Management?
Answer
-
Check
-
Validate
-
Import
-
Review
Question 6
Question
Which is NOT available for assigning customized navigation flows?
Question 7
Question
In order to set up weekly planning for a continuous 18 months, which three options would need to be selected/configured when initially enabling the Financials framework?
Answer
-
Weeks to months mapping
-
Weekly Planning
-
Rolling Forecast
-
Plan Element dimension
-
Custom Periods
Question 8
Question
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?
Answer
-
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.
-
Navigate to the Target Application screen in Data Management, and select the EPBCS application. Run the “Refresh Members and Metadata” action to update dimensions.
-
Navigate to the Target Application screen in Data Management, and select the EPBCS application. Run the “Refresh Metadata” action to update dimensions.
-
Navigate to the Application Dimensions screen in Data Management. Refresh dimensions using “Update Application” action.
Question 9
Question
Which two delimiters are supported when creating a metadata import file? (Choose two.)
Answer
-
Percent sign
-
Forward slash
-
Tab
-
Comma
Question 10
Question
Which two are valid commands in EPM Automate? (Choose two.)
Answer
-
epm automate clear cube
-
epm automate copy snapshot from instance “Artifact Snapshot” service Admin https://testcloud-pln.pbcs.us1.oraclecloud.com A12343
-
epm automate download file dataexport.txt
-
epm automate run business rule Rollup US Sales Period=Q1 Entity=USA
Question 11
Question
When a cube is enabled for sandboxes, what is the name of the dimension that is automatically added for the feature?
Answer
-
Sandboxes
-
HSP_Rates
-
ConsolidatedData
-
HSP_NoLink
-
HSP_View
Question 12
Question
Which three modules would you recommend deploying in ePBCS (Enterprise Planning and Budgeting Cloud)? (Choose three.)
Answer
-
Balance Sheet Planning
-
Statistical Planning
-
Capital Expense Planning
-
Workforce Planning
-
Project Planning
Question 13
Question
Which two are use cases for Smart Push? (Choose two.)
Answer
-
Allow the application to determine when it is best to synchronize data
-
Allow users to update data in another cube on-demand
-
Allow users to update data in a reporting cube upon saving data in the planning web form
-
Allow users to schedule when to synchronize data between cubes
Question 14
Question
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.)
Answer
-
Financial Data Quality Management Enterprise Edition (FDMEE)
-
Data Management
-
Data Maps
-
XREF member formulas
-
Import Data option with framework templates
-
DATAEXPORT command in Calculation Manager business rules
Question 15
Question
Which LCM Category is required to restore dimensional security?
Answer
-
Reporting
-
Groups and Memberships
-
Calculation Manager
-
Planning
Question 16
Question
Where would you navigate in Data Management to map source data to target scenarios?
Answer
-
Category Mapping
-
Target Application
-
Import Format
-
Data Flow Mapping
Question 17
Question
Which three metadata artifacts can be exported to a flat file? (Choose three.)
Answer
-
Data Entry Forms
-
Supporting Detail
-
Exchange Rate Tables
-
Smart Lists
-
Dimensions
Question 18
Question
After enabling the Financials framework, which three are recommended configuration tasks? (Choose three.)
Answer
-
Adding custom expense driver categories
-
Completing Planning and Forecast Preparation
-
Setting up exchange rates (for multicurrency applications)
-
Adding custom dimensions
-
Removing custom dimensions
Question 19
Question
Which two dimensions are displayed on the user point of view bar within a Financial Report? (Choose two.)
Answer
-
Dimension tagged as Time
-
Dimension tagged as Account
-
Dimensions in a row, column, or page that are flagged for the current point of view
-
Dimensions are not currently defined in a row, column, or page
Question 20
Question
Which three functions does the Enterprise Planning and Budgeting Cloud (EPBCS) data load templates allow?
Answer
-
Load data directly into Data Management without the need for mappings
-
Import business process data into a specific framework cube
-
Customize the data import process to your application’s unique requirements
-
Use the EPBCS Import Data feature
-
Allow for a single Excel template to load data to all frameworks without custom modifications
Question 21
Question
Which financial framework member within the Plan Element dimension stores the aggregated value of all driver-derived calculations after adjustments have been applied?
Answer
-
OFS_Adjustment
-
OFS_Trend
-
OFS_Calculated
-
OFS_Total
Question 22
Question
When setting up a data map, which two options are available for handling unmapped dimensions? (Choose two.)
Answer
-
Selecting multiple unmapped dimension members of the source to map to a single unmapped dimension member on the target
-
Selecting a single unmapped dimension members of the source to map to a single unmapped dimension member on the target
-
Selecting a single unmapped dimension members of the source to map to multiple unmapped dimension member on the target
-
Selecting multiple unmapped dimension members of the source to map to multiple unmapped dimension member on the target
Question 23
Question
Which three Financial framework members within the Plan Element dimension allow for forecast and plan data entry?
Question 24
Question
Which business rule is unavailable to manipulate existing employee data?
Answer
-
Remove Existing Employee
-
Change Job
-
Plan Departure
-
Transfer
Question 25
Question
Which three are Enterprise Planning and Budgeting Cloud (EPBCS) features that can be used to help streamline the amount of time a user spends in a web form? (Choose three.)
Answer
-
Valid intersections
-
Hide dimension name
-
Action menus
-
User variables
-
Workflow
Question 26
Question
Which two options related to Planning and Budgeting Cloud (PBCS) security are true? (Choose two.)
Answer
-
Users in the User role can create and edit Business Rules
-
Users can write to members in a dimension that are calculated
-
All users can install Smart View
-
Users can have different access to Data Forms between the SUI and Smart View
Question 27
Question
The company would like to enable Financials, Workforce, and Project frameworks. They would like to plan and forecast the Project dimension in the Financials framework, as well as track employee utilization in the projects framework. Which two actions must they take to ensure that the Project dimension is shared and the data integrated correctly across all three frameworks?
Answer
-
In the Projects framework, ensure that the Employee driver-based expense is enabled.
-
In the Workforce framework, rename one of the custom dimensions to “Project” and enable it
-
In the Financials framework, rename one of the custom dimensions to “Project” and enable it
-
In the Workforce framework, ensure that the granularity is at Employee or Employee and Job
Question 28
Question
Which two statements are true regarding the creation and management of business rules within the business process frameworks? (Choose two.)
Answer
-
The business process frameworks cannot use regular business rules – they must be scripted in Groovy
-
Custom business rules can be created for the business process frameworks
-
The pre-built framework business rules cannot be modified directly and saved
-
Custom business rules for the business process frameworks can only be created using the graphical designer
Question 29
Question
Which three are general methods for directly pushing data between cubes? (Choose three.)
Answer
-
Copy Data
-
Smart Push
-
Data Management
-
Import Data
-
Data Maps
Question 30
Question
To staff resources onto initiatives, which custom dimension is required in the Map/Rename Dimensions section?
Answer
-
Programs
-
Initiatives
-
Electives
-
Projects
Question 31
Question
Which two components can be installed on the administrator’s computer to support Planning and Budgeting Cloud (PBCS)? (Choose two.)
Question 32
Question
Which three security design principles will help reduce overall security maintenance and troubleshooting, while still balancing security control? (Choose three.)
Answer
-
Creating security groups over assigning individual access permissions to users
-
Using inherited permissions
-
Assigning a higher level role than necessary, then scaling back access permissions
-
Assigning global read access to each cube, then fine tuning none and write access within dimensional security
-
Configuring single sign-on (SSO)
Question 33
Question
Which LCM Category is required to restore Essbase data?
Answer
-
Calculation Manager
-
Planning
-
Data Management
-
Groups and Memberships
Question 34
Question
To configure ‘Benefits & Taxes”, which dimension should new members be imported into?
Answer
-
Pay Type
-
Component
-
Account
-
Property
Question 35
Question
When loading Employee data into Workforce Business Process, which month should the data be loaded into?
Answer
-
&OEP_FcstMnth
-
&OEP_CurMnth
-
&OEP_StartMnth
-
&OEP_EndMnth
Question 36
Question
Which statement is true when configuring the Projects option?
Answer
-
If using the Projects option, then the Capital option and the Workforce option must be configured
-
If using the Projects option, there is no dependency with the Capital option.
-
If using the Projects option, then the Capital option must also be configured.
-
If using the Projects option, then the Capital option must also be configured, only if capital projects are enabled.
Question 37
Question
What client requirement aligns with using a custom BSO plan type alongside the Enterprise Planning and Budgeting Cloud (EPBCS) plan types?
Answer
-
Due to sparse dimensionality, Aggregation times are slow in EPBCS.
-
The client has 10 dimensions in the EPBCS application and needs to report at each intersection.
-
The client requires to plan by more dimensions than the framework allows.
-
The client would like to plan revenue by Product.
-
The Operations department requires a more granular level of detail than the Sales department.
Question 38
Question
What are four types of values that can be used in business rule run-time prompts? (Choose four.)
Answer
-
Smart Lists
-
Text
-
Member of members
-
Dates
-
Numbers
-
Substitution Variables
Question 39
Question
What step is NOT required to calculate Merit dollars for each Employee within the Workforce framework?
Answer
-
Enter or Load a Merit Override Rate.
-
Enter or Load a Merit Month by employee.
-
Enter or Load a Performance Metric by employee.
-
Ensure there is a Merit Rate for each Performance Metric and component definitions have been updated
-
Execute the calculate Compensation Business Rule
Question 40
Question
Which year variable is NOT impacted by the Planning and Forecasting Preparation configuration step?
Answer
-
&OEP_CurYr
-
&OEP_YearRange
-
&OEP_YrlyFcstEnd
-
&OEP_FcstEndYr
Question 41
Question
If a user is having trouble accessing a specific intersection of data on a form that opens without error, which three actions can an administrator take to help troubleshoot the problem? (Choose three.)
Answer
-
Run a system report on Access Control
-
Confirm the user’s/group’s dimension access rights
-
Set Dimension Administration auditing within System Reports
-
Run Application Diagnostics
Question 42
Question
Which two options are true when implementing security in Enterprise Planning and Budgeting Cloud (EPBCS)? (Choose two.)
Answer
-
Users are restricted from applications by removing application/module security
-
EPBCS roles can be assigned to members in all dimensions
-
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
-
A user that is assigned read and write access to a member will result in write access
Question 43
Question
A user is new to creating business rules. Which two business rule features can help new users save time with pre-built components? (Choose two.)
Answer
-
Rule sets
-
Edit Script mode
-
Business rule templates
-
Business rule scripts
-
Designer mode
Question 44
Question
Which three are use cases for data maps? (Choose three.)
Answer
-
To push data from a planning cube to a reporting cube
-
To allow users to drill back to the data in a different cube
-
To integrate data between custom plan types and the business frameworks
-
To create a replicated partition between cubes
-
To integrate data between the business frameworks
Question 45
Question
Which OEP_WFSC dimension is NOT configurable in Enterprise Planning and Budgeting Cloud (EPBCS)?
Answer
-
Job
-
Property
-
Union Code
-
Component
Question 46
Question
Which two statements are false? (Choose two.)
Answer
-
Business logic is often developed in Rules.
-
Users connect to Data Management to update their budget and forecast.
-
Dashboards are not available in PBCS
-
Approvals allows the business to approve changes and request updates to budget and forecast data.
Question 47
Question
Which two operations can be performed on the default navigation flow? (Choose two.)
Answer
-
It can be copied.
-
It can be renamed
-
It can be deleted.
-
It can be deactivated.
Question 48
Question
Which three can be automated with EPM Automate? (Choose three.)
Question 49
Question
A company has enabled the Revenue/Gross Margin, Expense, Income Statement, and Balance Sheet options within the Financials framework and has run through the configuration steps.Which are three recommended post configuration tasks? (Choose three.)
Answer
-
Defining and managing the Accounts and Drives
-
Modifying account signage for alternate reporting methods
-
Entering exchange rates
-
Planning and Forecast preparation
-
Specifying days in period for driver-based Balance Sheet
-
Running Financials rules to aggregate and calculate the data
Question 50
Question
What is the correct sequence of steps for enabling each business process framework?
Answer
-
Enable the framework, refresh the database
-
Enable the framework, configure the framework, run post configuration tasks
-
Configure the framework, refresh the database
-
Run pre configuration tasks, enable the framework, configure the framework
Question 51
Question
Which Smart Push option would allow a user to push data to another cube after manually saving the form?
Question 52
Question
What would be the recommended Enterprise Planning and Budgeting Cloud (EPBC) cube architecture for a company wanting to enable the Financials and Capital frameworks, as well as create a Detailed Sales Forecasting cube with complex allocations and calculations, corresponding sales reporting cube, and consolidated reporting cube?
Answer
-
2 BSO cubes (1 required for the frameworks + 1 custom BSO cube), 2 ASO cubes
-
3 custom BSO cubes, 2 ASO cubes
-
3 BSO cubes (1 required for the frameworks + 2 custom BSO cubes), 2 ASO cubes
-
3 BSO cubes (2 required for the frameworks + 1 custom BSO cube), 2 ASO cubes
Question 53
Question
Which two statements are true about EPM Automate functions? (Choose two.)
Answer
-
Copy snapshot must use an encrypted password file
-
Downloading a file with only a file name looks to the Inbox folder
-
Deletepov removes data from a reporting application
-
Reset service deletes and resets the PBCS instance
Question 54
Question
Which three items would be in appropriate use case for “Data Management” in Enterprise Planning and Budgeting Cloud (EPBCS)? (Choose three.)
Answer
-
An organization requires the ability to provide “Drill-back” capabilities.
-
An organization requires the ability to load data to their application via flat files.
-
An organization requires the ability to build dimension hierarchies
-
An organization requires the ability to process data from multiple chart of accounts
-
An organization requires the ability to map data from multiple chart string segments to a single dimension
Question 55
Question
Which three parameters might be included when executing a REST Request? (Choose three.)
Answer
-
URL
-
Response Type
-
Payload
-
Content Type
-
Post Type
Question 56
Question
Which three are traits of the Sandboxes feature?
Answer
-
Sandboxes can be enabled at the application level only
-
Sandboxes can be enabled for BSO and ASO cubes
-
Planners can have multiple sandboxes
-
Planners can immediately see the effect of their changes
-
When working in a sandbox, planners can add members
Question 57
Question
Which two Essbase options can be changed in PBCS? (Choose two.)
Answer
-
The default caches
-
The default CalcTaskDims
-
Aggregate missing values
-
Two-Pass Calculation
Question 58
Question
Which two client requirements align with using an ASO plan type alongside the Enterprise Planning and Budgeting Cloud (EPBCS) plan types? (Choose two.)
Answer
-
Due to sparse dimensionality, Aggregation times are slow in EPBCS.
-
The client would like to plan revenue by Product and Services dimensions.
-
The client would like to report the results of the allocation process by Entity.
-
The client would like to store 10 years of actual history for reporting purposes but only requires prior year history for planning purposes
-
The client has 10 dimensions in the EPBCS application and needs to report at each intersection.
Question 59
Question
Which statement is true when executing an LCM migration?
Answer
-
Importing Dimensions will remove members that do not exist in the LCM Backup
-
Selected slices of data can be imported into Essbase
-
Restoring Essbase data from an LCM backup will remove any data that doesn’t exist in the backup
-
All forms that do not exist in the LCM backup will be deleted
Question 60
Question
When configuring expenses for driver and trend based calculations, which Action is NOT available for configuration?
Answer
-
Add Predefined Member
-
Add
-
Add Item
-
Add Expense Account
Question 61
Question
Which data map is not used to move data from OEP_WFP to OEP_REP?
Answer
-
Headcount Data for Reporting
-
Compensation Data for Reporting
-
FTE Data for Reporting
-
Non Compensation Data for Reporting
Question 62
Question
Which two items are NOT provided as configurable in Enterprise Planning and Budgeting Cloud (EPBCS)? (Choose two.)
Answer
-
Capital
-
Public
-
Financial Close
-
Financials
-
Strategic Modeling
Question 63
Question
Which item lists the available types of mapping in Data Management?
Answer
-
Explicit, Range, In, MultiDim, As
-
Explicit, Between, In, MultiDim, Like
-
Explicit, Range, In, Ignore, Like
-
Explicit, Range, In, MultiDim, Like
Question 64
Question
When enabling a business process framework, custom dimensions can be added by taking which action?
Answer
-
Renaming a dimension in the Map/Rename Dimensions section during enablement
-
Creating a new dimension through the Application Overview area
-
Adding a new dimension by loading it in Data Management
-
Adding a new dimension to the cube through the Create and Manage Dimensions area
Question 65
Question
Several users continuously use custom-created formulas in Excel to supplement their Planning form inputs. What is another design alternative to reduce offline Excel maintenance?
Answer
-
Ad Hoc Forms
-
Reports
-
Smart Forms
-
Cell commentary
-
Smart Push
Question 66
Question
Which two operations can be completed in calculation manager? (Choose two.)
Answer
-
View and kill requests
-
Delete a reporting application
-
Restructure a planning application
-
Create planning applications
Question 67
Question
Which two Jobs in Planning and Budgeting Cloud (PBCS) can be scheduled? (Choose two.)
Question 68
Question
Which three accounts leverage the component Dimension for driver and trend based calculations? (Answers not verified, do research on your own)
Answer
-
Cash Flow
-
Revenue
-
Expense
-
Balance Sheet
Question 69
Question
Which two options can be content within a report? (Choose two.)
Answer
-
Task lists
-
Data entry forms
-
Images
-
Grids
Question 70
Question
When loading Salaries into Workforce, which Property should the values be loaded to?
Answer
-
OWP_Gross Earnings
-
OWP_Expense Amount
-
OWP_Salary Basis
-
OWP_Value
Question 71
Question
Which artifact cannot be imported via a flat file?
Answer
-
Supporting Detail
-
Dimensions
-
Smart Lists
-
Exchange Rate Tables
Question 72
Question
What are two use cases for converting from Planning and Budgeting Cloud (PBCS) to Enterprise Planning and Budgeting Cloud (EPBCS)? (Choose two.)
Answer
-
The ability to directly integrate with Enterprise Performance Reporting Cloud (EPRCS).
-
The ability to leverage out of the box frameworks, like Financials and Projects.
-
The ability to utilize a fully integrated application, with shared metadata and direct data flows between plan types.
-
The ability to use Data Management.
-
The ability to directly integrate with on-premise Hyperion Planning.
Question 73
Question
Which two scenario configuration options are available within the Planning and Forecasting preparation area? (Choose two.)
Answer
-
Configure the Long Range Planning scenario Annually
-
Configure the Actual scenario for years 1 through 3 Monthly
-
Configure the Forecast scenario for years 1 through 3 Monthly, and Years 6 thru 10 Annually
-
Configure the Plan scenario for years 1 through 3 Bi-Weekly
-
Set the Current Month
Question 74
Question
A company has enabled the Financials business process and now would like to make changes to the initial configuration. Which three changes can be made after the initial setup of the Financials framework? (Choose three.)
Answer
-
Disabling already enabled features
-
Enabling Rolling Forecast
-
Enabling Income Statement
-
Enabling Expense
-
Removing custom dimensions
-
Adding custom dimensions
Question 75
Question
Which two are NOT true with a Planning and Budgeting Cloud (PBCS) application? (Choose two.)
Answer
-
Three custom planning applications can be Initialized
-
Four custom reporting applications can be initialized
-
Approvals is not included
-
Groovy calculations are available
Question 76
Question
A company wants to remove existing level zero data before allocating data back down to those same members. Which two graphical designer objects will help achieve this calculation process? (Choose two.)
Answer
-
Member Block
-
Clear Data
-
Allocation
-
Amount-Unit-Rate
-
Copy Data
Question 77
Question
If a user needs to be able to perform application administration, as well as assign user security in Enterprise Planning and Budgeting Cloud (EPBCS), which two global roles would need to be assigned to them? (Choose two.)
Question 78
Question
Which Substitution Variables are used in the ‘Process Loaded Data’ Business Rule?
Answer
-
&OEP_CurMnth, &OEP_CurYr, &OEP_YearRange
-
&OEP_FcstMnth, &OEP_FcstYr, &OEP_FcstEndYr
-
&OEP_PlanMnth, &OEP_PlanYr, &OEP_PlanRange
-
&OEP_LoadMnth, &OEP_LoadYr, &OEP_LoadRange
Question 79
Question
When calculating a tiered type of tax, what should be the selected ‘Maximum Value Type’?
Question 80
Question
A company wants to enable Cash Flow within the Financials framework using a derived method based on Operating, Investing, and Financing activities.
Which four options must be enabled to properly configure the Cash Flow Statement this way? (Choose four.)
Answer
-
Balance Sheet
-
Cash Flow Statement
-
Direct Method
-
Indirect Method
-
Income Statement
-
Expense