Oracle Business Intelligence Foundation Suite 11g Essentials
Question No: 41
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?
Project initiation and resourcing
Data Validation / Verification
Question No: 42
How will you model a Type II Slowly-Changing Dimension?
Add an additional column to the dimension table to capture a version of change
Overwrite an existing dimension table record with the changed record
Add a new row to the dimension table with a new key for the changed record
Explanation: 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 No: 43
Cache in OBIEE is used to . Select the two correct answers.
improve performance of Dashboards and Analysis
decrease query response time
improve Analysis data quality
eliminate Write Back Capabilities
create Aggregate tables
Explanation: Decrease query response time which will improve performance for Dashboards and Analysis.
Question No: 44
A customer frequently queries multiple dimension tables without a measure. What needs to be defined in the presentation layer?
Implicit Fact Column
Logical Column Name
Custom Display Name
Setting an Implicit Fact Column in the Subject Area
For each subject area in the Presentation layer, you can set an implicit fact column. The implicit fact column is added to a query when it contains columns from two or more dimension tables and no measures. The column is not visible in the results. It is used
to specify a default join path between dimension tables when there are several possible alternatives or contexts.
Question No: 45
A customer needs to do a cross database join between two tables where, one of the tables has a small number of values and the other has a large number of values. How can you optimize the way the BI Server processes the query?
By specifying a one-to-many join between the tables with the small and large numbers of values
By specifying a driving table
By specifying a many to one join between the tables with the small and large numbers of values
By creating your logical join by using the Joins Manager
By creating your joins by using the Business Model Diagram
Explanation: You can specify a Driving table parameter in a complex join.
Driving tables are for use in optimizing the manner in which the Oracle BI Server processes cross-database joins when one table is very small and the other table is very large.
The BI Server will query the driving table (the small one) and will get a list of values. The BI Server will then generate a second SQL using a parameterized IN list with the values from the first query.
Specifying driving tables leads to query optimization only when the number of rows being selected from the driving table is much smaller than the number of rows in the table to which it is being joined.
Question No: 46
Why is it necessary to join multiple source tables to a single dimension?
Because transactional source systems are often denormalized
Because transactional source systems are often normalized
Because a single source table often contains all the dimensions needed
Because the dimensions tables are built in the transactional systems
Explanation: Denormalized data in the transactional system could be divided into different tables to increase performance.
Question No: 47
Query Limits are used to manage Query environment in the repository for users and roles and can .
Control runaway queries
Limit Queries by maximum run time
Control User Authentication
Control Write Back Capabilities
Explanation: Query Limits. You can limit queries by the number of rows received, by maximum run time, and by restricting to particular time periods. You can also allow or disallow direct database requests or the Populate privilege.
See figure below.
Question No: 48
A derived measure is never used to .
Calculate share measures
Add two logical columns together
Calculate a variance between two measures
Calculate the rank dimension values
Question No: 49
What are the two types of Session Variables?
Explanation: There are two types of session variables:
System – A session variable that the Oracle BI Server and Oracle BI Presentation Services use for specific purposes.
System session variables have reserved names that cannot be used for other kinds of variables (such as static or dynamic repository variables and non-system session variables).
Non-system – A system variable that the administrator creates and names. For example, the administrator might create a SalesRegion non-system variable that initializes the name of a user#39;s sales region.
The administrator creates non-system session variables using the Oracle BI Administration Tool.
Note: Session Variables
A session variable is a variable that is initialized at login time for each user. When a user begins a session, the Oracle BI Server creates a new instance of a session variable and initializes it.
There are as many instances of a session variable as there are active sessions on the Oracle BI Server. Each instance of a session variable could be initialized to a different value.
Question No: 50
Content that is saved in personal and shared folders can be browsed by using which view?
New -gt; Analysis
Explanation: The Catalog Manager workspace enables you to view and work with catalog objects. It displays the following folders for an open catalog:
The shared folder- Contains content that is shared among catalog users. This includes the preconfigured dashboards and analyses that are distributed with prebuilt applications, and other objects such as shared filters.
The system folder – Contains administrative elements of Presentation Services. Some of these elements are distributed with the product, and others are configured by you as the administrator, such as privileges. Avoid modifying any files in this folder. Presentation Services uses these files internally and modifying them might cause unexpected results.
The users folder – Contains content that catalog users with the appropriate permissions have saved to their personal folders, such as individual analyses.
Reference: Oracle Fusion Middleware System Administrator#39;s Guide for Oracle Business Intelligence Enterprise Edition, What Does the Catalog Manager Workspace Look Like?
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|