Oracle 1Z0-591 Online Practice Questions and Exam Preparation

Oracle 1Z0-591 Online Questions & Answers

• Question 71:

  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 Excel
  C. MS Project
  D. MS Word
  B. MS Excel
  D. MS Word

  ---

  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

• Question 72:

  Which Oracle Partner is the supplier of map-based content to provide background maps, boundary information, and points of interest?

  A. Navteq
  B. TeleAtlas
  C. Google
  D. ESRI
  A. Navteq

• Question 73:

  One benefit of adding a second table source that is joined to the first table source in the Physical Layer by a foreign key relationship is that______.

  A. Multiple SQL queries are performed
  B. Two SQL queries are performed to get data from both tables
  C. A single SQL query is performed to get data from both tables
  D. No SQL queries are performed against the source tables
  C. A single SQL query is performed to get data from both tables

  ---

  A single query can be performed accessing data from both tables through a join on the columns in the foreign key relation.

• Question 74:

  If a customer is planning on building a data warehouse, how would you describe data warehousing to the customer?

  A. The data in the data warehouse describes events and statuses of business processes, products and services, goals and organizational units, and generally mirrors every aspect of the structure and behavior of the organization.
  B. Data warehouses can only be based on multidimensional data modeling.
  C. Application based data warehouses can be bought off the shelf and used without any tweaking.
  D. Data warehouse projects are usually implemented within two weeks.
  A. The data in the data warehouse describes events and statuses of business processes, products and services, goals and organizational units, and generally mirrors every aspect of the structure and behavior of the organization.

  ---

  A data warehouse is a database used for reporting and data analysis. It is a central repository of data which is created by integrating data from multiple disparate sources. Data warehouses store current as well as historical data and are commonly used for creating trending reports for senior management reporting such as annual and quarterly comparisons.

• Question 75:

  OBIEE 11g authentication of users is performed by which two components listed below?

  A. Repository file (rpd)
  B. Embedded WebLogic LDAP server
  C. External directories such as Active Directory using WebLogic and Fusion Middleware's Oracle Platform Security Services framework
  D. BI Presentation Services
  A. Repository file (rpd)
  B. Embedded WebLogic LDAP server

  ---

  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

• Question 76:

  How do System Session Variables obtain their values?

  A. They are entered by user input on a dashboard
  B. They are obtained from data fields in the Physical Layer
  C. They are obtained from the Presentation Layer
  D. They are obtained from the Initialization Block
  D. They are obtained from the Initialization Block

  ---

  Initialization blocks are used to initialize dynamic repository variables, system session variables, and nonsystem session variables.

• Question 77:

  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. the subject areas are both from the same physical source, though they may be in separate business layers
  D. two or more subject areas cannot be joined together without manually mapping the contents
  B. the subject areas both share the same model in the business model and mapping layer

  ---

  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.

• Question 78:

  Which task can be performed after the Administrator link has been reached through logging into OBIEE?

  A. Associate map layers to columns
  B. Manage access to Subject Areas
  C. SSO enablement
  D. Start or Stop BI Managed Servers
  B. Manage access to Subject Areas
  C. SSO enablement
  D. Start or Stop BI Managed Servers

  ---

  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.

• Question 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
  A. Master Server
  C. Primary Cluster Controller
  D. Web Server

  ---

  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 80:

  What must be purchased when integrating Oracle map with Oracle BI?

  A. Oracle Mapviewer
  B. Oracle Business Intelligence Enterprise Edition
  C. Spatial Option with Database
  D. OLAP option
  A. Oracle Mapviewer

  ---

  MapViewer is shipped as part of Oracle Fusion Middleware. Its main deliverable is a J2EE application that can be deployed to a J2EE container, such as that for Oracle Fusion Middleware. MapViewer includes the following main components:

  *

  A core rendering engine (Java library) named SDOVIS that performs cartographic rendering. A servlet is provided to expose the rendering functions to Web applications.

  *

  A suite of application programming interfaces (APIs) that allow programmable access to MapViewer features. These APIs include XML, Java, PL/SQL, and an AJAX-based JavaScript API.

  *

  A graphical Map builder tool that enables you to create map symbols, define spatial data rendering rules, and create and edit MapViewer objects.

  *

  Oracle Map, which includes map cache and FOI (feature of interest) servers that facilitate the development of interactive geospatial Web applications.

  Oracle Maps can be configured now in the map viewer as a built in layer.