1Z0-591 Exam Questions

Which three techniques are applied to support Failover?

The Oracle BI office plug-in allows you to import the results of an OBI request into which two MS applications?

A user's BI Home page provides one-click access to which three options?

A customer needs to have a calculation done prior to aggregating the data. How would you accomplish this?

Which of the following characteristics pertain to a "ragged" hierarchy?

Where is Cache in OBIEE located?

A customer always wants Aggregate Table l to be looked at first to see if it can answer the query. What should be done to make sure this happens?

Which OBIEE capability enables developers to build Aggregate tables?

When creating a new dimensional hierarchy in the BI Administration tool, right click the dimension, then select "New Object" What must be selected next?

What are the two types of Repository Variables?

Under what circumstances would you model within the BI environment to include transactional data directly?

What are the two capabilities that users can apply to an Analysis when working within Plug-In for MS Office?

Which three components are part of a cluster server?

If Security attributes conflict, what happens?

How do Dynamic Repository Variables differ from Static Repository Variables?

The three metadata layers are an important concept of the BI Server. Which statement is incorrect?

Which two options are included in Oracle BI Server cache management techniques?

To add multiple sources to on existing logical table dimension in the Business Model and Mapping layer, the source of the data must first exist in which option?

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?

What is the first step when creating an Aggregate table in the OBI repository?

When adding a new dimension to an existing logical table, what is the significance of the Logical Level setting in the Logical Table Source properties?

Where is Oracle Mapviewer installed?

Which component is responsible for determining the device that receives the alerts for a given user account?

What are the two disadvantages of implementing Query Caching?

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

Derived metrics are_____.

Which variable does not use initialization blocks to initialize its values?

An organization has its employees' names in an Employees table, and information about their jobs in a Jobs table. However, an organization's employees can have multiple jobs, and t...

Oracle BI Server at a company is connected to Data Warehouse that is refreshed on a daily basis, the majority of users at the company log in to Oracle BI every Monday to generate t...

Oracle BI Server cache setup information is configured by using Enterprise Manager Fusion Middleware control. Which component stores the configuration Information?

What must be done before you can run the Oracle Business Intelligence 11g Installer?

Security Manager is used for______.

Which option does not describe Aggregate tables?

Which configuration can be changed through Enterprise Manager?

Which two Oracle BI Components contain security information regarding permissions and privileges?

A customer needs to create a product share calculation. What are the two ways that they would get the revenue for all products to use in the denominator?

Which analysis features could be applied to provide interactive controls for end users? (Choose Two)

An organization would like to see a Time folder with subfolders for its Fiscal and Julian calendars. How would you accomplish this?

If a customer is planning on building a data warehouse, how would you describe data warehousing to the customer?

OBIEE default security model stores security Information such as user names and password combinations for accessing an external system such as Active Directory. It is stored in the...

Which two of the following object-level security configurations are NOT done in the BI Administration Tool?

Which of the following tasks can you perform in the catalog manager?

The customer is questioning the necessity to have a data warehouse in place. They want to run OBIEE against various transactional systems. Identify the two limitations.

Permissions for Presentation layer objects and Business layer objects that restrict users is configured in which software component?

You run the Consistency Check and receive the warning: [39003] Missing functional dependency association for column: DIM_Offer_End_Date.CREATE_DT. What would you check?

How do System Session Variables obtain their values?

Selecting the Manage Map Data link allows one to do which three of the following?

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

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

What are the two ways to use the administration tool?