Java and Middleware 1Z0-591 easy pass guidance: Preparing for Oracle Java and Middleware 1Z0-591 exam is really a tough task to achieve. However, CertBus provides the most comprehensive PDF and VCEs, covering each knowledge points required in the actual 1Z0-591 exam.
We CertBus has our own expert team. They selected and published the latest 1Z0-591 preparation materials from Oracle Official Exam-Center: http://www.certgod.com/1Z0-591.html
QUESTION NO:75
When creating a new dimensional hierarchy in the BI Administration tool, right click the
dimension, then select “New Object” What must be selected next?
A. Logical Key
B. Parent Level
C. Child Level
D. Dynamic Key
Answer: B
Explanation: Steps to Create a Dimension Hierarchy – >Create a dimension object.Add a
parent-level object.Add child-level objects.Determine number of elements.Specify level
columns.Create level keys.Create a level-based measure.Create additional level-based
measures.Create share measures.Create rank measures.Add measures to Presentation
layer.Test share and rank measures.
QUESTION NO:39
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 Dimension Dialog
B. Designating a chronological key for every level of every dimension hierarchy
C. Clicking the “Time” option in the Logical Table Source Dialog
D. Designating a chronological key for every logical column in the Logical Table Source
E. Specifying a sort order in the Logical Table dialog
Answer: A,B
Explanation: Creating Logical Time Dimensions
Compared to modeling an ordinary dimension, the time dimension requires just two
additional steps: selecting the Time option in the Logical Dimension dialog, and designating
a chronological key for every level of every dimension hierarchy.
Note: Time dimensions and chronological keys. You can identify a dimension as a time
dimension. At least one level of a time dimension must have a chronological key. The
following is a list of some guidelines you should use when setting up and using time
dimensions:
* At least one level of a time dimension must have a chronological key.
* All time series measures using the AGO, TODATE, and PERIODROLLING functions
must be on time levels. AGO, TODATE, and PERIODROLLING aggregates are created as
derived logical columns.
Reference: Oracle Fusion Middleware Metadata Repository Builder\’s Guide for Oracle
Business Intelligence Enterprise Edition. Working with Logical Dimensions
QUESTION NO: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 NO:79
Which three components are part of a cluster server?
A. Master Server
B. Repository Publishing Directory
C. Primary Cluster Controller
D. Web Server
E. Server request Controller
Answer: A,C,D
Explanation: Oracle BI Cluster Server Components
* Oracle Business Intelligence Cluster Controller: The Cluster Controller determines which
BI Server works in the cluster. It monitors the operation of servers in the cluster. The
Cluster Controller is deployed in active-passive mode.
* Clustered BI Servers: The BI Cluster Server feature supports up to 16 BI Servers in a
network domain to act as a single server. BI Servers in the cluster share requests from
multiple Oracle BI clients.
* Master BI Server: A clustered Oracle Business Intelligence Server is designated as the
Master BI Server. The Oracle Business Intelligence Administration Tool connects to the
master BI Server for online repository changes.
* Cluster Manager: The Cluster Manager is available in the Administration Tool when a
repository is opened in online mode. The Cluster Manager enables Oracle BI Server
clustered instances.
QUESTION NO:113
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)
QUESTION NO:56
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?
A. Create a physical time table in your database.
B. Create a Logical Table that is sourced from the time key in the fact table.
C. Create an “Opaque View” in the physical layer that contains the time columns from the
fact and map it into your physical model.
D. Create a Logical Table that is sourced from a time field in one of your dimension tables.
E. Create a time table that is joined through a intervening Table so there is no foreign key
relationship.
Answer: A,D
Explanation: Modeling Time Series Function in OBIEE
Modeling Time Series Data
Time series functions provide the ability to compare business performance with previous
time periods, allowing you to analyze data that spans multiple time periods. For example,
time series functions enable comparisons between current sales and sales a year ago, a
month ago, and so on.
Because SQL does not provide a direct way to make time comparisons, you must model
time series data in the Oracle BI repository. First, set up time dimensions based on the
period table in your data warehouse. Then, you can define measures that take advantage
of this time dimension to use the AGO, TODATE, and PERIODROLLING functions.
QUESTION NO:88
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 defines the granularity of the dimension.
B. It determines the actual value of the dimension.
C. It creates a new session variable.
D. It creates a foreign key relationship.
Answer: A
Explanation: OBIEE – Grain (Level of summarization)
Grain definition in the context of OBIEE.
The following list describes the different grains in navigating a query:
* Aggregation grain. The grain of the aggregate source of from a level based metrics
* Query grain. The grain of the request.
* Time Series grain. The grain at which the time series function aggregation is requested.
* Storage grain. The query in the example can be computed from daily sales or from
monthly sales, or from quarterly sales.
Note:
The aggregation grain is defined in the content tab of the logical table source.
When the query grain match the aggregation grain of a logical table source, this one is
used to create the physical query.
QUESTION NO:31
Which option describes how OBIEE natively integrates with HFM?
A. Through EPM Analytic Data Model (ADM) connectivity
B. Direct relational database access
C. Through Essbase connectivity
D. OBIEE does not support HFM integration
Answer: A
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 prerequisite
steps are done, we start off with the metadata import process.
QUESTION NO:110
Permissions for Presentation layer objects and Business layer objects that restrict users is
configured in which software component?
A. Oracle Enterprise Manager
B. Oracle HTTP Server
C. WebLogic Server Administration Component
D. BI Administration Tool
Answer: D
Explanation: Oracle Business Intelligence Enterprise Edition (OBIEE) Security is managed
through:
a) 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
b) BI Presentation administration accessed through Presentation Web Services.
* Manage Web groups and users
* Set Permissions for Web Catalog items
* Manage privileges and rights given to groups and users
* Control access to dashboards
c) Catalog Manager.
* Set permission for Web Catalog items (Dashboards and Dashboards pages)
CertBus exam braindumps are pass guaranteed. We guarantee your pass for the 1Z0-591 exam successfully with our Oracle materials. CertBus Oracle Business Intelligence Foundation Suite 11g Essentials exam PDF and VCE are the latest and most accurate. We have the best Oracle in our team to make sure CertBus Oracle Business Intelligence Foundation Suite 11g Essentials exam questions and answers are the most valid. CertBus exam Oracle Business Intelligence Foundation Suite 11g Essentials exam dumps will help you to be the Oracle specialist, clear your 1Z0-591 exam and get the final success.
1Z0-591 Latest questions and answers on Google Drive(100% Free Download): https://drive.google.com/file/d/0B_3QX8HGRR1mTmxMWlpXVzVxUDg/view?usp=sharing
1Z0-591 Oracle exam dumps (100% Pass Guaranteed) from CertBus: http://www.certgod.com/1Z0-591.html [100% Exam Pass Guaranteed]
Why select/choose CertBus?
Millions of interested professionals can touch the destination of success in exams by certgod.com. products which would be available, affordable, updated and of really best quality to overcome the difficulties of any course outlines. Questions and Answers material is updated in highly outclass manner on regular basis and material is released periodically and is available in testing centers with whom we are maintaining our relationship to get latest material.