Updated Nov-2025 Exam Engine or PDF for the 1Z1-591 Tests Free Updated Today!
Ultimate Guide to Prepare 1Z1-591 with Accurate PDF Questions
To prepare for the Oracle 1z0-591 certification exam, candidates can attend Oracle University training courses or use self-study materials such as books, online courses, and practice exams. Candidates should also have hands-on experience working with the Oracle Business Intelligence Foundation Suite 11g to gain a deeper understanding of the software and to prepare for the exam.
NEW QUESTION # 21
There is a logical fact table that contains Item number, store, time, and revenue. How would you add Number of items sold?
- A. By creating a derived measure on the logical column item number and usingthe count distinct function
- B. By creating a derived measure on the logical columnItem number and using the count Function
- C. By creating a derived measure based on the physical column item number and changing theaggregation method to count
- D. By creatinga derived metric by using the Expression Builder
Answer: C
Explanation:
A measure column is a column unlike the baseline column that has a default
aggregation rule defined in the Aggregation tab of the Logical Column dialog in the repository.
Measure columns always calculate the aggregation with which they are defined.
Measures need to be defined in a logical fact. Any column with an aggregation rule is a measure.
http://gerardnico.com/wiki/_media/dat/obiee/bi_server/design/obiee_measure_column.jpg
NEW QUESTION # 22
Which of the following native features of Essbase are not supported in OBIEE 11g?
- A. Member Alias
- B. Dynamic Time Series
- C. Parent/Child-based Hierarchies
- D. Alternate Hierarchies
Answer: B
Explanation:
If you want to create a dynamic time-series reference such as the value of a measure as at this time last year, or over the past three months, or year-to-date, you can use one of the OBIEE time-series functions (AGO, PERIODROLLING, TODATE) to provide an offset value for a measure.
Figure:
Sshot 30
Note: OBIEE 11g offered a bunch of improvements that were particularly aimed at Essbase, and
other OLAP server, customers; the new hierarchical columns feature brought proper OLAP
analysis to OBIEE, and coupled with OLAP-oriented features such as hierarchical prompts and
selection steps, made OBIEE 11g a much more conducive environment for Essbase users.
There's much better support for Essbase-native features such as value-based hierarchies,
alternate hierarchies, multiple alias tables, UDAs and other Essbase artifacts, and the value-based
hierarchy feature in particular is very welcome as it can avoid the need to completely re-import
your Essbase database if your outline gains additional hierarchy levels.
So coupled with the new and improved visualization capabilities in OBIEE 11g, including maps,
scorecards, improved dashboard controls, the whole new UI, improved BI Publisher and so on,
there's a lot to recommend OBIEE 11g to users of the "legacy" Hyperion tools looking for a bit of a
refresh of their BI environment.
NEW QUESTION # 23
Which option describes how OBIEE natively integrates with HFM?
- A. OBIEE does not support HFM integration
- B. Through EPM Analytic Data Model (ADM) connectivity
- C. Direct relational database access
- D. Through Essbase connectivity
Answer: B
Explanation:
BI EE uses the ADM driver to extract the data from HFM.
Note: HFM (Hyperion Financial Management)
Example:
I EE connects to HFM through JavaHost. So, the setup for configuring the connectivity is to
basically make the EPM environment variables available for access to BI EE. Before making the
changes, there are a couple of things to be aware of
1.Ensure that DCOM is enabled on the BI Server machine. This is needed for HFM client to work/connect properly with HFM Server.
2.Ensure that HFM Client is installed.
The above assumes EPM 11.1.2.x version. If you are on Hyperion 9.3.3, then you need to have the ADM drivers installed manually. All of this is documented clearly. So, rather than re-iterating that i will just point to the link here. Ensure that you follow all the steps mentioned in the docs else you will have issues in the connectivity. Once all the pre-requisite steps are done, we start off with the metadata import process.
NEW QUESTION # 24
A customer needs to have a calculation done prior to aggregating the data. How would you accomplish this?
- A. By creating a derived metric by using the Calculation Wizard
- B. By creating a derived metric by using the Expression Builder
- C. By creating a derived measure by using the Logical Columns available
- D. By creating a derived measure by using Logic Columns available and changing the aggregation type
- E. By creating a derived measure in the Column Mapping dialog box by using the physical table columns.
Answer: E
Explanation:
Explanation/Reference:
Note 1: OBIEE offers two calculation types for measure in the repository:
logical
physical
You can define calculations in either of the following ways:
* Before the aggregation, in the logical table source.
* After the aggregation, in a logical column derived from two other logical columns. For example: sum(col A) * sum(col B)
Note 2: A measure column is a column unlike the baseline column that has a default aggregation rule defined in the Aggregation tab of the Logical Column dialog in the repository.
Measure columns always calculate the aggregation with which they are defined.
Measures need to be defined in a logical fact. Any column with an aggregation rule is a measure.
NEW QUESTION # 25
Pre Deployment sign-off is a milestone for a OBIEE implementation and is based on successful completion of certain tasks. Which option is not one of them?
- A. System Testing
- B. Performance Tuning
- C. Test Environment
- D. Data Validation / Verification
- E. Projectinitiation and resourcing
Answer: E
NEW QUESTION # 26
The Oracle BI office plug-in allows you to import the results of an OBI request into which two MS applications?
- A. MS Visio
- B. MS Word
- C. MS Excel
- D. MS Project
Answer: B,C
Explanation:
Explanation/Reference:
Oracle Business Intelligence Office Plug-In is a Windows application that is an optional feature under the Oracle Business Intelligence Presentation Services. The Plug-In provides a way to browse the Analytics catalog, select a report, and then drop that report into Microsoft Word or Excel.
Reference: Oracle Business Intelligence Infrastructure Installation and Configuration Guide > Installing Individual Oracle BI Components >Installing Oracle BI Office Plug-In
NEW QUESTION # 27
How do you get the BI plug-in for MS Office?
- A. By downloading it from Microsoft Server
- B. By downloading it from the BI Server
- C. By downloading it from the Database Server
- D. By contacting the administrator
Answer: B
Explanation:
Download and installation of the client
The client install executable is available for download from the More Products menu in Oracle BI Interactive Dashboards and Oracle BI Answers.
See picture below.
NEW QUESTION # 28
What would you use to customize the text elements that appear on BI Analysis, Delivers and Dashboard pages?
- A. XML Message Files
- B. Cascading Style Sheets
- C. BI Presentation services web template
- D. DHML Message files
Answer: B
Explanation:
You can control the way that the interface for Oracle BI EE is displayed to users by creating skins and styles.
While skins and styles are typically used to customize the look and feel of analyses and dashboards by providing logos, color schemes, fonts, table borders, and other elements, they can also be used to control the position and justification of various elements by including specialized style tags in the relevant style sheet (.
css) file.
You can check the directory skin location with a right click on a OBIEE dashboard page, select show source code and search "custom.css".
NEW QUESTION # 29
When creating a query. Subject areas can be combined via point and click as long as____.
- A. the subject areas share objects of the same name
- B. the subject areas both share the same model in the business model and mapping layer
- C. two or more subject areas cannot be joined together without manually mapping the contents
- D. the subject areas are both from the same physical source, though they may be in separate business layers
Answer: B
Explanation:
Explanation
Users in Oracle BI Answers can create queries that span multiple subject areas, as long as the subject areas correspond to the same business model.
NEW QUESTION # 30
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?
- A. Mixed
- B. Complex
- C. Fact-based
- D. Time-based
Answer: B
Explanation:
You have three sort of fragmentation:
Fact-based / Dimension-based fragmentation
Content-based / Value-based fragmentation
Level-based fragmentation / aggregate navigation
You can combine the techniques above to construct powerful design that are known as Complex
partitioning / fragmentation. When you fragment a dimension, you are automatically in a complex
fragmentation.
NEW QUESTION # 31
Where is Cache in OBIEE located?
- A. In relational database
- B. In memory cache
- C. It is local disk-based.
- D. In dynamic aggregate
Answer: C
Explanation:
Explanation
In OBIEE cache will be stored as files on the Hard Disk of the OBIEE Server in the form of files.
NEW QUESTION # 32
Selecting the Manage Map Data link allows one to do which three of the following?
- A. Associate map layers to columns defined in the OBIEE metadata
- B. Create a new map layer
- C. Set the zoom level of an imported map
- D. Import images for use on maps
Answer: A,C,D
Explanation:
The Oracle BI Presentation Services Administration page provides the Manage Map Data link. This link displays the Manage Map Data page, where you can manage the logical and display versions of the data from various physical data sources. This defines the layers that content designers use when creating map views. The data that is available for managing maps and data is stored in Oracle Database as part of MapViewer.
Using this page, you provide:
*(A) Logical names to prevent any existing BI column mappings and map analyses from breaking because of changes to the physical data or to the data source.
*Display names so that the geographic data is meaningful to end users.
Note: Administering Maps Using Administration Pages
For (C) -layers, see 3-7 below.
For (D) -import images, see 11-12 below.
To administer maps using Administration pages:
Click OK when you have finished selecting layers that are appropriate for the subject area with
which you are working.
Click OK when you have finished editing the layer.
You use this tab to associate layers with BI data. If you use the City column in multiple subject
areas, then you must associate it with a layer for each subject area.
The connection that you select for the main map can be different from the connection for the
layers or images.
Click OK when you have finished selecting main maps.
Click OK when you have finished editing the map.
Click OK when you have finished selecting images.
Reference: Oracle Fusion Middleware System Administrator's Guide for Oracle Business
Intelligence Enterprise Edition, Configuring Mapping and Spatial Information
NEW QUESTION # 33
A customer needs to have a calculation done prior to aggregating the data. How would you accomplish this?
- A. By creating a derived measure in the Column Mapping dialog box byusing the physical tablecolumns.
- B. By creating a derived metricby using the Expression Builder
- C. By creating a derived measure by using the Logical Columns available
- D. By creating a derived measure by using LogicColumnsavailable andchanging theaggregationtype
- E. By creatinga derived metricby using the Calculation Wizard
Answer: D
Explanation:
Note1: OBIEE offers two calculation types for measure in the repository:
logical
physical
You can define calculations in either of the following ways:
*Before the aggregation, in the logical table source.
*After the aggregation, in a logical column derived from two other logical columns. For example: sum(col A) * sum(col B)
Note 2:A measure column is a column unlike the baseline column that has a default aggregation
rule defined in the Aggregation tab of the Logical Column dialog in the repository.
Measure columns always calculate the aggregation with which they are defined.
Measures need to be defined in a logical fact. Any column with an aggregation rule is a measure.
http://gerardnico.com/wiki/_media/dat/obiee/bi_server/design/obiee_measure_column.jpg
NEW QUESTION # 34
Use of the Enterprise Install option is recommended for which three options?
- A. Scale out for High Availability and Failover
- B. Multiple instances on a single computer
- C. Evaluation of end user functionality
- D. Single users working on a single computer
- E. Support for high security requirements
Answer: A,B,E
Explanation:
Explanation/Reference:
Enterprise Install: This installation type assumes some familiarity with Oracle Business Intelligence. All software components are downloaded onto one computer. You can accept the default configuration settings or use your own. You use this installation type when you have an established Oracle WebLogic domain, and you want to extend it to the Oracle Business Intelligence application. This install option is typically used for more advanced deployments with multiple users, such as to scale out a deployment on additional computers.
Incorrect answers:
D, E: Simple Install
The default selection. All software components are downloaded onto one computer and configured with default settings. Oracle Business Intelligence runs after the installation is completed. This install option is typically used for a single user deployment, such as for demonstration or development purposes.
NEW QUESTION # 35
Oracle BI Server at a company is connected to Data Warehouse that is refreshed on a daily basis, the majority of users at the company log in to Oracle BI every Monday to generate the previous week's sales report. The BI Administrator schedules cache purge and cache seeding to improve
report response times. How is this accomplished?
- A. Every day after Data Warehouse refresh
- B. Everyday before Data Warehouse refresh
- C. Every Monday late night
- D. Every Monday early morning
Answer: C
Explanation:
Purge and reseed once a week after the reports have run to improve report response time.
NEW QUESTION # 36
The WebLogic Console will allow you to perform which of the following functions in the BI Managed Server?
- A. Manage user logins
- B. Build Aggregate Queries
- C. Start and Stop BI Services
- D. Create Summary Tables
Answer: C
Explanation:
Screenshot below.
NEW QUESTION # 37
......
How to study the 1Z0-591 Exam
There are two main types of resources for preparation of certification exams first there are the study guides and the books that are detailed and suitable for building knowledge from ground up then there are video tutorial and lectures that can somehow ease the pain of through study and are comparatively less boring for some candidates yet these demand time and concentration from the learner. Smart Candidates who want to build a solid foundation in all exam topics and related technologies usually combine video lectures with study guides to reap the benefits of both but there is one crucial preparation tool as often overlooked by most candidates the practice exams. Practice exams are built to make students comfortable with the real exam environment. Statistics have shown that most students fail not due to that preparation but due to exam anxiety the fear of the unknown. TroytecDumps expert team recommends you to prepare some notes on these topics along with it don't forget to practice Oracle 1Z0-591 exam dumps which have been written by our expert team, Both these will help you a lot to clear this exam with good marks.
Pass Oracle With TroytecDumps Exam Dumps: https://www.troytecdumps.com/1z1-591-troytec-exam-dumps.html
Fully Updated 1Z1-591 Dumps - 100% Same Q&A In Your Real Exam: https://drive.google.com/open?id=1PqdNdEN02q0oo8jjZmxh1S7No6QZwGJW