1Z0-591 Exam Questions

Which three options apply to FMW Application Roles?

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

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?

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

The Consistency Checker checks______.

A company's Database Administrator has divided the region table into two tables so that the region "West" is in one table and all the other regions are in another single table. Wha...

What is the process in which there is redundancy of data to improve performance?

An organization has re-implemented one of its systems but has not moved history. One database has data for all years up to 2010 and the other has data for years from 2011 to the pr...

When creating a Security Realm in the WebLogic Console, which object is created?

Select the correct statement.

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

When creating a query. Subject areas can be combined via point and click as long as____.

Pre Deployment sign-off is a milestone for a OBIEE implementation and is based on successful completion of certain tasks. Which option is not one of them?

How will you model a Type II Slowly-Changing Dimension?

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

Identify the two types of storage for Essbase.

Which resource identifies the OBIEE Web Catalog (webcat)?

The ODBC DSN is never used for _______.

Identify the reason why Oracle OLAP provides a favorable aggregation strategy.

When Exporting an Analysis from a Dashboard, which of the following is NOT an option?

What must be purchased when integrating Oracle map with Oracle BI?

Data is stored in facts and dimensions _________

Initialization Blocks are never used to initialize which option?

In which Oracle-recommended implementation stage would you gather business requirements?

In the Oracle Data Warehouse Reference Architecture, which term is not a layer in the data warehouse?

Which two options are valid Repository Variable names?

When designing a Star Schema, which option does not apply?

Which of the following is NOT true of consistency check?

Which two of the following are not recommended when working with the catalog manager?

Which of the following NEVER uses initialization blocks to initialize its values?

Which two of the following variables persist only while a user's session is active?