Oracle 1Z0-531 Online Practice Questions and Exam Preparation

Oracle 1Z0-531 Online Questions & Answers

• Question 31:

  In Essbase, security can be managed in_______.

  A. Shared Services
  B. Administration Services
  C. Essbase Studio
  D. Shared Services or Administration Services
  E. All of the above
  D. Shared Services or Administration Services

  ---

  Basic integration with Shared Service is easily accomplished and involves 'externalizing' Essbase to Shared Services. To handle this a number of tasks need to occur first. Shared Services needs to be installed and configured; along with Essbase Administration Services (EAS). You must also install and configure Essbase. In addition, longtime Essbase users know they need to launch it from a command line first, setup some basic security options and then it will finally be running. Having accomplished all of that you can now launch the EAS console and get down to security work.

• Question 32:

  Identify the two true statements about incremental loading.

  A. Allows for real time data access for end users.
  B. Creates *subscribes* along the main slice in the database.
  C. Materialization of slices is required to provide users the correct query results.
  D. Different materialized views may exist within a slice as compared to the main slice of the database.
  A. Allows for real time data access for end users.
  C. Materialization of slices is required to provide users the correct query results.

  ---

  A: Incremental loading and fast aggregation can provide near real-time analysis of transactional data.

  C: Incremental loading creates subcubes or slices alongside the primary slice of the database.

  Note: Following a data load, Essbase ASO does not store any aggregate values, but instead calculates them on demand. For large databases, where the time required to generate these values may become inconvenient, the database can materialize one or more aggregate "views", made up of one aggregate level from each dimension (for example, the database may calculate all combinations of the fifth generation of Product with the third generation of Customer), and these views are then used to generate other aggregate values where possible. This process can be partially automated, where the administrator specifies the amount of disk space that may be used, and the database generates views according to actual usage. This approach has a major drawback in that the cube cannot be treated for calculation purposes as a single large hypercube, because aggregate values cannot be directly controlled, so write-back from front- end tools is limited, and complex calculations that cannot be expressed as MDX expressions are not possible.

  Hyperion Essbase - System 9 Database Administrator's Guide

• Question 33:

  Which two are Essbase components?

  A. Essbase server
  B. Administration services
  C. C API
  D. Web Analysis
  E. Financial reporting
  A. Essbase server
  B. Administration services

  ---

  Incorrect answer:

  C API is not a component of Essbase.

  Web analysis and Financial reporting are both parts of Hyperion, not Essbase.

• Question 34:

  Which four of the following activities can be performed by the administrator in Shared Services?

  A. Creates users and groups
  B. Accesses external users and groups for provisioning
  C. Migrates applications using Life Cycle Management
  D. Creates cube schemas from a relational database
  E. Provisions Essbase roles for users and groups like Read, Write, and Filter
  F. Creates Essbase filters
  A. Creates users and groups
  B. Accesses external users and groups for provisioning
  C. Migrates applications using Life Cycle Management
  E. Provisions Essbase roles for users and groups like Read, Write, and Filter

  ---

  Essbase Studio is a component of Oracle Essbase. Essbase Studio requires Hyperion Shared Services for user management and security.

  Shared Services provides a single sign-on (SSO) service, not only for Essbase and its components, but for all Oracle Enterprise Performance Management System products. SSO promotes an uninterrupted workflow when moving between Essbase components and/or Oracle Enterprise Performance Management System products. Shared Services can be linked with your existing corporate repository--for example, a Lightweight Directory Access Protocol (LDAP) server to authenticate users (B). Administrators can create user roles and groups (A) to define which products end users can use and the level of access they have to the product. Together, user authentication and role-based authorization provide a secure environment (E). Shared Services is part of Oracle Hyperion Foundation Services, which ships with Oracle Essbase. It is required for managing users in Essbase Studio.

• Question 35:

  In Essbase 11.1.1, what are two possible ways to calculate Period to Date values in ASO?

  A. Enable Dynamic Time Series
  B. Analytic dimension with member formulas to calculate period to date values
  C. Alternate hierarchy in Time dimension to rollup period to date values
  D. Create a Date Time dimension
  B. Analytic dimension with member formulas to calculate period to date values
  C. Alternate hierarchy in Time dimension to rollup period to date values

  ---

  B: More recent releases of Essbase will do time balancing natively, but period-to-date is something you still have to work out. A preferred method of doing this is to add an analytic dimension to the database and set the formula in one of the

  calculated members. For those of you who aren't familiar with the term, an analytic dimension is one that you add to your database that has a single default load member, all other members are calculated.

  B, C: Period to date functionality has to be managed via MDX formulas and/or alternate roll ups in your time dimension.

• Question 36:

  Identify the two true statements about materialization in ASO.

  A. When performing an incremental data load, aggregate views are updated
  B. The database is not available during materialization
  C. Materialization can be tuned via query hints and hard restrictions defined at the database level
  D. Materialization scripts can be saved for future reuse
  A. When performing an incremental data load, aggregate views are updated
  D. Materialization scripts can be saved for future reuse

  ---

  The following process is recommended for defining and materializing aggregations:

  *

  After the outline is created or changed, load data values.

  *

  Perform the default aggregation. Do not select specify a storage stopping point option.

  *

  Materialize the suggested aggregate views and save the default selection in an aggregation script.

  *

  Run the types of queries the aggregation is being designed for.

  *

  If query time or aggregation time is too long, consider fine-tuning the aggregation as stated below.

  *

  Save the aggregation selection as an aggregation script (D)

• Question 37:

  What is the extension for the file containing data for ASO applications?

  A. .pag
  B. .dat
  C. .txt
  D. .aso
  E. .fil
  B. .dat

  ---

  For ASO - the data is stored in table spaces in a .dat file in the \App\Appname\default folder. The format is some type of binary and you cannot open the file and do anything with the contents.

• Question 38:

  What does DTS (Dynamic Time Series) do?

  A. Calculates to date values for Essbase block storage databases
  B. Dynamically calculates the Time dimension
  C. Enable Time Balance functionality for accounts
  D. Calculates to date values for Essbase aggregate storage databases
  B. Dynamically calculates the Time dimension

  ---

  *

  In order to calculate period-to-date values dynamically, you need to use a Dynamic Time Series member for a period on the dimension tagged as time.

  *

  Use built in Dynamic Time series calculations for period to date calculations such as YTD, QTD, and MTD accumulations. DTScalculations are on the fly and require time related dimension to be tagged as Time.

  *

  You do not create the Dynamic Time Series member directly in the database outline. Instead, you enable a predefined DynamicTime Series member and associate it with an appropriate generation number.

  *

  Dynamic Time Series members are not displayed as members in the database outline. Instead, Essbase lists the currently active Dynamic Time Series members in a comment on the time dimension.

• Question 39:

  The following objects are considered metadata in Essbase studio except for which two?

  A. Dimensional element
  B. Hierarchy
  C. Cube Schema
  D. Metaoutline
  E. Essbase Model
  F. Metamodel
  E. Essbase Model
  F. Metamodel

  ---

  Metadata is defined as data about data. Metadata is a record of all information of database.

• Question 40:

  Within which two directories can you set the location and file size in ASO?

  A. Default
  B. Metadata
  C. Log
  D. Temp
  E. Bin
  F. Data
  A. Default
  D. Temp

  ---

  For aggregate storage applications, Tablespace Manager controls data retrieval and storage, using tablespace definitions to manage data storage and work areas on the disk.

  Tablespaces help optimize data file and work file storage and retrieval. Tablespaces define location definitions that map data artifacts, such as aggregate views and aggregations, to files. Each application directory contains directories for four tablespaces:

  *

  default

  *

  log

  *

  metadata

  *

  temp

  *

  Directory path locations

  *

  Maximum disk space to be used at each location

  *

  Maximum file size allowed within each location

  For default and temp you can specify multiple locations and sizes, and you can define tablespace properties: