Oracle 1Z0-591 Online Practice Questions and Exam Preparation

Oracle 1Z0-591 Online Questions & Answers

• Question 51:

  Which option is not an example of a level-based measure?

  A. Regional Revenue
  B. Sales
  C. Brand Cost
  D. Employee Salary
  C. Brand Cost

  ---

  Note 1: A level-based measure is a column whose values are always calculated to a specific level of aggregation.

  The calculation of this measure is independent of the query grain and used always the aggregation grain of the logical column.

  Level-based measures allow :

  *

  to return data at multiple levels of aggregation (the query grain and the level-based column grain) with one single query

  *

  to create share measures (percentage), that are calculated by taking some measure and dividing it by a level-based measure. For example, you can divide salesperson revenue by regional revenue to calculate the share of the regional

  revenue each salesperson generates.

  Note 2: To create a level based measure as the amount sold by region, you can:

  *

  make a copy of the Amount Sold logical column

  *

  and then

  / drag the logical column into its hierarchy level / or set the aggregation grain in the level tab of the logical column property.

• Question 52:

  Cache in OBIEE is used to_____. Select the two correct answers.

  A. improve performance of Dashboards and Analysis
  B. decrease query response time
  C. improve Analysis data quality
  D. eliminate Write Back Capabilities
  E. create Aggregate tables
  A. improve performance of Dashboards and Analysis
  B. decrease query response time

  ---

  Decrease query response time which will improve performance for Dashboards and Analysis.

• Question 53:

  Use of the Enterprise Install option is recommended for which three options?

  A. Multiple instances on a single computer
  B. Scale out for High Availability and Failover
  C. Support for high security requirements
  D. Evaluation of end user functionality
  E. Single users working on a single computer
  A. Multiple instances on a single computer
  B. Scale out for High Availability and Failover
  C. Support for high security requirements

  ---

  Enterprise Install: This installation type assumes some familiarity with Oracle Business Intelligence. All software components are downloaded onto one computer. You can accept the default configuration settings or use your own. You use this installation type when you have an established Oracle WebLogic domain, and you want to extend it to the Oracle Business Intelligence application. This install option is typically used for more advanced deployments with multiple users, such as to scale out a deployment on additional computers.

• Question 54:

  When creating an initialization Block, which BI Administration function is used?

  A. Variable Manager
  B. Job Manager
  C. Identity Manager
  D. Projects Manager
  A. Variable Manager

  ---

  Open up the Administration tool, go to Manage then variables. See screenshot below.

  

  Then follow this picture to create a new Initialization Block.

  

  Name your Initialization block init_block_test.

  

• Question 55:

  How do you get the BI plug-in for MS Office?

  A. By contacting the administrator
  B. By downloading it from the BI Server
  C. By downloading it from the Database Server
  D. By downloading it from Microsoft Server
  B. By downloading it from the BI Server

  ---

  Download and installation of the client

  The client install executable is available for download from the More Products menu in Oracle BI Interactive Dashboards and Oracle BI Answers.

  See picture below.

  

• Question 56:

  Identify the correct mode to use when opening the web catalog while performing security settings modifications and migrations.

  A. Online
  B. Offline
  C. Managed
  D. UnManaged
  A. Online

  ---

  In online mode, you connect to a catalog on a running web server. In this mode your permissions are applied, you can select a locale, and you can see the effects of any localization on the catalog. You can see only those objects for which

  you have the appropriate permissions. Both Presentation Services and the web server must be running for you to open catalogs in online mode.

  Use online mode when you want to make minor incremental changes or additions to the catalog, such as changes to permissions, updates to a single object, or migration of new objects to a production environment.

  Note:

  *

  You can open a catalog in one of two modes -- online or offline. Both modes can operate against an actual production catalog, with no need for any downtime.

  *

  Repository changes can be done in either online or offline mode. Online mode is when BI Server is actively reading the repository file (when a user is logged in). Offline is when BI Server is idle. Best practice is to develop in Offline mode. Minor changes can be made when in online mode.

• Question 57:

  A customer has a requirement for rolling period calculations. What two additional steps will need to be done to enable this in the repository?

  A. Clicking the "Time" option in the Logical Dimension Dialog
  B. Designating a chronological key for every level of every dimension hierarchy
  C. Clicking the "Time" option in the Logical Table Source Dialog
  D. Designating a chronological key for every logical column in the Logical Table Source
  E. Specifying a sort order in the Logical Table dialog
  A. Clicking the "Time" option in the Logical Dimension Dialog
  B. Designating a chronological key for every level of every dimension hierarchy

  ---

  Creating Logical Time Dimensions

  Compared to modeling an ordinary dimension, the time dimension requires just two additional steps: selecting the Time option in the Logical Dimension dialog, and designating a chronological key for every level of every dimension hierarchy.

  Note: Time dimensions and chronological keys. You can identify a dimension as a time dimension. At least one level of a time dimension must have a chronological key. The following is a list of some guidelines you should use when setting up

  and using time dimensions:

  *

  At least one level of a time dimension must have a chronological key.

  *

  All time series measures using the AGO, TODATE, and PERIODROLLING functions must be on time levels. AGO, TODATE, and PERIODROLLING aggregates are created as derived logical columns. Reference: Oracle Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition. Working with Logical Dimensions

• Question 58:

  A customer wants to analyze the efficiency of his/her order fulfillment process. If the customer has a dimensional model, which option is the fact table?

  A. Stores
  B. Orders
  C. Products
  D. Time
  B. Orders

• Question 59:

  Identify the two types of storage for Essbase.

  A. Aggregate Storage Option and Block Storage Option
  B. Aggregate Storage and Cell Storage
  C. OLAP Storage and Cell Storage
  D. Aggregate Storage and Hybrid Columnar Compression
  A. Aggregate Storage Option and Block Storage Option

  ---

  Oracle Essbase developers creating planning and budgeting applications have been keenly aware of the advantages and disadvantages of the two different storage types available to them:

  *

  Block storage option (BSO) databases support a wide range of calculations, including forecasts, allocations, and aggregations through procedural calculation scripts. The results of these calculations can be written back to the database, but applications that use BSO storage are limited to about 10 dimensions and member counts in the low hundreds of thousands.

  *

  Aggregate storage option (ASO) databases can support about 20 dimensions and member counts in the millions. ASO databases use multidimensional functions rather than procedural scripts to perform calculations, but the results of queries cannot be stored back in the database, making ASO unsuitable for most financial management applications.

• Question 60:

  Which option describes how OBIEE Integrates with Planning?

  A. OBIEE primarily accesses Planning using standard Essbase integration techniques.
  B. OBIEE provides complete access to all Planning data through the Analytic Data Model (ADM) layer.
  C. Planning is not a supported OBIEE source.
  D. OBIEE integrates with Planning directly through relational database access.
  A. OBIEE primarily accesses Planning using standard Essbase integration techniques.
  B. OBIEE provides complete access to all Planning data through the Analytic Data Model (ADM) layer.

  ---

  A:

  *

  Combining Relational and OLAP Data Sources: Oracle's Common Enterprise Information Model allows users to combine data from a relational system and an OLAP source in a single calculation. For example, a user can compare sales

  forecasts from an Oracle CRM System with budget data from an Oracle Essbase planning application. To clients of the Common Enterprise Information Model, the forecast and budget data appear to be from the same logical source.

  *

  The Essbase server provides advanced multi-user read and write capabilities, including data update and multi-user recalculation. Business users with front-end tools can write data back to a server and recalculate the data on a server using

  calculation scripts--key functionality to support sophisticated modeling and planning applications.

  *

  Using aggregate storage, Essbase serves a wide range of analytic needs--financial analysis, planning, budgeting, sales analysis, marketing analysis, supply-chain analysis, and profitability analytics--all from a single analytic infrastructure.

  B:

  Note: The Analytic Data Model (ADM) is an API used to access OLAP data and metadata. ADM is similar to JDBC, providing a single common API that hides most differences between OLAP data sources.

  Note 2: Data model for business intelligence The most important component of business intelligence is the concept of 'data model'. data model determinde what kind of analysis that end user could do with the data. It is also an independant concept that could span across different vendor 's product.

  Unlike data model of the transaction system, the typical analytic data model is often denormalized and store extra data for analytic query and better query performance while transaction data model use is often normalized and optimized for a few data read and write, which is implemented by jointing many tables.

  The most common used analytic data model in business intelligence is call the 'Star schema' data model.

  With the Oracle business intelligence system, We could define star schema and dimension data model in the 'logical layer' in the admin tools. The data model in OBIEE could span different data source in physical layer, which means OBIEE have the capability of building one logical data model which is actually connect to different database in the backend