Oracle Oracle Certifications 1Z0-591 Questions & Answers

• Question 11:

  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.

  A. Operational system might be overburdened with analytical requests resulting in had performance for transactional processes.

  B. The BI server cannot integrate various sources in one metadata model.

  C. Data quality issues might emerge, due to missing data cleansing.

  D. Business issues are depending on real-time data.

  Correct Answer: AC

• Question 12:

  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

  Correct 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)

• Question 13:

  An organization would like to see a Time folder with subfolders for its Fiscal and Julian calendars. How would you accomplish this?

  A. By creating Presentation Folder called Time and then two subsequent folders called -> Fiscal Calendar and -> Julian Calendar

  B. By creating a Presentation Folder called ->Time called then two subsequent folders called Fiscal Calendar and Julian Calendar

  C. By creating a Presentation Folder called -Time and then two subsequent folders called + Fiscal Calendar and + Julian Calendar

  D. By creating a Presentation Folder called Time and then two subsequent folders called Fiscal Calendar and Julian Calendar

  Correct Answer: A

  Explanation: You can nest presentation folders in two ways.

  1) You can enter a hyphen and a greater than sign in the description field of the table to achieve the result.

  2) Or, prefix the name of the presentation folder to be nested with a hyphen and a space and place it after the folder in which it nests to achieve the same result as shown below.

  

  Result

  

• Question 14:

  OBIEE default security model stores security Information such as user names and password combinations for accessing an external system such as Active Directory. It is stored in the____________.

  A. Policy Store

  B. Credential Store

  C. Identity Store

  D. Person Store

  Correct Answer: C

  Explanation: Identity Store: It is directory server to perform the authentication. It contains user name , password and groups membership information .When a user name and password combination is entered at log in, the authentication

  provider searches the identity store to verify the credentials provided.

  See figure below.

  

• Question 15:

  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.

  Correct Answer: A

  Explanation: 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 16:

  Initialization Blocks are never used to initialize which option?

  A. Dynamic Repository Variables

  B. System Session Variables

  C. Non System Session Variables

  D. rpd file

  Correct Answer: D

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

• Question 17:

  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

  Correct Answer: A

  Explanation: 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.

• Question 18:

  Which analysis features could be applied to provide interactive controls for end users?

  A. Column Selector

  B. Action Links

  C. Conditional Formatting

  D. Narrative View

  E. Greenbar Styling

  Correct Answer: B

  Explanation: An action link is a link to an action that you have embedded in an analysis, dashboard page, scorecard objective, scorecard initiative, or KPI that, when clicked, runs an associated action.

• Question 19:

  A customer needs to create a product share calculation. What are the two ways that they would get the revenue for all products to use in the denominator?

  A. Create a derived measure by using the addition function that adds each product value together.

  B. Create a derived measure based on Revenue that has the Level Total Product selected on the Level Tab of the Logical Column Dialog.

  C. Create a derived measure based on Revenue that has all the levels selected on the Level Tab of the Logical Column Dialog except Total Product.

  D. Create a derived metric by using the Expression Builder.

  Correct Answer: AC

  Note: 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.

  

  

• Question 20:

  Derived metrics are_____.

  A. Derived from other logical columns

  B. Derived from other physical columns

  C. Used to apply pre-aggregation calculations to measures

  D. Used to rename measures to user-friendly names

  Correct Answer: A