Oracle 1z0-591 Actual Free Exam Questions & Community Discussion

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

Exam Questions: 122
Updated On: Oct 03, 2026

Question #10

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

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

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

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

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: B Vote an answer

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

Question #11

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

A. decrease query response time

B. eliminate Write Back Capabilities

C. create Aggregate tables

D. improve Analysis data quality

E. improve performance of Dashboards and Analysis

Discussion 0

Correct Answer: A,E Vote an answer

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

Question #12

Which option does not describe Aggregate tables?

A. Aggregate tables are created and stored on the BI Server.

B. Aggregate tables typically have fewer rows than the non aggregate tables and, therefore, processing should be quicker.

C. Aggregate tables increase query performance by pre-calculating frequently accessed measure aggregations.

D. Aggregate tables relieve bottlenecks and pre-calculate and store the data for better query response.

Discussion 0

Correct Answer: A Vote an answer

Question #13

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

A. Because the dimensions tables are built in the transactional systems

B. Because a single source table often contains all the dimensions needed

C. Because transactional source systems are often denormalized

D. Because transactional source systems are often normalized

Discussion 0

Correct Answer: D Vote an answer

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

Question #14

Which OBIEE capability enables developers to build Aggregate tables?

A. Expression Builder

B. Aggregate Persistence Wizard

C. Table Builder

D. Query Analyzer

Discussion 0

Correct Answer: B Vote an answer

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

Question #15

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

A. Delivery Profiles

B. Dashboard

C. iBot

D. Alerts

Discussion 0

Correct Answer: A Vote an answer

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

Question #16

Where is Oracle Mapviewer installed?

A. Never on the same domain as OBIEE on the web application server

B. On its own application server

C. In the same domain as OBIEE on the web application server

D. On the Database server

Discussion 0

Correct Answer: C Vote an answer

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

Question #17

Security Manager is used for______.

A. Setting permissions for individual objects in the Presentation Layer

B. Setting permissions for particular users or application roles

C. Setting up new Roles and Groups

D. Setting up new Application Roles

Discussion 0

Correct Answer: B Vote an answer

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

Question #18

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

A. MS Project

B. MS Visio

C. MS Excel

D. MS Word

Discussion 0

Correct Answer: C,D Vote an answer

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

Download Free Oracle 1z0-591 Demo

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