[Sep 26, 2025] 1Z1-591 PDF Questions and Testing Engine With 122 Questions
Updated Exam Engine for 1Z1-591 Exam Free Demo & 365 Day Updates
Oracle Business Intelligence Foundation Suite 11g Essentials exam is ideal for professionals who want to demonstrate their expertise in implementing Oracle's BI solutions. Oracle Business Intelligence Foundation Suite is a comprehensive suite of enterprise BI products designed to deliver actionable insights and enable organizations to make better business decisions. The suite includes Oracle BI Analytics, Oracle BI Publisher, Oracle BI Mobile, and Oracle BI Server.
NEW QUESTION # 12
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?
- A. Quarter
- B. Month
- C. Year
- D. CurrentMonth
Answer: D
Explanation:
Explanation/Reference:
CurrentMonth can be calculated by a sql statement.
Note:
REPOSITORY VARIABLE(DYNAMIC)
Initialized when BI server is started
Assigned value dynamically based on the result of a query
Value is dependent of the sql provided in Initialization Block
Create a dynamic variable and provide a Name and Default Initializer.Create a new initialization block by clicking on the New button in the above screen.
Provide Intialization Block variable Name
Click on "Edit Data Source" button and provide the sql to be used for the variable, e.g.
select lower(sys_context('USERENV','SESSION_USER'))||
'@'||
lower(sys_context('USERENV','DB_NAME'))
from dual;
NEW QUESTION # 13
A user's BI Home page provides one-click access to which three options?
- A. Business model metadata
- B. Create new content
- C. Dashboard layout editor
- D. Oracle BI online documentation
- E. Catalog search functionality
Answer: B,D,E
Explanation:
Explanation
See BI Home Page screenshot below:
Note: The BI Home page contains the BI content catalog. Fusion Apps will use OBIEE web catalog to store all shipped reporting and analytics content.
From the BI home page users can browse and view the entire BI content. The BI catalog folder structure will match the Fusion Apps main menu structure. Folder structure would be content driven not technology driven which would enable ease of navigation for fusion Apps users.
Following content will be available under the BI catalog structure:
BI Publisher Reports (regardless of data source)
OTBI reports & dashboards
OBIA dashboards & scorecards
Financial Reporting
Also, users can do some additional actions from the BI Home page like: Access personal and shared reports, View/ edit BI publisher report schedules, Launch BI tools for advanced actions and create new reports with report wizard.
New reports created can be saved in BI catalog and added as embedded content within Fusion applications screens or links added to reporting pane. This enables users to extend the prebuilt embedded analytics within Fusion Applications.
NEW QUESTION # 14
Which two components are required for all OBIEE installations?
- A. RCU Schema
- B. Node Manager
- C. Managed Server
- D. Oracle 11g
- E. Admin Server
Answer: A,D
Explanation:
Explanation
B: Before you can run Oracle Business Intelligence 11g Installer, you must first create required Oracle Business Intelligence schemas in an unhardened database. You use a tool called the Repository Creation Utility (RCU) to create these schemas with the appropriate permissions and data.
E: The database 11gR2 is required if you want to run the Oracle Business Intelligence Enterprise Edition Plus Samples One Oracle Database Preinstalled and not hardened to host the schemas.
NEW QUESTION # 15
When creating an initialization Block, which BI Administration function is used?
- A. Identity Manager
- B. Projects Manager
- C. Job Manager
- D. Variable Manager
Answer: D
Explanation:
Explanation
Open up the Administration tool, go to Manage then variables.
See screenshot below.
variable manager
Then follow this picture to create a new Initialization Block.
create init block
Name your Initialization block init_block_test.
big picture
NEW QUESTION # 16
OBIEE 11g authentication of users is performed by which two components listed below?
- A. Repository file (rpd)
- B. BI Presentation Services
- C. Embedded WebLogic LDAP server
- D. External directories such as Active Directory using WebLogic and Fusion Middleware's Oracle Platform Security Services framework
Answer: A,C
Explanation:
Explanation/Reference:
A: Authentication at the Oracle Business Intelligence Enterprise Edition Layer The Oracle Product Lifecycle Analytics (Oracle PLA) application utilizes the Oracle Business Intelligence Enterprise Edition Layer (OBIEE) layer's platform authentication features.
You change the password for the PLMA.RPD repository file using the OBIEE Admin Tool.
B: LDAP Authentication
LDAP authentication is used as an alternative to storing user IDs and passwords in an Oracle BI repository.
You can set up the Oracle BI Server to take the user ID and password, and have it then pass the user ID and password to an LDAP server for authentication.
Reference: Oracle Product Lifecycle Analytics, Security Guide , Configuring and Using Authentication
NEW QUESTION # 17
Which component is responsible for determining the device that receives the alerts for a given user account?
- A. iBot
- B. Dashboard
- C. Delivery Profiles
- D. Alerts
Answer: C
Explanation:
--------
In an Ibor or Agent, in the 'Destinations' tab you can set the 'Specific Devices' However, it is a Device or Delivery Profile the one used for alerts, see this OBIEE guide:
---------------x--------------
User's Guide
http://download.oracle.com/docs/cd/E21764_01/bi.1111/e10544/toc.htm
http://download.oracle.com/docs/cd/E21764_01/bi.1111/e10544.pdf
page 218
What Are Devices and Delivery Profiles?
Devices and delivery profiles control how you will be reached when an alert is generated by an agent and which devices receive the content:
Device - A device is the medium used to deliver content to you. The content of an agent can be delivered to a range of devices as an e-mail or SMS message.
Delivery profile - A delivery profile specifies which devices to use to deliver content to you, based on the priority of the content. You can define several delivery profiles to meet your needs, and switch
---------------x--------------
NEW QUESTION # 18
When creating a Security Realm in the WebLogic Console, which object is created?
- A. Server Password
- B. Row Level Filters
- C. Single Sign On
- D. Groups
Answer: D
Explanation:
Explanation/Reference:
Security Realms are an Oracle Platform Security Services concept and bring together sets of users, groups, providers and so on for a WebLogic domain.
NEW QUESTION # 19
Which installation option is used to install into an existing Fusion Middleware Home?
- A. Cannot install into an existing Fusion Middleware Home
- B. Simple Install
- C. Enterprise Install
- D. Software Only Install
Answer: D
Explanation:
Explanation
The Software Only Install type installs the Oracle Business Intelligence software binary files in an Oracle home for later configuration as part of a Fusion Middleware deployment.
NEW QUESTION # 20
What are the two types of Repository Variables?
- A. Dynamic
- B. Static
- C. System
- D. Non System
Answer: A,B
Explanation:
Explanation
There are static and dynamic repository variables.
Note:
Variables in the Oracle BI Server can be either repository or session variables, and are defined using the Variable Manager within the Oracle BI Administrator (Manage > Variables).
Variable1
This brings up the Variable Manager, that divides variables out into repository and session variables, with a further subdivision into static and dynamic repository ones and system and non-system session ones. You can also define variables at the Presentation Server level, these are scoped to individual dashboards and are used amongst other things for setting dashboard prompt values and integrating the dashboard with BI Publisher parameters. Here's a screenshot of a typical Variable Manager screen.
Variable2
NEW QUESTION # 21
What must be done before you can run the Oracle Business Intelligence 11g Installer?
- A. Install the WLS Admin Server
- B. Ensure system meets installation requirements for Fusing Middleware, Oracle Business Intelligence, AND Repository Creation Utility
- C. Select installation components - OBIEE, BIP, RTD
- D. Create required Oracle Business Intelligence schemas in a database
- E. Obtain BI installation media
Answer: D
Explanation:
Before you can run Oracle Business Intelligence 11g Installer, you must first create required Oracle Business Intelligence schemas in an unhardened database. You use a tool called the Repository Creation Utility (RCU) to create these schemas with the appropriate permissions and data.
Reference: Installation Guide for Oracle Business Intelligence, Additional Oracle Business Intelligence 11g Installer Requirements
NEW QUESTION # 22
Which two options are included in Oracle BI Server cache management techniques?
- A. Inspecting the cache reports
- B. Maximum Number of Rows to Download to Excel
- C. Manage access to Subject Areas
- D. Using NQSConfig.ini to manually edit the parameters
- E. Scheduling Server password
Answer: A,D
Explanation:
A: Much of the configuration of OBI that used to be done in the NQSConfig.ini files can now be done using this front end console, which in turns updates the NQSConfig.ini file. Things in the NQSConfig.ini file that are set by EM are noted in the file with '# This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager'.Some thingsthat needs to be setup manually in the NQSConfig.ini file are:
1.Usage Tracking
2.Dynamic Libraries
3.Query Optimization Flags
4.MDX Member Name Cache Section (SAP BW)
5.More specific General Settings where EM doesn't contain the level of detail required
D: Cache Management Techniques include
Inspecting the cache reports
Configuring the cache parameters
Setting caching and cache persistence for tables
Using the Cache Manager
Inspecting SQL for cache entries
Modifying the Cache Manager column display
Purging the cache entries manually using the Cache Manager
Purging the cache entries automatically
Using event polling tables
Seeding the cache
NEW QUESTION # 23
Which option is used to enter the rank function when creating a new rank measure?
- A. Expression Builder
- B. Web Catalog
- C. Connection Pool
- D. Initialization Block
Answer: A
Explanation:
Example (see step 4 and 5 below): Getting Top-N Sales Reps for Year and Year-1
1.Under the "Business Model and Mapping" Layer, right click the "F1 Revenue" and select "New Object" -> "Logical Column..."
2.In the "Logical Column" Window give for Name: Year Ago Revenue as seen below:
3.Goto the "Column Source" Tab and select "Derived from existing columns using an expression" radio button then click on the "Edit Expression" icon.
4.Enter the following expression in the "Expression Builder" Window by selecting "Functions" in the "Category:" list, "Time Series Functions" in the "Functions:" list then "Ago" "Time Series Functions:" section.
5.Select the "<<Measure>>" in the "Ago( )" function, then select "Logical Tables" in the
"Category:" list, "F1 Revenue" in the "Logical Tables:" list, then double click the "Revenue" in the
"Columns:" list.
Etc.
NEW QUESTION # 24
When designing a Star Schema, which option does not apply?
- A. The fact has several foreign keys that are primary keys in the dimensional table
- B. Dimensional tables have one attribute primary key as Product_ID for products.
- C. Dimensional tables are normalized.
- D. The facts are quantifiable.
- E. Fact table is joined to the related dimensional tables.
Answer: C
Explanation:
In a Star Schema the dimensional tables does not need to be normalized.
A Snowflake Schema is a modified Star Schema that has normalized the dimensional tables.
NEW QUESTION # 25
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 transactional source systems are often normalized
- C. Because a single source table often contains all the dimensions needed
- D. Because transactional source systems are often denormalized
Answer: D
Explanation:
Denormalized data in the transactional system could be divided into different tables to increase performance.
NEW QUESTION # 26
Point-and-click generation of case statement logic can be accessed via which option?
- A. Column Formula -> Bins tab
- B. Subject Area metrics
- C. Column Properties -> Conditional Format tab
- D. Compound Layout
- E. Advanced Tab
Answer: A
Explanation:
Explanation
The "Edit Column Formula" dialog box has a second,
very tiny tab called, "Bins." You can use this tab to have OBIEE
build a CASE statement for you in a formula (you can also create
a CASE statement yourself by using one of the functions that
appears under "Expressions" if you want). A CASE statement is a
lot like an IF-THEN-ELSE statement, except that it's a little easier
to read when you have multiple options. Basically, it puts values
in different buckets that you define.
Note:
Figure:
NEW QUESTION # 27
Which of the following characteristics pertain to a "ragged" hierarchy?
- A. It can only be stored in an XML structure.
- B. It creates multiple levels of hierarchy in the databasetable.
- C. A branch of the hierarchy may have a different number of levels than other branches.
- D. All values can have a maximum of six levels.
Answer: C
Explanation:
Ragged Hierarchies are hierarchies where some routes down the hierarchy are longer than others; for example, you may have an organizational hierarchy for salespeople where the overall boss has two assistant managers, one of them works on their own and another has three sales managers under them; some of those sales manager may have sales staff under
them, and some sales staff may have trainees under them.
NEW QUESTION # 28
Which task can be performed after the Administrator link has been reached through logging into OBIEE?
- A. Associate map layers to columns
- B. Start or Stop BI Managed Servers
- C. SSO enablement
- D. Manage access to Subject Areas
Answer: B,C,D
Explanation:
Explanation/Reference:
B: BI Server Security Manager accessed through the BI Server Administration Tool.
* Set permission to business model, tables, columns and subject areas
* Specify filters to limit data accessible by users
* Set authentication options
C: Enable the SSO through the FMW Control.
D: You have three methods to start the managed server:
* with the console (recommended)
* with FMW control
* with the command line.
NEW QUESTION # 29
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 the same job can be performed by multiple employees. This situation would result in a many to-many relationship between the Employees and Jobs tables. How can the many to-many relationship issue be resolved?
- A. By modeling the many to many relationship in the business model
- B. By creating the many to many join in the physical model
- C. By creating a logical table source (LTS) that joins the Employees and Jobs tables
- D. By creating a bridge table that represents one employee doing one job, with several rows for an employee who has several jobs
Answer: D
Explanation:
Explanation/Reference:
When you need to model many-to-many relationships between dimension tables and fact tables, you can create a bridge table that resides between the fact and the dimension tables. A bridge table stores multiple records corresponding to that dimension. In the Administration Tool, General tab in the Logical Table dialog box contains a check box that you can select to specify that a table is a bridge table.
A bridge table allows you to resolve many-to-many data relationships.
Reference; OBI Server Administration Server Guide, Version 10.1, Identifying Bridge Tables
NEW QUESTION # 30
......
Exam Passing Guarantee 1Z1-591 Exam with Accurate Quastions: https://lead2pass.testvalid.com/1z1-591-valid-exam-test.html