Online Access Free 1z0-591 Exam Questions

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.CurrentMonth
• B.Year
• C.Month
• D.Quarter

What are the two methodologies that are followed within an OBIEE implementation?

• A.Do not use prototypes
• B.Start with a small model and then enhance the repository
• C.Start with a big repository and trim it down with the requirements
• D.Use an iterative approach

Oracle BI Server at a company is connected to Data Warehouse that is refreshed on a daily basis, the majority of users at the company log in to Oracle BI every Monday to generate the previous week's sales report. The BI Administrator schedules cache purge and cache seeding to improve report response times. How is this accomplished?

• A.Every day before Data Warehouse refresh
• B.Every day after Data Warehouse refresh
• C.Every Monday early morning
• D.Every Monday late night

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

Object Security controls access to Subject Areas, Tables, and Columns in OBIEE and can be implemented by using which method?

• A.Business Logic Object Security
• B.External Table Authentication
• C.LDAP Authentication
• D.Single Sign-On (SSO)
• E.Database Authentication