Oracle 1Z0-591 Online Practice Questions and Exam Preparation

Oracle 1Z0-591 Online Questions & Answers

• Question 31:

  Query limits tab can be accessed through________.

  A. Security Manager, Query tab, Application role dialog box, Permissions
  B. Security Manager, Application Roles tab, Query dialog box, Permissions
  C. Security Manager, Application Roles tab, Application role dialog box, Permissions
  D. Security Manager, Application Roles tab, Application role dialog box, Query Properties
  C. Security Manager, Application Roles tab, Application role dialog box, Permissions

  ---

  Query environment can be managed by setting query limits (governors) in the Repository (RPD) for particular Application Roles. You should always set query limits for particular application roles rather than for individual users. Steps:

  1.

  Login to Repository using OBIEE Admin Tool

  2.

  Navigate to Manage > Identity

  3.

  Go to Application Role tab, choose the role and double click on it to open.

  4.

  Click on Permissions tab

  

  

  5. Set the Query Limits. You can limit queries by the number of rows received, by maximum run time, and by restricting to particular time periods. You can also allow or disallow direct database requests or the Populate privilege.

  

• Question 32:

  Where is Oracle Mapviewer installed?

  A. In the same domain as OBIEE on the web application server
  B. Never on the same domain as OBIEE on the web application server
  C. On the Database server
  D. On its own application server
  A. In the same domain as OBIEE on the web application server

  ---

  With the advent of 11G, MapViewer is installed as part of Oracle BI Enterprise Edition and deployed in the same domain as Oracle BI EE on the Web application server. Before content designers can create map views, in the Manage map Data Administration page, the metadata must be configured:

  *

  layers (theme) and map (zoom level)

  *

  the mapping between Oracle BI EE data and spatial data

• Question 33:

  Object Security controls access to Subject Areas, Tables, and Columns in OBIEE and can be implemented by using which method?

  A. Single Sign-On (SSO)
  B. Database Authentication
  C. Business Logic Object Security
  D. External Table Authentication
  E. LDAP Authentication
  C. Business Logic Object Security

  ---

  Object-level security controls the visibility to business logical objects based on a user's role. You can set up object-level security for metadata repository objects, such as subject areas and presentation folders, and for Web objects, such as

  dashboards and dashboard pages, which are defined in the Presentation Catalog.

  1) Business logic object

  This controls access to objects, such as:

  *

  subject areas

  *

  presentation tables

  *

  presentation columns For example, users in a particular department can view only the subject areas that belong to their department. 2) Web object security This provides security for objects stored in the Web Catalog, such as dashboards, dashboard pages, folders, and reports. You can view only the objects for which you are authorized. For example, a mid-level manager may not be granted

  access to a dashboard containing summary information for an entire department.

• Question 34:

  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
  A. Derived from other logical columns

• Question 35:

  Which three options apply to FMW Application Roles?

  A. Provide an indirection between LDAP groups and BI roles
  B. Can be exported / moved between FMW11g environments
  C. Are created and managed by using the WLS Admin Console and FMW Control
  D. Can be created by using BI Administrator Client and "pushed" to WLS Admin Console
  E. Secures RPD permissions but NOT Web Catalog (webcat) permissions
  A. Provide an indirection between LDAP groups and BI roles
  C. Are created and managed by using the WLS Admin Console and FMW Control
  E. Secures RPD permissions but NOT Web Catalog (webcat) permissions

  ---

  A: The default Application Roles available after OBIEE 11g installation are BIAdministrator, BISystem, BIConsumer and BIAuthor.

  Note: In OBIEE 11g, Application roles provide insulation between permission definitions and corporate LDAP Groups. Permissions are defined at Application Role level and changes to LDAP groups just require a reassignment of the Group to the Application Roles.

  See figure below:

  

  C: Application Roles, Policies, association of Policies to application roles and association of users and groups to application roles are managed using Fusion Middleware Enterprise Manager (FMW EM).

  E: Object level permission association to Applications Roles resides in the RPD for repository objects. Permissions and Privilege for web catalog objects resides in the OBIEE Web Catalog. Wherever Groups were used in the web catalog and RPD has been replaced with Application roles in OBIEE 11g.

  Note: Application Roles are introduced in OBIEE 11g. An application role is specific to the application. They can be mapped to other application roles defined in the same application scope and also to enterprise users or groups, and they are used in authorization decisions.

• Question 36:

  Point-and-click generation of case statement logic can be accessed via which option?

  A. Column Formula -> Bins tab
  B. Compound Layout
  C. Column Properties -> Conditional Format tab
  D. Advanced Tab
  E. Subject Area metrics
  A. Column Formula -> Bins tab

  ---

  The "Edit Column Formula" dialog box has a second, very tiny tab called, "Bins." You can use this tab to have OBIEE build a CASE statement for you in a formula (you can also create a CASE statement yourself by using one of the functions that appears under "Expressions" if you want). A CASE statement is a lot like an IF-THEN-ELSE statement, except that it's a little easier to read when you have multiple options. Basically, it puts values in different buckets that you define.

  Note: Figure:

  

• Question 37:

  You do not have a physical time table in your database but would like to use the time series functions that OBIEE offers. What two options do you have?

  A. Create a physical time table in your database.
  B. Create a Logical Table that is sourced from the time key in the fact table.
  C. Create an "Opaque View" in the physical layer that contains the time columns from the fact and map it into your physical model.
  D. Create a Logical Table that is sourced from a time field in one of your dimension tables.
  E. Create a time table that is joined through a intervening Table so there is no foreign key relationship.
  A. Create a physical time table in your database.
  D. Create a Logical Table that is sourced from a time field in one of your dimension tables.

  ---

  Modeling Time Series Function in OBIEE Modeling Time Series Data

  Time series functions provide the ability to compare business performance with previous time periods, allowing you to analyze data that spans multiple time periods. For example, time series functions enable comparisons between current sales and sales a year ago, a month ago, and so on.

  Because SQL does not provide a direct way to make time comparisons, you must model time series data in the Oracle BI repository. First, set up time dimensions based on the period table in your data warehouse. Then, you can define measures that take advantage of this time dimension to use the AGO, TODATE, and PERIODROLLING functions.

• Question 38:

  A customer always wants Aggregate Table l to be looked at first to see if it can answer the query. What should be done to make sure this happens?

  A. Make Aggregate Table 1 the first table in the list of Logical Table Sources.
  B. Do not map the logical level in the Content tab.
  C. Set the Priority Group to 0.
  D. Set the Priority Croup to 5.
  C. Set the Priority Group to 0.

  ---

  Priority group

  You can set priority group numbers to determine which logical table source should be used for queries for which there is more than one logical table source that can satisfy the requested set of columns.

  For example, you might have user queries that can be fulfilled by both a data warehouse and an OLTP source. Often, access to an operational system is "expensive," while access to a data warehouse is "cheap." In this situation, you can

  assign a higher priority to the data warehouse to ensure that all queries are fulfilled by the data warehouse if possible.

  Note that the priority group of a given logical table source does not always ensure that a particular query will be fulfilled by that source.

  Priority Group Designation

  0 the highest-priority source (the default) 1 a lowest-priority source

• Question 39:

  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
  D. Presentation Data Layer

• Question 40:

  Query Limits are used to manage Query environment in the repository for users and roles and can_________.

  A. Control runaway queries
  B. Limit Queries by maximum run time
  C. Control aggregation
  D. Control User Authentication
  E. Control Write Back Capabilities
  B. Limit Queries by maximum run time

  ---

  Query Limits. You can limit queries by the number of rows received, by maximum run time, and by restricting to particular time periods. You can also allow or disallow direct database requests or the Populate privilege. See figure below.