Correct Answer: ACD

Explanation: WLS Embedded LDAP Server

*By default, OBIEE 11g users and groups are now held in the WLS LDAP Server (C)

-More robust directory for storing user details

-Recommended for >1000 users

*

WLS Admin Server Console now used for creating and maintaining users (A)

*

BI Server "outsources" all authentication, authorization to FMW11g (not B)

*

BI Administration tool now used for subject area and row-level security, connection pool passwords only (D) ?WLS LDAP Server can be "swapped out" for alternative directories (MS AD etc)

Correct Answer: BCD

Explanation: B: BI Server Security Manager accessed through the BI Server Administration Tool.

*

Set permission to business model, tables, columns and subject areas

*

Specify filters to limit data accessible by users

*

Set authentication options

C: Enable the SSO through the FMW Control.

D: You have three methods to start the managed server:

*

with the console (recommended)

*

with FMW control

*

with the command line.

Correct Answer: D

Correct Answer: C

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.

Correct Answer: AB

Explanation: It is a best practice to create aliases for all tables. Aliases are created in the Physical Layer of the repository. Some of the benefits of using aliases are given below:

(A) * An alias is used to avoid circular joins and to configure self joins.

*

You can create a join relationship which is different than the actual foreign key relationship in the database. This helps in defining relationships to meet business model criteria.

*

Aliases can function in numerous ways to define business model e.g. a table can act both as a dimension and a fact using aliases.

(B) * You can rename aliases to make physical and business model easier to understand.

Correct Answer: A

Explanation: The principal connection to an OBI Server inside the Oracle BI System is made through an Odbc Connection.

OBI Server can handle multiple repository but you can connect to only one at the same time by DSN Odbc Connection. Therefore, you must set up an ODBC connection for each repository.

Correct Answer: ACD

Explanation: Oracle BI Cluster Server Components

*

Oracle Business Intelligence Cluster Controller: The Cluster Controller determines which BI Server works in the cluster. It monitors the operation of servers in the cluster. The Cluster Controller is deployed in active-passive mode.

*

Clustered BI Servers: The BI Cluster Server feature supports up to 16 BI Servers in a network domain to act as a single server. BI Servers in the cluster share requests from multiple Oracle BI clients.

*

Master BI Server: A clustered Oracle Business Intelligence Server is designated as the Master BI Server. The Oracle Business Intelligence Administration Tool connects to the master BI Server for online repository changes.

*

Cluster Manager: The Cluster Manager is available in the Administration Tool when a repository is opened in online mode. The Cluster Manager enables Oracle BI Server clustered instances.

Correct Answer: C

Explanation: Dynamic Repository Variables:

You initialize dynamic repository variables in the same way as static variables, but the values are refreshed by data returned from queries. When defining a dynamic repository variable, you will create an initialization block or use a pre-existing

one that contains a SQL query. You will also set up a schedule that the Oracle BI Server will follow to execute the query and periodically refresh the value of the variable.

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

Correct Answer: B

Explanation: Before you can run Oracle Business Intelligence 11g Installer, you must first create

required Oracle Business Intelligence schemas in an unhardened database. You use a tool called the Repository Creation Utility (RCU) to create these schemas with the appropriate permissions and data.

Reference: Installation Guide for Oracle Business Intelligence, Additional Oracle Business Intelligence 11g Installer Requirements

Correct Answer: AC

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.