Oracle EPM Planning Certification

What artifacts & objects can you migrate when cloning an environment?

1. Users & Predefined Roles 2. Data Management 3. Application Audit 4. Job Console 5. Stored Snapshots & Files 6. Daily Maintenance Start Time

A Department Manager requires access to all accounts in their own department, but only a certain amount in all other departments. With the usual metadata security, the Service Administrator would have access to all accounts across all departments. By enabling this type of security, the Service Administrator can control the intersection of all accounts with the Manager's department and only the specific account in the other departments. Which security feature can Service Administrators set to enforce this? A. Cell-level Security B. Grid-level Security C. Account-level Security D. Evaluation Order

A

In Workforce, which option can you enable which allows you to set a date by which existing employees must be hired to be eligible to receive merit, and allows you to specify the month in which merit should start? A. Merit Assumptions B. Merit Rates C. Merit Month D. Workforce Assumptions

A

What is the correct sequence of steps for enabling each Planning module? A. Enable the module, configure the module, run post configuration tasks B. Enable the module, refresh the database C. Configure the module, refresh the database D. Run pre-configuration task, enable the module, configure the module

A

What are 2 ways you can affect the promotional path of an approval unit hierarchy? A. Use data validation rules to determine whether a change in the approval unit promotional path is necessary. B. Modify owners and reviewers for approval units and their descendants. C. Create a task list with a task to skip a user in the promotional path. D. Use the Approvals Audit feature to view data tasks performed by users and freeze that task for the user.

A, B

Which two permissions are available when a model is first created in Strategic Modeling? A. Default Permissions B. Owner Permissions C. Power User Permissions D. Viewer Permissions

A, B

Which 3 statements describe the benefits of using Groovy Rules? A. You can use Groovy rules to add validation checks for runtime prompt values before running calculations, add data validation checks before submitting data, and adding error handling B. You can use groovy rules to dynamically generate calculations scripts at runtime based on context to find in The Groovy script C. You can use groovy rules to perform complex procedural calculations in memory before submitting the results to the database D. You can use Groovy rules to find member formulas that combine operators, calculation functions, and numeric constraints to perform calculations on members and Dimension Editor E. You can use Groovy rules to dynamically calculate data and add validation checks before saving data on custom composite forms

A, B, C

Which four job types can be scheduled in Planning? A. Create Snapshot B. Import Data and Export Data C. Refresh Database D. Merge Data Slices E. Promote Planning Unit F. Data Map

A, B, C,F

Which three statements describe Intelligent Performance Management (IPM) offerings? A. Harness the power of data science by performing what if analysis on a trained ML model that has been imported into a Planning application. B. Quickly start your planning process and improve the accuracy of your forecasts with powerful and automated predictive capabilities. C. View and interact with high-level, essential information generated from different sources to help you quickly assess where to direct your attention. D. Reduce time spent in data analysis with financial pattern recognition on which you can evaluate and take action. E. Assess the impact organizational projects and initiatives have on overall corporate resources, and ensure they align with short and long term financial targets.

A, B, D

A company would like to configure Financials, Workforce, and Projects. They would like to plan and forecast the Project dimension in Financials, as well as track employee utilization in Projects. Which 2 actions must they take to ensure that the Project dimension is shared and the data integrated correctly across all three modules? A. In Financials, rename one of the custom dimensions to "Project" and enable it. B. In Workforce, rename one of the custom dimensions to "Project" and enable it. C. In Workforce, ensure that the granularity is at Employee or Employee and job. D. In Projects, ensure that the Employee driver-based expense is enabled.

A, C

From what two location options can you import data files? A. Local B. Workspace C. Inbox D. Repository

A, C

Which 2 statements are true regarding the creation and management of business rules in module-based Planning? A. Pre-defined business rules for modules may be modified, but may be ignited after an application upgrade B. Custom business rules for modules can only be created using the graphical designer C. Custom business rules can be created for each module D. Modules cannot use regular business rules. Instead, they must be scripted using Groovy

A, C

Which two statements are true regarding the creation and management of business rules in module-based Planning? (Choose two.) A.Pre-defined business rules for modules may be modified, but may be ignored after an application upgrade. B. Custom business rules for modules can only be created using the graphical designer. C. Custom business rules can be created for each module. D. Modules cannot use regular business rules. Instead, they must be scripted using Groovy.

A, C

In Strategic Modeling Simulations, what are the three guidelines for selecting the appropriate probability distribution? (Choose three.) A. Select the distribution where the conditions of the distribution match those of the input. B. Randomly generate a range of values for assumptions and enter best guess estimates one cell at a time. C. Evaluate the input in question, and list the conditions surrounding this input. D. Review the descriptions of the probability distributions. E. Use the Monte Carlo method to best guess your probability distribution options based on a range of assumptions.

A, C, D

Which 2 statements are true regarding what you can do when configuring insights? A. Use prediction results as input for generating insights B. Create and edit dataviews to customize the display on the dashboard C. Define insights for up to 1000 data intersections D. Select either a single type of insight, or multiple types of insights

A, D

Which 4 are correct regarding creating a Free Form application? A. You can with a maximum of 12 cubes B. You can by importing multiple Essbase Outlines - one for each cube C. You can by migrating an Essbase snapshot with Custom Defined Functions D. You can with a single cube and then more cubes later E. You can by importing a single Essbase outline and then add more cubes later F. You can with multiple cubes using the application wizard or excel template in Smart View

A, D, E, F

A company has enabled Financials and now would like to make changes to the initial configuration. Which 3 changes can be made? A. Enabling Income Statement B. Adding custom dimensions C. Changing the selected Cash Flow Method D. Enabling Rolling Forecast E. Renaming custom dimensions F. Enabling Expense

A, D, F

Which 2 statements are true when administrators assign permissions to artifacts? A. Users and Power Users can work only with members to which they have permission. B. Only Power Users can design forms, dashboards, and infolets. C. If you have inherited read permissions and assigned write permissions, the inherited permissions take precedence. D. Power Users are automatically granted Write permissions to all dimension members to all forms, dashboards, and infolets. E. Users and Power Users can view or enter data only into forms to which they have permissions.

A, E

A company wants to capitalize the expenses from their project initiatives. Which is NOT a capability within Projects or Capital to fulfill the business requirements? A. Within Capital, the ability to view capitalized asset values and associated depreciation B. Within Projects, the ability to calculate depreciation on capital assets C. Within Capital, the ability to change resource utilization by project and asset D. Within Projects, the ability to allocate project expenses either partially or in full to one or more assets

B

For "Modules" and "Custom" application types, which statement is true about the Currency Dimension? A. The Currency dimension contains a single member called "Local" and other members representing reporting currencies. B. The Currency dimension contains a section for input currencies and a section for reporting currencies. C. The Currency dimension is not provided with any content, and is set-up as a custom dimension. D. The Currency dimension contains a list of currencies and exchange rate types.

B

How many days until all files and snapshots that you create or upload to an environment are deleted? A. 30 days B. 60 days C. 1 day D. 90 days

B

In Data Management, what are the steps you need to perform to synchronize the application metadata in the target application? A. 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. C. In Data Management, navigate to Application Dimensions and click Refresh Dimensions. D. In Data Management, navigate to Import Format and select your Planning application. Click Refresh Dimensions.

B

What step does NOT need to be completed to manage configuration of Key Performance Indicators (KPIs) in Planning Financials? A. Reviewing KPIs in the hierarchy B. Adding the KPIs to the hierarchy C. Verifying enabled KPIs D. Adding KPIs to the alternate hierarchy E. Adding KPIs in Configure: Financials

B

Which Smart Push option would allow a user to push data to another cube after manually saving the form? A. Use form context B. Run after save C. Run form rules on autosave D. Overwrite selection

B

Which is the correct sequence of steps for enabling each business process framework? A. Enable the framework, refresh the database B. Enable the framework, configure the framework, run post configuration tasks C. Configure the framework, refresh the database D. Run pre configuration tasks, enable the framework, configure the framework

B

You want to share detailed benefits data from Workforce with Financials. Which statement describes the steps you must take? A. Enable and configure Financial and Workforce. When enabling Workforce, create a custom Benefits dimensions to map the data to. Then for the Financial Statement integration data map, synchronize and push the data. B. Enable and configure Financials and Workforce. Then in the Workforce Benefits and Taxes, select a financial account to map the benefit to. For Compensation Data synchronize and run the data map. C. Enable and configure Financials and Workforce. When enabling financials, create a custom Benefits dimension to map the data to. On the financials in a Gracian summary form, run, calculate compensation to update the workforce data. D. 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.

B

What are the two primary use cases for an ASO reporting cube? (Choose two.) A. You want to create and execute Calculation Manager business rules B. You want to report on Smart Lists in Planning, which you can't do in Planning C. You want to report on new Planning data originating from any source, such as a data warehouse D. You want to create, maintain, and report on Attribute dimensions

B, C

Which 2 statements correctly describe security assignments for Planning? A. All user, group, and artifact permissions are assigned through Oracle Cloud Identity Console B. Predefined roles to perform Planning functional activities are assigned directly in Planning C. Single sign-on and access to environments is controlled by Oracle Identity Management D. Global application roles, and artifact dimension access are assigned through Oracle Cloud Identity

B, C

What 3 form validation rule options are supported in Planning? A. Validate for all page combination and all existing or potential blocks B. Validate only four pages with existing blocks C. Validate only for cells and pages that user has access to D. Validate only for users with access to this form E. Validate rules as Service Administrator, regardless of logged-in user, when the form is loaded or saved

B, C, D

Which 3 statements are true about migrations snapshots? A. Generally, a snapshot is compatible with the previous and next updates of an environment B. Oracle backs up your application and data to create a snapshot while performing daily maintenance of your environment C. Snapshots must always run through an upgrade process if taken from previous version of the environment D. I thought you create or upload to an environment art delete it after 60 days E. if the daily maintenance snapshot size exceeds 150 GB, it marks it for a review and notify service administrator.

B, C, D

Which three are benefits of using EPM Enterprise Cloud Service over EPM Standard Cloud Service? (Choose three) A. Enable pre-seeded configurable content including dimensions, models, forms, rules, dashboards, infolets, and reports for Strategic Modeling B. With Free Form Planning, deploy Planning business processes with no dimension requirements and create business processes using Essbase outline files C. Custom Planning, which allows a high degree of business process customization to support business requirements D. Use of the Groovy scripting language to create or customize business rules E. Deploy more than one supported business process in the same instance

B, C, D

Which three do you need to enable in order to perform indirect cash flow statement planning? (Choose three.) A. Expense B. Cash Flow Statement C. Income Statement D. Balance Sheet E. Revenue

B, C, D

In Strategic Modeling, which 3 are benefits of Simulations help improve forecast accuracy? A. Simulations allow you to calculate the model a maximum of three times using random scenarios created from the input assumptions. B. Simulations allow you to assign a range of possible values to uncertain inputs and analyze how that uncertainty affects related accounts. C. Simulations allow you to assess the likelihood of meeting target goals. D. Simulations limit you to performing a simple and error-prone what-if analysis by entering best guess estimates one cell at a time for uncertain input accounts. E. Simulations allow you to see how key uncertain inputs affect your bottom line.

B, C, E

What 3 features do you need to enable in order to perform indirect cash flow statement planning? A. Revenue B. Balance Sheet C. Cash Flow Statement D. Expense E. Income Statement

B, C, E

Which 3 are requirements when enabling Flexible Account Mapping in Workforce? A. You can enable flexible account mapping only when you bring your own chart of accounts to financials. B. Specify whether the mapping drivers should be based on the Grade or on the Defaults for the application. C. For mapping level, specify whether the mapping should be done at the global level, (the same mapping for every entity), or at the entity level D. You must map Salary and Merit from Workforce to the same account in Financials and Projects E. Financials and the Financials Expense Planning option must be enabled in order to enable this feature

B, C, E

In Financial Reporting Web Studio, what are 4 reusable objects or templates can you use when designing multiple dynamic reports? A. Data queries B. Text and images C. Charts D. Hidden sheets E. Row and column templates F. Grids

B, C, E, F

To enable Strategic Modeling business cases to be a data push target, what are two data mapping types are supported for Strategic Modeling? A. Strategic Modeling Scenario Rollup to Strategic Modeling Model B. Planning to Strategic Modeling Scenario Rollup C. Strategic Modeling Scenario Rollup to Strategic Modeling Scenario Rollup D. Strategic Modeling Model to Strategic Modeling Scenario Rollup

B, D

What 2 levels of workforce detail granularity do you need to select to do Merit Based Planning? A. Job B. Employee C. Merit D. Employee and Job

B, D

Which 2 statements about approval units are true? A. You can have up to three scenario/version combinations per approval unit B. You can set the option in Application Settings to include detailed annotations for approval units C. Approval units can also include secondary dimensions within any entity D. Approval units are combinations of scenario, version, and entity or part of an entity.

B, D

Which two are benefits of enabling Use Database Suppression in Smart Push? (Choose two.) A. It automatically merges comments, attachments, and supporting detail when mapping a cube for reporting. B. It helps eliminate the impact on query thresholds and improving wait times. C. It allows you to continue using the application while Smart Push runs in the background. D. It enables you to apply row suppression at the database level instead of the application level.

B, D

Aside from the artifact snapshot, which 3 items can you include when cloning the environment? A. Performance Substitution Variables B. Data Management records C. Smart View connection details D. Stored Snapshots and contents of the Inbox and Outbox E. Application Audit

B, D, E

Which 3 statements are true regarding importing metadata from a flat file into Planning? A. You can rename or delete members of attribute dimensions during a metadata import. B. When selecting to clear members during the import, any member not specified is deleted from the outline after importing the dimension unless it is an ancestor of a member that was specified, or it is a base member of a shared member that was specified. C. You can import data forms, dashboards, and infolets by loading a local import file or an import file from the Inbox server. D. Your import file must contain a list of Metadata records; and each metadata record contains a delimited list of property values that matches the order designated in the header record. E. You can use import file functionality to import more metadata or to perform incremental updates from the source system.

B, D, E

Which are 3 benefits of using EPM Enterprise Cloud Service over EPM Standard Cloud? A. Deploy more than one supported business process in the same instance. B. With Free Form Planning, you can create applications with no dimensional requirements or an Essbase outline file. C. Enable preseeded configurable content including dimensions, models, forms, rules, dashboards, infolets, and reports for Strategic Modeling. D. Custom Planning allows a high degree of business process customization to support business requirements. E. Use the Groovy scripting language to create or customize business rules.

B, D, E

Which 4 statements are true for the Optimize Dimension Feature? A. Optimizing dimension order is available only for Financials and Workforce, and only for the provided BSO cubes that are created when you enable and configure. B. The new optimized dimension order is maintained even if you enable additional features or other modules. C. Optimizing dimension order is available only for BSO cubes in Custom Planning applications. D. Optimize dimension order in your test environment before performing it in the production environment. E. Before you optimize dimension order, refresh the database and then back up the application and download the snapshot. F. Optimizing dimension order is available only for Financials and Projects, and only for the provided BSO cubes that are created when you enable and configure.

B, D, E, F

Which 3 methods can be used to import data from BSO cube to an ASO cube? A. XWRITE business rule B. Data Maps C. Valid Intersections D. Planning Import and Export E. Data Integration

B, D,E

Which are 2 considerations when designing data entry forms? A. Avoid putting Dance Dimensions on the row and column of a form B. Use substitution variables to reference dimensions such as Years. substitution variables reduce the maintenance of forms C. Use functional relationships to incorporate numbers on to the forms instead of selected members individually D. Include all or as many accounts on a single form

B,C

If you are using your own chart of accounts and want to use dashboards that graphically depict total results, you must add your accounts under the appropriate parent. Which 4 parent members do you add your own chart of accounts to as shared members if you want to include them in predefined dashboards? A. OFS_Financial Integrations B. OFS_Total Operating Expenses C. OFS_Cash D. OFS_Rollup Data E. OFS_Total Revenue F. OFS_Total Cost of Sales

B,C, E, F

** DUPLICATE QUESTION ** A Department Manager requires access to all accounts in their own department, but only a certain amount in all other departments. With the usual metadata security, the Service Administrator would have access to all accounts across all departments. By enabling this type of security, the Service Administrator can control the intersection of all accounts with the Manager's department and only the specific account in the other departments. Which security feature can Service Administrators set to enforce this? A. Artifact security B. Member security C. Cell-level security D. Access control

C

Before EPM Administrators can import a Machine Learning model into Planning, which task must be completed first? A. EPM Administrators create data maps and Groovy rules to move and process the data. B. EPM Administrators create a data model and push data to it to generate a PMML file. C. Data scientists build and train the ML model in a data science tool and save it as a PMML file. D. Data scientists create Groovy rules designed to evaluate historical data and identity patterns.

C

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 Import Format and select your Planning application. Click Refresh Dimensions. C. In Data Management, navigate to Target Application and select your Planning application. Click Refresh Members. D. In Data Management, to Target Application and select your Planning application. Click Refresh Metadata.

C

What does a navigation flow allow you to do? A. Track begets and review status, process issues, and approval unit ownership using approval units. B. Set the flow of business rules in a predetermined sequence. C. Customize the clusters and cards that a user can access D. Guide users through the planning process by listing tasks, instructions, and end dates.

C

What module should you enable to first track utilization of employees in Projects? A. Projects Module before Financials Module B. Financials Module before Projects Module C. Workforce Module before Projects Module D. Projects Module before Workforce Module

C

When designing forms, which Smart Push option do you select that would automatically move data when the form data is saved? A. Sync Data After Save B. Enable Autosave C. Run After save D. Push Data After Save

C

When designing with the new Reports for EPM Cloud, which statement is true about what dimensions are displayed on the Global Point of View within a report? A. Dimensions selected by a report viewer for the Global Point of View, are saved for all viewers. B. Only one dimension is in the Global Point of View. C. Dimensions not defined in a row, column, or page are displayed in the Global Point of View. D. All dimensions are displayed in the Global Point of View.

C

Which option is true when implementing security in Enterprise Planning and Budgeting Cloud (EPBCS)? (Choose one option.) A. Users are restricted from applications by removing application/module security B. EPBCS roles can be assigned to members in all dimensions C. 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 D. A user that is assigned read and write access to a member will result in write access

C

Which statement describes Strategic Modeling? A. It is used to develop driver based strategy plans and generate core financial statements. B. It is used to model the flow of data by defining strategic rules for sharing data between modules. C. It is used to quickly model and evaluate financial scenarios, and offers out of the box treasury capabilities. D. It is used to strategically manage and analyze finances at any business level with built in dashboards.

C

Which tasks do you perform using a sequence of commands in EPM Automate to import metadata into Planning? A. Upload the file to the inbox/outbox. Use a job to import the metadata, and refresh the cube. B. Perform a migration and Specify the local metadata file in the EPM Automate command. C. Specify the path to the local file in the import metadata command, run the import, and refresh the cube D. Upload the file to the Inbox/Outbox, and Perform a migration using that file

C

What are the 2 primary use cases for an ASO reporting cube? A. You want to save data for upper level members. B. You want to create and execute complex Calculation Manager business rules. C. You want to report on Smart lists. D. You want to report on new Planning data originating from any source, such as a data warehouse.

C, D

Which 2 tasks can you perform without approvals? A. Continue to change plan data even after promoting the approval unit as long as you were the original owner. B. Override validation rules to promote approval units. C. Ensure that the plan data meets data validation rules. D. View reviewers' remarks through annotations.

C, D

When copying data between two Planning instances, what 3 tasks must you complete? A. Associate the data map with a form B. Define an EPM Connection to the source instance C. Define a data map with Remote Cube as the target D. Enable cross-POD mapping on the Smart Push card E. Define an EPM Connection to the target instance

C, D, E

Which 2 are benefits of enabling Use Database Suppression in Smart Push? A. It suppresses rows, or columns, or both that contain No Data/ Missing or Zero, but not both B. It automatically merges comments, attachments, and supporting detail when mapping a database for reporting C. It helps eliminate the impact on query thresholds and improving wait times D. It allows you to load large amounts of data from an aggregate storage cube without using the missing block and row suppression options E. It enables you to apply a row suppression at the database level instead of the application Level

C, E

Which two are true regarding rent-free periods with IFRS 16 enabled? A. Calculations are based on a date range B. Lease payments are set to the index rate C. Calculations are based on periods and payment frequency D. Lease payments are set to zero

C,D

Which 3 statements are true for dimension and members in FreeForm apps? A. Set up the core required dimensions for account (measure) and time before adding custom dimensions. B. You can include up to 30 total dimensions. C. Cubes can have standalone dimensionality. D. Native account, period, and/or entity dimensions can be inherited by the cubes. E. Dimensions can be shared between cubes.

C,D,E

In Module-based Planning, you can configure the time frame and granularity for plans and forecast for each module. You can have different time frame and granularity for each module and for each year. When configuring Financials, in which component do you configure time frame and granularity for plans? A. Valid INtersections B. Seasonal Management C. Manage Time Periods D. Planning and Forecast Preparation

D

In order to be able to configure Additional Earnings in the Benefits and Taxes wizard, into which dimension do you have to import members? A. Pay Type B. Account C. Property D. Component

D

What can help you optimize your decision making by performing automated what-if analysis in Strategic Modeling? A. Model Change Management B. EPM Automate C. Consolidations D. Simulations

D

What does a navigation flow allow you to do? Choose the best answer. A. Promote a plan to your supervisor B. Display report variances by geography C. Run multiple business rules in a predetermined sequence D. Customize the clusters and cards that a user can access

D

Which Machine Learning, which type of prediction do you define to predict product volume based on historical time series data using the same dimension, measure, and slice of data? A. Dimension Prediction B. Forecast Prediction C. Source Prediction D. Univariate Prediction

D

Which Mass Update form in Workforce allows you to update employee properties, job properties or salary-related information? A. Synchronize Definitions B. Process Updated Data C. Synchronize Defaults D. Process Data and Synchronize Defaults

D

Which Snapshot Category is required to restore dimensional security? A. Reporting B. Groups and Memberships C. Calculation Manager D. Core

D

Which configuration tasks is NOT mandatory in Workforce? A. Workforce Assumptions B. Planning and Forecast Preparation C. Benefits and Taxes D. Employee Type

D

Which migration category is required to restore dimensional security? A. Reporting B. Calculation Manager C. Groups and Memberships D. Core

D

Which option is true when implementing access permissions in Planning? A. Planning roles can be assigned to members in all dimensions in all modules in the application. B. Users and groups are restricted from accessing applications by removing custom application and plan-type security. C. If a user with group access has individual access permissions that conflict with those of a group the user belongs to, group access permissions take precedence. D. A member with Read access that has a parent with Write access to all its descendants results in an access level of Read for that member.

D