The WebLogic Console will allow you to perform which of the following functions in the BI Managed Server?

• A.Start and Stop BI Services
• B.Build Aggregate Queries
• C.Create Summary Tables
• D.Manage user logins

Correct Answer: A

Screenshot below.

Comment: *

Name: *

Email: *

Verification: *

Use of the Enterprise Install option is recommended for which three options?

• A.Multiple instances on a single computer
• B.Scale out for High Availability and Failover
• C.Support for high security requirements
• D.Evaluation of end user functionality
• E.Single users working on a single computer

Comment: *

Name: *

Email: *

Verification: *

One of the most common uses of Dynamic Repository Variables is to setup filters for use in reporting. Which variable below is a valid example of a Dynamic Repository Variable?

• A.Year
• B.Month
• C.Quarter
• D.CurrentMonth

Correct Answer: D

CurrentMonth can be calculated by a sql statement.
Note:
REPOSITORY VARIABLE(DYNAMIC)
*
Initialized when BI server is started
*
Assigned value dynamically based on the result of a query
*
Value is dependent of the sql provided in Initialization Block
Create a dynamic variable and provide a Name and Default Initializer.Create a new initialization block by clicking on the New button in the above screen.

http://www.adivaconsulting.com/images/blog/OBIEE_Variable_files/image003.jpg Provide Intialization Block variable Name

http://www.adivaconsulting.com/images/blog/OBIEE_Variable_files/image004.jpg
Click on "Edit Data Source" button and provide the sql to be used for the variable, e.g.
select lower(sys_context('USERENV','SESSION_USER'))|| '@'|| lower(sys_context('USERENV','DB_NAME'))
from dual;

Comment: *

Name: *

Email: *

Verification: *

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

Correct Answer: B,C

Explanation

Comment: *

Name: *

Email: *

Verification: *

Security Manager is used for______.

• A.Setting permissions for particular users or application roles
• B.Setting permissions for individual objects in the Presentation Layer
• C.Setting up new Roles and Groups
• D.Setting up new Application Roles

Correct Answer: A

Security Manager - is used to setup users, groups, synchronize LDAP users and Groups, set access rights for Objects (tables, columns) and to control over when and what data a user can access.

http://onlineappsdba.com/wp-content/uploads/2008/09/bi_admin_8.JPG

http://onlineappsdba.com/wp-content/uploads/2008/09/bi_admin_9.JPG
Note: When you open the administration tool, you can reach the security manager by the Menu : Manage > Security

http://gerardnico.com/wiki/lib/exe/fetch.php?hash=29d18d&media=http%3A%2F%2Fdownload.ora cle.com%2Fdocs%2Fcd%2FE14571_01%2Fbi.1111%2Fe10543%2Fimg%2Fadmintool2.gif

Comment: *

Name: *

Email: *

Verification: *