Oracle 1Z0-591 Online Practice Questions and Exam Preparation

Oracle 1Z0-591 Online Questions & Answers

• Question 111:

  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
  A. Setting permissions for particular users or application roles

  ---

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

  Which two components are required for all OBIEE installations?

  A. Admin Server
  B. RCU Schema
  C. Managed Server
  D. Node Manager
  E. Oracle 11g
  B. RCU Schema
  E. Oracle 11g

  ---

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

  E: The database 11gR2 is required if you want to run the Oracle Business Intelligence Enterprise Edition Plus Samples One Oracle Database Preinstalled and not hardened to host the schemas.

• Question 113:

  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
  D. rpd file

  ---

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

• Question 114:

  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
  C. By creating a derived measure based on the physical column item number and changing the aggregation method to count

  ---

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

  What are the two types of Repository Variables?

  A. System
  B. Non System
  C. Static
  D. Dynamic
  C. Static
  D. Dynamic

  ---

  There are static and dynamic repository variables.

  Note:

  Variables in the Oracle BI Server can be either repository or session variables, and are defined using the Variable Manager within the Oracle BI Administrator (Manage > Variables).

  

  This brings up the Variable Manager, that divides variables out into repository and session variables, with a further subdivision into static and dynamic repository ones and system and non-system session ones. You can also define variables at the Presentation Server level, these are scoped to individual dashboards and are used amongst other things for setting dashboard prompt values and integrating the dashboard with BI Publisher parameters. Here's a screenshot of a typical Variable Manager screen.

  

• Question 116:

  WLS Embedded LDAP Server is managed by the Admin Server Console and supports which three options?

  A. Creating and Maintaining Users
  B. Authentication and Authorization
  C. Basic Directory for storing user details
  D. Subject area and row-level security, connection pool passwords
  E. Application of Session Variables as Data Filters
  A. Creating and Maintaining Users
  C. Basic Directory for storing user details
  D. Subject area and row-level security, connection pool passwords

  ---

  WLS Embedded LDAP Server

  *By default, OBIEE 11g users and groups are now held in the WLS LDAP Server (C)

  -More robust directory for storing user details

  -Recommended for >1000 users

  *

  WLS Admin Server Console now used for creating and maintaining users (A)

  *

  BI Server "outsources" all authentication, authorization to FMW11g (not B)

  *

  BI Administration tool now used for subject area and row-level security, connection pool passwords only (D) ?WLS LDAP Server can be "swapped out" for alternative directories (MS AD etc)

• Question 117:

  When a customer wants to get sales numbers by day, how is data stored in the Star Schema, if the data is loaded nightly?

  A. The lowest level of aggregation
  B. The highest level of aggregation
  C. Multiple levels of aggregation
  D. Independently from aggregation level
  A. The lowest level of aggregation

• Question 118:

  What are the two leading design solutions recommended by Oracle that you would use for performance?

  A. Design requests that use Complex Queries
  B. Avoid returning big data sets within the Dashboard
  C. Use Cache
  D. Avoid using Guided Navigation unless the data set is large
  B. Avoid returning big data sets within the Dashboard
  C. Use Cache

  ---

  C: OBIEE Caching and Cache Seeding

  Cache is a component that improves performance by transparently storing data such that future requests for the same criteria can be served much faster. Like other application cache is not virtual memory in OBIEE. In OBIEE cache will be

  stored as files on the Hard Disk of the OBIEE Server in the form of files. By Default caching is enabled in the OBIEE server configuration.

  For time-consuming Dashboard Pages, we can use the concept of cache seeding in OBIEE, this can be configured as a scheduled job that will ensure that the data is cached and readily available as and when the user runs the dashboard.

• Question 119:

  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
  A. Cascading Style Sheets

  ---

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

  A customer needs to have a calculation done prior to aggregating the data. How would you accomplish this?

  A. By creating a derived measure by using the Logical Columns available
  B. By creating a derived measure in the Column Mapping dialog box by using the physical table columns.
  C. By creating a derived measure by using Logic Columns available and changing the aggregation type
  D. By creating a derived metric by using the Expression Builder
  E. By creating a derived metric by using the Calculation Wizard
  B. By creating a derived measure in the Column Mapping dialog box by using the physical table columns.

  ---

  Note 1: OBIEE offers two calculation types for measure in the repository:

  logical

  physical

  You can define calculations in either of the following ways:

  *

  Before the aggregation, in the logical table source.

  *

  After the aggregation, in a logical column derived from two other logical columns. For example: sum(col A) * sum(col B)

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