Updated Jan-2026 100% Cover Real 1Z1-591 Exam Questions – 100% Pass Guarantee [Q28-Q49]

5/5 - (1 vote)

Updated Jan-2026 100% Cover Real 1Z1-591 Exam Questions – 100% Pass Guarantee

Use Real Oracle Dumps – 100% Free 1Z1-591 Exam Dumps

QUESTION 28
You do not have a physical time table in your database but would like to use the time series functions that OBIEE offers. What two options do you have?

Create a physical time table in your database.

Create a Logical Table that is sourced from the time key in the fact table.

Create an “Opaque View” in the physical layer that contains the time columns from the fact and map it into your physical model.

Create a Logical Table that is sourced from a time field in one of your dimension tables.

Create a time table that is joined through a intervening Table so there is no foreign key relationship.

QUESTION 29
Which two steps are needed to set up Failover support for an OBIEE deployment?

Use Installer to affect Horizontal scale out of an existing instance

Employ WebLogic Enterprise Edition, licensed separately

Use Installer to set up separate single instances, then apply Horizontal scale out clustering

Apply OBIEE Clustering option

Leverage spare hardware capacity of single machine by using Vertical scale out option

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

Column Selector

Action Links

Conditional Formatting

Narrative View

Greenbar Styling

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

OLAP cubes eliminate the need for a large number of aggregate tables.

OLAP cubes are stored outside of the database in highly optimized file structures.

OLAP cubes can be easily transported from database to database.

OLAP cubes can be queried by using SQL.

QUESTION 32
Select the correct statement.

Cache provides fast and always up-to-date information.

Cache can increase traffic to back end database.

Cache needs to be purged to refresh data.

Cache can degrade query performance by reading data from the disk instead of the database.

Cache is seeded by manually running PL/SQL at the back end database.

QUESTION 33
Security Manager is used for______.

Setting permissions for particular users or application roles

Setting permissions for individual objects in the Presentation Layer

Setting up new Roles and Groups

Setting up new Application Roles

QUESTION 34
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. What kind of partition is being used?

Fact-based

Time-based

Mixed

Complex

QUESTION 35
One of the most common uses of Dynamic Repository Variables is to setup filters for use in reporting. Which variable below is a valid example of a Dynamic Repository Variable?

Year

Month

Quarter

CurrentMonth

QUESTION 36
One of the initial phases in OBIEE implementation is the Discovery phase where the project team focuses on a few activities. Which option is not one of them?

Business Requirements Definition

Technical Requirements Definition

Data Quality Assessment

Dashboard Testing

QUESTION 37
The WebLogic Console will allow you to perform which of the following functions in the BI Managed Server?

Start and Stop BI Services

Build Aggregate Queries

Create Summary Tables

Manage user logins

QUESTION 38
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?

Whether the logical table source for this column has been disabled

Whether the columns creating CREATE_DT have been deleted

Whether there is a logical join between the DIM and FACT tables

Whether there is a physical join between the DIM and FACT tables

Whether there is a physical column mapped to the logical column

DIM_Offer_End_Date.CREATE_DT

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

By creating a derived measure by using the Logical Columns available

By creating a derived measure in the Column Mapping dialog box by using the physical table columns.

By creating a derived measure by using Logic Columns available and changing the aggregation type

By creating a derived metric by using the Expression Builder

By creating a derived metric by using the Calculation Wizard

QUESTION 40
Where is Oracle Mapviewer installed?

In the same domain as OBIEE on the web application server

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

On the Database server

On its own application server

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

Add an additional column to the dimension table to capture a version of change

Overwrite an existing dimension table record with the changed record

Add a new row to the dimension table with a new key for the changed record

Do Nothing

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

By creating Presentation Folder calledTime and then two subsequent folders called-> Fiscal Calendar and-> Julian Calendar

By creating aPresentationFolder called ->Timecalledthen two subsequent folders calledFiscal Calendar and Julian Calendar

By creatingaPresentation Foldercalled -Time and then two subsequent folders called + FiscalCalendar and+Julian Calendar

Bycreating a Presentation Foldercalled Time and thentwo subsequent folders called Fiscal Calendar and Julian Calendar

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

Groups

Row Level Filters

Server Password

Single Sign On

QUESTION 44
The administration tool is the developer’s interface to the repository file. It allows the development of and changes to the metadata repository file. Which statement is true?

Changes to the repository can only be carried out in offline mode.

Multiple developers can work on one repository at the same time.Results can be merged later on.

All aspects of security are being held in the repository file.

Opening the rpd.filein online mode results in performance Issues for the application user.

QUESTION 45
One of the most common uses of Dynamic Repository Variables is to setup filters for use in reporting. Which variable below is a valid example of a Dynamic Repository Variable?

CurrentMonth

Quarter

Year

Month

QUESTION 46
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. What kind of partition is being used?

Fact-based

Time-based

Mixed

Complex

QUESTION 47
A customer would like to create a change and a % Change for Revenue at the same time. How would they accomplish this?

Using the Expression Builder

Using the Calculation Wizard

Defining them in the physical data model

Defining them in the Presentation Layer

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

Clicking the “Time” option in the Logical Dimension Dialog

Designating a chronological key for every level of every dimension hierarchy

Clicking the “Time” option in the Logical Table Source Dialog

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

Specifying a sort order in the Logical Table dialog

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

Add an additional column to the dimension table to capture a version of change

Overwrite an existing dimension table record with the changed record

Add a new row to the dimension table with a new key for the changed record

Do Nothing