1Z0-591 Online Practice Questions and Answers

What is an example of a Session Variable?

A. ETL Load Date

B. User Organization

C. OLAP DSN

D. Top Customers by Revenue

Select the correct statement.

A. Cache provides fast and always up-to-date information.

B. Cache can increase traffic to back end database.

C. Cache needs to be purged to refresh data.

D. Cache can degrade query performance by reading data from the disk instead of the database.

E. Cache is seeded by manually running PL/SQL at the back end database.

A customer needs to do a cross database join between two tables where, one of the tables has a small number of values and the other has a large number of values. How can you optimize the way the BI Server processes the query?

A. By specifying a one-to-many join between the tables with the small and large numbers of values

B. By specifying a driving table

C. By specifying a many to one join between the tables with the small and large numbers of values

D. By creating your logical join by using the Joins Manager

E. By creating your joins by using the Business Model Diagram

A derived measure is never used to_________.

A. Calculate share measures

B. Add two logical columns together

C. Calculate a variance between two measures

D. Calculate the rank dimension values

E. Input data

One of the initial phases in OBIEE implementation is the Discovery phase where the project team focuses on a few activities. Which option is not one of them?

A. Business Requirements Definition

B. Technical Requirements Definition

C. Data Quality Assessment

D. Dashboard Testing

A company's Database Administrator has divided the region table into two tables so that the region "West" is in one table and all the other regions are in another single table. What kind of partition is being used?

A. Fact-based

B. Time-based

C. Mixed

D. Complex

Derived metrics are_____.

A. Derived from other logical columns

B. Derived from other physical columns

C. Used to apply pre-aggregation calculations to measures

D. Used to rename measures to user-friendly names

Which variable does not use initialization blocks to initialize its values?

A. Static Repository Variable

B. Dynamic Repository Variable

C. System Variable

D. Non System Variable

An organization would like to see a Time folder with subfolders for its Fiscal and Julian calendars. How would you accomplish this?

A. By creating Presentation Folder called Time and then two subsequent folders called -> Fiscal Calendar and -> Julian Calendar

B. By creating a Presentation Folder called ->Time called then two subsequent folders called Fiscal Calendar and Julian Calendar

C. By creating a Presentation Folder called -Time and then two subsequent folders called + Fiscal Calendar and + Julian Calendar

D. By creating a Presentation Folder called Time and then two subsequent folders called Fiscal Calendar and Julian Calendar

The customer is questioning the necessity to have a data warehouse in place. They want to run OBIEE against various transactional systems. Identify the two limitations.

A. Operational system might be overburdened with analytical requests resulting in had performance for transactional processes.

B. The BI server cannot integrate various sources in one metadata model.

C. Data quality issues might emerge, due to missing data cleansing.

D. Business issues are depending on real-time data.