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

OBIEE default security model stores security Information such as user names and password combinations for accessing an external system such as Active Directory. It is stored in the____________.

• A.Policy Store
• B.Credential Store
• C.Identity Store
• D.Person Store

Correct Answer: C

Identity Store: It is directory server to perform the authentication. It contains user name , password and groups membership information .When a user name and password combination is entered at log in, the authentication provider searches the identity store to verify the credentials provided. See figure below.

http://debaatobiee.files.wordpress.com/2011/02/obiee-11g-security-policy-revised1.png

Comment: *

Name: *

Email: *

Verification: *

There is a logical fact table that contains Item number, store, time, and revenue. How would you add Number of items sold?

• A.By creating a derived measure on the logical columnItem number and using the count Function
• B.By creating a derived measure on the logical column item number and usingthe count distinct function
• C.By creating a derived measure based on the physical column item number and changing theaggregation method to count
• D.By creatinga derived metric by using the Expression Builder

Correct Answer: C

A measure column is a column unlike the baseline column that has a default
aggregation rule defined in the Aggregation tab of the Logical Column dialog in the repository.
Measure columns always calculate the aggregation with which they are defined.
Measures need to be defined in a logical fact. Any column with an aggregation rule is a measure.

http://gerardnico.com/wiki/_media/dat/obiee/bi_server/design/obiee_measure_column.jpg

Comment: *

Name: *

Email: *

Verification: *

You do not have a physical time table in your database but would like to use the time series functions that OBIEE offers. What two options do you have?

• A.Create a physical time table in your database.
• B.Create a Logical Table that is sourced from the time key in the fact table.
• C.Create an "Opaque View" in the physical layer that contains the time columns from the fact and map it into your physical model.
• D.Create a Logical Table that is sourced from a time field in one of your dimension tables.
• E.Create a time table that is joined through a intervening Table so there is no foreign key relationship.

Comment: *

Name: *

Email: *

Verification: *

Which three components are part of a cluster server?

• A.Master Server
• B.Repository Publishing Directory
• C.Primary Cluster Controller
• D.Web Server
• E.Server request Controller

Comment: *

Name: *

Email: *

Verification: *