1Z0-591 Exam Questions

An integrated BI tools business case can be built around which three options?

Object Security controls access to Subject Areas, Tables, and Columns in OBIEE and can be implemented by using which method?

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

Which two steps are needed to set up Failover support for an OBIEE deployment?

When a customer wants to get sales numbers by day, how is data stored in the Star Schema, if the data is loaded nightly?

The highest sales amount for this year is $10,000. If you create a rank measure for sales this year and display it on a report, the value will be________.

Which two components are required for all OBIEE installations?

The administration tool is the developer's interface to the repository file. It allows the development of and changes to the metadata repository file. Which statement is true?

Which installation option is used to install into an existing Fusion Middleware Home?

What are the two methodologies that are followed within an OBIEE implementation?

Which option describes how OBIEE Integrates with Planning?

Which option is used to enter the rank function when creating a new rank measure?

Query limits tab can be accessed through________.

What is an example of a Session Variable?

One of the most common uses of Dynamic Repository Variables is to setup filters for use in reporting. Which variable below is a valid example of a Dynamic Repository Variable?

WLS Embedded LDAP Server is managed by the Admin Server Console and supports which three options?

Point-and-click generation of case statement logic can be accessed via which option?

Which task can be performed after the Administrator link has been reached through logging into OBIEE?

What are the two leading design solutions recommended by Oracle that you would use for performance?

The WebLogic Repository Schema generated via RCU can be deployed to which three DBMS?

There is a logical fact table that contains Item number, store, time, and revenue. How would you add Number of items sold?

Which language is used by OBIEE to query Essbase?

Which are the three types of tables available to physical tables in the physical layer?

Which option describes how OBIEE natively integrates with HFM?

Select the scenario in which block storage must be used instead of aggregate storage.

What would you use to customize the text elements that appear on BI Analysis, Delivers and Dashboard pages?

Which two of the following could be the disadvantages of implementing query caching?

Row-wise initialization is enabled to initialize_________

One benefit of adding a second table source that is joined to the first table source in the Physical Layer by a foreign key relationship is that______.

Why is it necessary to join multiple source tables to a single dimension?

Query Limits are used to manage Query environment in the repository for users and roles and can_________.

A derived measure is never used to_________.

What are the two types of Session Variables?

Content that is saved in personal and shared folders can be browsed by using which view?

Identify the two Object level security functions that are done on the repository by using the BI Admin tool.

OBIEE 11g authentication of users is performed by which two components listed below?

One of the initial phases in OBIEE implementation is the Discovery phase where the project team focuses on a few activities. Which option is not one of them?

Identify the two true statements about alias tables.

DSNs are set up for access to which data sources?

Identity the three advantages of the BI Server metadata repository.

You do not have a physical time table in your database but would like to use the time series functions that OBIEE offers. What two options do you have?

The WebLogic Console will allow you to perform which of the following functions in the BI Managed Server?

A customer frequently queries multiple dimension tables without a measure. What needs to be defined in the presentation layer?

A customer needs to do a cross database join between two tables where, one of the tables has a small number of values and the other has a large number of values. How can you optimi...

The Time Dimension hierarchy is a good example of a__________.

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

You would like to customize the text elements that appear in BI answer, BI delivers, and on dashboard pages. Which of the following would you use?

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

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

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