Free Oracle 1Z1-591 Practice Test & Real Exam Questions

Exam Code/Number: 1Z1-591
Exam Name/Title: Oracle Business Intelligence Foundation Suite 11g Essentials
Certification Provider: Oracle
Corresponding Certification: Java and Middleware

Exam Questions: 122
Updated On: Aug 03, 2026

Question #11

Which two components are required for all OBIEE installations?

A. Managed Server

B. Node Manager

C. RCU Schema

D. Admin Server

E. Oracle 11g

Discussion 0

Correct Answer: C,E Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #12

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

A. Presentation Data Layer

B. Master Data Layer

C. Staging Data Layer

D. Access and Performance Layer

Discussion 0

Correct Answer: A Vote an answer

Question #13

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

A. Parent/Child-based Hierarchies

B. Member Alias

C. Dynamic Time Series

D. Alternate Hierarchies

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #14

Which language is used by OBIEE to query Essbase?

A. SQL

B. DMX

C. MDX

D. LINQ

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #15

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______.

A. Multiple SQL queries are performed

B. No SQL queries are performed against the source tables

C. Two SQL queries are performed to get data from both tables

D. A single SQL query is performed to get data from both tables

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #16

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

A. The physical layer defines the objects and relationships that the Oracle BI Server needs to write native queries against each physical data source.

B. The model and mapping layer define the business or logical model of the data. This layer determines the analytic behavior seen by users.

C. The presentation layer defines the relationship that is needed to create the DML.

D. Separating the logical of the application from the physical model provides the ability to federate multiple physical sources to the same logical object.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #17

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

A. The lowest level of aggregation

B. Multiple levels of aggregation

C. The highest level of aggregation

D. Independently from aggregation level

Discussion 0

Correct Answer: A Vote an answer

Question #18

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

A. Normalization

B. Granularity

C. Redundancy

D. Cardinality

E. Denormalization

Discussion 0

Correct Answer: E Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #19

Initialization Blocks are never used to initialize which option?

A. Non System Session Variables

B. Dynamic Repository Variables

C. rpd file

D. System Session Variables

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #20

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

A. Start with a small model and then enhance the repository

B. Use an iterative approach

C. Do not use prototypes

D. Start with a big repository and trim it down with the requirements

Discussion 0

Correct Answer: A,B Vote an answer

Download Free Oracle 1Z1-591 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z1-591 exam.