Oracle 1Z0-982 Online Practice Questions and Exam Preparation

Oracle 1Z0-982 Online Questions & Answers

• Question 11:

  Which business rule is unavailable to manipulate existing employee data?

  A. Remove Existing Employee
  B. Change Job
  C. Plan Departure
  D. Transfer
  A. Remove Existing Employee

• Question 12:

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

  A. An organization requires the ability to provide "Drill-back" capabilities.
  B. An organization requires the ability to load data to their application via flat files.
  C. An organization requires the ability to build dimension hierarchies
  D. An organization requires the ability to process data from multiple chart of accounts
  E. An organization requires the ability to map data from multiple chart string segments to a single dimension
  A. An organization requires the ability to provide "Drill-back" capabilities.
  B. An organization requires the ability to load data to their application via flat files.
  D. An organization requires the ability to process data from multiple chart of accounts

  ---

  A: You can drill through to the detail from the EPM target application and view data in the Enterprise Resource Planning (ERP) source system. Predefined by administrators, drill- through reports are available to users from specified individual member cells and data cells. A cell can be associated with multiple drill-through reports. Cells that contain drill- through reports can be indicated on the grid by a cell style.

  B: Data loads and write-back are supported for those users who do not have a direct connection to their Enterprise Resource Planning (ERP) source data, but have data available from their source in a text file. Any file, whether it is a fixed width file or a delimited file, can be easily imported into an Oracle Enterprise Performance Management Cloud application.

  References: https://docs.oracle.com/cloud/latest/epm-common/ERPIA/toc.htm

• Question 13:

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

  A. View and kill requests
  B. Delete a reporting application
  C. Restructure a planning application
  D. Create planning applications
  A. View and kill requests
  C. Restructure a planning application

  ---

  A: The Sessions window lists active user sessions and requests for the server, application, or database. A user can have more than one session open at any given time. For example, one user may have open sessions on two databases. If you have Administrator or Application Manager permissions, you can end all requests, end all requests for a user, or end a specific request.

  C: To restructure a database:

  References: Oracle Cloud Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud, page 12-21 https://docs.oracle.com/cloud/latest/epm-common/ECALC/ECALC.pdf

• Question 14:

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

  A. Executing Data Maps
  B. Import Data
  C. Executing a Data Management process
  D. Restarting the PBCS instance
  B. Import Data
  C. Executing a Data Management process

  ---

  Examples of job that can be scheduled:

  References: Oracle Cloud, Administering Planning for Oracle Enterprise Planning and Budgeting Cloud, 4-12

• Question 15:

  Which REST API Method would be used to execute a job in Planning and Budgeting Cloud (PBCS)?

  A. POST
  B. GET
  C. PUT
  D. Execute
  A. POST

  ---

  Reference: https://docs.oracle.com/en/cloud/saas/enterprise-performance-management- common/prest/quick_reference_table_rest_api_resource_view.html

• Question 16:

  Which LCM Category is required to restore dimensional security?

  A. Reporting
  B. Groups and Memberships
  C. Calculation Manager
  D. Planning
  B. Groups and Memberships

  ---

  In EPM System security mode, Essbase obtains user and group details (including user and group information and provisioning to Essbase applications) from Shared Services References: https://docs.oracle.com/cd/E57185_01/EDBAG/dsemain.html#dsemain_6

• Question 17:

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

  A. OFS_Adjustment
  B. OFS_Trend
  C. OFS_Calculated
  D. OFS_Total
  C. OFS_Calculated

  ---

  The Plan Element dimension delineates the different types and sources of data used in the application. For example:

  Total: Calculated--Aggregates the value of all driver-derived calculations.

  References:

  https://docs.oracle.com/cloud/latest/pbcs_common/EPBCA/fin_about_the_plan_element_di mension.htm#EPBCA-financials_755

• Question 18:

  What is NOT available for assigning customized navigation flows?

  A. Global
  B. Group
  C. User
  D. Role
  C. User

  ---

  Reference: https://docs.oracle.com/en/cloud/saas/planning-budgeting-cloud/pfusa/navigation_flow_customization_categories_104xdb1f1c26.html

• Question 19:

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

  A. Copy Data
  B. Smart Push
  C. Data Management
  D. Import Data
  E. Data Maps
  A. Copy Data
  B. Smart Push
  E. Data Maps

  ---

  A: You can copy plans from one dimensional intersection to another, including relational data and supporting detail.

  B: About Smart Push

  For more meaningful and complete reporting, planners can move comments, attachments, and supporting detail to multiple cubes. Users can then do more analysis on the planning data coming from the different cubes.

  E: To move data to a reporting cube:

  Create the reporting cube.

  Click Application, and then click Data Maps.

  To the right of a data map, click Action icon, and then select Push Data.

  References:

  https://docs.oracle.com/cloud/latest/pbcs_common/PFUSA/copydata.htm#PFUSA- f_navigate_workspace_1379

  https://docs.oracle.com/cloud/latest/pbcs_common/PFUSA/push_dat.htm#PFUSA- f_data_maps_204

  https://docs.oracle.com/cloud/latest/pbcs_common/PFUSU/smart_push_details.htm#PFUS U-f_basics_data_70

• Question 20:

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

  A. Load data directly into Data Management without the need for mappings
  B. Import business process data into a specific framework cube
  C. Customize the data import process to your application's unique requirements
  D. Use the EPBCS Import Data feature
  E. Allow for a single Excel template to load data to all frameworks without custom modifications
  B. Import business process data into a specific framework cube
  C. Customize the data import process to your application's unique requirements
  D. Use the EPBCS Import Data feature

  ---

  B: Essbase is selected as Source Type for the data import to load data in an Essbase data file format. If you select this option, you must choose a cube.

  C: Open the templates in Microsoft Excel, and customize them to specify your business data.

  D: To import data:

  References:

  https://docs.oracle.com/cloud/latest/pbcs_common/PFUSA/importing_data_101.htm#PFUS A-f_manage_app_49