Oracle Business Intelligence Foundation Suite 11g Essentials
Question No: 61
If you have a database with four aggregate tables, how should the repository be configured to take advantage of the aggregates?
By creating four new logical tables sources
By creating four new logical table sources and choosing each dimension#39;s level of aggregation in the Content tab
By creating four new logical table sources and using the Fragmentation content to specify the aggregation levels
By creating four new logical table sources and using the quot;wherequot; section of the Content tab to specify the aggregation levels
Explanation: Content Tab Aggregation Content
You can define the aggregation (ie the group by) of:
by hierarchy level by logical column
It helps you to define an aggregate navigation
Note: logical table source
Logical table sources define the mappings from a single logical table to one or more physical tables. A logicaltable contains one or more logical table source. The mapping between physical columns and logical columns are done in this element.
The definition of the logical table source is used:
->to specify transformations/calculations (in the column mapping tab),
->to enable aggregate navigation and fragmentation (in the content tab) The Content tab of the Logical Table Source is used to define :
->any aggregate table content definitions (specify the grain of the physical tables),
->fragmented table definitions for the source,
->and WHERE clauses (if you want to limit the number of rows returned).
Question No: 62
Which of the following native features of Essbase are not supported in OBIEE 11g?
Dynamic Time Series
Explanation: 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.
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
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 No: 63
A customer would like to create a change and a % Change for Revenue at the same time. How would they accomplish this?
Using the Expression Builder
Using the Calculation Wizard
Defining them in the physical data model
Defining them in the Presentation Layer
Answer: B Explanation:
After creating your base metrics, try using the Calculation Wizard to automate the process of creating time-series metrics or comparison metrics such as: Change, Percent Change, Index, and Percent. The Wizard may save you many hours of time and frustration, especially if you have to create more than a handful of these metrics. In addition, the Wizard allows you to include customized logic to handle nulls in the base metrics. You may refer to the Oracle documentation for further detail.
Question No: 64
When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard, which two statements are true?
The analyst must first write DML (Data Manipulation Language) scripts to create the aggregate table.
The Aggregate Persistence Wizard enables you to automate the creation of physical
aggregate tables and their corresponding objects in the repository.
Job Manager can be used to run the Aggregate Persistence script.
The Extraction Transformation and Loading process creates the aggregate tables.
Explanation: 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: quot;ag_Itemsquot;
for quot;Seminar – Completequot;.quot;Itemsquot;(quot;Quantityquot;)
at levels (quot;Seminar – Completequot;.quot;Customerdimquot;.quot;Statequot;, quot;Seminar – Completequot;.quot;Productdimquot;.quot;Categoryquot;, quot;Seminar – Completequot;.quot;Timedimquot;.quot;Yearquot;) using connection pool quot;custdwquot;.quot;CUSTDW_Poolquot;
Question No: 65
Which three options apply to FMW Application Roles?
Provide an indirection between LDAP groups and BI roles
Can be exported / moved between FMW11g environments
Are created and managed by using the WLS Admin Console and FMW Control
Can be created by using BI Administrator Client and quot;pushedquot; to WLS Admin Console
Secures RPD permissions but NOT Web Catalog (webcat) permissions
Question No: 66
How do you get the BI plug-in for MS Office?
By contacting the administrator
By downloading it from the BI Server
By downloading it from the Database Server
By downloading it from Microsoft Server
Explanation: Download and installation of the client
The client install executable is available for download from the More Products menu in Oracle BI Interactive Dashboards and Oracle BI Answers.
See picture below.
Question No: 67
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?
By creating two new logical tables sources
By opening the two logical Table Source dialog boxes and mapping the appropriate levels in the Content tab
Both A and B
By creating one new Logical Table Source
Explanation: B: Example:
Configure the new source table to have the #39;logical level#39; under the content set to
#39;Countries#39; (the summarized level)
Do the similiar setting for dimension table
Now when user query the data at #39;Counties#39; 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 No: 68
Which Oracle Partner is the supplier of map-based content to provide background maps, boundary information, and points of interest?
Question No: 69
The Consistency Checker checks .
The validity of objects outside the metadata using the connection
Mappings to the physical objects
For objects deleted from the database
Syntax errors in derived logical columns
Explanation: 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 No: 70
A company#39;s Database Administrator has divided the region table into two tables so that the region quot;Westquot; is in one table and all the other regions are in another single table. What kind of partition is being used?
Explanation: 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.
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|