Oracle 1Z0-591 Online Practice Questions and Exam Preparation

Oracle 1Z0-591 Online Questions & Answers

• Question 41:

  A derived measure is never used to_________.

  A. Calculate share measures
  B. Add two logical columns together
  C. Calculate a variance between two measures
  D. Calculate the rank dimension values
  E. Input data
  E. Input data

• Question 42:

  A customer needs to create a product share calculation. What are the two ways that they would get the revenue for all products to use in the denominator?

  A. Create a derived measure by using the addition function that adds each product value together.
  B. Create a derived measure based on Revenue that has the Level Total Product selected on the Level Tab of the Logical Column Dialog.
  C. Create a derived measure based on Revenue that has all the levels selected on the Level Tab of the Logical Column Dialog except Total Product.
  D. Create a derived metric by using the Expression Builder.
  A. Create a derived measure by using the addition function that adds each product value together.
  C. Create a derived measure based on Revenue that has all the levels selected on the Level Tab of the Logical Column Dialog except Total Product.

  ---

  Note: A level-based measure is a column whose values are always calculated to a specific level of aggregation.

  The calculation of this measure is independent of the query grain and used always the aggregation grain of the logical column.

  Level-based measures allow :

  *

  to return data at multiple levels of aggregation (the query grain and the level-based column grain) with one single query

  *

  to create share measures (percentage), that are calculated by taking some measure and dividing it by a level-based measure. For example, you can divide salesperson revenue by regional revenue to calculate the share of the regional revenue each salesperson generates.

  

  

• Question 43:

  What are the two methodologies that are followed within an OBIEE implementation?

  A. Do not use prototypes
  B. Use an iterative approach
  C. Start with a small model and then enhance the repository
  D. Start with a big repository and trim it down with the requirements
  B. Use an iterative approach
  C. Start with a small model and then enhance the repository

• Question 44:

  Which analysis features could be applied to provide interactive controls for end users?

  A. Column Selector
  B. Action Links
  C. Conditional Formatting
  D. Narrative View
  E. Greenbar Styling
  B. Action Links

  ---

  An action link is a link to an action that you have embedded in an analysis, dashboard page, scorecard objective, scorecard initiative, or KPI that, when clicked, runs an associated action.

• Question 45:

  When designing a Star Schema, which option does not apply?

  A. The facts are quantifiable.
  B. The fact has several foreign keys that are primary keys in the dimensional table
  C. Fact table is joined to the related dimensional tables.
  D. Dimensional tables are normalized.
  E. Dimensional tables have one attribute primary key as Product_ID for products.
  D. Dimensional tables are normalized.

  ---

  In a Star Schema the dimensional tables does not need to be normalized. A Snowflake Schema is a modified Star Schema that has normalized the dimensional tables.

• Question 46:

  An organization has its employees' names in an Employees table, and information about their jobs in a Jobs table.

  However, an organization's employees can have multiple jobs, and the same job can be performed by multiple employees. This situation would result in a many to-many relationship between the Employees and Jobs tables. How can the many to-many relationship issue be resolved?

  A. By modeling the many to many relationship in the business model
  B. By creating a bridge table that represents one employee doing one job, with several rows for an employee who has several jobs
  C. By creating the many to many join in the physical model
  D. By creating a logical table source (LTS) that joins the Employees and Jobs tables
  B. By creating a bridge table that represents one employee doing one job, with several rows for an employee who has several jobs

  ---

  When you need to model many-to-many relationships between dimension tables and fact tables, you can create a bridge table that resides between the fact and the dimension tables. A bridge table stores multiple records corresponding to that dimension. In the Administration Tool, General tab in the Logical Table dialog box contains a check box that you can select to specify that a table is a bridge table. A bridge table allows you to resolve many-to-many data relationships.

  Reference; OBI Server Administration Server Guide, Version 10.1, Identifying Bridge Tables

• Question 47:

  The administration tool is the developer's interface to the repository file. It allows the development of and changes to the metadata repository file. Which statement is true?

  A. Changes to the repository can only be carried out in offline mode.
  B. Multiple developers can work on one repository at the same time. Results can be merged later on.
  C. All aspects of security are being held in the repository file.
  D. Opening the rpd.file in online mode results in performance Issues for the application user.
  B. Multiple developers can work on one repository at the same time. Results can be merged later on.

  ---

  The Oracle BI repository development process adheres to the classic Software Configuration Management (SCM)process, which utilizes a three-way merge to manage concurrent development.

  The merge process involves three repositories:

  In a multiuser environment (MUDE), Developers check out the file and make changes locally. Then, these changes are automatically reconciled and merged into the master repository.

• Question 48:

  There are two aggregate tables that are available for query. How would they be mapped into the logical data model so queries can use them?

  A. By creating two new logical tables sources
  B. By opening the two logical Table Source dialog boxes and mapping the appropriate levels in the Content tab
  C. Both A and B
  D. By creating one new Logical Table Source
  B. By opening the two logical Table Source dialog boxes and mapping the appropriate levels in the Content tab

  ---

  B: Example:

  1. Configure the new source table to have the 'logical level' under the content set to 'Countries' (the summarized level)

  

  b

  2. Do the similiar setting for dimension table Now when user query the data at 'Counties' level, the query will be redirected to these summary table instead of the more detail fact table Note: Aggregate tables are Physical tables that store Aggregates of measures across multiple levels of a Hierarchy.

• Question 49:

  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
  A. Using NQSConfig.ini to manually edit the parameters
  D. Inspecting the cache reports

  ---

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

  Which option is used to enter the rank function when creating a new rank measure?

  A. Initialization Block
  B. Expression Builder
  C. Connection Pool
  D. Web Catalog
  B. Expression Builder

  ---

  Example (see step 4 and 5 below): Getting Top-N Sales Reps for Year and Year-1

  1.

  Under the "Business Model and Mapping" Layer, right click the "F1 Revenue" and select "New Object" -> "Logical Column..."

  2.

  In the "Logical Column" Window give for Name: Year Ago Revenue as seen below:

  3.

  Goto the "Column Source" Tab and select "Derived from existing columns using an expression" radio button then click on the "Edit Expression" icon.

  4.

  Enter the following expression in the "Expression Builder" Window by selecting "Functions" in the "Category:" list, "Time Series Functions" in the "Functions:" list then "Ago" "Time Series Functions:" section.

  5.

  Select the "<>" in the "Ago( )" function, then select "Logical Tables" in the "Category:" list, "F1 Revenue" in the "Logical Tables:" list, then double click the "Revenue" in the "Columns:" list. Etc.