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 #1

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

A. Table

B. Stored Proc

C. Physical Table

D. View

E. Select

Discussion 0

Correct Answer: B,C,E Vote an answer

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

Question #2

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

A. The Repository

B. NQServer.ini File

C. NQSConfig.ini File

D. The Web Catalog

E. InstanceConfig.xml File

Discussion 0

Correct Answer: A,D Vote an answer

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

Question #3

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

A. Clicking the "Time" option in the Logical Table Source Dialog

B. Designating a chronological key for every logical column in the Logical Table Source

C. Designating a chronological key for every level of every dimension hierarchy

D. Specifying a sort order in the Logical Table dialog

E. Clicking the "Time" option in the Logical Dimension Dialog

Discussion 0

Correct Answer: C,E Vote an answer

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

Question #4

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 EduDump members. You can sign-up / login (it's free).

Question #5

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 highest level of aggregation

B. The lowest level of aggregation

C. Multiple levels of aggregation

D. Independently from aggregation level

Discussion 0

Correct Answer: B Vote an answer

Question #6

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?

A. It creates a new session variable.

B. It determines the actual value of the dimension.

C. It creates a foreign key relationship.

D. It defines the granularity of the dimension.

Discussion 0

Correct Answer: D Vote an answer

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

Question #7

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

A. Row Level Filters

B. Single Sign On

C. Server Password

D. Groups

Discussion 0

Correct Answer: D Vote an answer

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

Question #8

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

A. Job Manager

B. Variable Manager

C. Identity Manager

D. Projects Manager

Discussion 0

Correct Answer: B Vote an answer

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

Question #9

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

A. Application based data warehouses can be bought off the shelf and used without any tweaking.

B. Data warehouses can only be based on multidimensional data modeling.

C. The data in the data warehouse describes events and statuses of business processes, products and services, goals and organizational units, and generally mirrors every aspect of the structure and behavior of the organization.

D. Data warehouse projects are usually implemented within two weeks.

Discussion 0

Correct Answer: C 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.