Oracle Business Intelligence Foundation Suite 11g Essentials - 1Z1-591 Free Exam Questions

A. Year

B. CurrentMonth

C. Quarter

D. Month

A. Oracle Mapviewer

B. Spatial Option with Database

C. OLAP option

D. Oracle Business Intelligence Enterprise Edition

A. Level-based Time Dimension hierarchy

B. Value-based Hierarchy

C. Ragged Hierarchy

D. Skip Level Hierarchy

A. When the customer needs near real-time data to support decision making in a fast changing environment

B. When the complexity of operational schema does not allow modeling in the BI repository

C. When the customer is not prepared to spend budget on data-warehousing

D. When it is not possible to query against a transactional system

A. Custom Display Name

B. Alias

C. Logical Column Name

D. Implicit Fact Column

E. Logical Key

A. Alias tables are set up to avoid triangular or circular joins.

B. Alias tables are set up to create another physical copy of the data.

C. Alias tables are set up to create a copy of the data with a filter applied to it.

D. Alias tables are set up to include best practice naming conventions for physical table names.

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

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

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

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

A. Opening the rpd.file in online mode results in performance Issues for the application user.

B. All aspects of security are being held in the repository file.

C. Multiple developers can work on one repository at the same time. Results can be merged later on.

D. Changes to the repository can only be carried out in offline mode.