Oracle Oracle Certifications 1Z0-591 Questions & Answers

• Question 21:

  Which variable does not use initialization blocks to initialize its values?

  A. Static Repository Variable

  B. Dynamic Repository Variable

  C. System Variable

  D. Non System Variable

  Correct Answer: A

  Explanation: The value of a static repository value is initialized in the Variable dialog box. This value persists, and does not change until an Oracle BI Administrator decides to change it.

• Question 22:

  An organization has its employees' names in an Employees table, and information about their jobs in a Jobs table.

  However, an organization's employees can have multiple jobs, and the same job can be performed by multiple employees. This situation would result in a many to-many relationship between the Employees and Jobs tables. How can the many to-many relationship issue be resolved?

  A. By modeling the many to many relationship in the business model

  B. By creating a bridge table that represents one employee doing one job, with several rows for an employee who has several jobs

  C. By creating the many to many join in the physical model

  D. By creating a logical table source (LTS) that joins the Employees and Jobs tables

  Correct Answer: B

  Explanation: When you need to model many-to-many relationships between dimension tables and fact tables, you can create a bridge table that resides between the fact and the dimension tables. A bridge table stores multiple records corresponding to that dimension. In the Administration Tool, General tab in the Logical Table dialog box contains a check box that you can select to specify that a table is a bridge table. A bridge table allows you to resolve many-to-many data relationships.

  Reference; OBI Server Administration Server Guide, Version 10.1, Identifying Bridge Tables

• Question 23:

  Oracle BI Server at a company is connected to Data Warehouse that is refreshed on a daily basis, the majority of users at the company log in to Oracle BI every Monday to generate the previous week's sales report. The BI Administrator schedules cache purge and cache seeding to improve report response times. How is this accomplished?

  A. Every day before Data Warehouse refresh

  B. Every day after Data Warehouse refresh

  C. Every Monday early morning

  D. Every Monday late night

  Correct Answer: D

  Explanation: Purge and reseed once a week after the reports have run to improve report response time.

• Question 24:

  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

  Correct Answer: A

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

  What must be done before you can run the Oracle Business Intelligence 11g Installer?

  A. Obtain BI installation media

  B. Create required Oracle Business Intelligence schemas in a database

  C. Ensure system meets installation requirements for Fusing Middleware, Oracle Business Intelligence, AND Repository Creation Utility

  D. Install the WLS Admin Server

  E. Select installation components ?OBIEE, BIP, RTD

  Correct Answer: B

  Explanation: Before you can run Oracle Business Intelligence 11g Installer, you must first create

  required Oracle Business Intelligence schemas in an unhardened database. You use a tool called the Repository Creation Utility (RCU) to create these schemas with the appropriate permissions and data.

  Reference: Installation Guide for Oracle Business Intelligence, Additional Oracle Business Intelligence 11g Installer Requirements

• Question 26:

  Which option does not describe Aggregate tables?

  A. Aggregate tables increase query performance by pre-calculating frequently accessed measure aggregations.

  B. Aggregate tables relieve bottlenecks and pre-calculate and store the data for better query response.

  C. Aggregate tables typically have fewer rows than the non aggregate tables and, therefore, processing should be quicker.

  D. Aggregate tables are created and stored on the BI Server.

  Correct Answer: D

• Question 27:

  Security Manager is used for______.

  A. Setting permissions for particular users or application roles

  B. Setting permissions for individual objects in the Presentation Layer

  C. Setting up new Roles and Groups

  D. Setting up new Application Roles

  Correct Answer: A

  Explanation: Security Manager ?is used to setup users, groups, synchronize LDAP users and Groups, set access rights for Objects (tables, columns) and to control over when and what data a user can access.

  

  

  Note: When you open the administration tool, you can reach the security manager by the Menu : Manage > Security

  

• Question 28:

  Which configuration can be changed through Enterprise Manager?

  A. Minimum Number of Rows to Download to Excel

  B. The default BI Server Repository

  C. Start and Stop BI Services

  D. Manages user login

  Correct Answer: B

  Explanation: The Repository can be configured within the Enterprise Manager. See Note 1 below.

  Note 1: Once you've locked the Oracle BI Domain, you would then use the same screen back in Enterprise Manager to browse and select the RPD file, and then enter the password, twice.

  

  Once you've entered these details you would then press the Apply button, to save the changes. At this point, the RPD gets a sequence number after it, and it's displayed as the current default online repository for the Oracle BI Domain.

  Note 2: An OBIEE 11g system (or "Oracle BI Domain") is generally managed through a combination of Oracle Enterprise Manager Fusion Middleware Control, part of the Enterprise Manager "family", or through WebLogic Server Scripting Tool (WLST) scripts. Each Fusion Middleware Control instance as shipped with OBIEE 11g controls a single Oracle BI Domain (DEV, or PROD for example), and is installed along with WebLogic Server Admin Console in the WebLogic Admin Server, one of the two JVMs (the other being the managed server) that gets installed by default with OBIEE 11g. The screenshot below shows Fusion Middleware Control showing the status of the BI Server, Presentation Server and other system components within the installation.

  

• Question 29:

  Which two Oracle BI Components contain security information regarding permissions and privileges?

  A. The Web Catalog

  B. The Repository

  C. NQSConfig.ini File

  D. NQServer.ini File

  E. InstanceConfig.xml File

  Correct Answer: BC

  Explanation: B: Oracle Business Intelligence uses a role-based access control model. Security is defined in terms of Application Roles that are mapped to directory server groups and users.

  To define a complete security model, you have then to define:

  1. A security structure by creating this elements:

  *

  The directory Server User and Group managed by the authentication provider.

  *

  The application roles managed by the policy store provider

  2. a security policy (permissions) split across the following components: *Presentation Catalog

  *

  Repository

  *

  Policy Store to define the Application Policies managed by the policy store provider

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

  The file is located in this directory :

  11g: ORACLE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisn

  All changes made to this file require that you restart the Oracle BI Server Service.

  Type of Parameters in NQSConfig.ini:

  *

  Security Section Parameters

  The security parameters specify default values for the Oracle BI Server security features.

  Includes among others:

  / DEFAULT_PRIVILEGES

  *

  Repository Section Parameters

  *

  Query Result Cache Section Parameters

  *

  General Section Parameters

  The General section contains general server default parameters, including localization and internationalization, temporary space and memory allocation, and other default parameters used to determine how data is returned from the Oracle BI

  Server to a client.

  Reference: Oracle Fusion Middleware System Administrator's Guide for Oracle Business, A NQSConfig.INI File Configuration Settings

• Question 30:

  What are the two disadvantages of implementing Query Caching?

  A. Reduction in BI server processing time

  B. Cache results being old

  C. Storage space for cache

  D. Increased network traffic

  E. Needs a lot of administrators' time

  Correct Answer: BC

  Explanation: B: The problem with caching of any kind is how to deal with stale data. How you decide to deal with this depends on how time critical your business intelligence queries happen to be. OBIEE provides a wide variety of mechanisms for dealing with stale data. The cache can be purged automatically at intervals. Caching can be enabled selectively for individual physical tables, so that data in a frequently updated table is never cached. OBIEE provides a set of ODBC procedures that can be called when ETL processes complete to programmatically purge designated tables. But, by far the best way to selectively purge the cache is to use an event polling table. This table is populated by the client database whenever changes are made to any table (by an ETL process for a data warehouse or by a table-based trigger for an OLTP database). At specified intervals the BI Server polls this event polling table and deletes from its cache any query results that are dependent on the changed data.