What is the process in which there is redundancy of data to improve performance?

• A.Redundancy
• B.Normalization
• C.Denormalization
• D.Granularity
• E.Cardinality

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

Where is Cache in OBIEE located?

• A.In relational database
• B.It is local disk-based.
• C.In dynamic aggregate
• D.In memory cache

Comment: *

Name: *

Email: *

Verification: *

Query limits tab can be accessed through________.

• A.Security Manager, Query tab, Application role dialog box, Permissions
• B.Security Manager, Application Roles tab, Query dialog box, Permissions
• C.Security Manager, Application Roles tab, Application role dialog box, Permissions
• D.Security Manager, Application Roles tab, Application role dialog box, Query Properties

Correct Answer: C

Explanation
Query environment can be managed by setting query limits (governors) in the Repository (RPD) for particular Application Roles. You should always set query limits for particular application roles rather than for individual users.
Steps:
1. Login to Repository using OBIEE Admin Tool
2. Navigate to Manage > Identity
3. Go to Application Role tab, choose the role and double click on it to open.
http://123obi.com/wp-content/uploads/2011/04/25-04-2011-10-25-38.png

4. Click on Permissions tab
http://123obi.com/wp-content/uploads/2011/04/25-04-2011-10-26-13.png

5. Set the 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.
http://123obi.com/wp-content/uploads/2011/04/25-04-2011-10-26-45.png

Comment: *

Name: *

Email: *

Verification: *

The Oracle BI office plug-in allows you to import the results of an OBI request into which two MS applications?

• A.MS Visio
• B.MS Excel
• C.MS Project
• D.MS Word

Comment: *

Name: *

Email: *

Verification: *