Oracle Oracle Certifications 1Z0-591 Questions & Answers

• Question 31:

  Identify the correct mode to use when opening the web catalog while performing security settings modifications and migrations.

  A. Online

  B. Offline

  C. Managed

  D. UnManaged

  Correct Answer: A

  Explanation: In online mode, you connect to a catalog on a running web server. In this mode your permissions are applied, you can select a locale, and you can see the effects of any localization on the catalog. You can see only those objects

  for which you have the appropriate permissions. Both Presentation Services and the web server must be running for you to open catalogs in online mode.

  Use online mode when you want to make minor incremental changes or additions to the catalog, such as changes to permissions, updates to a single object, or migration of new objects to a production environment.

  Note:

  *

  You can open a catalog in one of two modes -- online or offline. Both modes can operate against an actual production catalog, with no need for any downtime.

  *

  Repository changes can be done in either online or offline mode. Online mode is when BI Server is actively reading the repository file (when a user is logged in). Offline is when BI Server is idle. Best practice is to develop in Offline mode. Minor changes can be made when in online mode.

• Question 32:

  Which component is responsible for determining the device that receives the alerts for a given user account?

  A. Dashboard

  B. iBot

  C. Alerts

  D. Delivery Profiles

  Correct Answer: B

  Explanation: Intelligent Bursting and Output Tool (iBot).

  iBot is an utility available in OBIEE which is used for reports scheduling as well as Alerts sent to the required recipients on different web accessible / communication devices.

• Question 33:

  The three metadata layers are an important concept of the BI Server. Which statement is incorrect?

  A. The physical layer defines the objects and relationships that the Oracle BI Server needs to write native queries against each physical data source.

  B. Separating the logical of the application from the physical model provides the ability to federate multiple physical sources to the same logical object.

  C. The model and mapping layer define the business or logical model of the data. This layer determines the analytic behavior seen by users.

  D. The presentation layer defines the relationship that is needed to create the DML.

  Correct Answer: D

  Explanation: The relationship is defined at the model and mapping layer.

  Note:

  At the highest level, an OBIEE Metadata Repository includes three layers of information:

  1.

  First, a Physical layer is defined. The metadata layer identifies the source data.

  2.Second, a Business Model and Mapping layer is defined. This metadata layer organizes the physical layer into logical categories and records the appropriate metadata for access to the source data. 3.Finally, the Presentation layer is defined. This metadata layer exposes the business model entities for end-user access.

• Question 34:

  Which two options are included in Oracle BI Server cache management techniques?

  A. Using NQSConfig.ini to manually edit the parameters

  B. Scheduling Server password

  C. Maximum Number of Rows to Download to Excel

  D. Inspecting the cache reports

  E. Manage access to Subject Areas

  Correct Answer: AD

  Explanation: A: Much of the configuration of OBI that used to be done in the NQSConfig.ini files can now be done using this front end console, which in turns updates the NQSConfig.ini file. Things in the NQSConfig.ini file that are set by EM are noted in the file with '# This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager'. Some things that needs to be setup manually in the NQSConfig.ini file are:

  1. Usage Tracking

  2. Dynamic Libraries

  3. Query Optimization Flags

  4. MDX Member Name Cache Section (SAP BW)

  5. More specific General Settings where EM doesn't contain the level of detail required

  D: Cache Management Techniques include ?Inspecting the cache reports ?Configuring the cache parameters ?Setting caching and cache persistence for tables ?Using the Cache Manager ?Inspecting SQL for cache entries ?Modifying the Cache Manager column display ?Purging the cache entries manually using the Cache Manager ?Purging the cache entries automatically ?Using event polling tables ?Seeding the cache

• Question 35:

  To add multiple sources to on existing logical table dimension in the Business Model and Mapping layer, the source of the data must first exist in which option?

  A. Presentation Layer

  B. Business Aggregate Layer

  C. Physical Layer

  D. Web Catalog

  Correct Answer: C

  Note:

  At the highest level, an OBIEE Metadata Repository includes three layers of information:

  1.

  First, a Physical layer is defined. The metadata layer identifies the source data.

  2.Second, a Business Model and Mapping layer is defined. This metadata layer organizes the physical layer into logical categories and records the appropriate metadata for access to the source data. 3.Finally, the Presentation layer is defined. This metadata layer exposes the business model entities for end-user access.

• Question 36:

  A customer wants to analyze the efficiency of his/her order fulfillment process. If the customer has a dimensional model, which option is the fact table?

  A. Stores

  B. Orders

  C. Products

  D. Time

  Correct Answer: B

• Question 37:

  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

  Correct Answer: B

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

• Question 38:

  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

  Correct Answer: A

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

  When adding a new dimension to an existing logical table, what is the significance of the Logical Level setting in the Logical Table Source properties?

  A. It defines the granularity of the dimension.

  B. It determines the actual value of the dimension.

  C. It creates a new session variable.

  D. It creates a foreign key relationship.

  Correct Answer: A

  Explanation: OBIEE - Grain (Level of summarization) Grain definition in the context of OBIEE. The following list describes the different grains in navigating a query:

  *

  Aggregation grain. The grain of the aggregate source of from a level based metrics

  *

  Query grain. The grain of the request.

  *

  Time Series grain. The grain at which the time series function aggregation is requested.

  *

  Storage grain. The query in the example can be computed from daily sales or from monthly sales, or from quarterly sales.

  Note:

  The aggregation grain is defined in the content tab of the logical table source. When the query grain match the aggregation grain of a logical table source, this one is used to create the physical query.

  

• Question 40:

  If Security attributes conflict, what happens?

  A. The user or application role is granted the minimum security attribute

  B. The user or application role is granted the maximum security attribute

  C. The user or application role is granted No security attribute

  D. The user or application role is granted the Fully Restrictive security attribute

  Correct Answer: A

  Explanation: If security attributes conflict, a user or group is granted the least restrictive security attribute.