1z0-591 Exam Dumps - Oracle Business Intelligence Foundation Suite 11g Essentials

Go to page:

Question # 9

The three metadata layers are an important concept of the BI Server. Which statement is incorrect?

The physical layer defines the objects and relationships that the Oracle BI Server needs to write native queries against each physical data source.

Separating the logical of the application from the physical model provides the ability to federate multiple physical sources to the same logical object.

The model and mapping layer define the business or logical model of the data. This layer determines the analytic behavior seen by users.

The presentation layer defines the relationship that is needed to create the DML.

Full Access

Question # 10

One benefit of adding a second table source that is joined to the first table source in the Physical Layer by a foreign key relationship is that______.

Multiple SQL queries are performed

Two SQL queries are performed to get data from both tables

A single SQL query is performed to get data from both tables

No SQL queries are performed against the source tables

Full Access

Question # 11

Identify the reason why Oracle OLAP provides a favorable aggregation strategy.

OLAP cubes eliminate the need for a large number of aggregate tables.

OLAP cubes are stored outside of the database in highly optimized file structures.

OLAP cubes can be easily transported from database to database.

OLAP cubes can be queried by using SQL.

Full Access

Question # 12

Derived metrics are_____.

Derived from other logical columns

Derived from other physical columns

Used to apply pre-aggregation calculations to measures

Used to rename measures to user-friendly names

Full Access

Question # 13

Pre Deployment sign-off is a milestone for a OBIEE implementation and is based on successful completion of certain tasks. Which option is not one of them?

Test Environment

System Testing

Performance Tuning

Project initiation and resourcing

Data Validation / Verification

Full Access

Question # 14

A customer needs to have a calculation done prior to aggregating the data. How would you accomplish this?

By creating a derived measure by using the Logical Columns available

By creating a derived measure in the Column Mapping dialog box by using the physical table columns.

By creating a derived measure by using Logic Columns available and changing the aggregation type

By creating a derived metric by using the Expression Builder

By creating a derived metric by using the Calculation Wizard

Full Access

Question # 15

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.

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

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

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

Business issues are depending on real-time data.

Full Access

Question # 16

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?

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

By specifying a driving table

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

By creating your logical join by using the Joins Manager

By creating your joins by using the Business Model Diagram

Full Access