Oracle 1Z0-591 Online Practice Questions and Exam Preparation

Oracle 1Z0-591 Online Questions & Answers

• Question 1:

  The Consistency Checker checks______.

  A. The validity of objects outside the metadata using the connection
  B. Mappings to the physical objects
  C. For objects deleted from the database
  D. Syntax errors in derived logical columns
  B. Mappings to the physical objects

  ---

  Consistency check is one of the process to check whether a repository is yielding proper results in Answer reports. It checks whether;* All logical columns are mapped correctly to physical columns (B).* All logical dimension tables have a logical key.* There are at least two logical tables in the business model; one is a logical fact table, the other is logical dimension table with join condition.* There are no circular logical join relationships.* A presentation catalog exists for the business model.

• Question 2:

  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.
  A. It defines the granularity of the dimension.

  ---

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

  Which language is used by OBIEE to query Essbase?

  A. SQL
  B. LINQ
  C. MDX
  D. DMX
  C. MDX

  ---

  The Essbase cube looks just like any other relational star schema in my Presentation Layer, however when it is queried Oracle BI Server will issue MDX queries against a multi-dimensional data source, rather than an SQL query against a relational star schema.

• Question 4:

  The Time Dimension hierarchy is a good example of a__________.

  A. Level-based Time Dimension hierarchy
  B. Ragged Hierarchy
  C. Skip Level Hierarchy
  D. Value-based Hierarchy
  A. Level-based Time Dimension hierarchy

  ---

  Level-based Hierarchy Level-based hierarchy is the first type of hierarchy in OBIEE. Consists of an ordered set of two or more levels. For example, a Time hierarchy might have three levels for Year, Quarter, and Month. Level-based hierarchies can also contain parent-child relationships.

  Dimension hierarchy levels allow :

  *

  to perform aggregate navigation,

  *

  to configure level-based measure calculations,

  *

  users from Dashboard and Answers to drill down from one parent to a child level.

  Special type of level-based dimension are supported:

  *

  Unbalanced (or ragged) and Skip-level hierarchy

  *

  time dimension to provides special functionality for modeling time series data.

• Question 5:

  What are the two disadvantages of implementing Query Caching?

  A. Reduction in BI server processing time
  B. Cache results being old
  C. Storage space for cache
  D. Increased network traffic
  E. Needs a lot of administrators' time
  B. Cache results being old
  C. Storage space for cache

  ---

  B: The problem with caching of any kind is how to deal with stale data. How you decide to deal with this depends on how time critical your business intelligence queries happen to be. OBIEE provides a wide variety of mechanisms for dealing with stale data. The cache can be purged automatically at intervals. Caching can be enabled selectively for individual physical tables, so that data in a frequently updated table is never cached. OBIEE provides a set of ODBC procedures that can be called when ETL processes complete to programmatically purge designated tables. But, by far the best way to selectively purge the cache is to use an event polling table. This table is populated by the client database whenever changes are made to any table (by an ETL process for a data warehouse or by a table-based trigger for an OLTP database). At specified intervals the BI Server polls this event polling table and deletes from its cache any query results that are dependent on the changed data.

• Question 6:

  Which of the following native features of Essbase are not supported in OBIEE 11g?

  A. Member Alias
  B. Alternate Hierarchies
  C. Dynamic Time Series
  D. Parent/Child-based Hierarchies
  C. Dynamic Time Series

  ---

  If you want to create a dynamic time-series reference such as the value of a measure as at this time last year, or over the past three months, or year-to-date, you can use one of the OBIEE time-series functions (AGO, PERIODROLLING, TODATE) to provide an offset value for a measure.

  Figure:

  

  Note: OBIEE 11g offered a bunch of improvements that were particularly aimed at Essbase, and other OLAP server, customers; the new hierarchical columns feature brought proper OLAP analysis to OBIEE, and coupled with OLAP-oriented

  features such as hierarchical prompts and selection steps, made OBIEE 11g a much more conducive environment for Essbase users.

  There's much better support for Essbase-native features such as value-based hierarchies, alternate hierarchies, multiple alias tables, UDAs and other Essbase artifacts, and the value-based hierarchy feature in particular is very welcome as it

  can avoid the need to completely re-import your Essbase database if your outline gains additional hierarchy levels.

  So coupled with the new and improved visualization capabilities in OBIEE 11g, including maps, scorecards, improved dashboard controls, the whole new UI, improved BI Publisher and so on, there's a lot to recommend OBIEE 11g to users of

  the "legacy" Hyperion tools looking for a bit of a refresh of their BI environment.

• Question 7:

  When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard, which two statements are true?

  A. The analyst must first write DML (Data Manipulation Language) scripts to create the aggregate table.
  B. The Aggregate Persistence Wizard enables you to automate the creation of physical aggregate tables and their corresponding objects in the repository.
  C. Job Manager can be used to run the Aggregate Persistence script.
  D. The Extraction Transformation and Loading process creates the aggregate tables.
  B. The Aggregate Persistence Wizard enables you to automate the creation of physical aggregate tables and their corresponding objects in the repository.
  C. Job Manager can be used to run the Aggregate Persistence script.

  ---

  B: The Aggregate Persistence Wizard automates the creation and initial population of aggregates, persists them in a back-end database and configures the BI Server metadata layer so that they're used when appropriate.

  C: The wizard then shows me a preview of the script it's going to generate, and asks me if I want to create any more summaries. Here's how the preview script looks ?note that it's not SQL, it's a script language that the BI Server understands and uses as the specification for an aggregation job, which it then turns into separate CREATE TABLE, INSERT ... SELECT and so on SQL statements, "optimized" for the particular back-end database platform.

  Script example:

  "ag_Items"

  for "Seminar - Complete"."Items"("Quantity")

  at levels ("Seminar - Complete"."Customerdim"."State", "Seminar - Complete"."Productdim"."Category", "Seminar - Complete"."Timedim"."Year") using connection pool "custdw"."CUSTDW_Pool"

  in "custdw".."CUSTDW";

• Question 8:

  Pre Deployment sign-off is a milestone for a OBIEE implementation and is based on successful completion of certain tasks. Which option is not one of them?

  A. Test Environment
  B. System Testing
  C. Performance Tuning
  D. Project initiation and resourcing
  E. Data Validation / Verification
  D. Project initiation and resourcing

• Question 9:

  Which variable does not use initialization blocks to initialize its values?

  A. Static Repository Variable
  B. Dynamic Repository Variable
  C. System Variable
  D. Non System Variable
  A. Static Repository Variable

  ---

  The value of a static repository value is initialized in the Variable dialog box. This value persists, and does not change until an Oracle BI Administrator decides to change it.

• Question 10:

  Which of the following characteristics pertain to a "ragged" hierarchy?

  A. It can only be stored in an XML structure.
  B. A branch of the hierarchy may have a different number of levels than other branches.
  C. All values can have a maximum of six levels.
  D. It creates multiple levels of hierarchy in the database table.
  B. A branch of the hierarchy may have a different number of levels than other branches.

  ---

  Ragged Hierarchies are hierarchies where some routes down the hierarchy are longer than others; for example, you may have an organizational hierarchy for salespeople where the overall boss has two assistant managers, one of them works on their own and another has three sales managers under them; some of those sales manager may have sales staff under them, and some sales staff may have trainees under them.