Oracle 1Z0-591 Online Practice Questions and Exam Preparation

Oracle 1Z0-591 Online Questions & Answers

• Question 11:

  Under what circumstances would you model within the BI environment to include transactional data directly?

  A. When the customer needs near real-time data to support decision making in a fast changing environment
  B. When the customer is not prepared to spend budget on data-warehousing
  C. When the complexity of operational schema does not allow modeling in the BI repository
  D. When it is not possible to query against a transactional system
  A. When the customer needs near real-time data to support decision making in a fast changing environment

• Question 12:

  Which installation option is used to install into an existing Fusion Middleware Home?

  A. Software Only Install
  B. Simple Install
  C. Enterprise Install
  D. Cannot install into an existing Fusion Middleware Home
  A. Software Only Install

  ---

  The Software Only Install type installs the Oracle Business Intelligence software binary files in an Oracle home for later configuration as part of a Fusion Middleware deployment.

• Question 13:

  A company's Database Administrator has divided the region table into two tables so that the region "West" is in one table and all the other regions are in another single table. What kind of partition is being used?

  A. Fact-based
  B. Time-based
  C. Mixed
  D. Complex
  D. Complex

  ---

  You have three sort of fragmentation:

  Fact-based / Dimension-based fragmentation Content-based / Value-based fragmentation Level-based fragmentation / aggregate navigation You can combine the techniques above to construct powerful design that are known as Complex partitioning / fragmentation. When you fragment a dimension, you are automatically in a complex fragmentation.

• Question 14:

  How will you model a Type II Slowly-Changing Dimension?

  A. Add an additional column to the dimension table to capture a version of change
  B. Overwrite an existing dimension table record with the changed record
  C. Add a new row to the dimension table with a new key for the changed record
  D. Do Nothing
  C. Add a new row to the dimension table with a new key for the changed record

  ---

  Dimensional Modeling - Slowly Changing Dimensions

  *

  Type 1 - Overwrite Original Value

  A change does not require tracking

  *

  Type 2 - Add a new record

  With Type II SCD, a new version of the dimension record (row) is created, and the existing version is marked as history.

  Each row does not correspond to a different instance of an entity but a different "state", a "snapshot" of the instance at a point in time.

  Note: Tracking changes in dimension is referred in datawarehousing as slowly changing dimensions.

  In the source system a lot of changes are daily made :

  new customers are added,

  addresses are modified,

  new regional hierarchies are implemented,

  or simply the product descriptions and packaging change.

  These sorts of changes need to be reflected in the dimension tables and in several cases, the history of the changes also needs to be tracked.

  By remembering history, we are then able to look at historical data and compare it to their current situation.

• Question 15:

  When creating a Security Realm in the WebLogic Console, which object is created?

  A. Groups
  B. Row Level Filters
  C. Server Password
  D. Single Sign On
  A. Groups

  ---

  Security Realms are an Oracle Platform Security Services concept and bring together sets of users, groups, providers and so on for a WebLogic domain.

• Question 16:

  The ODBC DSN is never used for _______.

  A. Initial import of the physical layer metadata on a Windows server
  B. Query execution and data access on a Windows server
  C. Initial import of the physical layer metadata, query execution, and data access on a Windows Server
  D. Changing passwords
  E. Comparing RPDs
  E. Comparing RPDs

  ---

  You do not use ODBC DSN to compare repositories.

  Note: When an ODBC based application connects to a database, it connects to a logical name, the Data Source Name (DSN), which identifies the datasource to which it wants to connect.

  Some external repository of configuration information holds the various DSN values that are available, together with the necessary configuration and control information needed by the ODBC driver to establish a connection and manage usage

  of the data source. The DSN (data source name) is a data structure that contains the information about a specific data source (database, ...), typically used by an ODBC driver to be able to connect to it.

  The DSN contains information about the data source such as:

  the name,

  the directory,

  and the driver.

  On Windows, the DSN also specifies the ODBC driver to be used to access the database.

• Question 17:

  An organization has re-implemented one of its systems but has not moved history. One database has data for all years up to 2010 and the other has data for years from 2011 to the present. The organization needs data from the years 2010

  and 2011 on a single report.

  How can you model this in the RPD?

  A. By creating two Logical Fact Tables for each database
  B. By creating joins in the physical model so it looks like a single table
  C. By creating two logical table sources, that specify in Content tab using the Fragmentation content areas to specify the years for each source
  D. By creating two logical table sources and checking the "This Source should be combined with other sources at this level" box leaving the Fragmentation content area blank.
  E. By creating one logical table sources and checking the "This Source should be combined with other sources at this level" box
  C. By creating two logical table sources, that specify in Content tab using the Fragmentation content areas to specify the years for each source

  ---

  Note: This source should be combined with other sources at this level (check box) Description: Check this box when data sources at the same level of aggregation do not contain overlapping information. In this situation, all sources must be combined to get a complete picture of information at this level of aggregation.

  Note 2: To use a source correctly, the Analytics Server has to know what each source contains in terms of the business model. Therefore, you need to define aggregation content for each logical table source of a fact table. The aggregation content rule defines at what level of granularity the data is stored in this fact table. Use the Content tab of the Logical Table Source dialog box to define any aggregate table content definitions, fragmented table definitions for the source, and Where clauses (if you want to limit the number of rows returned).

  Reference: Siebel Business Analytics Server Administration Guide > Creating and Administering the Business Model and Mapping Layer in a Repository > Creating and Administering Logical Table Sources (Mappings) > Defining Content of Logical Table Sources

• Question 18:

  Which option describes how OBIEE natively integrates with HFM?

  A. Through EPM Analytic Data Model (ADM) connectivity
  B. Direct relational database access
  C. Through Essbase connectivity
  D. OBIEE does not support HFM integration
  A. Through EPM Analytic Data Model (ADM) connectivity

  ---

  BI EE uses the ADM driver to extract the data from HFM.

  Note: HFM (Hyperion Financial Management)

  Example:

  I EE connects to HFM through JavaHost. So, the setup for configuring the connectivity is to basically make the EPM environment variables available for access to BI EE. Before making the changes, there are a couple of things to be aware of

  1.

  Ensure that DCOM is enabled on the BI Server machine. This is needed for HFM client to work/connect properly with HFM Server.

  2.

  Ensure that HFM Client is installed.

  The above assumes EPM 11.1.2.x version. If you are on Hyperion 9.3.3, then you need to have the ADM drivers installed manually. All of this is documented clearly. So, rather than re-iterating that i will just point to the link here. Ensure that you follow all the steps mentioned in the docs else you will have issues in the connectivity. Once all the pre- requisite steps are done, we start off with the metadata import process.

  

• Question 19:

  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
  B. The Repository
  C. NQSConfig.ini File

  ---

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

  What is the first step when creating an Aggregate table in the OBI repository?

  A. Test the Aggregate table by using Analysis
  B. Specify the Fact table that you want to aggregate
  C. Use Job Manager to run the Aggregate script
  D. Create a dedicated Connection Pool
  B. Specify the Fact table that you want to aggregate

  ---

  Steps for Creating Aggregate Tables in OBIEE

  1. Create all Dimension Tables, Fact Tables and Hierarchies, which are required to be aggregated.

  2. Go to Tools郩tilities (from Administration tool menu bar), a dialog box will pop up with all available utilities.

  3. Select Aggregate Persistence Wizard, and then click Execute Button.

  4. Now Select appropriate path where you need to generate Aggregate Table SQL. Note : Click Generate DDL file for first time generation of Aggregate Table Click Next, to move to next page (Select Business Model and Measure Page) In

  Select Business Model and Measure Page, Select Appropriate Business Model and then select associated Fact / Measure.

  

  Etc.