Oracle Oracle Certifications 1Z0-982 Questions & Answers

• Question 71:

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

  A. Percent sign

  B. Forward slash

  C. Tab

  D. Comma

  Correct Answer: CD

  References: https://docs.oracle.com/cloud/latest/pbcs_common/PFUSA/other_supported_delimiter_char acters_104x085fcea9.htm

• Question 72:

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

  A. Renaming a dimension in the Map/Rename Dimensions section during enablement?

  B. Creating a new dimension through the Application Overview area

  C. Adding a new dimension by loading it in Data Management

  D. Adding a new dimension to the cube through the Create and Manage Dimensions area

  Correct Answer: D

  To add or change user-defined dimensions:

  Click Refresh to revert to the previous values and keep the page open.

  References:

  https://docs.oracle.com/cd/E57185_01/AGOHP/dim_add.html https://docs.oracle.com/cd/E57185_01/

  DRMIG/ch01s05s06.html

• Question 73:

  Which three items are available sources for loading data with Data Management into Oracle Enterprise Planning and Budgeting Cloud (EPBCS)? (Choose three.)

  A. Oracle Financials Cloud

  B. Oracle EBS

  C. HCM Cloud

  D. File

  E. Oracle Peoplesoft

  Correct Answer: ACD

  Reference: https://docs.oracle.com/en/cloud/saas/enterprise-performance-management- common/erpia/ GUIDF8001C5A-A922-43C7-A0C6-4025F1EB7BDF.pdf search on source system type.

• Question 74:

  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

  Correct Answer: ABE

  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#PFUSAf_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 Uf_basics_data_70

• Question 75:

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

  A. Financial Data Quality Management Enterprise Edition (FDMEE)

  B. Data Management

  C. Data Maps

  D. XREF member formulas

  E. Import Data option with framework templates

  F. DATAEXPORT command in Calculation Manager business rules

  Correct Answer: ABE

  A: Oracle Hyperion Financial Data Quality Management Enterprise Edition eliminates the data integrity risks associated with collecting, mapping, verifying, and moving critical financial data. With it, you can build standardized, repeatable processes and avoid the typical inefficiencies of collecting financial data.

  B: You can import data using Data Management.

  E: Use the Export-Import Data template to export data from, or import data into, a location in the database outline.

  References: Oracle Cloud, Administering Planning for Oracle Enterprise Planning and Budgeting Cloud

• Question 76:

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

  A. Due to sparse dimensionality, Aggregation times are slow in EPBCS.

  B. The client would like to plan revenue by Product and Services dimensions.

  C. The client would like to report the results of the allocation process by Entity.

  D. The client would like to store 10 years of actual history for reporting purposes but only requires prior year history for planning purposes.

  E. The client has 10 dimensions in the EPBCS application and needs to report at each intersection.

  Correct Answer: AE

  The advantage of creating these Aggregate Storage Option (ASO) cubes is obviously for reporting capabilities. With any application that utilizes a large dimension set with several sparse members, ASO cubes make reporting on data much faster.

  References: http://www.performancearchitects.com/wp/2014/05/07/advantages-and- disadvantages-of-theaggregate-storage-option-aso-plan-type-feature-in-oracle-hyperion- planning-version-11-1-2-3/

• Question 77:

  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

  Correct Answer: C

  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 78:

  Which statement is true when configuring the Projects option?

  A. If using the Projects option, then the Capital option and the Workforce option must be configured

  B. If using the Projects option, there is no dependency with the Capital option.

  C. If using the Projects option, then the Capital option must also be configured.

  D. If using the Projects option, then the Capital option must also be configured, only if capital projects are enabled.

  Correct Answer: D

  Optionally, for capital projects, you can allocate project expenses either partially or in full to one or more assets.

  References: Oracle Cloud, Administering Planning for Oracle Enterprise Planning and Budgeting Cloud, page 5-1 https://docs.oracle.com/cloud/latest/pbcs_common/EPBUG/EPBUG.pdf

• Question 79:

  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?

  A. OFS_Integration

  B. OFS_Calculated

  C. OFS_Systems

  D. OFS_Load

  Correct Answer: D

  OFS_Load--Data value to import.

  References: https://docs.oracle.com/cloud/latest/pbcs_common/EPBCA/general_importing_financials_1 16x04dcf57d.htm#EPBCA-GUID-ABF5EAB0-A5D3-43CD-BA2E-72C56996AA2F

• Question 80:

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

  A. Three custom planning applications can be Initialized

  B. Four custom reporting applications can be initialized

  C. Approvals is not included

  D. Groovy calculations are available

  Correct Answer: BC

  B: These are planning applications, not reporting applications.

  C: An approval unit is the basic unit for preparing, annotating, reviewing, and approving plan data. Approval units are combinations of scenario, version, and entity or part of an entity. You can have one scenario/version combination per approval unit. Scenarios and versions are the basis of the review cycle. Approval units submit planning data for a scenario and version.