Oracle Oracle Certifications 1Z0-591 Questions & Answers

• Question 81:

  Content that is saved in personal and shared folders can be browsed by using which view?

  A. Catalog

  B. Dashboard

  C. New -> Analysis

  D. Home

  E. Favorites

  Correct Answer: A

  Explanation: The Catalog Manager workspace enables you to view and work with catalog objects. It displays the following folders for an open catalog:

  The shared folder-- Contains content that is shared among catalog users. This includes the preconfigured dashboards and analyses that are distributed with prebuilt applications, and other objects such as shared filters.

  The system folder -- Contains administrative elements of Presentation Services. Some of these elements are distributed with the product, and others are configured by you as the administrator, such as privileges. Avoid modifying any files in

  this folder. Presentation Services uses these files internally and modifying them might cause unexpected results.

  The users folder -- Contains content that catalog users with the appropriate permissions have saved to their personal folders, such as individual analyses.

  Reference: Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition, What Does the Catalog Manager Workspace Look Like?

• Question 82:

  Identify the two Object level security functions that are done on the repository by using the BI Admin tool.

  A. Assign users to a web catalog group

  B. Create a new repository group

  C. Create a new user in the repository

  D. Create a web catalog group

  E. Define permissions for Dashboard

  Correct Answer: BC

  Explanation: The Oracle Business Intelligence (BI) Administration Tool can be used to build, modify, enhance, and manage an Oracle BI repository.

  C: To add a new user to a repository

  1 Open a repository in the Administration Tool.

  2 Display the security manager by selecting Manage > Security. 3 Select Action > New > User to open the User dialog box.

  4 Type a name and password for the user.

  5 If you want to log queries for this user in the query log, change the query logging level to 1 or 2.

  6 Click OK.

  This creates a new user with default rights granted to it.

  Note: What is Oracle BI Admin Tool/Oracle Business Intelligence Administration Tool?

  Oracle Business Intelligence Administration Tool is Used to manage OBIEE server Available only for Windows operating systems.

  A Windows application that allows the BI Server administrator to create and edit repositories. Can edit repositories in either online or offline mode. Having a session manager and a cache manager in online mode.

• Question 83:

  The WebLogic Repository Schema generated via RCU can be deployed to which three DBMS?

  A. Oracle RDBMS

  B. Microsoft SQL Server

  C. IBM DB2

  D. Teradata

  Correct Answer: ABC

  Explanation: BIEE 11g Install High level Steps : Software Required

  1.

  Database (Oracle, IBM DB2 or MS-SQL)

  2.

  Repository Creation Utility (RCU)

  3.

  OBIEE 11g (11.1.1.3 is latest OBIEE as of 30 April 2011)

  4.

  WebLogic 10.3.3 (Optional ?Only required for 64 bit machine or IBM AIX)

  5.

  JDK 1.6 64 bit (Optional ?Only required for 64 bit machine)

• Question 84:

  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 using the count Function

  B. By creating a derived measure on the logical column item number and using the count distinct function

  C. By creating a derived measure based on the physical column item number and changing the aggregation method to count

  D. By creating a derived metric by using the Expression Builder

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

  

• Question 85:

  Which language is used by OBIEE to query Essbase?

  A. SQL

  B. LINQ

  C. MDX

  D. DMX

  Correct Answer: C

  Explanation: The Essbase cube looks just like any other relational star schema in my Presentation Layer, however when it is queried Oracle BI Server will issue MDX queries against a multi-dimensional data source, rather than an SQL query against a relational star schema.

• Question 86:

  Which are the three types of tables available to physical tables in the physical layer?

  A. Physical Table

  B. Stored Proc

  C. Select

  D. View

  E. Table

  Correct Answer: ABC

  Explanation: Pull the table and column definition into the physical layer Use the OBIEE "import metadata" wizard to pull the table and column definition into the physical layer. The wizard is used so that all of the column definitions do not need to be manually added into the physical layer.

  Figure:

  

  Note: The physical layer is the layer of the Logical Business Model where you define the physical data model of your data source. It contains information about the physical data sources.

• Question 87:

  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

  Correct 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 pre- requisite steps are done, we start off with the metadata import process.

  

• Question 88:

  Select the scenario in which block storage must be used instead of aggregate storage.

  A. Incremental data loading

  B. Top - down planning

  C. Extremely sparse data sets

  D. Millions of members in the outline

  Correct Answer: B

  Explanation: BSO is preferred to ASO in the following scenarios:

  *

  Top-down planning and allocation (Sales Forecasting)

  *

  Cost Allocations across products and customers (Profitability Analysis)

  *

  Currency conversion, inter-company eliminations(Financial consolidations)

• Question 89:

  What would you use to customize the text elements that appear on BI Analysis, Delivers and Dashboard pages?

  A. Cascading Style Sheets

  B. DHML Message files

  C. XML Message Files

  D. BI Presentation services web template

  Correct Answer: A

  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".

• Question 90:

  In the Oracle Data Warehouse Reference Architecture, which term is not a layer in the data warehouse?

  A. Access and Performance Layer

  B. Master Data Layer

  C. Staging Data Layer

  D. Presentation Data Layer

  Correct Answer: D