Oracle 1Z0-533 Online Practice Questions and Exam Preparation

Oracle 1Z0-533 Online Questions & Answers

• Question 41:

  Identify the two true statements about Enterprise performance Management Architect.

  A. If you decide to implement EPMA, all Planning applications must be EPMA-deployed applications.
  B. EPMA-deployed applications may either use EAS Business Rules or Calculation Manager in 11.1.1.3.
  C. You can create Planning, TM, Essbase, and FDM applications in EPMA.
  D. Data can be shared from a Planning application to an FM application within EPMA.
  E. EPMA can be used by end users to manage and update member properties such as hierarchies and aliases.
  F. In the Dimension Library, you can maintain one full dimension (for example. Account) but filter portions of the dimension for different applications (for example, Revenue accounts. Balance Sheet)
  B. EPMA-deployed applications may either use EAS Business Rules or Calculation Manager in 11.1.1.3.
  D. Data can be shared from a Planning application to an FM application within EPMA.

  ---

  B: Calculation Manager, a component of Hyperion Enterprise Performance

  Management Architect, is the new tool to create business rules and business rule sets to run against Hyperion Planning and Oracle Essbase.

  D: EPMA Data Synchronization--Enables data synchronization within Hyperion applications. You can use the Data Synchronizer to:

  *Create data movement synchronizations between Hyperion applications. For example, an administrator can synchronize data between two Financial Management; two Planning

  applications, and between one Financial Management and a Planning application

  *Create data mappings for reuse

  *Create flat file and interface table mappings to import data into Hyperion applications

  Note:

  

• Question 42:

  Management dictates a major reorganization of the company structure, meaning you need to rebuild the Entity dimension from the beginning. You need to delete members in the Entity dimension. Identify the three true statements about deleting members from a Planning application.

  A. You must delete members one by one.
  B. You must delete a reference to a member from all data forms before deleting it from the dimension.
  C. In a data form definition, you selected @IDescendants(IT) for the entity dimension in the page section. The IT member will remain but 2 of its 10 cost centers are being removed. You must remove the reference to "IT" in this data form.
  D. You should back up all data for the deleted entity members; after a member is deleted, the data is not retained.
  E. A database refresh is required after deleting members from the Entity dimension.
  B. You must delete a reference to a member from all data forms before deleting it from the dimension.
  D. You should back up all data for the deleted entity members; after a member is deleted, the data is not retained.
  E. A database refresh is required after deleting members from the Entity dimension.

  ---

  B: members of the dimension entity must be first delete in data forms and then in the library dimension

  D: Make a backup to retain the information.

  E: A refresh of the database is required.

• Question 43:

  Identify the three characteristics of the Scenarios dimension.

  A. Security can be assigned to members of the Scenario dimension.
  B. It allows the administrator to assign valid periods for data entry
  C. It allows bottoms up or target planning
  D. Exchange rate tables are tied to the Scenario dimension.
  E. One member in the scenario dimension may be valid for Plan Type.
  A. Security can be assigned to members of the Scenario dimension.
  B. It allows the administrator to assign valid periods for data entry
  D. Exchange rate tables are tied to the Scenario dimension.

  ---

  A: Specify access rights to members of the Scenario dimension for groups or users.

  Access rights determine users or groups can view or modify data. A user or group can have only one of these access rights: Read, Write, or None. Access rights for a user can be combined based on groups to which the user belongs.

  B: When creating a scenario For Start Yr., Start Period, End Yr., and End Period are used to select the time period to associate with the scenario.

  D: The Scenario dimension has an Exchange Table property with value of the name of an exchange rate table defined in the application.

  Reference: Oracle Hyperion Planning, Fusion Edition

• Question 44:

  Given the following:

  Measures (Dense): 40 stored members, 50 total members

  Time (Dense): 17 stored members, 17 total members Scenario (Dense): 2 stored members, 5 total members

  Market (Sparse): 100 stored members, 100 total members

  Product(Sparse): 500 stored members, 550 total members

  What is the block size in bytes?

  A. Block size = 40 * 17 * 2
  B. Block size = 40 * 17 * 2 * 8
  C. Block size = 50 * 17 * 5 * 8
  D. Block size = 50 * 17 * 5
  E. Block size = 100 * 500 * 8
  F. Block size = 100 * 500
  B. Block size = 40 * 17 * 2 * 8

  ---

  We need to multiple the stored (not the total) members of the dense dimensions (here Measures: 40, Time:17, and Dense:2) with 8 to calculate the block size.

  Note: Data block size is determined by the amount of data in particular combination of dense dimensions. For ex: when you change the dense or sparse configuration of one or more dimensions in the database, the data block size changes. Data block size is 8n bytes, where n is the number of cells that exist (ie. Stored, not total) for that combination of dense dimensions. Note: Optimal range is 8 to 100 kb

• Question 45:

  What are the three supported methods to create and update a member and its properties ming Classic or non-Classic Planning applications)?

  A. Planning Web Client
  B. EAS
  C. EPMA
  D. DRM
  E. Outline Load Utility
  A. Planning Web Client
  B. EAS
  C. EPMA

  ---

  A: Planning Web Client provides complete functionality for Web users. Use the Web interface to roll out applications to large, distributed organizations without installing software on client computers.

  All software resides on the server. Many administrative features that were formerly in the Planning Desktop are now available through Planning Web.

  B: Oracle Hyperion Essbase Administration Services (Essbase Administration Services) software is a robust, cross-platform graphical user interface that makes Essbase administration tasks easy to perform.

  Administrators can simultaneously view and edit properties for multiple Hyperion Essbase databases, applications, users, scripts, and other objects from a single intuitive view.

  Essbase Administration Services also provides wizards, editors, dynamic menus, and other tools to help you implement, monitor, and maintain analytic and enterprise performance management applications.

  C: Enterprise Performance Management Architect (EPMA) enables administrators to manage, create, and deploy Hyperion applications within one interface. EPMA can do adds, moves, modify properties, etc.

• Question 46:

  Based on the following design: Plan type 1: Summary Plan type with all Accounts by Entity Plan type 2: Sales Plan type with Sales by Product by Entity Plan type 3: Salary Plan type with Salary Expense by Employee by Entity You need to get Sales data to the Summary plan type. Identify the two true statements about

  sharing revenue data between the sales plan type and the summary plan type.

  A. Planning will build in @XREF calculations in a calc script by default to share data between plan types.
  B. A replicated partition could be created to replicate data from the sales plan type to the summary plan type and this would be done if we wanted to store the sales data in the summary plan type.
  C. A transparent partition and @XREF calculations could have performance issues for retrievals because data is not stored; it is dynamically calculated.
  D. A calc export script on the source database with the DATAEXPORT command could be used to export data out of the revenue plan type and calc import script on the target database with the DATAIMPORT command could be used to import the data file to the summary plan type.
  E. To disable the building of @XREF, update the HSPProperties file for the application before you click Create during the application creation process.
  B. A replicated partition could be created to replicate data from the sales plan type to the summary plan type and this would be done if we wanted to store the sales data in the summary plan type.
  C. A transparent partition and @XREF calculations could have performance issues for retrievals because data is not stored; it is dynamically calculated.

  ---

  B: Replicated Partition:

  A portion of a database, defined through Partition Manager, used to propagate an update to data mastered at one site to a copy of data stored at another site. Users can access the data as though it were part of their local database.

  C:

  Transparent partition:

  A form of shared partition that provides the ability to access and manipulate remote data transparently as though it is part of your local database. The remote data is retrieved from the data source each time you request it. Any updates made

  to the data are written back to the data source and become immediately accessible to both local data target users and transparent data source users

  Note: @XREF

  Enables a database calculation to incorporate values from another Essbase database.

  The following terminology is used to describe the @XREF function:

  Data target: the database on which the current calculation is running (that is, the database on which the @XREF call originates).

  Data source: the database that is queried by the @XREF function. This database may be remote (that is, on a different machine than the data target).

  Point of view: the member combination currently being calculated on the data target (that is, the member combination that identifies the left hand side of a calculation).

  The @XREF function retrieves values from a data source to be used in a calculation on a data target. @XREF does not impose member and dimension mapping restrictions, which means that the data source and data target outlines can be

  different.

  Note #2:

  Hyperion planning's Plan Types treated as individual databases in underlying Essbase database comes with inherent facility to share data and dimension members across plan types in Hyperion Planning or equivalent databases in underlying

  Essbase. This reduces the need for additional development/maintenance effort when compared to Planning systems based on Standalone Essbase. The Hyperion Planning user would seldom realize that the dimension members belong to

  multiple databases. While this might be an area of concern while using Standalone Essbase to build planning system.

• Question 47:

  Identify the two statements about the Planning Import security utility.

  A. Imports Planning application access for users and groups
  B. Imports users and groups into Planning
  C. Requires the source text file to be named PLANSECFILE.txt
  D. Can be scheduled to run nightly using an encrypted password
  E. Clears existing security definitions by default before the import takes place
  A. Imports Planning application access for users and groups
  D. Can be scheduled to run nightly using an encrypted password

  ---

  The Import Security utility performs a Oracle Hyperion Planning security import.

  A: The ImportSecurity utility loads access permissions for users or groups from a text file into Planning.

  (To add users or groups, see the Oracle Hyperion Enterprise Performance Management System Security Administration Guide. . not B)

  Importing access permissions overwrites existing access assignments only for imported members, data forms, data form folders, task lists, Calculation Manager business rules, and Calculation Manager business rule folders. All other existing

  access permissions remain intact. (not E).

  The SL_CLEARALL parameter clears all existing access permissions; you can use it with other parameters to replace existing access permissions. See also Exporting Access Permissions.

  D: To import access permissions into Planning:

  Locate the ImportSecurity utility by navigating to the bin directory.

  From the Command Prompt, enter this case-sensitive command, one space, and the parameters, separating each with a comma. Enclose the parameters with double quotation marks:

  ImportSecurity.cmd [-f:passwordFile] "appname,username,[delimiter],[RUN_SILENT],[SL_CLEARALL]"

  This command can be scheduled.

• Question 48:

  You need to calculate benefit expense in your Planning application using the following logic:

  Benefit expense is equal to the Total Salary of the Organization multiplied by a factor data loaded to each cost center.

  Given the following components, what is the correct order of calculation:

  1-Custom calculation (Total Salary * Factor)

  2-Aggregate benefits

  3-Aggregate salaries

  A. 1, 2, 3
  B. 3, 2, 1
  C. 2, 3, 1
  D. 3, 1, 2
  D. 3, 1, 2

  ---

  First calculate the aggregated saleries.

  Then make the custom calculation on the saleries.

  Finally use the result of the custom calculation to product the benefits.

• Question 49:

  What differentiates a user-defined custom dimension from the Entity and Account dimensions?

  A. You can only add custom attributes to user-defined custom dimensions.
  B. You assign valid plan types for the user-defined custom dimension at the dimension level.
  C. You assign data types for the user-defined custom dimension at the dimension level.
  D. You cannot: assign security for user-defined custom dimensions.
  E. You can easily delete a user-defined custom dimension in Planning but you cannot delete an Entity dimension.
  B. You assign valid plan types for the user-defined custom dimension at the dimension level.

  ---

  User-defined custom dimensions differ from the Entity and Account dimensions in that you assign valid plan types at the dimension level, not at the member level. All members of a user defined custom dimension are valid for plan types assigned at the dimension level.

• Question 50:

  Identify the one Planning component that is not accessible over the Web.

  A. Dimension Editor for Planning
  B. Shared Services
  C. Exchange Rates Definition
  D. Planning Utilities
  E. Create and Manage Database Options
  F. Create Data Sources
  D. Planning Utilities

  ---

  Hyperion Planning Utilities can only be used locally.