1Z0-591 Oracle Business Intelligence (OBI) Foundation Suite 11g Essentials

Exam Title: Oracle Business Intelligence (OBI) Foundation Suite 11g Essentials
Exam Number: 1Z0-591
Exam Price: $245.00 More on exam pricing
Format: Multiple Choice
Duration: 120 minutes
Number of Questions: 75
Passing Score: 63%
Validated Against: This exam has been validated 11.1.1.5.

Take Recommended Training Courses

Complete one of the courses below to prepare for your exam (optional):
Oracle Business Intelligence Enterprise Edition Plus Implementation Boot Camp
Oracle Business Intelligence Foundation 11g Implementation Specialist
Oracle BI 11g R1: Build Repositories
Oracle BI 11g R1: Create Analyses and Dashboards

Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

Oracle BI and EPM System Overview
Describe how OBIEE addresses business intelligence challenges
Describe the Oracle Business Intelligence Enterprise Edition (OBIEE) products

Oracle BI Installation
Describe the Installation Architecture for OBI EE
Explain system requirements, supported platforms and installation pre-requisites
Install OBIEE

Dimensional Modeling
Describe the differences between Transactional and Analytical Systems
Describe Data Warehousing
Build Dimensions, Facts and Hierarchies
Explain Dimensional Modeling

Build Basic Repository
Define a System Data Source Name (DSN) for a data source
Build the Physical layer of the Repository
Build the Logical layer of the Repository
Build the Presentation layer of the repository

Complex Repository Modeling
Describe Derived Metrics and its use
Configure Derived Metrics based on existing logical columns
Configure Derived Metrics based on physical columns

Building a Repository with Multiple Sources
Add multiple sources to an existing logical table source for a dimension in the business model
Add a second table source to a dimension in the business model

Using Variables
Explain session variables
Describe repository variables
Describe initialization blocks
Implement a dynamic repository variable

Oracle Business Intelligence Enterprise Edition Security
Describe authentication and authorization
Describe the different levels at which security is enforced
Configure security using Security Manager
Configure Query Governing controls

MS Office Integration
Use MS Office Plug-In for OBI EE
Describe the required components to enable office integration
Install and configure MS office server and client for OBI EE

Write Back within OBI EE
Describe Write Back capabilities
Configure Write Back with OBI EE

OBI EE Architecture
Describe major components of the OBIEE architecture
Describe the function of each component

OBI EE User Interface Overview
Describe the components of OBI EE User Interface
Perform Oracle Analysis to construct, modify, and save BI requests
Build Dashboards
Create BI Delivers

Oracle BI Repository Overview
Describe the three layers of the OBI Repository
Use the Administration Tool to view and modify the repository

Repository Testing and Deployment
Describe techniques for testing a repository
Validate and test a repository

Advanced Repository Modeling
Create Data Partitioning
Create Segmentation of Data
Create Time Series Data

Hierarchies and Level Based Measures
Create a dimensional hierarchy
Use level-based measures
Create a rank measure
Describe Aggregate tables and the purpose they serve
Create Aggregate tables in the OBI repository

Implementation Methodology and Best Practices
Describe the implementation phases

Cache Management & Performance Tuning
Explain the purpose of cache in OBI EE
Configure caching and manage cache files
Develop caching strategies
Describe the request and data flow in OBI EE

Spatial Integration
Explain Spatial Intelligence and Integration
Add Map based visualization to OBI EE

Essbase Integration
Implement Essbase as a Data Source
Configure BI Server Metadata for Essbase
Explain Essbase Integration

---

QUESTION 1
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. The highest level of aggregation
C. Multiple levels of aggregation
D. Independently from aggregation level

Answer: B

Explanation: Aggegated by days.

---

QUESTION 2
The highest sales amount for this year is $10,000. If you create a rank measure for sales this year
and display it on a report, the value will be________.

A. $10,000
B. 0
C. 1
D. Year

Answer: C

Explanation: The rank measure is numbered from 1. The highest sales amount will be ranked 1.

---

QUESTION 3
Which two components are required for all OBIEE installations?

A. Admin Server
B. RCU Schema
C. Managed Server
D. Node Manager
E. Oracle 11g

Answer: B,E

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.

---

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

A. Changes to the repository can only be carried out in offline mode.
B. Multiple developers can work on one repository at the same time. Results can be merged later on.
C. All aspects of security are being held in the repository file.
D. Opening the rpd.filein online mode results in performance Issues for the application user.

Answer: B

Explanation: The Oracle BI repository development process adheres to the classic Software
Configuration Management (SCM)process, which utilizes a three-way merge to manage
concurrent development.
The merge process involves three repositories:
In a multiuser environment (MUDE), Developers check out the file and make changes locally.
Then, these changes are automatically reconciled and merged into the master repository.

---

QUESTION 5
Which installation option is used to install into an existing Fusion Middleware Home?

A. Software Only Install
B. Simple Install
C. EnterpriseInstall
D. Cannot installinto an existing Fusion Middleware Home

Answer: A

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.

Click here to view complete Q&A of 1Z0-591 exam
Certkingdom Review, Certkingdom PDF Torrents

Best Oracle 1Z0-591 Certification, Oracle 1Z0-591 Training at certkingdom.com