Oracle 1Z0-591 Online Practice Questions and Exam Preparation

Oracle 1Z0-591 Online Questions & Answers

• Question 101:

  Permissions for Presentation layer objects and Business layer objects that restrict users is configured in which software component?

  A. Oracle Enterprise Manager
  B. Oracle HTTP Server
  C. WebLogic Server Administration Component
  D. BI Administration Tool
  D. BI Administration Tool

  ---

  Oracle Business Intelligence Enterprise Edition (OBIEE) Security is managed through:

  a) BI Server Security Manager accessed through the BI Server Administration Tool.

  *

  Set permission to business model, tables, columns and subject areas

  *

  Specify filters to limit data accessible by users

  *

  Set authentication options

  b) BI Presentation administration accessed through Presentation Web Services.

  *

  Manage Web groups and users

  *

  Set Permissions for Web Catalog items

  *

  Manage privileges and rights given to groups and users

  *

  Control access to dashboards c) Catalog Manager.

  *

  Set permission for Web Catalog items (Dashboards and Dashboards pages)

• Question 102:

  What is the process in which there is redundancy of data to improve performance?

  A. Redundancy
  B. Normalization
  C. Denormalization
  D. Granularity
  E. Cardinality
  C. Denormalization

  ---

  Denormalization is the process of intentionally backing away from normalization to improve performance by suppressing join and permitting the use of star transformation technique. Denormalization should not be the first choice for improving performance and should only be used for fine tuning of a database for a particular application.

• Question 103:

  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
  B. Top - down planning

  ---

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

  Which two steps are needed to set up Failover support for an OBIEE deployment?

  A. Use Installer to affect Horizontal scale out of an existing instance
  B. Employ WebLogic Enterprise Edition, licensed separately C. Use Installer to set up separate single instances, then apply Horizontal scale out clustering
  D. Apply OBIEE Clustering option
  E. Leverage spare hardware capacity of single machine by using Vertical scale out option
  A. Use Installer to affect Horizontal scale out of an existing instance
  D. Apply OBIEE Clustering option

  ---

  Horizonal Scaleout of System Components

  *

  Used for adding additional managed servers (Java components) and system components to an existing cluster

  *

  Used for scalability and failover

  *

  Set up via the Universal Installer > Scale Out BI System option

• Question 105:

  Identify the reason why Oracle OLAP provides a favorable aggregation strategy.

  A. OLAP cubes eliminate the need for a large number of aggregate tables.
  B. OLAP cubes are stored outside of the database in highly optimized file structures.
  C. OLAP cubes can be easily transported from database to database.
  D. OLAP cubes can be queried by using SQL.
  D. OLAP cubes can be queried by using SQL.

  ---

  All metadata for cubes and dimensions is stored in the Oracle database and revealed in the data dictionary views, so that you can query the entire business model in SQL. Reference: Oracle OLAP User's Guide, What's New in Oracle OLAP?

• Question 106:

  Selecting the Manage Map Data link allows one to do which three of the following?

  A. Associate map layers to columns defined in the OBIEE metadata
  B. Create a new map layer
  C. Set the zoom level of an imported map
  D. Import images for use on maps
  A. Associate map layers to columns defined in the OBIEE metadata
  C. Set the zoom level of an imported map
  D. Import images for use on maps

  ---

  The Oracle BI Presentation Services Administration page provides the Manage Map Data link. This link displays the Manage Map Data page, where you can manage the logical and display versions of the data from various physical data sources. This defines the layers that content designers use when creating map views. The data that is available for managing maps and data is stored in Oracle Database as part of MapViewer. Using this page, you provide:

  *

  (A) Logical names to prevent any existing BI column mappings and map analyses from breaking because of changes to the physical data or to the data source.

  *

  Display names so that the geographic data is meaningful to end users.

  Note: Administering Maps Using Administration Pages For (C) 璴ayers, see 3-7 below.

  For (D) 璱mport images, see 11-12 below.

  To administer maps using Administration pages:

  Click OK when you have finished selecting layers that are appropriate for the subject area with which you are working.

  Click OK when you have finished editing the layer. You use this tab to associate layers with BI data. If you use the City column in multiple subject areas, then you must associate it with a layer for each subject area. The connection that you

  select for the main map can be different from the connection for the layers or images.

  Click OK when you have finished selecting main maps. Click OK when you have finished editing the map. Click OK when you have finished selecting images.

  Reference: Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition, Configuring Mapping and Spatial Information

• Question 107:

  When creating a new dimensional hierarchy in the BI Administration tool, right click the dimension, then select "New Object" What must be selected next?

  A. Logical Key
  B. Parent Level
  C. Child Level
  D. Dynamic Key
  B. Parent Level

  ---

  Steps to Create a Dimension Hierarchy - >Create a dimension object.Add a parent-level object.Add child-level objects.Determine number of elements.Specify level columns.Create level keys.Create a level-based measure.Create additional level-based measures.Create share measures.Create rank measures.Add measures to Presentation layer.Test share and rank measures.

• Question 108:

  What are the two ways to use the administration tool?

  A. It can be used to manage user password.
  B. The administration tool uses a set of wizards that support the design of calculations, expressions, dimensions, and so on.
  C. It can be used for versioning of the rpd.
  D. Administrator can use repository and session variables in a repository to streamline administrative tasks and dynamically modify metadata content to adjust to a changing data environment.
  C. It can be used for versioning of the rpd.
  D. Administrator can use repository and session variables in a repository to streamline administrative tasks and dynamically modify metadata content to adjust to a changing data environment.

  ---

  Note: The Administration tool is used to manage OBIEE server and have some capabilities to automate some repetitive tasks and principally his embedded tools.

  Oracle Business Intelligence Administration Tool is available only for Windows operating systems.

  The Administration Tool is a Windows application that allows the BI Server administrator to create and edit repositories.

  Repositories can be edited with the administration tool in either online or offline mode.

  The Administration Tool also includes a session manager and a cache manager which are available in online mode. The Cache Manager displays what queries have been cached and how frequently they have been accessed. You can also

  select and delete items

• Question 109:

  The WebLogic Console will allow you to perform which of the following functions in the BI Managed Server?

  A. Start and Stop BI Services
  B. Build Aggregate Queries
  C. Create Summary Tables
  D. Manage user logins
  A. Start and Stop BI Services

  ---

  Screenshot below.

  

• Question 110:

  Identify the two true statements about alias tables.

  A. Alias tables are set up to avoid triangular or circular joins.
  B. Alias tables are set up to include best practice naming conventions for physical table names.
  C. Alias tables are set up to create another physical copy of the data.
  D. Alias tables are set up to create a copy of the data with a filter applied to it.
  A. Alias tables are set up to avoid triangular or circular joins.
  B. Alias tables are set up to include best practice naming conventions for physical table names.

  ---

  It is a best practice to create aliases for all tables. Aliases are created in the Physical Layer of the repository. Some of the benefits of using aliases are given below:

  (A) * An alias is used to avoid circular joins and to configure self joins.

  *

  You can create a join relationship which is different than the actual foreign key relationship in the database. This helps in defining relationships to meet business model criteria.

  *

  Aliases can function in numerous ways to define business model e.g. a table can act both as a dimension and a fact using aliases.

  (B) * You can rename aliases to make physical and business model easier to understand.