Sam Heidelberg
Quiz by , created more than 1 year ago

Majority of the questions from the quizzes in Oracle University

362
0
0
Sam Heidelberg
Created by Sam Heidelberg over 2 years ago
Close

Oracle EPM Cloud: Planning Implementation Quizzes/Questions (Oracle U as of Jan-21)

Question 1 of 37

1

After how many days are the files and snapshots that you have created or uploaded are deleted?

Select one of the following:

  • 15 Days

  • 30 Days

  • 60 Days

  • 45 Days

Explanation

Question 2 of 37

1

Which three validation rule option are available in Planning?

Select one or more of the following:

  • Validate only for pages with existing blocks

  • Validate for all page combinations and all existing or potential blocks

  • Validate only for cells and pages the user has access to

  • Validate only for users who have access to this form

Explanation

Question 3 of 37

1

You want that once a form is run its data should be automatically saved. When designing the form which smart push option will you select?

Select one of the following:

  • Run Form Calc on Autosave

  • Enable Autosave

  • Run Form Rules on Autosave

  • Run After Save

Explanation

Question 4 of 37

1

Which two are valid locations for the metadata import file or files?

Select one or more of the following:

  • HTTP

  • Local

  • Inbox

  • Outbox

Explanation

Question 5 of 37

1

Which artifacts are supported in metadata import?

Select one of the following:

  • Dimension and Exchange Rate Tables only

  • Smart Lists and Exchange Rate Tables only

  • Dimensions, Smart Lists, and Exchange Rate Tables

  • Dimensions and Smart Lists only

Explanation

Question 6 of 37

1

In order to restore dimensional security which migration category is required?

Select one of the following:

  • Core

  • Groups and Memberships

  • Reporting

  • Calculation Manager

Explanation

Question 7 of 37

1

Which two are mandatory while configuring Workforce?

Select one or more of the following:

  • Component

  • Entities

  • Salary Grade

  • Pay Type

Explanation

Question 8 of 37

1

Which two can work as free form application sources?

Select one or more of the following:

  • an Outline (OTL) file from an on-premises release 11.1.2.4.400 single cube Essbase application

  • Snapshot from an on-premises release 11.1.2.4.400 single cube Essbase application

  • a word definition file

  • comma separated data file

Explanation

Question 9 of 37

1

Which two statements are true?

Select one or more of the following:

  • Essbase snapshots with Custom Defined Functions (CDF) and CDF references cannot be used to create Free Form applications

  • The OTL file or the Essbase application snapshot that you are using must not have member and alias names that are longer than 80 characters

  • You can use the uploadSource EPM Automate command to upload the OTL file or snapshot to an EPM Cloud Environment

  • The OTL file or the Essbase application snapshot that you are using can contain objects with system restricted names

Explanation

Question 10 of 37

1

Which statement is true for Free Form Applications?

Select one of the following:

  • They allow you to create cubes with any dimension combination you need in your BSO or ASO cube

  • They allow you to create cubes with any dimension ASO cube only

  • They allow you to create cubes with any dimension BSO cube only

  • They allow you to create cubes with any dimension combination you need in except for BSO or ASO Cube

Explanation

Question 11 of 37

1

Which two statements are true for Groovy Rules?

Select one or more of the following:

  • You create Groovy rules in Calculation Manager

  • You cannot execute jobs of type rules, rulesets, and templates synchronously from a Groovy rule.

  • Groovy rules are supported in composite forms.

  • Groovy rules are supported in rulesets.

Explanation

Question 12 of 37

1

Which two options are applicable for calc scripts or graphical rules?

Select one or more of the following:

  • Run After Save

  • Run Before Load

  • Run Before Save

  • Run After Load

Explanation

Question 13 of 37

1

Which component can you use to review the log, and optimize the steps within the rule to improve performance of business rules?

Select one of the following:

  • Data Management

  • Calculation Manager

  • Smart View

  • EPM Automate

Explanation

Question 14 of 37

1

Which two statements are true?

Select one or more of the following:

  • If a rule is deleted in Calculation Manager, the rules must be redeployed to Planning in order for them to no longer be used in Planning.

  • Rules that are set to automatically run when a form is loaded or saved never run in the background.

  • You can associate only one rules with a form, by cube.

  • You can add rules to Planning forms before they are deployed to Planning from Calculation Manager.

Explanation

Question 15 of 37

1

Business rules can be used in the which four artifacts?

Select one or more of the following:

  • Forms

  • Rulesets

  • Menus

  • Task Lists

  • Prompts

  • Reports

Explanation

Question 16 of 37

1

The Entity dimension requires association with which dimension in order to enter a value for Base Currency?

Select one of the following:

  • Version

  • Currency

  • Period

  • Account

Explanation

Question 17 of 37

1

How many time periods can an application have?

Select one of the following:

  • 500

  • 750

  • 1000

  • 100

  • 250

Explanation

Question 18 of 37

1

How many dimensions can a General Planning application contain?

Select one of the following:

  • twenty-one custom dimensions and eleven standard dimensions

  • twenty-three custom dimensions and nine standard dimensions

  • twenty-four custom dimensions and three standard dimensions.

  • Thirty-two standard and custom dimension

Explanation

Question 19 of 37

1

Which three properties are applicable to Account dimension?

Select one or more of the following:

  • ExchangeRateType

  • TriangulationCurrency

  • TimeBalance

  • VarianceReporting

  • Scale

Explanation

Question 20 of 37

1

Which two tasks you can perform in Oracle EPM Planning?

Select one or more of the following:

  • Use calculation manager to develop business logic.

  • Request changes to budget and forecast data with Approvals.

  • Analyze your tax expense across jurisdictions using CbR reporting tool.

  • Input budget and forecast data through data management.

Explanation

Question 21 of 37

1

Which client or tool can an administrator use to remotely perform command line tasks?

Select one of the following:

  • Data Management

  • Strategic Modeling Smart View Add on

  • EPM Automate

  • Calculation Manager

Explanation

Question 22 of 37

1

Which two features or components allow you to move data in Planning?

Select one or more of the following:

  • Data Management

  • Data Integration

  • Dashboards

  • Navigation Flows

Explanation

Question 23 of 37

1

Which two tools allow you to manage data, and perform application administration activities via Microsoft Excel?

Select one or more of the following:

  • Smart View

  • Calculation Manager

  • Data Integration

  • Admin Extension

Explanation

Question 24 of 37

1

In order to create, validate, deploy and launch business rules which Planning feature or component you will use?

Select one of the following:

  • Calculation Manager

  • Data Integration

  • Rules Editor

  • Member Formulas

Explanation

Question 25 of 37

1

Which two delimiters can you use for import metadata files?

Select one or more of the following:

  • double vertical bars (||)

  • caret (^)

  • commas (,)

  • equals (=)

Explanation

Question 26 of 37

1

Before you begin loading, you must create an import file for each artifact you want to import. Which are the two supported file formats for this?

Select one or more of the following:

  • .vbsx

  • .txt

  • .cpp

  • .csv

Explanation

Question 27 of 37

1

Which two tools can be used to load Metadata?

Select one or more of the following:

  • REST APIs

  • Data Management

  • Data Pump

  • Performance Management Architect data synchronization

Explanation

Question 28 of 37

1

Which five inheritance options are available in Planning?

Select one or more of the following:

  • Parents (inclusive)

  • Descendants (inclusive)

  • Children (inclusive)

  • Children

  • Member

  • Parents

  • Descendants

Explanation

Question 29 of 37

1

Which are the three types of access permission that can be granted?

Select one or more of the following:

  • None

  • Write

  • Read

  • Inspect

  • Execute

Explanation

Question 30 of 37

1

Access Control enables you to complete which three activities in an environment?

Select one or more of the following:

  • Assign permissions to launch privileges to rules.

  • Managing Groups

  • Assign permissions to Dimensions, including user-defined dimensions

  • Assigning Roles to a Group or a User

  • Generating a Role Assignment Report for a User or Group

Explanation

Question 31 of 37

1

Which role will you grant to a user who only needs to view the business plans during the budgeting process?

Select one of the following:

  • User

  • Viewer

  • Service Administrator

  • Power User

Explanation

Question 32 of 37

1

Which two access permissions can you grant for a rule?

Select one or more of the following:

  • Launch

  • No Launch

  • Write

  • Read

Explanation

Question 33 of 37

1

Which three sources of data can you use in Dashboard 2.0?

Select one or more of the following:

  • Cubes

  • Spreadsheets

  • Simple forms

  • Reports

  • Ad hoc grids

Explanation

Question 34 of 37

1

Which data entry element of a form will you use to view the context of the data in the pages, rows, and columns?

Select one of the following:

  • Point of View

  • Page

  • Actions

  • Data Entry Cell

Explanation

Question 35 of 37

1

Which of these is used as web based authoring solution for Planning?

Select one of the following:

  • Oracle Financial Reporting Web Studio

  • Task Lists

  • Smart View

  • EPM Automate

Explanation

Question 36 of 37

1

Daily process logs are maintained for how many days?

Select one of the following:

  • 15 days

  • 1 days

  • 7 days

  • 30 days

Explanation

Question 37 of 37

1

Which two statements are true for Strategic Modeling?

Select one or more of the following:

  • Strategic Modeling helps to evaluate how assets and resources related to corporate initiatives are allocated, and analyze their probable return on investment.

  • Once enabled there are no configuration tasks required for Strategic Modeling.

  • You can enable Strategic Modeling from the Home page, by clicking Application.

  • Strategic Modeling delivers tools to help you quickly develop plans and forecasts, and generate core financial statements such as balance sheets, cash flow statements, and income statements for internal analysis.

Explanation