Oracle 1Z0-533 Online Practice Questions and Exam Preparation

Oracle 1Z0-533 Online Questions & Answers

• Question 51:

  Identify two true statements about the DATAEXPORT calc script command.

  A. Using DATAEXPORT within the FIX statement of a calc script allows you to export specific data sets from an Essbase database.
  B. DATAEXPORT only exports level zero data.
  C. DATAEXPORT only exports to flat files.
  D. DATAEXPORT only exports entire data blocks.
  E. DATAEXPORT is faster than Essbase Report.
  A. Using DATAEXPORT within the FIX statement of a calc script allows you to export specific data sets from an Essbase database.
  E. DATAEXPORT is faster than Essbase Report.

  ---

  A: To develop a calculation script that exports a subset of data, you first specify the SET DATAEXPORTOPTIONS command to define options for export content, format, and process Use FIX...ENDFIX or EXCLUDE...ENDEXCLUDE calculations to select a slice of the database and use a DATAEXPORTCOND command to select data based on data values.

  Note: The DATAEXPORT command enables calculation scripts to export data in binary or text, or directly to a relational database. A set of data-export-related calculation commands qualify what data to export and provide various output and

  formatting options.

  Compared to using other methods to export data, using a calculation script has the following advantages and disadvantages:

  Advantages:

  Enables exporting a subset of data.

  *

  Supports multiple targets: flat files, relational databases, and binary files (not B, C, D)

  *

  Provides many flexible options for type and format or data.

  *

  As part of a calculation script, can be easily deployed in a batch process.

  *

  Can be very fast when the dynamic calculation export option is not used because DATAEXPORT directly accesses Kernel storage blocks in memory. (E)

  *

  Provides, through binary export-import, a faster way to back up and restore data because the compressed format used by binary export requires less storage for the export files.

  *

  Can be used as a debug tool to trace batch calculation results by using the DATAEXPORT command before and after other calculation commands to track data changes.

  Disadvantages

  Contains limited data formatting options compared to Report Writer formatting.

• Question 52:

  What are the two possible effects on the database when the data storage property of a parent member in the sparse Entity dimension is set to Dynamic Calc?

  A. Essbase data block size decrease.
  B. The member is not available for process management.
  C. Retrieval performance could be slower when referencing the parent entity member.
  D. Data cannot be input to the parent in target versions.
  A. Essbase data block size decrease.
  C. Retrieval performance could be slower when referencing the parent entity member.

  ---

  Dynamic Calc members in a block storage outline that Essbase calculates only at retrieval time. Essbase discards calculated values after completing the retrieval request.

• Question 53:

  Identify three key benefits of the Planning solution.

  A. Standardized data forms for plan data entry available both for the Web and in Excel
  B. One tool to budget and forecast as well as provide reporting for very detailed Actuals Information
  C. Central repository of business rules that can be run by end users to calculate plan data
  D. Detailed security down to the cell level
  E. Flexible solution customizable for almost any kind of budgeting and forecasting process
  A. Standardized data forms for plan data entry available both for the Web and in Excel
  C. Central repository of business rules that can be run by end users to calculate plan data
  E. Flexible solution customizable for almost any kind of budgeting and forecasting process

  ---

  A: Hyperion Planning leverages Multidimensional functionalities and capabilities of Essbase to the fullest to provide varied planning options along with inherent Data Forms, MS Excel, Web based grid interface for the data entry and reporting

  needs. ata Forms in Hyperion planning provides a standard centralized grid-based interface for data entry and data-checks.

  Customizing or fixing a Data Form issues take lesser time and effort compared to the Excel based spreadsheets.

  C: Use of a central repository makes administration and maintenance of business rules easy, because the repository stores information for several applications in one database.

  A user or group who has the role of basic user can do these tasks:

  *

  Launch business rules and sequences to which the user has access

  *

  View business rules and sequences to which the users has access

  *

  View all variables and macros

  *

  Edit business rules, sequences, macros, variables, and projects for which the user was granted editing privileges

  E: Oracle Hyperion Planning provides an in-depth look at business operations and its related impact on financials, by tightly integrating financial and operational planning models. With Oracle Hyperion Planning you can meet your immediate financial planning needs while enabling a platform for future cross-functional expansion and automated process integration.

  Reference: Hyperion Business Rules, Administrative Guide

• Question 54:

  Identify the three true statements about weekly distribution.

  A. For Weekly Distribution options 445, 454, 544, the quarterly values are treated as if they are divided into 13 weeks and the weeks are distributed via a pattern you specify.
  B. The only valid weekly distribution options are 445, 454, and 544.
  C. If you select the 4-5-4 Weekly distribution option, Planning treats the first month in the quarter as if it has 4 weeks, the second month as If it has 5 weeks, and the third month as if it has 4 weeks.
  D. If you choose weekly distribution for Custom-based time periods. Planning will not distribute the data values across base periods.
  E. Weekly distribution determines how data entered into summary periods should spread to its base periods.
  A. For Weekly Distribution options 445, 454, 544, the quarterly values are treated as if they are divided into 13 weeks and the weeks are distributed via a pattern you specify.
  C. If you select the 4-5-4 Weekly distribution option, Planning treats the first month in the quarter as if it has 4 weeks, the second month as If it has 5 weeks, and the third month as if it has 4 weeks.
  E. Weekly distribution determines how data entered into summary periods should spread to its base periods.

  ---

  A: If you select a weekly distribution pattern other than Even, Planning treats quarterly values as if they were divided into 13 weeks and distributes weeks according to the selected pattern.

  E:

  Weekly distribution sets the monthly distribution pattern, based on the number of fiscal weeks in a month. This determines how data in summary time periods spreads within the base time period. When users enter data into summary time

  periods, such as quarters, the value is distributed over base time periods in the summary time period.

• Question 55:

  Name the valid ways to create blocks in an underlying Essbase database. Select all that apply

  A. Copy data
  B. Load data
  C. Create block on Equation D. Aggregate data
  A. Copy data
  B. Load data
  C. Create block on Equation D. Aggregate data

  ---

  Ways to create data blocks:

  1.

  Data Load, (B)

  2.

  DataCopy Command, (A)

  3.

  Sparse Dimension Consolidation,

  4.

  Member Formulas:

  4a. Assiging a constant value to a sparse member,

  4b. Turning Create Block on Equation setting on and assiging a non constant value (C)

  4c. Create non missing blocks

  B: The moment we load data to essbase, It creates block for those combinations automatically.

  C: Controls, within a calculation script, whether or not new blocks are created when a calculation formula assigns anything other than a constant to a member of a sparse dimension. SET

  CREATEBLOCKONEQ overrides the Create Block on Equation setting for the database.

  If calculations result in a value for a sparse dimension member for which no block exists, Analytic Services creates a new block. Sometimes, the new blocks are not desired; for example, when they contain no other values. In large databases,

  creation and processing of unneeded blocks can increase processing time as well as the storage requirement for a database.

  For the situation when new blocks would be created as a result of assigning something other than a constant to a member of a sparse dimension, Analytic Services provides the Create Blocks on Equation setting. For example, when the

  Create Blocks on Equation setting is ON and West is assigned a value where it did not have a value before, new blocks are created. When this setting is OFF, new blocks are not created.

  Incorrect answer:

  Copy Data--Use to copy data from one part of your database to another. You select the source data to copy and specify the target or destination value.

  D: Aggregate data. There is no such specific command or utility. It is just a general concept in the Hyperion context.

• Question 56:

  Why is the Create Blocks function in calc scripts and Business Rules important in Planning?

  A. Data may not exist for the combination of dense members so you have to create the block before calculating the data value for the block.
  B. Data may not exist for the combination of sparse members so you have to create the block before calculating the data value for the block.
  C. Data may not exist for the combination of dense members so you have to create the block before block loading data to the block.
  D. Data may not exist for the combination of sparse members so you have to create the block before loading data value to the block.
  D. Data may not exist for the combination of sparse members so you have to create the block before loading data value to the block.

  ---

  You can use the Create Blocks action to make sure that blocks are created in the database for sparse member combinations in a specified slice of data. Since there is a potential for a large increase in the database size when creating blocks,

  be careful when adding this action to your business rule. To help you get an idea of the size, the system displays a calculation of the block size and maximum possible blocks that would exist for the specified data slice after the business rule

  is launched. Since some blocks may exist in the database, this calculation does not represent the exact amount of the increase.

  Note: You can choose from four possible actions to include in a graphical business rule:

  Aggregate

  Data, Copy Data, Clear Data, and Create Blocks.

  *

  Create Blocks--Use to specify a data slice to ensure that blocks are created for all sparse member combinations in that slice.

  *

  Aggregate Data--Use to calculate your database by specifying which dimensions to calculate and what calculation options you want to use during the aggregation.

  *

  Copy Data--Use to copy data from one part of your database to another. You select the source data to copy and specify the target or destination value.

  *

  Clear Data--Use to define a subset of data that will be cleared from the database before a new value is added. You can choose to clear cells or to clear blocks of data.

  Reference: Hyperion Business Rules, Administrative Guide, Release 9.3.1, Adding a Create Blocks Actio

• Question 57:

  Assuming you have a Period dimension with calendar months rolling to quarters to total years. If you assign the property Time Balance Last to the "Headcount" account member, what will user see for Q1?

  A. January's value
  B. March's value
  C. The total of January+February +March
  D. The average of January + February + March
  B. March's value

  ---

  Set the time balance as "last" when you want the parent value to represent the value of the last member in the branch (often at the end of a time period).

  Note:

  Essbase - Time balance properties

  The tags :

  first,

  last,

  average,

  and expense

  are available exclusively for use with accounts dimension members.

  Using this tag requires an accounts dimension and a time dimension

  If an accounts dimension member uses the time balance property, it affects how Essbase calculates the parent of that member in the time dimension. By default, a parent in the time

  dimension is calculated based on the consolidation and formulas of its children. For example, in the database in this scenarion, the Q1 member is the sum of its children (Jan, Feb, and Mar). However, setting a time balance property causes

  parents, for example Q1, to roll up differently.

  If you set the time balance as first, last, or average, set the skip property to tell Essbase what to do when it encounters missing values or values of 0.

• Question 58:

  Which three components can be changed after the creation of the Planning application?

  A. Number of years
  B. Names of plan types
  C. Number of plan types
  D. Initialization of WFP or CapEx Planning modules
  E. Weekly distribution spread
  F. Year Dimension Name
  G. Default Currency
  A. Number of years
  D. Initialization of WFP or CapEx Planning modules
  F. Year Dimension Name

  ---

  Note: WFP ?Workforce planning. Oracle Hyperion Capital Expense Planning (CAPEX) software is a specialized planning module that automates the planning of capital assets and capital asset related expenses, such as depreciation, maintenance and insurance.

• Question 59:

  Identify two ways that Essbase data load rules cannot manipulate source data files.

  A. Select or reject records based on certain criteria.
  B. Flip the sign for records with a certain member tagged with a comment.
  C. Split or join columns in a source.
  D. Find and replace manipulations on source records.
  E. Map data based on an external table.
  C. Split or join columns in a source.
  E. Map data based on an external table.

  ---

  C: Columns cannot be split or joined at runtime in the source.

  E: An external table cannot be used to map data.

  Note: Data Load Rules file is the second type of rules files which is involved in the data load process.

  A data source for data load must contain :

  not only the values that you want to load but also identification of the location to which Essbase should load the values:

  a data address that includes one member from every standard dimension in your outline.

• Question 60:

  Which three tasks can be performed using the Smart View Planning Provider in Microsoft Excel?

  A. Open a data form and submit data.
  B. enter supporting detail and cell text.
  C. Run business rules.
  D. enter planning unit annotations.
  E. Perform workflow tasks.
  A. Open a data form and submit data.
  B. enter supporting detail and cell text.
  C. Run business rules.

  ---

  Oracle Hyperion Smart View for Office (Smart View) is a component of Hyperion Foundation Services. Smart View provides a common Microsoft Office interface designed specifically for Oracle's Enterprise Performance Management (EPM) and Business Intelligence (BI). Using Smart View, you can view, import, manipulate, distribute and share data in Microsoft Excel, Word and PowerPoint interfaces. It is a comprehensive tool for accessing and integrating EPM and BI content from Microsoft Office products.