DAVID SHIROMA
Quiz by , created more than 1 year ago

Professional Development Quiz on Oracle 1Z0-1080-20 Planning 2020 Implementation Essentials, created by DAVID SHIROMA on 24/02/2021.

2479
3
1
DAVID SHIROMA
Created by DAVID SHIROMA almost 4 years ago
Close

Oracle 1Z0-1080-20 Planning 2020 Implementation Essentials

Oracle 1Z0-1080-20 Planning 2020 Implementation Essentials

Question 1 of 125

1

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?

Select one of the following:

  • OFS_Integration

  • OFS_Calculated

  • OFS_Systems

  • OFS_Load

Explanation

Question 2 of 125

1

When modifying Employee and Job dimensions, what step is required to synchronize Smart Lists in Data Maps?

Select one of the following:

  • Execute the Rollup WFP Business Rule

  • Synchronize Data Maps

  • Execute the Synchronize Components Business Rule

  • Execute the Synchronize Defaults Business Rule

Explanation

Question 3 of 125

1

What is a navigation flow?

Select one of the following:

  • 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

Explanation

Question 4 of 125

1

What Enterprise Planning and Budgeting Cloud (EPBCS) card in the Application cluster was built to navigate administrators through maintenance activities?

Select one of the following:

  • Data Maps

  • Overview

  • Settings

  • Valid Intersections

  • Configure

Explanation

Question 5 of 125

1

Which step is NOT associated with the ‘data load work bench” in Data Management?

Select one of the following:

  • Check

  • Validate

  • Import

  • Review

Explanation

Question 6 of 125

1

Which is NOT available for assigning customized navigation flows?

Select one of the following:

  • Global

  • Group

  • User

  • Role

Explanation

Question 7 of 125

1

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? (Select all that apply)

Select one or more of the following:

  • Weeks to months mapping

  • Weekly Planning

  • Rolling Forecast

  • Plan Element dimension

  • Custom Periods

Explanation

Question 8 of 125

1

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?

Select one of the following:

  • 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 the “Update Application” action.

Explanation

Question 9 of 125

1

Which two delimiters are supported when creating a metadata import file? (Choose two.)

Select one or more of the following:

  • Percent sign

  • Forward slash

  • Tab

  • Comma

Explanation

Question 10 of 125

1

Which two are valid commands in EPM Automate? (Choose two.)

Select one or more of the following:

  • 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

Explanation

Question 11 of 125

1

When a cube is enabled for sandboxes, what is the name of the dimension that is automatically added for the feature?

Select one of the following:

  • Sandboxes

  • HSP_Rates

  • ConsolidatedData

  • HSP_NoLink

  • HSP_View

Explanation

Question 12 of 125

1

Which three modules would you recommend deploying in EPBCS (Enterprise Planning and Budgeting Cloud)? (Choose three.)

Select one or more of the following:

  • Balance Sheet Planning

  • Statistical Planning

  • Capital Expense Planning

  • Workforce Planning

  • Project Planning

Explanation

Question 13 of 125

1

Which two are use cases for Smart Push? (Choose two.)

Select one or more of the following:

  • 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

Explanation

Question 14 of 125

1

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.)

Select one or more of the following:

  • 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

Explanation

Question 15 of 125

1

Which migration in Snapshot is required to restore dimensional security?

Select one of the following:

  • Reporting

  • Groups and Memberships

  • Calculation Manager

  • Planning

Explanation

Question 16 of 125

1

Where would you navigate in Data Management to map source data to target scenarios?

Select one of the following:

  • Category Mapping

  • Target Application

  • Import Format

  • Data Flow Mapping

Explanation

Question 17 of 125

1

Which three metadata artifacts can be exported to a flat file? (Choose three.)

Select one or more of the following:

  • Data Entry Forms

  • Supporting Detail

  • Exchange Rate Tables

  • Smart Lists

  • Dimensions

Explanation

Question 18 of 125

1

After enabling the Financials framework, which three are recommended configuration tasks? (Choose three.)

Select one or more of the following:

  • Adding custom expense driver categories

  • Completing Planning and Forecast Preparation

  • Setting up exchange rates (for multicurrency applications)

  • Adding custom dimensions

  • Removing custom dimensions

Explanation

Question 19 of 125

1

Which two dimensions are displayed on the user point of view bar within a Financial Report? (Choose two.)

Select one or more of the following:

  • 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

Explanation

Question 20 of 125

1

Which three functions does the Enterprise Planning and Budgeting Cloud (EPBCS) data load templates allow?

Select one or more of the following:

  • 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

Explanation

Question 21 of 125

1

Which financial framework member within the Plan Element dimension stores the aggregated value of all driver-derived calculations after adjustments have been applied?

Select one of the following:

  • OFS_Adjustment

  • OFS_Trend

  • OFS_Calculated

  • OFS_Total

Explanation

Question 22 of 125

1

When setting up a data map, which two options are available for handling unmapped dimensions? (Choose two.)

Select one or more of the following:

  • 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

Explanation

Question 23 of 125

1

Which three Financials framework members within the Plan Element dimension allow for forecast and plan data entry?

Select one or more of the following:

  • OFS_Direct Input

  • OFS_Input

  • OFS_Form Entry

  • OFS_Trend

  • OFS_% Increase/(Decrease)

Explanation

Question 24 of 125

1

Which business rule is unavailable to manipulate existing employee data?

Select one of the following:

  • Remove Existing Employee

  • Change Job

  • Plan Departure

  • Transfer

Explanation

Question 25 of 125

1

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.)

Select one or more of the following:

  • Valid intersections

  • Hide dimension name

  • Action menus

  • User variables

  • Workflow

Explanation

Question 26 of 125

1

Which two options related to Planning and Budgeting Cloud (PBCS) security are true? (Choose two.)

Select one or more of the following:

  • 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

Explanation

Question 27 of 125

1

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?

Select one or more of the following:

  • 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

Explanation

Question 28 of 125

1

Which two statements are true regarding the creation and management of business rules within the business process frameworks? (Choose two.)

Select one or more of the following:

  • 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

Explanation

Question 29 of 125

1

Which three are general methods for directly pushing data between cubes? (Choose three.)

Select one or more of the following:

  • Copy Data

  • Smart Push

  • Data Management

  • Import Data

  • Data Maps

Explanation

Question 30 of 125

1

To staff resources onto initiatives, which custom dimension is required in the Map/Rename Dimensions section?

Select one of the following:

  • Programs

  • Initiatives

  • Electives

  • Projects

Explanation

Question 31 of 125

1

Which two components can be installed on the administrator’s computer to support Planning and Budgeting Cloud (PBCS)? (Choose two.)

Select one or more of the following:

  • Strategic Modeling

  • Calculation Manager

  • EPM Automate

  • The Simplified User Interface

Explanation

Question 32 of 125

1

Which three security design principles can help reduce overall security maintenance and troubleshooting, while still balancing security control? (Choose three.)

Select one or more of the following:

  • Creating groups over assigning individual access permissions to users

  • Configuring single sign-on (SSO)

  • Assigning a higher-level role than necessary, then scaling back access permissions

  • Using inherited permissions

  • Assigning global read access to each cube, then fine-tuning none and write access within dimensional security

Explanation

Question 33 of 125

1

Which LCM Category is required to restore Essbase data?

Select one of the following:

  • Calculation Manager

  • Planning

  • Data Management

  • Groups and Memberships

Explanation

Question 34 of 125

1

To configure ‘Benefits & Taxes”, which dimension should new members be imported into?

Select one of the following:

  • Pay Type

  • Component

  • Account

  • Property

Explanation

Question 35 of 125

1

When loading Employee data into Workforce Business Process, which month should the data be loaded into?

Select one of the following:

  • &OEP_FcstMnth

  • &OEP_CurMnth

  • &OEP_StartMnth

  • &OEP_EndMnth

Explanation

Question 36 of 125

1

Which statement is true when configuring the Projects option?

Select one of the following:

  • 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.

Explanation

Question 37 of 125

1

What client requirement aligns with using a custom BSO plan type alongside the Enterprise Planning and Budgeting Cloud (EPBCS) plan types?

Select one of the following:

  • 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.

Explanation

Question 38 of 125

1

What are four types of values that can be used in business rule run-time prompts? (Choose four.)

Select one or more of the following:

  • Smart Lists

  • Integer

  • Member or members

  • Dates by Numbers

  • Numbers

  • Substitution Variables

  • String

  • Text

Explanation

Question 39 of 125

1

What step is NOT required to calculate Merit dollars for each Employee within the Workforce framework?

Select one of the following:

  • 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

Explanation

Question 40 of 125

1

Which year variable is NOT impacted by the Planning and Forecasting Preparation configuration step?

Select one of the following:

  • &OEP_CurYr

  • &OEP_YearRange

  • &OEP_YrlyFcstEnd

  • &OEP_FcstEndYr

Explanation

Question 41 of 125

1

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.)

Select one or more of the following:

  • 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

Explanation

Question 42 of 125

1

Which two options are true when implementing security in Enterprise Planning and Budgeting Cloud (EPBCS)? (Choose two.)

Select one or more of the following:

  • 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

Explanation

Question 43 of 125

1

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.)

Select one or more of the following:

  • Rule sets

  • Edit Script mode

  • Business rule templates

  • Business rule scripts

  • Designer mode

Explanation

Question 44 of 125

1

Which three are use cases for data maps? (Choose four.)

Select one or more of the following:

  • 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 planning modules

  • To create a replicated partition between cubes

  • To integrate data between the planning modules

Explanation

Question 45 of 125

1

Which OEP_WFSC dimension is NOT configurable in Enterprise Planning and Budgeting Cloud (EPBCS)?

Select one of the following:

  • Job

  • Property

  • Union Code

  • Component

Explanation

Question 46 of 125

1

Which two statements are false? (Choose two.)

Select one or more of the following:

  • 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.

Explanation

Question 47 of 125

1

Which two operations can be performed on the default navigation flow? (Choose two.)

Select one or more of the following:

  • It can be copied.

  • It can be renamed

  • It can be deleted.

  • It can be deactivated.

Explanation

Question 48 of 125

1

Which three can be automated with EPM Automate? (Choose three.)

Select one or more of the following:

  • Send an email to users

  • Run a Business Rule

  • Import a file into the EPBCS’s inbox

  • Import user security

  • Migrate a backup between test and production

Explanation

Question 49 of 125

1

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.)

Select one or more of the following:

  • Defining and managing the Accounts and Drivers

  • 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

Explanation

Question 50 of 125

1

Is the sequence of steps for enabling each business process framework?

Select one of the following:

  • 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

Explanation

Question 51 of 125

1

Which Smart Push option would allow a user to push data to another cube after manually saving the form?

Select one of the following:

  • Use form context

  • Run after save

  • Run form rules on autosave

  • Overwrite selection

Explanation

Question 52 of 125

1

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?

Select one of the following:

  • 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 cubes + 1 custom BSO cube), 2 ASO cubes

Explanation

Question 53 of 125

1

Which two statements are true about EPM Automate functions? (Choose two.)

Select one or more of the following:

  • 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

  • Resetservice deletes and resets the PBCS instance

Explanation

Question 54 of 125

1

Which three items would be an appropriate use case for “Data Management” in Enterprise Planning and Budgeting Cloud (EPBCS)? (Choose three.)

Select one or more of the following:

  • 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

Explanation

Question 55 of 125

1

Which three parameters might be included when executing a REST Request? (Choose three.)

Select one or more of the following:

  • URL

  • Response Type

  • Payload

  • Content Type

  • Post Type

Explanation

Question 56 of 125

1

Which three are traits of the Sandboxes feature?

Select one or more of the following:

  • 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

Explanation

Question 57 of 125

1

Which two Essbase options can be changed in PBCS? (Choose two.)

Select one or more of the following:

  • The default caches

  • The default CalcTaskDims

  • Aggregate missing values

  • Two-Pass Calculation

Explanation

Question 58 of 125

1

Which two client requirements align with using an ASO plan type alongside the Enterprise Planning and Budgeting Cloud (EPBCS) plan types? (Choose two.)

Select one or more of the following:

  • 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.

Explanation

Question 59 of 125

1

Which statement is true when executing a Lifecycle Management migration? Choose the best answer.

Select one of the following:

  • Restoring Essbase data from a snapshot will remove any data that doesn't exist in the backup.

  • Importing Dimensions will remove members that do not exist in the snapshot.

  • Selected slices of data can be imported into Essbase.

  • All forms that do not exist in the snapshot will be deleted.

Explanation

Question 60 of 125

1

When configuring expenses for driver and trend based calculations, which Action is NOT available for configuration?

Select one of the following:

  • Add Predefined Member

  • Add

  • Add Item

  • Add Expense Account

Explanation

Question 61 of 125

1

Which data maps are used to move data from OEP_WFP to OEP_REP? (Choose three).

Select one or more of the following:

  • Headcount Data for Reporting

  • Compensation Data for Reporting

  • FTE Data for Reporting

  • Non Compensation Data for Reporting

Explanation

Question 62 of 125

1

Which two items are NOT provided as configurable in Enterprise Planning and Budgeting Cloud (EPBCS)? (Choose two.)

Select one or more of the following:

  • Capital

  • Public

  • Financial Close

  • Financials

  • Strategic Modeling

Explanation

Question 63 of 125

1

Which item lists the available types of mapping in Data Management?

Select one of the following:

  • Explicit, Range, In, MultiDim, As

  • Explicit, Between, In, MultiDim, Like

  • Explicit, Range, In, Ignore, Like

  • Explicit, Range, In, MultiDim, Like

Explanation

Question 64 of 125

1

When enabling a business process framework, custom dimensions can be added by taking which action?

Select one of the following:

  • 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

Explanation

Question 65 of 125

1

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?

Select one of the following:

  • Ad Hoc Forms

  • Reports

  • Smart Forms

  • Cell commentary

  • Smart Push

Explanation

Question 66 of 125

1

Which two operations can be completed in calculation manager? (Choose two.)

Select one or more of the following:

  • View and kill requests

  • Delete a reporting application

  • Restructure a planning application

  • Create planning applications

Explanation

Question 67 of 125

1

Which two Jobs in Planning and Budgeting Cloud (PBCS) can be scheduled? (Choose two.)

Select one or more of the following:

  • Executing Data Maps

  • Import Data

  • Executing a Data Management process

  • Restarting the PBCS instance

Explanation

Question 68 of 125

1

Which three accounts leverage the component Dimension for driver and trend based calculations? (Answers not verified, do research on your own)

Select one or more of the following:

  • Cash Flow

  • Revenue

  • Expense

  • Balance Sheet

Explanation

Question 69 of 125

1

Which two options can be content within a report? (Choose two.)

Select one or more of the following:

  • Task lists

  • Data entry forms

  • Images

  • Grids

Explanation

Question 70 of 125

1

When loading Salaries into Workforce, which Property should the values be loaded to?

Select one of the following:

  • OWP_Gross Earnings

  • OWP_Expense Amount

  • OWP_Salary Basis

  • OWP_Value

Explanation

Question 71 of 125

1

Which artifact cannot be imported via a flat file?

Select one of the following:

  • Supporting Detail

  • Dimensions

  • Smart Lists

  • Exchange Rate Tables

Explanation

Question 72 of 125

1

What are two use cases for converting from Planning and Budgeting Cloud (PBCS) to Enterprise Planning and Budgeting Cloud (EPBCS)? (Choose two.)

Select one or more of the following:

  • 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.

Explanation

Question 73 of 125

1

Which two scenario configuration options are available within the Planning and Forecasting preparation area? (Choose two.)

Select one or more of the following:

  • 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

Explanation

Question 74 of 125

1

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.)

Select one or more of the following:

  • Disabling already enabled features

  • Enabling Rolling Forecast

  • Enabling Income Statement

  • Enabling Expense

  • Removing custom dimensions

  • Adding custom dimensions

Explanation

Question 75 of 125

1

Which two are NOT true with a Planning and Budgeting Cloud (PBCS) application? (Choose two.)

Select one or more of the following:

  • Three custom planning applications can be Initialized

  • Four custom reporting applications can be initialized

  • Approvals is not included

  • Groovy calculations are available

Explanation

Question 76 of 125

1

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.)

Select one or more of the following:

  • Member Block

  • Clear Data

  • Allocation

  • Amount-Unit-Rate

  • Copy Data

Explanation

Question 77 of 125

1

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.)

Select one or more of the following:

  • Service Administrator

  • Identity Domain Administrator

  • Approvals Administrator

  • System Administrator

Explanation

Question 78 of 125

1

Which Substitution Variables are used in the ‘Process Loaded Data’ Business Rule?

Select one of the following:

  • &OEP_CurMnth, &OEP_CurYr, &OEP_YearRange

  • &OEP_FcstMnth, &OEP_FcstYr, &OEP_FcstEndYr

  • &OEP_PlanMnth, &OEP_PlanYr, &OEP_PlanRange

  • &OEP_LoadMnth, &OEP_LoadYr, &OEP_LoadRange

Explanation

Question 79 of 125

1

When calculating a tiered type of tax, what should be the selected ‘Maximum Value Type’?

Select one of the following:

  • Threshold Amount

  • Percentage of Taxable Earnings

  • Percentage of Salary

  • Flat Amount

  • Percentage of Overall Earnings

Explanation

Question 80 of 125

1

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.)

Select one or more of the following:

  • Balance Sheet

  • Cash Flow Statement

  • Direct Method

  • Indirect Method

  • Income Statement

  • Expense

Explanation

Question 81 of 125

1

What is the difference between Financials and Strategic Modeling? (Choose the best answer.)

Select one of the following:

  • There is not a technical difference, both do essentially the same thing

  • Ownership Contributions and Consolidations are out of the box in Financials

  • Strategic Modeling is broader in focus and used for long range planning

  • Financials is more summarized than Strategic Modeling

Explanation

Question 82 of 125

1

Which two tasks can be scheduled as a job in Planning? (Choose two.)

Select one or more of the following:

  • Import or export data

  • Create snapshots

  • Promote a Planning Unit

  • Execute Data Maps

Explanation

Question 83 of 125

1

What does a navigation flow allow you to do? Choose the best answer.

Select one of the following:

  • Promote a plan to your supervisor

  • Display report variances by geography

  • Run multiple business rules in a predetermined sequence

  • Customize the clusters and cards that a user can access

Explanation

Question 84 of 125

1

In order to be able to configure Additional Earnings in the Benefits and Taxes wizard, into which dimension do you have to import members? Choose the best answer.

Select one of the following:

  • Pay Type

  • Property

  • Component

  • Account

Explanation

Question 85 of 125

1

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.)

Select one of the following:

  • Normal

  • Lognormal

  • Triangular

  • BetaPERT

  • Uniform

Explanation

Question 86 of 125

1

After loading Workforce data from external systems, which statement describes actions you can take to make adjustments to loaded data and then calculate compensation expenses? Choose the best answer.

Select one or more of the following:

  • In Workforce, change properties such as salary grade and FTE, and then calculate salary, benefits, additional earnings, and taxes based on assumptions in Planning.

  • Change loaded salary information in Workforce and then run the data map for Compensation Data to calculate the updated benefits.

  • Change loaded benefit information in Workforce such as options for medical benefits and then launch the compensation data business rule to calculate the updated benefit data.

  • In Workforce, if you change both the selected benefit option and the rate, when compensation expenses are calculated, the value will be based on the benefit option's default value.

Explanation

Question 87 of 125

1

Which three statements are TRUE for Sandboxes? (Choose three.)

Select one or more of the following:

  • After you enable sandboxes for a cube, you can later disable that option.

  • You can enable sandboxes for all Planning cubes and Reporting cubes.

  • If you enable sandboxes for a cube, Version members have the Enable Sandboxes option.

  • You can enable sandboxes only in Planning cubes and for custom cubes created in module-based Planning, not for Reporting cubes.

  • After you enable sandboxes for a cube, you can't later disable that option.

Explanation

Question 88 of 125

1

Which two are benefits of enabling Use Database Suppression in Smart Push? (Choose two.)

Select one or more of the following:

  • It automatically merges comments, attachments, and supporting detail when mapping a cube for reporting.

  • It helps eliminate the impact on query thresholds and improving wait times.

  • It allows you to continue using the application while Smart Push runs in the background.

  • It enables you to apply row suppression at the database level instead of the application level.

Explanation

Question 89 of 125

1

Whenever you change dimensionality in a target cube, what action on the Data Maps page must you take to ensure that you see metadata changes immediately? (Choose the best answer.)

Select one of the following:

  • Select the corresponding data map, and Refresh the Database.

  • Select the corresponding data map, and execute the Synchronize Defaults Business.

  • Select the corresponding data map, and Synchronize to refresh the data.

  • Select the corresponding data map, and execute the Synchronize Components Business Rule.

Explanation

Question 90 of 125

1

In Projects, which is NOT a valid option for Contract project revenue recognition? Choose the best answer.

Select one of the following:

  • Monthly, Quarterly, or Semiannually

  • After Completion

  • When Paid

  • When Billed

Explanation

Question 91 of 125

1

In Financials, you want to see asset related expenses such as depreciation, amortization, and insurance.
Which describes the steps you can take to set this up? (Choose the best answer.)

Select one of the following:

  • Set up the Equipment Expense Reporting Capex data map to map asset related expenses to Financials.

  • On the Configure page for Capital, select the option to map Capital accounts to financial accounts. Then for each Capital account, select a financial account to map to.

  • On the Configure page for Financials, when enabling features, include a custom dimension to store asset related information.

  • On the Configure page for Financials, select Asset Accounts to set up the accounts from Capital that map to Financials.

Explanation

Question 92 of 125

1

Which card allows you to enable modules? (Choose the best answer.)

Select one of the following:

  • Valid Intersections

  • Data Maps

  • Overview

  • Settings

  • Configure

Explanation

Question 93 of 125

1

Which two statements are true regarding the creation and management of business rules in module-based Planning? (Choose two.)

Select one or more of the following:

  • Pre-defined business rules for modules may be modified, but may be ignored after an application upgrade.

  • Custom business rules for modules can only be created using the graphical designer.

  • Custom business rules can be created for each module.

  • Modules cannot use regular business rules. Instead, they must be scripted using Groovy.

Explanation

Question 94 of 125

1

Which option is true when implementing access permissions in Planning? (Choose the best answer.)

Select one of the following:

  • Users and groups are restricted from accessing applications by removing custom application and plan-type security

  • A member that is set to read that has a parent with write access to all descendants will result in an access level of read

  • Planning roles can be assigned to members in all dimensions in all modules in the application

Explanation

Question 95 of 125

1

Which three are benefits of using EPM Enterprise Cloud Service over EPM Standard Cloud Service? (Choose three.)

Select one or more of the following:

  • Enable pre-seeded configurable content including dimensions, models, forms, rules, dashboards, infolets, and reports for Strategic Modeling

  • With Free Form Planning, deploy Planning business processes with no dimension requirements and create business processes using Essbase outline files

  • Custom Planning, which allows a high degree of business process customization to support business requirements

  • Use of the Groovy scripting language to create or customize business rules

  • Deploy more than one supported business process in the same instance

Explanation

Question 96 of 125

1

What three actions can you perform on the data displayed in the Data Integration Workbench? (Choose three.)

Select one or more of the following:

  • Re-register or modify the data source system

  • Open loaded data in Microsoft Excel

  • Apply a filter using Equal and a specific value

  • Apply a filter using Contains and a specific value

  • Drill-through to source from specified data cells

Explanation

Question 97 of 125

1

In porting data from a BSO plan type to an ASO plan type, which method cannot be utilized? Choose the best answer.

Select one of the following:

  • Smart Push

  • Data Maps

  • XWRITE business rule

  • Export/Import Capabilities

Explanation

Question 98 of 125

1

What three time period management tasks can you perform in Strategic Modeling? (Choose three.)

Select one or more of the following:

  • Combine periods of years, halves, quarters, months, and weeks for historical forecast data.

  • Configure time periods to reflect the detail required by financial models, such as different levels of granularity for different years.

  • Enable the input option for upper level time periods when you add time detail.

  • Create period-to-date, trailing periods, deal periods, and sub periods to record transactions.

  • Select and combine periods of years, halves, quarters, months, and weeks for the beginning balance year.

Explanation

Question 99 of 125

1

What are the two primary use cases for an ASO reporting cube? (Choose two.)

Select one or more of the following:

  • You want to create and execute Calculation Manager business rules

  • You want to report on Smart Lists in Planning, which you can't do in Planning

  • You want to report on new Planning data originating from any source, such as a data warehouse

  • You want to create, maintain, and report on Attribute dimensions

Explanation

Question 100 of 125

1

To assign Workforce resources to initiatives, which default custom dimension is required in the Map/Rename Dimensions section? (Choose the best answer.)

Select one of the following:

  • Project

  • Program

  • Elective

  • Measure

Explanation

Question 101 of 125

1

Which two roles can be set for Strategic Modeling? Choose two.

Select one or more of the following:

  • Analyst

  • Forecaster

  • Planner

  • Modeler

Explanation

Question 102 of 125

1

What is the purpose of selecting the Project Benefits option when enabling Projects? (Choose the best answer.)

Select one of the following:

  • To track the Workforce expense benefits calculated on each Contract project

  • To plan detailed project revenue for Contract projects

  • To help justify the need for projects and plan non-financial benefits

  • To plan detailed project expenses for projects

Explanation

Question 103 of 125

1

In what three ways can Service Administrators implement EPM Automate in Planning? (Choose three.)

Select one or more of the following:

  • To copy data from an aggregate storage database to a block storage database

  • To copy data from a block storage database to an aggregate storage database

  • To execute scripts that complete tasks using a scheduler

  • To import and export metadata, data, artifacts and snapshots

  • To promote financial plans to the next level in the approval hierarchy Copy data from one database to another; typically, from a block storage database to an aggregate storage database. You can create scripts that are capable of completing a wide array of tasks and automate their execution using a scheduler. Import and export metadata, data, artifact and application snapshots, templates, and Data Management mappings.

Explanation

Question 104 of 125

1

In Data Management, what are the steps you need to perform to synchronize the application metadata in the target application? (Choose the best answer.)

Select one of the following:

  • In Data Management, navigate to Application Dimensions and click Refresh Dimensions.

  • In Data Management, navigate to Import Format and select your Planning application. Click Refresh Dimensions.

  • In Data Management, navigate to Target Application and select your Planning application. Click Refresh Members.

  • In Data Management, to Target Application and select your Planning application. Click Refresh Metadata.

Explanation

Question 105 of 125

1

You want to move financial information from Projects to Financials for account level data. Which describes the action you can take to accomplish this? (Choose the best answer.)

Select one of the following:

  • In data maps, push data for the predefined Financial Statement Integration.

  • Rollup project data which pushes data to Financials based on account mappings.

  • On the Financials Integration Summary form, from the Actions menu, select PFP Detail to calculate project data.

  • In Financials, run the Financials Integration business rule to update data from Projects.

Explanation

Question 106 of 125

1

You want to share detailed benefits data from Workforce with Financials. Which statement describes the steps you must take? Choose the best answer.

Select one of the following:

  • Enable and configure Financials, and Workforce. When enabling Workforce, create a custom Benefits dimension to map the data to. Then for the Financial Statement Integration data map, synchronize and push the data.

  • Enable and configure Financials and Workforce. Then in the Workforce Benefits and Taxes wizard, select a financial account to map the benefit to. For Compensation Data, synchronize and run the data map.

  • Enable and configure Financials, and Workforce. When enabling Financials, create a custom Benefits dimension to map the data to. On the Financials Integration Summary form, run Calculate Compensation to update the Workforce data.

  • Enable and configure Financials, and Workforce. Then to capture Workforce expenses for employees, enable Standard Rates from Workforce. For the Compensation Data for Reporting data map, synchronize then push the data.

Explanation

Question 107 of 125

1

How do you add custom dimensions when you enable features? (Choose the best answer.)

Select one of the following:

  • By adding a new dimension with Data Management

  • By adding a new dimension to the cube in Create and Manage Dimensions

  • By renaming a dimension in Map/Rename Dimensions

  • By creating a new dimension in Application Overview

Explanation

Question 108 of 125

1

Which time period allows you to collect the most recent number of time periods and measure business performance over a specific time duration? (Choose the best answer.)

Select one of the following:

  • Deal Period

  • Sub Period

  • Trailing Period

  • Base Period

  • Periods-to-Date

Explanation

Question 109 of 125

1

A company has enabled and configured Financials. Which are three recommended post configuration tasks? (Choose three.)

Select one or more of the following:

  • Entering exchange rates

  • Defining and managing the accounts and drivers

  • Specifying days in period for driver-based Balance Sheet

  • Running Financials rules to aggregate and calculate the data

  • Setting Up Planning and Forecast Preparation

  • Modifying account signage for alternate reporting methods

Explanation

Question 110 of 125

1

Which three are predefined Workforce business rules? (Choose three.)

Select one or more of the following:

  • Transfer

  • Plan Departure

  • Promote Employee

  • Change Job

  • Remove Existing Employee

Explanation

Question 111 of 125

1

In Strategic Modeling Simulations, what are the three guidelines for selecting the appropriate probability distribution? (Choose three.)

Select one or more of the following:

  • Select the distribution where the conditions of the distribution match those of the input.

  • Randomly generate a range of values for assumptions and enter best guess estimates one cell at a time.

  • Evaluate the input in question, and list the conditions surrounding this input.

  • Review the descriptions of the probability distributions.

  • Use the Monte Carlo method to best guess your probability distribution options based on a range of assumptions.

Explanation

Question 112 of 125

1

In Projects, which three types of revenue and expense assumptions drive data calculations? (Choose three.)

Select one or more of the following:

  • Project rates

  • Standard rates

  • Discount rates

  • Program mappings

  • Plan start year

  • Working days and hours

Explanation

Question 113 of 125

1

Which statement describes infolets? Choose the best answer.

Select one of the following:

  • Infolets help you personalize focused data slices that you frequently use for analysis.

  • Infolets help you quickly analyze data and understand key business questions by presenting a visual overview of high-level, aggregated information.

  • Infolets are predefined dashboards that give you insight into overall project financials and expense and revenue metrics.

  • Infolets help you organize, track, and prioritize your workload.

Explanation

Question 114 of 125

1

Which two are supported funding methods in Strategic Modeling? (Choose two.)

Select one or more of the following:

  • Target Capital Structure funding method

  • Standard funding method

  • Proposed Projects funding method

  • Employee-based funding method

Explanation

Question 115 of 125

1

Which three describe the supported rolling forecast time periods in Financials? (Choose three.)

Select one or more of the following:

  • 4, 6, or 8 quarters

  • 4, 12, 36 weeks

  • 1, 2, 4, 5 years

  • 13, 26, or 52 weeks

  • 12, 18, 24, 30, 36, 48, or 60 months

Explanation

Question 116 of 125

1

Which describes Strategic Modeling? Choose the best answer.

Select one of the following:

  • Used to evaluate financial scenarios and perform financial impact analysis.

  • Used to evaluate how assets and resources related to corporate initiatives are allocated

  • Used primarily for balance sheet planning

  • Used to develop plans and forecasts and generate core financial statements

Explanation

Question 117 of 125

1

What two form validation rules options are supported in Planning? (Choose two.)

Select one or more of the following:

  • When enabled, execute validations associated with the form for all users regardless of access rights when validating the Approval unit.

  • When enabled, all validations are run as the administrator and applied to the form members.

  • When enabled, the user variable for the approval dimension on the form will be replaced by the approval unit member before the validations are run.

  • When enabled, the system figures out which page combinations have potential data blocks and runs the validations regardless of those page combinations.

  • When enabled, the form will be validated multiple times by replacing the user variable from the approval unit dimension with every possible value.

Explanation

Question 118 of 125

1

If you choose to create your own chart of accounts in Financials, which four statements are TRUE? (Choose four.)

Select one or more of the following:

  • Predefined drivers and the chart of accounts you brought in can co-exist within the Account dimension member outline.

  • You enable base or parent features to create an account structure with key members for you to add your own chart of accounts.

  • You cannot reuse existing integrated financial statements and must design your own financial statements that include the accounts you imported.

  • You do not need to enable base or parent features, and instead import the metadata directly into the Financials cube.

  • You can perform calculations using existing rules, and plan using existing forms and dashboards.

  • You input or import your own accounts for each enabled feature.

Explanation

Question 119 of 125

1

Revenue planned in Projects is rolled up into Financials for contract projects. How must you set up the modules to share the data? Choose the best answer.

Select one of the following:

  • To capture Project revenue, enable Standard Rates from Projects.

  • When enabling Financials, create a custom Project dimension to map the data to.

  • In Projects, select an entity and map revenue accounts to Financials accounts for that entity.

  • Set up the Contract Revenue Reporting data map to map contract-related revenue to Financials.

Explanation

Question 120 of 125

1

Which REST API method would be used to execute a job in Planning? (Choose the best answer.)

Select one of the following:

  • POST

  • EXECUTE

  • GET

  • PUT

Explanation

Question 121 of 125

1

Which three do you need to enable in order to perform indirect cash flow statement planning? (Choose three.)

Select one or more of the following:

  • Expense

  • Cash Flow Statement

  • Income Statement

  • Balance Sheet

  • Revenue

Explanation

Question 122 of 125

1

If the HSP_VIEW dimension exists in the cube, what feature has been enabled? (Choose the best answer.)

Select one of the following:

  • Rolling Forecast

  • Intercompany Eliminations

  • Multicurrency

  • Sandboxes

Explanation

Question 123 of 125

1

After loading Workforce data from external systems, which two statements describe actions you can take to process Workforce data? (Choose two.)

Select one or more of the following:

  • If an existing employee was omitted from the load file, you can add that existing employee in Workforce. Then assign properties and compensation options for that employee.

  • To calculate updated compensation data after changing benefit options and rates from the loaded file, first change the benefit options and rates in Workforce and then run the Calculate Compensation business rule.

  • If an existing employee was not loaded from the load file, you won't be able to add their compensation information before first adding them to the source system and reloading the file.

  • Because you cannot override loaded default assignments in Workforce, change the defaults in the load file and reload it.

  • To override loaded default assignments, change them in Workforce. After saving your changes, updated compensation data is calculated.

Explanation

Question 124 of 125

1

Which two clients or command line tools can you download from Planning? (Choose two.)

Select one or more of the following:

  • Data Management

  • EPM Automate

  • Strategic Modeling Smart View add-on

  • Calculation Manager

Explanation

Question 125 of 125

1

Which three describe what you can do with Valid Intersections? (Choose three.)

Select one or more of the following:

  • Specify that certain programs are valid only for some periods or departments.

  • Restrict cells containing invalid data, setting them to a read-only state within forms.

  • Filter cell intersections to users when they enter data or select runtime prompts

  • Prevent the user from executing any type of Calculation Manager rule that uses runtime prompts

  • Allow all users to select from a non-filtered list of members on the form's point of view

Explanation

Previous
Next