|Exam Name||:||Oracle Business Intelligence Foundation Suite 11g Essentials|
|Questions and Answers||:||120 Q & A|
|Updated On||:||August 16, 2017|
|PDF Download Mirror||:||1Z1-591 Brain Dump|
|Get Full Version||:||Pass4sure 1Z1-591 Full Version|
The customer is questioning the necessity to have a data warehouse in place. They want to run OBIEE against various transactional systems. Identify the two limitations.
Operational system might be overburdened with analytical requests resulting in had performance for transactional processes.
TheBIserver cannot integrate various sourcesin one metadata model.
Dataquality issues might emerge, due to missing data cleansing.
Business issues are depending on real-time data.
Permissions for Presentation layer objects and Business layer objects that restrict users is configured in which software component?
WebLogicServer Administration Component
Oracle Business Intelligence Enterprise Edition (OBIEE) Security is managed through:
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
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)
You run the Consistency Check and receive the warning:
 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 E. Whether there is a physical column mapped to the logical column
This warning indicates that the given column is only mapped to logical table sources that are disabled. The warning brings this issue to the repository developer's attention in case the default behavior is not desired.
Oracle Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition, Common Consistency Check Messages
How do System Session Variables obtain their values?
They are entered by user input on a dashboard
They are obtained from data fields in the Physical Layer
They are obtained from the Presentation Layer
They are obtained from the Initialization Block
Initialization blocks are used to initialize dynamic repository variables, system session variables, and nonsystem session variables.
Selecting the Manage Map Data link allows one to do which three of the following?
Associate map layers to columns defined in the OBIEE metadata
Create a new map layer
Set the zoom level of an imported map
Import images for use on maps
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.
Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition, Configuring Mapping and Spatial Information
Which option is not an example of a level-based measure?
Note 1: A level-based measure is a column whose values are always calculated to a specific level of aggregation.
The calculation of this measure is independent of the query grain and used always the aggregation grain of the logical column.
Level-based measures allow :
*to return data at multiple levels of aggregation (the query grain and the level-based column grain)
with one single query
*to create share measures (percentage), that are calculated by taking some measure and dividing it by a level-based measure. For example, you can divide salesperson revenue by regional revenue to calculate the share of the regional revenue each salesperson generates.
Note 2: To create a level based measure as the amount sold by region, you can:
make a copy of the Amount Sold logical column
and then / drag the logical column into its hierarchy level / or set the aggregation grain in the level tab of the logical column property.
Use of the Enterprise Install option is recommended for which three options?
Multiple instances on a single computer
Scale out for High Availability and Failover
Support for high security requirements
Evaluation of end user functionality
Single users working on a single computer
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.
What are the two ways to use the administration tool?
It can be used to manage user password.
The administration tool uses a set of wizards that support the design of calculations, expressions, dimensions, and so on.
It can be used for versioning of the rpd.
Administrator can use repository and session variables in a repository to streamline administrative tasks and dynamically modify metadata content to adjust to a changing data environment.
Note: The Administration tool is used to manage OBIEE server and have some capabilities to automate some repetitive tasks and principally his embedded tools.
Oracle Business Intelligence Administration Tool is available only for Windows operating systems. The Administration Tool is a Windows application that allows the BI Server administrator to create and edit repositories.
Repositories can be edited with the administration tool in either online or offline mode. The Administration Tool also includes a session manager and a cache manager which are available in online mode. The Cache Manager displays what queries have been cached and how frequently they have been accessed. You can also select and delete items
An integrated BI tools business case can be built around which three options?
Object Security controls access to Subject Areas, Tables, and Columns in OBIEE and can be implemented by using which method?
Single Sign-On (SSO)
Business Logic Object Security
External Table Authentication
Object-level security controls the visibility to business logical objects based on a user's role. You can set up object-level security for metadata repository objects, such as subject areas and presentation folders, and for Web objects, such as dashboards and dashboard pages, which are defined in the Presentation Catalog.
Business logic object
This controls access to objects, such as:
For example, users in a particular department can view only the subject areas that belong to their department.
Web object security
This provides security for objects stored in the Web Catalog, such as dashboards, dashboard pages, folders, and reports. You can view only the objects for which you are authorized. For example, a mid- level manager may not be granted access to a dashboard containing summary information for an entire department.
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 Verticalscale out option
Horizonal Scaleout of System Components
Used for adding additional managed servers (Java components) and system components to an existing cluster
Used for scalability and failover
Set up via the Universal Installer > Scale Out BI System option
When creating an initialization Block, which BI Administration function is used?
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.
Our OBI partners can now update their specialisation certification to the latest product version 11g for OBI: until now, the accreditation had examined skills for OBI 10g.
As an introductory offer, since the exam is in “Beta” phase, OPN partners can apply for a free of charge voucher to take this exam. For more details see Oracle Business Intelligence Foundation Suite 11g Essentials (">1Z1-591) where you can apply for this Oracle Implementation Specialist credential.
Send an e-mail to opn-edu_wworaclem to get your free voucher NOW and become an Oracle Business Intelligence Foundation Suite 11g Implementation Specialist. For more help, try How To Get OPN “Specialized” - Business Intelligence & Hyperion.
This exam is primarily intended for consultants that are skilled in implementing solutions based on Oracle Business Intelligence Foundation Suite 11g. The certification covers skills such as: installing OBIEE, building the BI Server metadata repository, building BI dashboards, constructing ad hoc queries, defining security settings and configuring and managing cache files. The exam targets the intermediate-level implementation team member. Up-to-date training and field experience are recommended.
Also Note the New OPN on-line Sales & Pre-sales Assessment Tests Available
Us: Please direct any inquiries you might have to the Partner Enablement team.
For More Information
Article by ArticleForge
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.
If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional andor OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.
smworthm - Last updated: Tuesday, October 25th, 2016. All links and promo codes are still valid as of this date. If you are an organized writer, like myself, Scrivener is the best software for both your ficti...