Oracle Oracle Certifications 1Z0-591 Questions & Answers

• Question 51:

  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

  Correct Answer: A

  Explanation: 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 52:

  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

  Correct Answer: B

  Explanation: 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 53:

  There are two aggregate tables that are available for query. How would they be mapped into the logical data model so queries can use them?

  A. By creating two new logical tables sources

  B. By opening the two logical Table Source dialog boxes and mapping the appropriate levels in the Content tab

  C. Both A and B

  D. By creating one new Logical Table Source

  Correct Answer: B

  1. Configure the new source table to have the 'logical level' under the content set to 'Countries' (the summarized level)

  

  Explanation: B: Example:

  b

  2. Do the similiar setting for dimension table Now when user query the data at 'Counties' level, the query will be redirected to these summary table instead of the more detail fact table Note: Aggregate tables are Physical tables that store Aggregates of measures across multiple levels of a Hierarchy.

• Question 54:

  Which Oracle Partner is the supplier of map-based content to provide background maps, boundary information, and points of interest?

  A. Navteq

  B. TeleAtlas

  C. Google

  D. ESRI

  Correct Answer: A

• Question 55:

  The Consistency Checker checks______.

  A. The validity of objects outside the metadata using the connection

  B. Mappings to the physical objects

  C. For objects deleted from the database

  D. Syntax errors in derived logical columns

  Correct Answer: B

  Explanation: Consistency check is one of the process to check whether a repository is yielding proper results in Answer reports. It checks whether;* All logical columns are mapped correctly to physical columns (B).* All logical dimension tables have a logical key.* There are at least two logical tables in the business model; one is a logical fact table, the other is logical dimension table with join condition.* There are no circular logical join relationships.* A presentation catalog exists for the business model.

• Question 56:

  Which three options apply to FMW Application Roles?

  A. Provide an indirection between LDAP groups and BI roles

  B. Can be exported / moved between FMW11g environments

  C. Are created and managed by using the WLS Admin Console and FMW Control

  D. Can be created by using BI Administrator Client and "pushed" to WLS Admin Console

  E. Secures RPD permissions but NOT Web Catalog (webcat) permissions

  Correct Answer: ACE

  Explanation: A: The default Application Roles available after OBIEE 11g installation are BIAdministrator, BISystem, BIConsumer and BIAuthor.

  Note: In OBIEE 11g, Application roles provide insulation between permission definitions and corporate LDAP Groups. Permissions are defined at Application Role level and changes to LDAP groups just require a reassignment of the Group to the Application Roles.

  See figure below:

  

  C: Application Roles, Policies, association of Policies to application roles and association of users and groups to application roles are managed using Fusion Middleware Enterprise Manager (FMW EM).

  E: Object level permission association to Applications Roles resides in the RPD for repository objects. Permissions and Privilege for web catalog objects resides in the OBIEE Web Catalog. Wherever Groups were used in the web catalog and RPD has been replaced with Application roles in OBIEE 11g.

  Note: Application Roles are introduced in OBIEE 11g. An application role is specific to the application. They can be mapped to other application roles defined in the same application scope and also to enterprise users or groups, and they are used in authorization decisions.

• Question 57:

  Which of the following native features of Essbase are not supported in OBIEE 11g?

  A. Member Alias

  B. Alternate Hierarchies

  C. Dynamic Time Series

  D. Parent/Child-based Hierarchies

  Correct Answer: C

  Explanation: If you want to create a dynamic time-series reference such as the value of a measure as at this time last year, or over the past three months, or year-to-date, you can use one of the OBIEE time-series functions (AGO, PERIODROLLING, TODATE) to provide an offset value for a measure.

  Figure:

  

  Note: OBIEE 11g offered a bunch of improvements that were particularly aimed at Essbase, and other OLAP server, customers; the new hierarchical columns feature brought proper OLAP analysis to OBIEE, and coupled with OLAP-oriented

  features such as hierarchical prompts and selection steps, made OBIEE 11g a much more conducive environment for Essbase users.

  There's much better support for Essbase-native features such as value-based hierarchies, alternate hierarchies, multiple alias tables, UDAs and other Essbase artifacts, and the value-based hierarchy feature in particular is very welcome as it

  can avoid the need to completely re-import your Essbase database if your outline gains additional hierarchy levels.

  So coupled with the new and improved visualization capabilities in OBIEE 11g, including maps, scorecards, improved dashboard controls, the whole new UI, improved BI Publisher and so on, there's a lot to recommend OBIEE 11g to users of

  the "legacy" Hyperion tools looking for a bit of a refresh of their BI environment.

• Question 58:

  A customer would like to create a change and a % Change for Revenue at the same time. How would they accomplish this?

  A. Using the Expression Builder

  B. Using the Calculation Wizard

  C. Defining them in the physical data model

  D. Defining them in the Presentation Layer

  Correct Answer: B

  After creating your base metrics, try using the Calculation Wizard to automate the process of creating time-series metrics or comparison metrics such as: Change, Percent Change, Index, and Percent. The Wizard may save you many hours of time and frustration, especially if you have to create more than a handful of these metrics. In addition, the Wizard allows you to include customized logic to handle nulls in the base metrics. You may refer to the Oracle documentation for further detail.

• Question 59:

  When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard, which two statements are true?

  A. The analyst must first write DML (Data Manipulation Language) scripts to create the aggregate table.

  B. The Aggregate Persistence Wizard enables you to automate the creation of physical aggregate tables and their corresponding objects in the repository.

  C. Job Manager can be used to run the Aggregate Persistence script.

  D. The Extraction Transformation and Loading process creates the aggregate tables.

  Correct Answer: BC

  Explanation: B: The Aggregate Persistence Wizard automates the creation and initial population of aggregates, persists them in a back-end database and configures the BI Server metadata layer so that they're used when appropriate.

  C: The wizard then shows me a preview of the script it's going to generate, and asks me if I want to create any more summaries. Here's how the preview script looks ?note that it's not SQL, it's a script language that the BI Server understands and uses as the specification for an aggregation job, which it then turns into separate CREATE TABLE, INSERT ... SELECT and so on SQL statements, "optimized" for the particular back-end database platform.

  Script example:

  "ag_Items"

  for "Seminar - Complete"."Items"("Quantity")

  at levels ("Seminar - Complete"."Customerdim"."State", "Seminar - Complete"."Productdim"."Category", "Seminar - Complete"."Timedim"."Year") using connection pool "custdw"."CUSTDW_Pool"

  in "custdw".."CUSTDW";

• Question 60:

  If you have a database with four aggregate tables, how should the repository be configured to take advantage of the aggregates?

  A. By creating four new logical tables sources

  B. By creating four new logical table sources and choosing each dimension's level of aggregation in the Content tab

  C. By creating four new logical table sources and using the Fragmentation content to specify the aggregation levels

  D. By creating four new logical table sources and using the "where" section of the Content tab to specify the aggregation levels

  Correct Answer: B

  Explanation: Content Tab Aggregation Content You can define the aggregation (ie the group by) of: by hierarchy level

  by logical column It helps you to define an aggregate navigation

  

  Note: logical table source

  Logical table sources define the mappings from a single logical table to one or more physical tables. A logicaltable contains one or more logical table source. The mapping between physical columns and logical columns are done in this

  element. The definition of the logical table source is used:

  The Content tab of the Logical Table Source is used to define :