Oracle 1Z0-591 Online Practice Questions and Exam Preparation

Oracle 1Z0-591 Online Questions & Answers

• Question 61:

  Which three techniques are applied to support Failover?

  A. WebLogic Clustering
  B. Universal Installer > Scale Out BI System option
  C. OBIEE Clustering
  D. Vertical Scaleout
  A. WebLogic Clustering
  B. Universal Installer > Scale Out BI System option
  C. OBIEE Clustering

  ---

  A: OBIEE 11g is centred on WebLogic Server as the underlying application server architecture.

  B: If you want to scale out this infrastructure, you would typically run the OBIEE 11g installer on a second server, and instead of choosing to do a new install, you'd choose to instead scale out the existing BI domain.

  

  C: OBIEE Clustering ?Approach of Oracle BI Server Load balancing/Failover

• Question 62:

  Select the correct statement.

  A. Cache provides fast and always up-to-date information.
  B. Cache can increase traffic to back end database.
  C. Cache needs to be purged to refresh data.
  D. Cache can degrade query performance by reading data from the disk instead of the database.
  E. Cache is seeded by manually running PL/SQL at the back end database.
  C. Cache needs to be purged to refresh data.

  ---

  In a standard OBIEE implementation, we generally want to purge and re- build the cache after every ETL (extract, transform, and load) run.

• Question 63:

  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
  A. Oracle RDBMS
  B. Microsoft SQL Server
  C. IBM DB2

  ---

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

  A user's BI Home page provides one-click access to which three options?

  A. Create new content
  B. Oracle BI online documentation
  C. Catalog search functionality
  D. Dashboard layout editor
  E. Business model metadata
  A. Create new content
  B. Oracle BI online documentation
  C. Catalog search functionality

  ---

  See BI Home Page screenshot below: Note: The BI Home page contains the BI content catalog. Fusion Apps will use OBIEE web catalog to store all shipped reporting and analytics content. From the BI home page users can browse and view the entire BI content. The BI catalog folder structure will match the Fusion Apps main menu structure. Folder structure would be content driven not technology driven which would enable ease of navigation for fusion Apps users.

  

  Following content will be available under the BI catalog structure: BI Publisher Reports (regardless of data source) OTBI reports and dashboards OBIA dashboards and scorecards Financial Reporting

  Also, users can do some additional actions from the BI Home page like: Access personal and shared reports, View/ edit BI publisher report schedules, Launch BI tools for advanced actions and create new reports with report wizard.

  New reports created can be saved in BI catalog and added as embedded content within Fusion applications screens or links added to reporting pane. This enables users to extend the prebuilt embedded analytics within Fusion Applications.

• Question 65:

  One of the initial phases in OBIEE implementation is the Discovery phase where the project team focuses on a few activities. Which option is not one of them?

  A. Business Requirements Definition
  B. Technical Requirements Definition
  C. Data Quality Assessment
  D. Dashboard Testing
  B. Technical Requirements Definition

• Question 66:

  What are the two capabilities that users can apply to an Analysis when working within Plug- In for MS Office?

  A. Edit Analysis
  B. Refresh All
  C. Edit Prompts and Levels
  D. Publish
  B. Refresh All
  C. Edit Prompts and Levels

  ---

  B: Click Refresh All from the Oracle BI menu in PowerPoint to refresh all the refreshable objects in the presentation.

  C: Right-click Table and select Insert as List from the shortcut menu. The Edit Prompts and Levels dialog box appears. Accept the default options and click Insert.

  

  Reference: Using Oracle Business Intelligence Office Add-Ins with Oracle Business Intelligence Enterprise Edition (10.1.3.4) on Windows

• Question 67:

  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
  B. Create a new repository group
  C. Create a new user in the repository

  ---

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

  What is an example of a Session Variable?

  A. ETL Load Date
  B. User Organization
  C. OLAP DSN
  D. Top Customers by Revenue
  B. User Organization

  ---

  Note 1: There are four types of variables that you can use:

  Session

  Repository

  Presentation

  Request

  Note 2: Session Variables

  A session variable is a variable that is initialized at login time for each user. When a user begins a session, the Oracle BI Server creates a new instance of a session variable and initializes it.

  There are as many instances of a session variable as there are active sessions on the Oracle BI Server. Each instance of a session variable could be initialized to a different value.

  There are two types of session variables:

  System -- A session variable that the Oracle BI Server and Oracle BI Presentation Services use for specific purposes.

  System session variables have reserved names that cannot be used for other kinds of variables (such as static or dynamic repository variables and non-system session variables).

  Non-system -- A system variable that the administrator creates and names. For example, the administrator might create a SalesRegion non-system variable that initializes the name of a user's sales region.

  The administrator creates non-system session variables using the Oracle BI Administration Tool.

• Question 69:

  Oracle BI Server cache setup information is configured by using Enterprise Manager Fusion Middleware control. Which component stores the configuration Information?

  A. NQSConfig.ini
  B. Cache table in OBIEE repository
  C. Web Catalogue
  D. Instanceconfig.xml
  A. NQSConfig.ini

  ---

  NQSConfig.ini is the main configuration file of Bi Server and contains a lot of parameters.

  The parameters in the Query Result Cache Section provide configuration information for Oracle BI Server caching. The query cache is enabled by default. After deciding on a strategy for flushing outdated entries, you should configure the cache storage parameters in Fusion Middleware Control and in the NQSConfig.INI file.

• Question 70:

  A customer would like to create a change and a % Change for Revenue at the same time. How would they accomplish this?

  A. Using the Expression Builder
  B. Using the Calculation Wizard
  C. Defining them in the physical data model
  D. Defining them in the Presentation Layer
  B. Using the Calculation Wizard

  ---

  After creating your base metrics, try using the Calculation Wizard to automate the process of creating time-series metrics or comparison metrics such as: Change, Percent Change, Index, and Percent. The Wizard may save you many hours of time and frustration, especially if you have to create more than a handful of these metrics. In addition, the Wizard allows you to include customized logic to handle nulls in the base metrics. You may refer to the Oracle documentation for further detail.